Options
- Click the Options tab in the Financial Table Formats dialog.
-
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
- Save your changes.