Consolidation Group Maintenance

Menu Path: General Ledger Images\bluerarw.gif Accounts Images\bluerarw.gif Setup Images\bluerarw.gif Consolidation Group Maintenance

Purpose

Set up and maintain consolidation groups.

Overview

Use Consolidation Group Maintenance to view, create, edit, and delete consolidation groups, which are groups of general ledger accounts in a ledger, which are grouped together for consolidation purposes.

Note Each general ledger account can only be included in one consolidation group.

Creating Consolidation Groups

To create a consolidation group:

  1. Verify the ledger in the Ledger ID field is the ledger for which you want to create a consolidation group.

  2. Click the New button in the ribbon.

  3. Enter an ID for the consolidation group in the Group ID field.

  4. Select filter criteria for accounts you want to display, and then click the Show Data button in the ribbon. The Accounts Available grid displays accounts that meet the filter criteria.

  5. Select an account in the Accounts Available grid, and click the Add button to add the account to the consolidation group. Repeat this for all the accounts you want to add to the consolidation group.

  6. Click the OK button in the ribbon. The consolidation group is created.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Consolidation Group Maintenance window. This button is only available if you are not creating, editing, or deleting a consolidation group.

New

Click this button to create a new consolidation group. This button is only available if you are not creating, editing, or deleting a consolidation group.

Update

Click this button to update the selected consolidation group. This button is only available if you are not creating, editing, or deleting a consolidation group.

Delete

Click this button to delete the selected consolidation group. This button is only available if you are not creating, editing, or deleting a consolidation group.

OK

Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon.

Cancel

Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon.

Show Data

Click this button to display accounts based on the selected criteria. This button is only available after you click the New or Update button in the ribbon.

First

Click this button to display the first consolidation group. This button is only available if you are not creating, editing, or deleting a consolidation group.

Prev

Click this button to display the previous consolidation group. This button is only available if you are not creating, editing, or deleting a consolidation group.

Next

Click this button to display the next consolidation group. This button is only available if you are not creating, editing, or deleting a consolidation group.

Last

Click this button to display the last consolidation group. This button is only available if you are not creating, editing, or deleting a consolidation group.

Fields and Buttons

Field or Button

Description

Group ID

Enter a consolidation group ID, or click the Lookup button to select an existing consolidation group ID.

Ledger ID

Enter a ledger ID for the consolidation group, or click the Lookup button to select a ledger ID.

Main Tab Fields and Buttons

Field or Button

Description

All Categories

Select this check box to display accounts in all account categories. This check box is selected by default.

From (Category)

Enter an account category for which to display accounts, or click the Lookup button to select and account category. If you want to display accounts for a range of categories, enter the first category in the range. This field is only enabled if you clear the All Categories check box.

To (Category)

Enter the last account category in a range of account categories for which to display accounts, or click the Lookup button to select an account category. If you only want to display accounts for a single account category, you can leave this field blank. This field is only enabled if you clear the All Categories check box.

All Types

Select this check box to display accounts in all account types. This check box is selected by default.

From (Type)

Enter an account type for which to display accounts, or click the Lookup button to select an account type. If you want to display accounts for a range of account types, enter the first account type in the range. This field is only enabled if you clear the All Types check box.

To (Type)

Enter the last account type in a range of account types for which to display accounts, or click the Lookup button to select an account type. If you only want to display accounts for a single account type, you can leave this field blank. This field is only enabled if you clear the All Types check box.

Accounts Available

This grid displays available accounts based on the selected criteria after you click the Show Data button in the ribbon. Double-click an account to add it to the selected consolidation group if you are creating or editing a consolidation group.

Note This grid is cached to improve performance. You cannot sort, filter, group, graph, or summarize data in this grid.

Add

Click this button to add the account selected in the Accounts Available grid to the Accounts Selected grid.

Add All

Click this button to add all accounts in the Accounts Available grid to the Accounts Selected grid.

Remove

Click this button to remove the selected account from the Accounts Selected grid.

Remove All

Click this button to remove all accounts from the Accounts Selected grid.

Accounts Selected

This grid displays accounts selected for the consolidation group. Double-click an account to remove it from the selected consolidation group if you are creating or editing a group.

Note This grid is cached to improve performance. You cannot sort, filter, group, graph, or summarize data in this grid.