Use the Detail Account Group tab to associate detail account group names with accounts. You can also use this tab to specify how account group table information prints on General Ledger reports.
Contents
| Field | Description |
|---|
| Number
|
Enter the number associated with the new table.
|
| Name
|
Enter a name to identify this table. This table name displays as a choice for your General Ledger reports.
|
| Lookup fields
|
Use the lookup fields at the bottom of the form to associate an organization or account code with the selected account table.
You can limit the tables available to a particular user with the following lookup criteria:
-
Organization — Select an organization from the lookup. This field only displays if you use Organizations.
-
Code — Select a code from the drop – down list. These codes are defined in the Unit Table Code Table.
|
| Test Setup
|
Each account in your chart of accounts must belong to an account group. Amounts for accounts not assigned to account groups display in the
Other column on the General Ledger reports.
This option works with the
Exclude from Report Total option.
When you click
Test Setup, the following things happen:
- Vision displays a list of all accounts not currently assigned to an account group.
If an account is assigned to an account group, but the account group is marked for exclusion from report totals, that account displays in the list of "missing" accounts.
Amounts for accounts not assigned to account groups display in the
Other column on the General Ledger reports. However, if an account is assigned to an account group marked for exclusion from report totals, that account's amount is not included in the
Other column.
|
Detail Account Group Names Grid
| Field | Description |
|---|
 Insert
|
Open an account group table and click this option to associate the detail account group name with a sort order. Set the options for use on General Ledger reports.
|
 Delete
|
Open an account group table, select a grid row, and click this option to remove the detail account group name from the account group table.
If you specify two levels of account group structure and the detail account group is already associated with a summary account group table, Vision displays a warning message. This message advises you that you must remove the detail account group from the table on the Summary Account Group tab of Account Group Tables.
|
| Sort Order
|
Enter a number to set the order in which detail account groups display on reports.
|
| Account Group Name
|
From the drop-down list, select a detail account group name. This name displays as a label on general ledger reports.
|
| Exclude from Report Total
|
Select this option to define subtotals on general ledger reports without those subtotals impacting the bottom line or the report totals. 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. For example, you can create an account group for the sum of current assets less current liabilities, but this account must not impact the total Assets or Total Liabilities on the Balance Sheet.
Do not select this option if you want accounts to impact the bottom line and be included in report totals.
This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.
|
| Show Account Detail
|
By account group, you specify whether the account number or name displays on general ledger reports. Select one of the following settings from the drop-down list:
-
Yes — Select this setting for the account number or name to display 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 on the report's Sorting/Grouping tab.
-
No — Select this setting if you do not want the account number and account name to display 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 on the report's Sorting/Grouping tab.
-
Report — Select this setting for the account name and number to display on the report if you select them on the Sorting/Grouping tab for the report.
This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.
|
| Subtotal
|
This option is available only if you set the
Show Account Detail option to
Yes. If you set
Show Account 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 all the accounts associated with the account group; 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 it on the Sorting/Grouping tab for the report.
This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.
|
Accounts in Detail Account Group Names Grid
Use this grid to associate one or more accounts with each detail account group.
| Field | Description |
|---|
| Insert
|
Open an account group table and click this option to insert an account or range of accounts for the detail account group table.
|
|
Delete
|
Open an account group table, select a line, and click this option to remove the account from the detail account group table.
|
| Start Account
|
Enter the starting account number for the account group, or click
Search to select the account on the Account Lookup.
For each account group, you can specify either a single account number or a range of account numbers:
- To specify a single account number, enter the same account number in the
End Account field, so your start account and end account are identical.
- To specify a range, enter an end account number that is greater than the start account number.
|
| End Account
|
Enter the ending account number for the account group, or click
Search to select the account on the Account Lookup.
For each account group, you can specify either a single account number or a range of account numbers:
- To specify a single account number, enter the same account number that you entered in the
Start Account field, so your start account and end account are identical.
- To specify a range, enter an end account number that is greater than the start account number.
|
