Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Performing an Average Balance Inquiry

Performing Consolidated Balance Inquiries

From your consolidated parent ledger, you can drill down to account balances, review consolidation journal entries, drill down further to your subsidiary ledger, 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.

Note: Drilling down on balance level secondary ledgers is the same as drilling down on consolidated balances because consolidation is used to transfer balances to balance-level secondary ledgers.

From your balance level secondary ledger, you can drill down to account balances, review consolidation journal entries, and drill down further to your source representation’s journal entries and subledger details.

To perform a consolidated balance inquiry:

  1. Perform an account inquiry in your consolidated parent ledger. See: Performing an Account 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 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 ledger name, Period, Balance Type, Budget name, Currency, Currency Type, and Factor. The Transfer Details region will display the Consolidation 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 ledger 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 affected the selected detail balance.

Note: You can customize this folder form to show the Account Inquiry information you need. Refer to the Oracle E-Business Suite User’s Guide for more information on modifying and saving folder forms.

Related Topics

Performing an Account Inquiry

Reviewing Balances in an Account Inquiry

Drilling Down to Journal Detail

Drilling Down to Oracle Subledger Detail

Global Consolidation System