You can drill down from an account balance to view the details of the journals that comprise the account balance.
Subledger Drilldown: When you are reviewing balances in a ledger, you can drill down to Oracle Subledger Accounting and the original subledger transaction. The subledger source must have the Import Journal References flag enabled in the Journal Sources window when it was transferred to General Ledger.
Consolidated Balance Drilldown: When you are reviewing consolidated balances in a parent ledger, you can drill down to view your subsidiaries' General Ledger journal detail. You can even drill further to the original subledger transaction in the subsidiary ledger.
Translated Balance Drilldown: When you are reviewing translated balances by specifying a balance-level reporting currency and the Total Currency Type, you can drill down to view the journal details of the source ledger. This enables you to view the entered balances and journal amounts that were used to create the translated balances without having to requery from the source ledger directly.
Reporting Currency Drilldown: When reviewing balances that have been converted automatically to your reporting currencies, you can drill down to see the journal amounts entered and posted in the source ledger, such as the primary or secondary ledger.
Secondary Ledger Drilldown: When reviewing balances that have been transferred to your journal-level and subledger-level secondary ledger, you can drill down to see the journal amounts entered and posted in the primary ledger.
Note: If drilling down on a journal level secondary ledger that uses a journal level reporting currency as its source representation, you can drill down from the secondary ledger to the reporting currency and then to the original journal entered in the primary ledger.
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. For more information on drilling down on consolidated balances, see Performing Consolidated Balance Inquiries.
Prerequisite
Perform an account inquiry for a ledger or ledger set, then drill down to the Detail Balances window. See: Overview of Account Inquiry
From the Detail Balances window, select the detail balance row whose journal details you want to review.
Choose the Journal Details button.
You see the Batch name, Journal Entry name, Source, Currency, Line, and Entered Debits and Credits for all journals that contributed to the selected detail balance.
Select the journal whose detail you want to review.
Choose one of the following buttons:
Drilldown: Choose this button to drill down to Oracle subledger applications or to the subsidiary ledger. For Subledger drilldown, you can review the subledger transactions that comprise the journal. This button is only enabled if the following exists:
The journal originated from an Oracle subledger application that uses Oracle Subledger Accounting (SLA).
The subledger application is installed. See: Drilling Down to Subledger Detail.
The Import Journal References flag is enabled for the subledger source in the Journal Sources window.
See: Drilling Down to Subledger Detail.
For Consolidation drilldown, you can drill down from a consolidation journal batch to your subsidiary's General Ledger. From the subsidiary's General Ledger, you can drill down further to review the subsidiary's journal details and subledger transactions.
See: Performing Consolidated Balance Inquiries
Show Full Journal: Choose this button to drill down to the Journals window to view the full journal entry.
Detail Balance: Choose this button to return to the Detail Balances window.