Defining the Report Columns

A report can have up to twelve columns, depending on the width of the columns. Each column is identified by a 3 character column heading code.

You can use predefined columns, for example This Period Actual, This Period Budget, This Period Budget Variance, Year-to-Date Actual. For a list of these codes see What are the Column Heading Codes?. See also Setting Up Column Codes.

In addition to using the predefined column codes, you can define columns that are calculated at run time, based on other columns. The second character of a calculated column must be Z or V.

The third character of the column code specifies from which budget ledger (B-K) budget figures are to be taken, for example, PBB and YBB. It should be left blank for the actual ledger figures.

A spread of up to 13 period amounts can also be requested in place of the regular column codes. For more information on the spread codes SA and SB see Specifying a Period Spread.

You can leave columns blank to improve legibility.