Accounts Payable Journal Entry Exception Report
Use the Accounts Payable Journal Entry Exception Report to identify and resolve all exceptions that occurred when you initiated the transfer of invoices or payments to your general ledger. Payables does not transfer an invoice or payment if one or more lines have exceptions. When you submit the Payables Transfer to General Ledger Program, Payables also provides an Accounts Payable Journal Entry Audit report, which lists detail information for the journal entries Payables successfully created.
The report provides a detailed explanation of exceptions and displays the total number of invoice distributions and invoice payments which contain exceptions. If you use Oracle Cash Management to reconcile your payments, Payables also displays reconciliation distributions which contain exceptions.
Payables divides the report into three sections:
- Invoice Distributions with Exceptions
- Invoice Payments with Exceptions
- Reconciliation Payment Distributions with Exceptions (generated only if you use Oracle Cash Management)
The Invoice Distributions section is ordered by supplier, invoice number, currency, and amount. The Invoice Payments and Reconciliation Payment Distributions sections are ordered by supplier, payment document number, currency, and amount.
Report Submission
Payables automatically prints the Accounts Payable Journal Entry Exception Report when you submit the Payables Transfer to General Ledger Program. See: Payables Transfer to General Ledger Program (Posting).
Selected Report Headings
Distribution Num/Amount/Description/GL Date
Payables prints the line number/amount/description/GL Date for an invoice distribution with an exception.
The GL Date determines the accounting period in which the transaction affects your general ledger account. Payables determines the accounting period by comparing the GL Date to the ranges of dates you have defined for your accounting periods.
Exception Code (Invoice Distributions with Exceptions)
- Disabled. The account for this distribution is disabled.
- Inactive. The account for this distribution is not active.
- Invalid. This distribution contains an invalid account.
- Period. The accounting date of the distribution or payment is in a general ledger period which is not open or future.
- Post. Posting is not permitted to the account specified in this distribution.
- Rate. This distribution is in a foreign currency and has no exchange rate information.
Exception Code (Invoice Payments with Exceptions)
- Period. The accounting date for this payment is in a general ledger period which is not open or future.
- Undist. You have enabled Automatic Offsets and a distribution on this payment was not built correctly by Payables. You can correct incorrectly built payment distributions in the GL Accounts window.
- Rate. This payment is in a foreign currency and has no exchange rate information.
Exception Code. (Reconciliation Payment Distributions with Exceptions)
- Disabled. The account for this distribution is disabled.
- Inactive. The account for this distribution is not active.
- Invalid. This distribution contains an invalid account.
- Period. The accounting date of the distribution is in a general ledger period which is not open or future.
- Post. Posting is not permitted to the account specified in this distribution.
- Rate. This distribution is in a foreign currency and has no exchange rate information.
See Also
Posting
Reconciling Payments with Oracle Cash Management
Adjusting Invoice Distributions
Updating Payments
Defining Calendars
Common Report Headings