Show TOC

Object documentationFinancial Report Templates Window

 

Use this window to create or edit Financial Report Templates.

To open the window, choose Start of the navigation path Financials Next navigation step Financial Report Templates End of the navigation path.

Financial Report Templates Window
Template Details

  • Report – From the dropdown menu, select the report for which you want to create a template.

  • Template – Specify whether to use an existing template or define a new one.
Show Missing Accounts

Displays accounts that are not included in the template.
G/L Account Details

Name and foreign name of the selected account.

Note Note

You can change the name and foreign name of the account for display in the report.

End of the note.
G/L Account Location

Current parent article and account location in the tree.

Note Note

You can change the location of the account.

End of the note.
Group Data

  • For Balance Sheet: Select whether to group the data from the Active side or the Passive side.

  • For Profit and Loss: Subtotal displays subtotals in the report. Select the account under which you want to locate the subtotal, select Subtotal and specify its title in the field on the right.

    • Totals Formula calculates the subtotals from a formula you specify using the Formula option on the right.

    • Automatic Summary calculates the default subtotals.

  • For FA historic report: Subtotal displays subtotals in asset history sheet reports. Automatic Summary calculates the subtotals.
Add Child Acct

Enables you to create an account on a level lower than that of the selected account.
Add Same-Level Acct

Enables you to add a new account on the same level as the selected account.
Generate Standard Chart of Accounts / Generate From Cash Flow Line Items

Generates the standard chart of accounts for the temperate.

For cash flow report templates, generate the template from cash flow line items.

For fixed asset templates, generates only the assets of the standard chart of accounts.

You can add new accounts, rearrange the accounts, or remove non-relevant accounts as required.
Mock Title

Hides the selected account in the financial report.

Not available for FA history report templates.
Hide Accounts

Hides selected accounts in the report.

Not available for FA history report templates.
Cash Flow Report Template Fields
Report

Specify a report type.
Line Item

Displays the name of a selected line item.
Parent Article

Specify the title to be assigned to the line item.
Loc. on Tree

Specify the location of the line item relative to other line items under the same title.
Line Number

Specify the line item number to be displayed in the final Cash Flow report.
Indent Characters

Specify the number of character indentations to display in the final report. The default number for Level 3 is four indentations.
Text Title

Selecting this field:

  • Defines the selected line item as a text title that cannot have any child cash flow line items or cash flow relevant G/L accounts

  • Disables the Subtotal and Reversal Sign fields
Reversal Sign

Changes the cash flow line item amount to a negative number.

To display the Financial Report Templates – Expansion window, double-click the line item.