This report, in conjunction with the Account Analysis report in Oracle General Ledger, provides information needed to reconcile your accounts receivable subledger with the General Ledger. Using this report you can review the details that make up your general ledger journal entries.
This report selects all transactions that will be posted to the General Ledger (i.e. associated transaction type has Post to GL set to Yes).
The Journal Entries report displays:
Details of what is or will be posted to each GL account for a specific period
Journals by receivables categories
Receivables provides you with four different parameters that enable you to generate multiple formats for this report:
Print Detail by Category
Print Detail by Account
Print Summary by Category
Print Summary by Account
Select one or more formats. If you select each parameter, then Receivables prints four different reports in one report submission.
If Multiple Reporting Currencies (MRC) is enabled you can run this report for a reporting currency.
Use the following journal entries reports to confirm that account balances match the appropriate registers:
Sales Journal
These specific journals ensure that you access only the data that you need during reconciliation activities.
If reports are submitted in Receivables Mode, then only the journals for the selected category (AR) are displayed and the total will match the related value on the AR Reconciliation report. If not, then all categories will print.
Note: See also: Common Report Parameters for Reconciliation Reports.
Print Detail By Category: Print each transaction for each category and its "Receivables" equivalent GL account and currency.
Print Detail By Account: Print each transaction for each GL account, category, and currency.
Transaction Category: Choose to select and print information for the transaction categories that you specify.
Transaction categories include: Sales Invoices, Debit Memos, Chargebacks, Credit Memos, Credit Memo Applications, Adjustments, Trade Receipts, Miscellaneous Receipts, and Bills Receivable.
Or, run specific journal reports. See: Using Specific Journal Entries Reports.
Exclude Rounding Equals Zero: If this option is Yes, then the report does not print journal entries that impact rounding accounts and have a balance of zero.
Currency: The currency that you chose to generate the report.
GL Date: The GL Date range that you specify for this report.
Posted Date: The GL Posted Date range that you specify for this report.
Accounting Flexfield: Receivables prints each Accounting Flexfield that is referenced by a category that you include in this report.
Category: Categories include Cash, Misc Receipts, Debit Memos, Credit Memos, Adjustments, Sales Invoices and Trade receipts.
Currency: The currency for the sum in that currency of each Accounting Flexfield that is referenced by a category that you include in this report.
Foreign Currency: Credits: The foreign currency credit amount for each Accounting Flexfield that is referenced by a category that you include in this report.
Foreign Currency: Debits: The foreign currency debit amount for each Accounting Flexfield that is referenced by a category that you include in this report.
Functional Currency: Debits: The functional currency debit amount for each Accounting Flexfield that is referenced by a category that you include in this report.
Functional Currency: Credits: The functional currency credit amount for each Accounting Flexfield that is referenced by a category that you include in this report.
Total Receivables: The total functional currency debit and credit amounts for the Receivables account.
Total for Category: The total functional currency debit and credit amounts for each category of transactions selected for this report. Oracle Receivables does use the sums of an Accounting Flexfield that are referenced by categories that you select to calculate the total functional currency debit and credit amounts for this report if this Accounting Flexfield contains a sum in only one currency.
Total for Currency: The total functional currency debit and credit amounts for each currency of transactions that you select for this report.
Category: Categories include Cash, Misc Receipts, Debit Memos, Credit Memos, Adjustments, Invoices and Trade receipts.