Columns

A maximum of 12, normal width, columns can be included on the report. These columns are identified using the letters A to L. If you select the wide columns option, then only ten columns are available.

  1. Specify this information:
    Column A-L

    Enter the column codes in the order you want them to appear across the report.

    Note:  If you include a column code that performs a ratio calculation, you must enter the Ratio Base Accounts From/To above.
    Column A-L Source Value

    The source currency value you want to report on. Select one of the values available: Base currency value, Transaction currency value, Second base/Reporting currency value, Memo value, or Fourth Currency value. Select Unused if this is a Column Calculation.

    Column A-L Target Currency

    The currency code you want to convert the source currency into. This is only required if you want to convert the source currency value into another currency. For example, to report in a completely different currency to any of the currencies held on the transactions. You can select any valid currency code, as defined using Currency Codes (CNC). Leave blank if this is a Column Calculation.

    Revaluation Rate

    The period currency rate to be used to revalue the source amount. Six rates can be defined for each currency/period using Currency Period Rates (CNP). Reporting Rate 1 is the period rate set for the currency and used for ledger entry and other system processes. Reporting Rates 2 to 6 are the additional reporting only rates defined for the currency. Select Unused if this is a Column Calculation.

    Note:  For Column Calculations, you must set the Source Value and Revaluation Rate to Unused, and leave the Target Currency blank.
  2. Save your changes.