Menu Path: General Ledger Accounts Setup Consolidation Group Maintenance
Set up and maintain consolidation groups.
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.
To create a consolidation group:
Verify the ledger in the Ledger ID field is the ledger for which you want to create a consolidation group.
Click the New button in the ribbon.
Enter an ID for the consolidation group in the Group ID field.
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.
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.
Click the OK button in the ribbon. The consolidation group is created.
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. |
Field or Button |
Description |
Enter a consolidation group ID, or click the Lookup button to select an existing consolidation group ID. |
|
Enter a ledger ID for the consolidation group, or click the Lookup button to select a ledger ID. |
Field or Button |
Description |
Select this check box to display accounts in all account categories. This check box is selected by default. |
|
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. |
|
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. |
|
Select this check box to display accounts in all account types. This check box is selected by default. |
|
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. |
|
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. |
|
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. |
|
Click this button to add the account selected in the Accounts Available grid to the Accounts Selected grid. |
|
Click this button to add all accounts in the Accounts Available grid to the Accounts Selected grid. |
|
Click this button to remove the selected account from the Accounts Selected grid. |
|
Click this button to remove all accounts from the Accounts Selected grid. |
|
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. |