We moved!
Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!
In the Report Designer, you are able to display the total amount for a subset of accounts as well as the detail for the other accounts. For example, you can display the total for all of the cash accounts and details for the other current asset accounts in the Balance Sheet - Current Year financial statement.
Use the following steps to set up a financial statement to display totals for all cash accounts and detail for other current asset accounts.
- Choose File > Report Designer and click Financial Statements section button in the lower left of the Reports frame.
- Double-click the Balance Sheet - Current Year financial statement to open it in the design grid.
- Add two rows between rows 4 and 5. For details, see Adding or removing columns and rows.
- Rows 5 and 6 may be grouped together. To ungroup rows 5 and 6, you can right-click row 5 and choose Ungroup from Repeating Level. For details about repeating elements, see Repeating elements in a report.
Note: If the rows are not grouped together, you can right-click the row in which the variable is to be inserted (row 6 in our example) and choose Group into Repeating Level.
- Right-click row 5 and choose Row Height.
- Enter 0.00 and click OK.
- Right-click cell A4 and choose Delete Cell Contents.
- Enter Cash Accounts in cell A4.
- Select cell B4 and change the Grouping content of the cell to CA : CASH in the Cell Properties section of the Design Tools frame and mark the Print total amount checkbox.
- Select cell A6 and insert the [ChartofAccountsActivity.Core.GLAccountDescription] variable. (For details, see Working with variables.)
- Select cell B6, and insert the [ChartofAccountsActivity.Core.Amount] variable.
- Select cell B6, and in the Cell Properties section of the Design Tools frame, choose Account Classification as the Grouping type.
- Click the Formula button next to Grouping content field and choose Clear Formula in the lower left of the Formula dialog.
- Select the following codes in the Account Classifications list and click the Add operator button after each selection.
Code Description CA: No subcode Current Assets: No subcode CA: MS Current Assets: Marketable Securities CA: AR Current Assets: Accounts Receivable CA: INV Current Assets: Inventory CA: PE Current Assets: Prepaid CA: OCA Current Assets: Other Current Accounts - Select the appropriate Period, Amount type, and Basis in the Design Tools frame.
Note: The Adjusted basis is used when the Basis field in the Row Properties section of the Design Tools frame is blank.
- Select cell B8. The formula in this cell needs to be adjusted to account for the new row. In the example, it should be [B4 + B6]. You may also need to adjust the formatting of the inserted cells. For details, see Format Cells dialog.
The following screen displays the applied changes in the appropriate sections of the design grid for the Balance Sheet - Current Year statement.
Was this article helpful?
Thank you for the feedback!