Consolidation Account Inquiry

Menu Path: General Ledger Images\bluerarw.gif Inquiries Images\bluerarw.gif Consolidation Account Inquiry

Purpose

View cross references for accounts between ledgers.

Overview

Use Consolidation Account Inquiry to display ledger cross references for general ledger accounts, or to display accounts for which cross references are not yet set up.

Using the Inquiry

To use Consolidation Account Inquiry:

  1. In the Source Filter Options section, select criteria for the source ledger accounts for which to display cross references.

  2. In the Destination Filter Options section, select criteria for the destination ledger accounts for which to display cross references.

  3. Click the Show Data button in the ribbon. The Results tab displays account cross reference information based on the criteria selected in steps 1 and 2.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Consolidation Account Inquiry window.

Show Data

Click this button to display account cross reference information on the Results tab, based on the criteria selected on the Selection tab.

Selection Tab Fields and Buttons

Field or Button

Description

All Ledgers (Source)

Select this check box to display source accounts for all ledgers. This check box is cleared by default.

Source Ledger ID

Enter a ledger ID for which to display source accounts, or click the Lookup button to select a ledger ID. This field is only enabled if the All Ledgers check box in the Source Filter Options section is cleared.

All Types (Source)

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

Account Type (Source)

Enter an account type for which to display source accounts, or click the Lookup button to select an account type. This field is only enabled if you clear the All Types check box in the Source Filter Options section.

All Categories (Source)

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

Category (Source)

Enter an account category for which to display source accounts, or click the Lookup button to select an account category. This field is only enabled if you clear the All Categories check box in the Source Filter Options section.

All Groups

Select this check box to display source accounts for all consolidation groups. This check box is selected by default.

Group

Enter a consolidation group for which to display source accounts, or click the Lookup button to select a consolidation group. This field is only enabled if you clear the All Groups check box. For information on setting up consolidation groups, see Consolidation Group Maintenance.

From (Source)

Enter a source account you want to display, or click one of the Lookup buttons to select a source account. If you want to display a range of source accounts, enter the first account in the range. These fields are only enabled if the All Ledgers check box in the Source Filter Options section is cleared.

To (Source)

Enter the last source account in a range of source accounts you want to display, or click one of the Lookup buttons to select a source account. If you only want to display a single source account, you can leave these fields blank. These fields are only enabled if the All Ledgers check box in the Source Filter Options section is cleared.

Display Options (Source)

Select whether to display source accounts with no cross references, or to only display source accounts with no cross references.

All Ledgers (Destination)

Select this check box to display destination accounts for all ledgers. This check box is selected by default.

Destination Ledger ID

Enter a ledger ID for which to display destination accounts, or click the Lookup button to select a ledger ID. This field is only enabled if you clear the All Ledgers check box in the Destination Filter Options section.

All Types (Destination)

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

Account Type (Destination)

Enter an account type for which to display destination accounts, or click the Lookup button to select an account type. This field is only enabled if you clear the All Types check box in the Destination Filter Options section.

All Categories (Destination)

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

Category (Destination)

Enter an account category for which to display destination accounts, or click the Lookup button to select an account category. This field is only enabled if you clear the All Categories check box in the Destination Filter Options section.

From (Destination)

Enter a destination account you want to display, or click one of the Lookup buttons to select a destination account. If you want to display a range of destination accounts, enter the first account in the range. These fields are only enabled if you clear the All Ledgers check box in the Destination Filter Options section.

To (Destination)

Enter the last destination account in a range of destination accounts you want to display, or click one of the Lookup buttons to select a destination account. If you only want to display a single destination account, you can leave these fields blank. These fields are only enabled if you clear the All Ledgers check box in the Destination Filter Options section.

Display Options (Destination)

Select whether to display destination accounts with no cross references, or to only display destination accounts with no cross references.

Results Tab Fields and Buttons

Field or Button

Description

Accounts

This grid displays account cross reference information after you click the Show Data button in the ribbon, based on the criteria selected on the Selection tab.