, Edit Line 
, Move Up 
, and Move Down 
buttons on the Report Structure toolbar. These conventions can be used to remove, edit, or re-position the items or nodes within the report structure.Use Financial Reporting Rows to define financial statement row formats that you can select in Financial Reports. Financial Reporting Rows for a given financial report specify the row format used for the report. The column format and any selection criteria are determined at the time the report is run based on selections made by the user in Reports.
The Report Structure area is under user control and is where you define the structure for a specific financial report. This area supports drag-and-drop as well as providing Remove Line, Edit Line , Move Up , and Move Down buttons on the Report Structure toolbar. These conventions can be used to remove, edit, or re-position the items or nodes within the report structure.
Use the Account Structure area to select accounts for reporting. The account structure represents the Account portion of the Account Group hierarchy defined in Account Groups. You can select one or more accounts to correspond with a single row in the report structure. You can include accounts in the financial report in either a summary format or a detail format.
If the financial report row is a Summary row type, the totals for the account(s) are rolled up into the designated row. If the financial report row is a Detail row type, each of the selected accounts are included as separate rows within the report. The Account Structure area is only enabled for selection purposes when the current row within the report structure is assigned a record type of Summary or Detail. The Account Structure hierarchy that is displayed is display-only.
Setting up Financial Reporting Rows
Select Financials | Setup | Financial Reporting Rows.
In Description, specify a description for the financial reporting row. This fields supports up to 255 characters.
Click to select the Active check box if the financial reporting row is active status. This allows for the financial reporting row to be used. Leaving this check box cleared means the financial reporting row is not available for use.
In the Report Structure area, specify the following settings:
Row Types - A financial reporting row set is created by dragging the Row Type icons into the Report Structure area. The structure of the report is created first by dragging Heading rows into the grid. A heading row must be created for any grouping and subtotaling required by the report format. The other row types are then associated with the header rows to determine the data that will be included in each of the groupings. The available Row Types include:
Detail (
) – A detail line should be included at the lowest level of the header hierarchy and determines the data that will appear in the header grouping. Accounts can be assigned to the detail row by expanding the account structure and checking the accounts that are associated with the detail row type. A detail row type will display the Account Group or Account Level amounts when a Financial Report is run with a Detail Level of Detail or Account, respectively.
Summary (
) – A summary line is similar to a detail line except that it will only display a single line in the financial statements for all accounts associated with the Summary line regardless of the Detail Level specified when the Financial Reports run.
Pct Total (
) – Identifies the row within the report structure that will be used as the 100% value when percentages of total are computed. All account-related rows prior to the Percent Total row within the current heading will be summed and the resulting value will be used as the dividend in calculating the required percentages. Only one Pct Total row can be used per financial reporting rows definition.
Total (
) – Sums the value of all Detail and Summary rows within the current Heading row. Subtotals are supported within Total lines.
Heading (
) – A non-data row used for organizing sections of the resulting report. A Heading line may be added under an existing Heading line as a subheading when detail lines exist.
To add a new row, drag the appropriate row type icon to the grid and Report Structure Detail appears.
In Report Label, specify the label that you want to appear in the financial statement as the row description when you run the report.
The Type is determined by which row type you drag to the grid and will automatically populate.
Click to select the Subtract From Total check box to subtract the amount for the row from the Total rows.
Since row values are calculated as a positive value based on their normal balance (for example, a Revenue account with a credit balance would be treated as a positive number while an Expense account with a credit balance would be treated as a negative number), this allows you to calculate net income which is revenue minus expenses.
Click to select the Suppress Output check box if you do not want the line to print on the financial report.
Click to select the Display As Negative check box to display the amount as a negative of its “normal” balance.
Click Save to save the row and return to Financial Reporting Rows.
The Account Structure area contains the hierarchy of accounts that can be associated with the Detail or Summary rows that are currently highlighted in the Report Structure. For example, to select an account structure you must highlight the row type line on the left side of screen to enable the account structure accounts to be selected.
Note: Accounts assigned to other Detail or Summary rows will appear with a dark background color in the check box and will not be available for selection. For example, an account can only be associated with a single Detail or Summary row in a Financial Reporting Rows set.
Click Save and New, or click Save and then click New, to save the current financial reporting row and start adding the next.