Menu Path: General Ledger Inquiries Consolidation Account Inquiry
View cross references for accounts between ledgers.
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.
To use Consolidation Account Inquiry:
In the Source Filter Options section, select criteria for the source ledger accounts for which to display cross references.
In the Destination Filter Options section, select criteria for the destination ledger accounts for which to display cross references.
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.
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. |
Field or Button |
Description |
Select this check box to display source accounts for all ledgers. This check box is cleared by default. |
|
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. |
|
Select this check box to display source accounts for all account types. This check box is selected by default. |
|
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. |
|
Select this check box to display source accounts for all account categories. This check box is selected by default. |
|
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. |
|
Select this check box to display source accounts for all consolidation groups. This check box is selected by default. |
|
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. |
|
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. |
|
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. |
|
Select whether to display source accounts with no cross references, or to only display source accounts with no cross references. |
|
Select this check box to display destination accounts for all ledgers. This check box is selected by default. |
|
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. |
|
Select this check box to display destination accounts for all account types. This check box is selected by default. |
|
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. |
|
Select this check box to display destination accounts for all account categories. This check box is selected by default. |
|
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. |
|
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. |
|
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. |
|
Select whether to display destination accounts with no cross references, or to only display destination accounts with no cross references. |
Field or Button |
Description |
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. |