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:
-
In the Navigation pane, select
.
-
On the
Account Tables form, click the Detail Groups tab.
-
Click
+ New
Account Group Table.
-
Enter a name and a number for the
account group table.
-
In the Detail
Account Groups grid, click
+ Add Detail
Account Group and complete the following fields:
-
In the
Sort Order field, enter a number to specify the order in which the
account group displays on general ledger reports.
-
In the
Account Group Name field, select an
account group.
-
Select
Exclude From Report Total to define subtotals on general ledger reports without those subtotals impacting the bottom line or the report totals.
-
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.
-
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.
-
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.
-
Use the
Test Setup option to check that each
account is assigned to a detail
account group.
-
Click
Save.