Function Path: ”Setting up SunSystems” -> “Setting up Ledger Accounting”->”Setting up Reports”->“Financial Reports”->”Financial Tables”
Function Code: FTF – Financial Table Formats Setup
FTF-GRID - Financial Table Formats Setup - Grid

Financial Table Formats Setup (FTF) is used to define the layout of a Financial Table report.
A financial table format pulls together the table rows and table columns defined separately for the Financial Table report. Click here to see how it's done

Table Code
A code to uniquely identify the table format. This is the code used to identify the report in Financial Tables (FT) when you want to produce it.

Line 1-2
Up to two lines of heading for the report. This is printed at the top of each page. It cannot be left completely blank. You may want to center the heading by leaving spaces at the start.

Filter/Sort
Row Content Code
The code of the set of financial table rows which control the lines that appear on the report. This set of rows must have been defined using Financial Table Rows Setup (FTR).

Each row defines the account codes or analysis codes, headings, comments and totals to be included on the report. You can use the same set of financial table rows for several reports.
Column Content Code
The code of the set of financial table columns to be included on the report. This set of columns must have been defined using Financial Table Columns Setup (FTC).

You can use the same set of Financial Table Columns for several reports by defining separate table formats.
Selection 2/1
Level Selection codes are used to determine the transaction selection, sequencing and totalling for the report. Since the Level codes are hierarchical, you should use Level 2 before Level 1. See Sorting the Financial Table Data.

For each dimension you select here, you are prompted at run time to enter a code, or range of codes, to limit the transactions selected for report.

Subdimension 2/1
Enter a subdimension to apply to the dimension selected. Subdimensions are used to subdivide the analysis codes for a dimension. They are defined using Financial Reporting Subdimensions (FRS).

Report Level 2/1 Code
Select this field if you want the applicable code to be printed alongside the Level Selection name or description in the heading of the report. Otherwise, leave this blank.

Page Levels
The page break level for the report. Select Break at Level 2, or Break at Level 1, to include a page break after the appropriate total has been printed. This is useful if the report is to be distributed to different managers or budget holders.

Alternatively, select Continuous Printing if forced page breaks are not required.