Financial Reports Column Headings (FRH)

  1. Open Financial Reports Column Headings (FRH) from the main SunSystems menu.
  2. Specify this information:
    Column Headings Code

    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.

    Note: Variance calculations can only be used in Financial Statements and take into consideration the Normal Sign setting in Financial Statement Rows (FSR).
    Source Currency

    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.

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

    Rate Indicator
    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.
    Column Heading 1-4

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

    Note: All column headings must be defined in order to run Financial Analysis and Financial Statement reports.
    Column Calculation

    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.

    Note: For Column Calculations, you must set the Source Currency and Rate Indicator to Unused, and leave the Target Currency blank.
  3. Save your changes.
Related topics