When you query a invoice, payment, or adjustment in Oracle Receivables, you can choose to view the detail accounting lines for the queried transaction in the form of a balanced accounting entry (i.e., debits equal credits). You can also choose to view the detail accounting as t-accounts. Use these features to see how a transaction affects the account balances in your general ledger.
Query the invoice, payment, or adjustment for which you want to view accounting lines.
Note: Transactions include invoices, debit/credit memos, chargebacks, deposits, and guarantees. Receipts include cash or miscellaneous receipts.
Choose View Accounting from the Tools menu.
The View Invoice Accounting, View Payment Accounting, or View Adjustment Accounting window appears, depending on whether you queried an invoice, payment, or adjustment.
See: View Accounting Windows.
(Optional) If your organization uses Multiple Reporting Currencies, choose the Alternate Currency button to view the accounting using an alternate currency. For example, if you are viewing the accounting in your primary functional currency (e.g., BEF), you can switch to EUR (reporting functional currency).
From the poplist that appears after you choose the Alternate Currency button, choose the ledger whose transactions you want to view. The View Invoice Accounting, View Payment Accounting, or View Adjustment Accounting window changes to reflect amounts in the appropriate currency for the chosen ledger.
(Optional) To view the accounting detail as t-accounts, choose the T-Accounts button.
See: T-Accounts.
The first time you open the View Invoice Accounting, View Payment Accounting, or View Adjustment Accounting windows, the following information will be displayed for the detailed accounting lines:
| Column Name | Transaction | Receipt | Adjustment |
|---|---|---|---|
| Account | X | X | X |
| Applied Date | X | ||
| Credit | X | X | X |
| Curr Conversion Rate | 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 |
| Quantity | X | ||
| Reversal Date | X | ||
| Tax Code | X | X | X |
| Tax Rate | X | ||
| Trans Line Num | X | ||
| Trans Line Type | X | ||
| Trans Num | 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 View Accounting window:
For Transactions: Account Description, Accounting Rule, Comments, Accounting Date, Transferred to GL
For Receipts: Account Description, Transaction Num, Comments, Accounting Date, Transferred to GL
For Adjustments: Account Description, Transaction Num, Comments, Accounting Date, Transferred to GL
The View Invoice Accounting, View Payment Accounting, and View Adjustment Accounting 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 View Accounting 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 Description | X | X | X |
| Accounting Date | X | X | X |
| Accounting Rule | X | ||
| Activity Name | X | X | |
| Adjustment Class | X | ||
| Adjustment Creation Type | X | ||
| Adjustment Date | X | ||
| Adjustment Num | X | ||
| Adjustment Type | 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 | ||
| Bank Account | 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 | X | X | X |
| Customer Num | X | X | X |
| Customer Site | X | X | X |
| Distribution Set | X | ||
| Document Seq Name | X | X | |
| Document Seq Num | X | X | X |
| Document Seq Type | X | ||
| Entered Taxable Credit | X | X | |
| Entered Taxable Debit | X | X | |
| Line Reference | X | X | X |
| Receipt Method | X | ||
| Receipt Date | X | ||
| Reversal Comments | 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 | X |
| Transaction Line Num | X | ||
| Transaction Line Type | X | ||
| Transaction Num | X | X | |
| Transaction Type | X | ||
| Transferred to GL | X | X | X |