Options

  1. Click the Options tab in the Financial Table Formats dialog.
  2. Specify this information:
    Data Access Group Code

    Data access groups allow you to apply security on the data that is maintained and viewed in SunSystems.

    Document Format Code

    The document format to be used to produce the Financial Table reports. The default format code is FT3. However, several document formats may be available to cater for different types of Financial Table report. For example, there may be a wide column format. You may want to test the report using different format options.

    Transfer File Format

    If you want to transfer the report data to a file, select the file format you require. The column details that are transferred are determined by the Transfer Internal Columns setting.

    Wide Columns

    Set this to specify that wide columns should be used if your amounts are too large to be displayed in standard width columns.

    Bracket Negatives

    Select this field if you want negative amounts to be shown in brackets. Leave it blank to have negative amounts shown preceded by a '-' minus sign.

    Exclude Zero Value Rows

    Select this option to suppress rows if all of the column values are zero. Leave this blank if you want to print report rows that contain all zero amounts.

    Notify If Held Journals

    Select this option if you want Financial Tables to display a warning at run time, if there are any held journals for the business unit. You are given the option to continue or to view any existing held journals. Leave this blank if no check is to be performed.

    Transfer Internal Columns

    Select this option to transfer all of the internal financial table columns for the report to the transfer file. There are a maximum of 50 internal columns. Leave this blank if you only want to transfer the printed financial table columns.

    Single Spread Period

    Select this option if you want your report to cover a single period. Leave this blank if you want separate spread periods for each ledger or database in your report.

    Select Transactions
  3. Save your changes.