Performing Consolidated Balance Inquiries
From your consolidated parent set of books, you can drill down to account balances, review consolidation journal entries, drill down further to your subsidiary sets of books, review subsidiary account balances, then drill down further to subsidiary journal entries and even to your subsidiaries' subledger details.
For example, while analyzing total consolidated sales, you may want to determine how much each subsidiary contributed to the total amount. Simply drill down from the consolidated sales balance to any subsidiary sales account balance. From there, you can view account details and journals. If you need still more information, drill down further to the subledger transactions that contributed to your total consolidated sales balance.
To perform a consolidated balance inquiry:
2. Choose the Show Journal Details button to drill down to the Journals window.
3. Select a consolidation journal batch whose details you want to review. Note: Look for journal batches with Consolidation as the journal source.
4. Choose the Drilldown to {subsidiary set of books name} button to view the Consolidation Drilldown window. The window displays information about the subsidiary balance that was consolidated to the parent. The amount of information displayed will vary, depending on whether the balances or transactions consolidation method was used:
Balances Method -- includes Subsidiary set of books name, Period, Balance Type, Budget name, Currency, Currency Type, and Factor. The Transfer Details region will display the Mapping name and the Amount Type. The Account region will display each detail Account, Consolidated Amount, and other amount type amounts.
Transactions Method -- includes the mapped subsidiary Account, accounting Period, Balance Type, and Currency Type. The window also shows batch details, including Batch name, Journal Entry name, journal Source, Currency, journal Line number, Entered Debits, and Entered Credits.
Note: If your subsidiary set of books uses a currency different from your parent, General Ledger displays the translated account balances.
5. (Optional - Balances Method) Choose the Switch Amount Type button to change the other amount type amounts displayed in the Consolidation Drilldown window. When you choose the button, the column heading in the Account region will change to the amount type (YTD, QTD, etc.). Repeatedly choosing the button will cycle through the available amount types.
To review subsidiary detail journal information:
- Choose the Journal Details button from the Consolidation Drilldown window.
You see the Batch name, Journal Entry name, Source, Currency, Line, and Entered Debits and Credits for journals that effected the selected detail balance.
Note: You can customize this folder form to show the Account Inquiry information you need. Refer to the Oracle Applications User's Guide for more information on modifying and saving folder forms.
See Also
Performing an Account Inquiry
Reviewing Balances in a Detail Account Inquiry
Drilling Down to Journal Detail
Drilling Down to Oracle Payables Detail
Drilling Down to Oracle Receivables Detail
Global Consolidation System