Use this report to identify and review all unaccounted invoice and payment transactions and see the reason that Payables cannot account for a transaction.
Payables sorts the report by transaction type (invoice or payment), exception, supplier, transaction currency, and transaction number.
Run this report after you create accounting entries. The report will then show only transactions that had problems that prevented accounting. You can then correct the problems and resubmit the accounting process. Note that this report does not include invoices that have no distributions.
Prerequisites
(Recommended) Validate invoices to reduce the number of unvalidated invoices on the report. See Invoice Validation.
(Recommended) If you use bills payable (future dated payments), submit the Update Matured Future Payment Status Program to update the status of any future dated payments with a maturity date on or before today's date. See: Update Matured Bills Payable Status Program.
(Recommended) Create accounting entries. See: Creating Accounting Entries in Payables.
Note: If you do not specify a value for the Period Name or From/To Accounting Date parameters, then the report lists all unaccounted entries, regardless of date.
Period Name. If you want to run the report for a single period, enter the period name. If you enter a value here, you cannot enter values in the From/To Accounting Date parameters.
From/To Accounting Date. If you want to run the report for a particular date range, then enter both the first and last dates in the range. If you enter values for a date range, then you cannot enter a value for Period Name.
The report has two sections: Unaccounted Invoices, and Unaccounted Payments. All amounts are in the transaction currency.
Unaccounted Invoices: This section of the report lists the supplier name, supplier number, invoice number, voucher number, invoice date, invoice currency, invoice amount, purchase order number (if the invoice is on a purchase order matching related hold), and the exception.
Unaccounted Payments: This section of the report lists the supplier name, supplier number, payment number, payment date, payment currency, payment amount, and exception.
Exception. The report displays one or more of the following exception conditions for invoices and/or payments:
Dist Acct Invalid. The account on the invoice distribution is invalid.
Dist Variance. The sum of the invoice distributions is not equal to the invoice amount.
Funds Check. You are using budgetary control and Payables cannot check funds for an invoice.
Insufficient Funds. You are using budgetary control and you have insufficient funds available in your budget for an invoice.
No Rate. You have not entered an exchange rate for a foreign currency transaction.
Unaccounted. The Create Accounting process has not been submitted for the transaction.
Other Hold Names. This invoice has a hold applied to it that prevents accounting. You define holds using the Invoice Holds and Release Names window.
Unvalidated. You have not submitted Invoice Validation for the invoice.
Withholding Tax. The invoice distribution has a withholding tax group assigned to it. Payables could not withhold tax and applied a Withholding Tax hold on this invoice. Several conditions cause this hold including: the withholding tax group is inactive, a Withholding Tax type tax code within a withholding tax group is inactive, an account segment assigned to a Withholding Tax type tax code is invalid, a rate has not been defined for a Withholding Tax type tax code, a period has not been defined for a Withholding Tax type tax code, or a tax rate for a Withholding Tax type tax code has been defined using an invalid date range.