Drilling Down to Oracle Receivables from Oracle General Ledger

From General Ledger, you can drill down to subledger details from the Account Inquiry, Enter Journals, or Journal Entry Inquiry windows for journals that have specific journal sources assigned to them. For example, if a journal source is Receivables, you can drill down to the transaction details in Oracle Receivables.

Depending on the nature of the originating Receivables transaction, drilling down from General Ledger opens the Payables Invoice Accounting, Payables Payment Accounting, or Receivables Adjustment Accounting window.

The first time you open one of these windows, the following information will be displayed:

Column Name Transaction Receipt Adjustment
Account X X  
Adjustment Class     X
Adjustment Date     X
Adjustment Num     X
Applied Date   X  
Bank Account   X  
Credit X X X
Curr Conversion Rate X X X
Customer X X X
Debit X X X
Deposit Date   X  
Detail Line Num X    
Entered Credit X X X
Entered Curr X X X
Entered Debit X X X
Item X    
Item Description X    
Line Type X X X
Receipt Method   X  
Quantity X    
Receipt Date   X  
Receipt Num   X  
Reversal Date   X  
Tax Code X X X
Tax Rate X    
Transaction Date X    
Transaction Line Num X    
Transaction Line Type X    
Transaction Num X X  
Transaction Type X    
Unit Price X    
UOM X    

When you select a detailed accounting line, Oracle Receivables displays the following information at the bottom of the related window:

For Transactions: Transaction Class, Accounting Rule, Document Seq Num, Comments, Transaction Source, Accounting Date

For Receipts: Transaction Curr, Transaction Num, Document Seq Num, Comments, Receipt Curr, Accounting Date

For Adjustments: Adjustment Class, Transaction Num, Comments, Document Sequence, Adjustment Type, Accounting Date

Customizing the Drilldown Windows

The drilldown windows are folders. You can easily customize the information that is displayed in the windows.

See: Customizing the Presentation of Data in a Folder.

When customizing the drilldown windows, you can hide the columns that normally appear in the windows and you can choose to display any additional columns that are available.

Following is a list of all the hidden columns that you can choose to display:

Column Name Transaction Receipt Adjustment
Account     X
Account Description X X X
Accounting Date X X X
Accounting Rule X    
Activity Name     X
Adjustment Creation Type     X
Adjustment Type     X
Applied Date X    
Applied to Invoice Curr X    
Applied to Invoice Date X    
Applied to Invoice Line Num X    
Applied to Invoice Line Type X    
Applied to Invoice Num X    
Bill to Customer Name     X
Cash Receipt Date     X
Cash Receipt Num     X
Chargeback Num     X
Comments X X X
Curr Conversion Date X X X
Curr Conversion Type X X X
Customer Num X X X
Customer Site X X X
Distribution Set   X  
Document Seq Name X X X
Document Seq Num X X X
Entered Taxable Credit   X X
Entered Taxable Debit   X X
Line Reference X X X
Receipt Class   X  
Receipt Curr   X  
Reversal Comments   X  
Reversal Curr   X  
Sales Order Num X    
Sales Rep X    
Tax Exemption Num X    
Taxable Credit   X X
Taxable Debit   X X
Transaction Class X    
Transaction Date   X X
Transaction Line Num   X  
Transaction Line Type   X  
Transaction Num     X
Transaction Source X    
Transferred to GL X X X

Drilling Down Further

From the Payables Invoice Accounting, Payables Payment Accounting, or Receivables Adjustment Accounting window, you can drill down even further to view detail transactions or you can choose to view the underlying transaction accounting.

To drill down to detail transactions or to view transaction accounting:

  1. From the Payables Invoice Accounting, Payables Payment Accounting, or Receivables Adjustment Accounting window, select a detail accounting line.

  2. Choose the Show Transaction button to view detail transactions.

  3. Choose the Show Transaction Accounting button to view the transaction accounting.

Related Topics