Creating a Custom Financial Statement Section
On the Financial Report Builder's Edit Layout page, you can create a custom section by adding a new section with new selection criteria or by editing selection criteria for an existing section, causing a duplicate section to be created. Selection criteria define the accounts to be included in a financial statement section.
Be aware of the following limitations for custom sections:
-
To avoid unexpected results, do not define overlapping criteria for two or more custom sections in a financial statement. If an account fits the criteria for more than one section, the system determines the account's section, which may not be the one you expect.
-
If you create a custom Cash Flow Statement that includes custom sections, its value for the Cash at Beginning of Period row is likely to be incorrect unless you create a custom Cash Statement that shares these custom sections and make that custom Cash Statement the referenced report for the Cash at Beginning of Period row. See Customizing Cash Flow Statement Account Sections.
-
Be careful that section filtering does not result in a duplicate combination of account, department, location, class, or subsidiary filtered values on multiple lines because a financial statement cannot display values for an identical account multiple times. To avoid incorrect totals, the statement displays correct values the first time the account is listed and displays zeroes for later listings of the same account. For example, this issue may occur when accounts are filtered by a department that is a parent of one or more other departments.
You need both the Financial Statements permission and the Report Customization permission to customize reports in the Financial Report Builder. If you do not have necessary permissions, contact your account administrator. See Giving Access to Financial Statements for more information.
Editing Selection Criteria for an Existing Section
To edit selection criteria for an existing section:
-
Start the Financial Report Builder, and ensure an editable custom layout is selected in the Edit Layout page. For information, see Accessing the Financial Report Builder.
-
Select a financial section in the Layout outline.
-
In the right pane of the Financial Report Builder on the Section subtab, click Edit Criteria.
-
In the Edit Section Criteria popup, click OK to indicate that you are creating a new custom section.
-
You can insert and remove filters.
-
To add a filter, select a field from the list in the Filter column.
-
In the Filter popup that opens immediately after you select a filter, select one or more values to indicate the criteria to be applied to this section. You also can click Set Options to open this popup.
-
If you want to use parenthetical expressions to define section data filters, check the Use Expressions box. This option functions here in the same manner as it does for search criteria. For more information, see Using Expressions in Search Criteria.
-
-
If you want this custom section to be available for use in other custom financial layouts, click Share Section.
-
In the Share Section popup, click OK.
-
Change the section name/ID as desired.
-
-
Make other changes to the section as desired. See Editing a Financial Statement Section.
Adding a New Custom Section
To add a new custom section to a custom financial statement:
-
Start the Financial Report Builder, and ensure an editable custom layout is selected in the Edit Layout page. For information, see Accessing the Financial Report Builder.
-
In the Layout outline, select the row where you want to insert the new section. The section is added above the selected row. (Note that you also can use the up arrow and down arrow buttons or drag and drop the section to move it after it is added.)
-
From the Add Row/Section... list, select Add Financial Section.
-
In the New Section Row popup, choose the Create New Section option, and click OK.
-
You can insert and remove filters.
-
To add a filter, select a field from the list in the Filter column.
-
In the Filter popup that opens immediately after you select a filter, select one or more values to indicate the data that will be included in this section. You also can click Set Options to open this popup.
-
If you want to use parenthetical expressions to define section data filters, check the Use Expressions box. This option functions here in the same manner as it does for search criteria. For more information, see Using Expressions in Search Criteria.
-
-
If you want this custom section to be available for use in other custom financial statements, click Share Section.
-
In the Share Section popup, click OK.
-
Change the section name/ID as desired.
-
-
Make other changes to the section as desired. See Editing a Financial Statement Section.