Enter a report master code that uniquely identifies the report master record in the system.

Enter a description of the report master. This description is displayed in lookup browses.

Enter the title to print at the beginning of the report. The translate functionality allows you to translate the string in this field. You can enter plain text and you can also use the special variables as part of the text. These special variables are replaced on the report with the report year and period details you specify when you run the report. The special variables are:

Enter the title to print under the report title. The translate functionality allows you to translate the string in this field. You can enter plain text and you can also use the special variables as part of the text.

You can secure reports so that only certain users can run them. When the Roles field is blank, you can only run a report when you have access to all the entities linked to the report. You must have permission to use the menu Financial Report Run in each entity.

Optionally, you can use the lookup to specify a role that a user must have in each of the involved entities. When you specify more than one role, a user must have only one of the roles in each involved entity.

If you do not have the permissions for entities linked to the report, but want to run the report for entities where you have permissions, create an additional filter analysis code. This code filters out the forbidden entities and uses this analysis code as a Filter Analysis Code in the Financial Report Run selection screen. You can then run the report for the allowed entities only.

If you are creating a report master record, enter a report chart code. This code must relate to an existing report chart. All subsequent elements of the report master must be linked to the same report chart. The elements are the report tree, column group, and controlling report analysis code. The description of the report chart is displayed in a read-only field.

Enter an existing column group code that is linked to the report chart specified in the report master. The column group specified here determines the column layout of the report. See Report Column Group. The description of the column group is displayed in a read-only field.

Specify how you want to display the amounts in the report. You can display the amounts in full, in thousands, or in millions.

From the list, select the number of decimals you want in the report. You can have up to three decimals.

You can specify the nodes to appear as rows in the report. The options are:

Enter the top-level report analysis code for the report tree, also referred to as the root node. This code must be an existing report tree linked to the report chart as specified in the report master. The report tree specified here determines the printed report hierarchy structure, including all detail layout options that you can set using Financial Report Tree Import from a CSV file. The description of the report tree is displayed in a read-only field.

Specify the label you want to print as the column header label above the report tree hierarchy. This label is on the left part of the layout. The string entered in this field can be translated.

Specify whether to print the code, the description, or both for the report tree hierarchy.

The report tree hierarchy on the report prints child nodes, indented relative to their parent. Use this field to specify the size of the indent in twips. Three hundred twips are approximately 0.7 cm.

Specify the level of report tree detail you want to display in the report. The default is zero, which displays all levels of the report tree. To only see the top level of the report tree, set the value to 1. To see the top two levels, change the value to 2, and so on.

Select a value to indicate how you want to print GL transactions on the report. The options are:

Choose All to include all detailed transactions in the report tree in the report. When running the report in Financial Report Run, you must also select the Print Details report selection criteria for this option to take effect.

Choose Selected to only include detailed transactions that relate to a report tree leaf node for which Show Details is selected in the Report Tree. When running the report in Financial Report Run, you must also select the Print Details report selection criteria for this option to take effect.

Choose No if you do not want to display detailed transactions on the report.

Specify the maximum number of posting lines to include in the report. If the total number of lines in the report exceeds the maximum posting line value specified, an error message displays when you run the report.

The default limitation on posting lines is 50,000.