Financial Reports Column Headings (FRH)

A column heading code. You can use Query to list the available, predefined codes. You can enter a third character to the code, B to K, to identify the budget ledger required.

To create a new Column Calculation you must use AZ, BZ through to ZZ or, for variance type calculations, AV, BV through to ZV.

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.

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 fourth, 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.

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.

The heading lines required for the column. The text should be aligned exactly as required on reports.

An algebraic expression in the form xfy, where x and y identify a report column and f is an operator. The report columns are identified by the letters A to L. The valid operators are: '+' plus, '-' minus, '/' divide, '*' multiply, '%' percentage.

For example, A/B means column A divided by column B. A%B means column A divided by column B and then multiplied by 100.