Summary Account Group Tab of Account Group Table Info Center

Use the Summary Account Group tab to associate each summary account group with one or more detail account groups.

Contents

You can think of the summary account group as the parent to all detail account groups associated with it. The detail account groups define which accounts are included. You can also use this tab to specify how account group table information prints on general ledger reports.

The availability of some options on this tab depend upon your security access rights. See your system administrator if you have questions.

Field Description
Test Setup

Each detail account group should belong to a summary account group. This option works in conjunction with the Exclude from Report Total option.

When you click Test Setup, the following things happen:

  • Vision displays a list of all detail account groups not currently assigned to a summary account group.

If a detail account group is assigned to a summary account group, but the summary account group is marked for exclusion from report totals, the detail account group displays in the list of "missing" detail account groups.

Amounts for accounts associated with any detail account groups not included in a summary account group display in the Other column on the General Ledger reports. However, if the summary account group is marked for exclusion from report totals, corresponding child account amounts are not included in the Other column.

  • Vision checks for duplicates, which in this case are detail account groups assigned to more than one summary account group.

Vision considers account group assignments as duplicates only the Exclude from Report Total option is not selected for either summary account group to which the detail account group is assigned. In other words, the list does not include a detail account group assigned to two summary account groups if one of the summary account groups is included in report totals and the other summary account group is excluded from report totals.

Summary Account Group Names Grid

Field Description
Insert Open an account group table and click this option to specify a summary account group name.
Delete Open an account group table, select a line, and click this option to remove the summary account group name from the table.
Sort Order Enter a number that indicates the order in which account groups display on reports.
Account Group Name From this drop-down list, select a summary account group name. This name displays as a label on general ledger reports.
Exclude from Report Total

Your setting for this option for the summary account group overrides the corresponding setting for its constituent detail account groups.

Select this option to define subtotals on general ledger reports without those subtotals impacting the bottom line. If you run the Test Setup option, any account assigned to an account group marked for exclusion from report totals displays in the list of accounts not yet assigned.

Do not select this option if you want accounts to impact the bottom line.

This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.

Show Account Detail

Use this option to specify whether or not the detail account groups associated with the current summary account group display on general ledger reports.

Select one of the following settings from the drop-down list:

  • Yes — The names of the detail account groups display beneath each summary account group on the report. This setting overrides any settings on the report's Sorting/Grouping tab.

  • No — The detail account groups do not display on the report. This setting overrides any settings on the report's Sorting/Grouping tab.

This option does not affect the display of account names and numbers on the report. To control their display, use the Show Account Detail option on the Detail Account Group tab (of Account Group Tables).

This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.

Subtotal

This option is available only if you set the Show Group Detail option to Yes. If you set Show Group Detail to Report, the subtotals are also based on report options.

Select one of the following settings from the drop-down list:

  • Yes — Select this setting for the report to include a subtotal for the summary account group if more than one account is included in the definitions for any associated detail account groups. The subtotal displays under the account group name. This setting overrides any settings on the report's Sorting/Grouping tab.

  • No — Select this setting for the report to not subtotal by account group. This setting overrides any settings on the report's Sorting/Grouping tab.

  • Report — Select this setting for the subtotal to display only if you select to subtotal on the account group record on the Sorting/Grouping tab for the report.

This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.

Detail Account Group Name in Summary Account Group Grid

Use this grid to associate one or more detail account groups with the summary account group.

Field Description
Insert

Open an account group table and click this option to insert a detail account group name for the summary account group table.

The detail account groups you specify are considered sub accounts of the summary account group. This means that all accounts named as part of each detail account group belong to the summary account group.

Delete Open an account group table, select a table, and click this option to remove a detail account group name from the summary account group table.
Detail Account Group Name

Detail account groups that you created on the Detail Account Group Tab (of Account Group Names) are available from the drop-down list for this option. You must set up the detail account groups — including your designations of which accounts are associated with the detail account groups — before you can associate them with a summary account group here.

If you attempt to select a detail account group that is already associated with another summary account group, Vision displays a warning message.