Add a New Detail Account Group Table and Insert Accounts

In each account group table, you can specify a range of account numbers or a single account number.

If possible duplicate records are detected during this procedure, the Potential Duplicate Records Found dialog box displays. This dialog box lists any existing record that already has the identifier that you are trying to use for a new record.

To add a new detail account group table and insert accounts:

  1. In the Navigation pane, select Settings > General Ledger > Account Group Tables.
  2. On the Account Tables form, click the Detail Groups tab.
  3. Click + New Account Group Table.
  4. Enter a name and a number for the account group table.
  5. In the Detail Account Groups grid, click + Add Detail Account Group and complete the following fields:
    1. In the Sort Order field, enter a number to specify the order in which the account group displays on general ledger reports.
    2. In the Account Group Name field, select an account group.
    3. Select Exclude From Report Total to define subtotals on general ledger reports without those subtotals impacting the bottom line or the report totals.
    4. In the Show Account Detail field, specify whether the account number or name displays on general ledger reports.
      • Yes: Display the account number or name beneath each detail account group on the report. Whether just the account name, or both the account name and number, display is based on report options settings. This setting overrides any settings in the report's Sorting/Grouping fields.
      • No: Do not display the account number and name on the report. In this case, the total amount includes amounts from all accounts associated with the detail account group. This setting overrides any settings in the report's Sorting/Grouping fields.
      • Report: Display the account name and number on the report only if you select them in the Sorting/Grouping fields for the report.
    5. In the Group Total field, specify whether to display a total on general ledger reports.
      • Yes: Display a total on the report for all the accounts associated with the account group; the total displays under the account group name. This setting overrides any settings in the report's Sorting/Grouping section.
      • No: Do not display a total for the account group on the report. This setting overrides any settings in the report's Sorting/Grouping section.
      • Report: Display a total on the report only if you select it in the Sorting/Grouping section for the report.
  6. In the Accounts in Detail Account Groups grid, click + Add Account Range to insert an account or range of accounts.
    To specify a single account number, enter the same account number in the Start Account and End Account fields.
  7. Use the Test Setup option to check that each account is assigned to a detail account group.
  8. Click Save.