Columns

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

  1. Click the Columns tab in the Financial Analysis Layouts (FNL) dialog.
  2. Specify this information:
    Column A-L

    The column code that determines the type of value to be included in the column on the report. You should select the columns in the order you want them to appear across the report.

    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.
  3. Save your changes.
Related topics