Setting Up Financial Table Formats - Options

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.

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.

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

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.

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.

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.

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.

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.