Payables Unaccounted Transactions and Sweep Report
Identify and review all unaccounted invoice and payment transactions and the reasons why they can't be accounted. You can also specify to sweep unaccounted transactions to another period.
You can run this report from the Scheduled Processes work area.
Before running this report:
-
Validate invoices to reduce the number of unvalidated invoices on the report.
-
Create payables accounting entries. The report then shows only problem transactions that couldn't be accounted. You can correct the problems, and resubmit the create accounting process.
-
If you use bills payables, submit the Update Matured Bills Payable Status process. The process updates the status of any bills payable with a maturity date on or before today's date.
Parameters
If you don't specify a value for the Period Name or Accounting Date parameters, the report lists all unaccounted entries, regardless of date.
Report Level
Select Ledger or Business unit.
Report Context
The values for this parameter are based on the Report Level parameter.
-
If the Report Level is Business unit, select a business unit.
-
If the Report Level is Ledger, select a ledger.
From Accounting Date, To Accounting Date
To run the report for a particular date range, enter both the first and last dates in the range.
Period
To run the report for a single period, enter the period name.
Sweep Now
Specify whether to sweep unaccounted transactions to another period.
-
Yes: Sweeps unaccounted transactions.
-
No: Only reports exceptions.
Sweep to Period
If the Sweep Now parameter is set to Yes, specify an open or future period. The accounting date for unaccounted transactions is updated to the first date of the period that you specify.
Report Results
All amounts are reported in the entered currency.
The report has the following sections:
-
Unaccounted Invoices: Lists the supplier, supplier number, invoice number, invoice date, entered currency, invoice amount, purchase order number (if an invoice has matching-related holds), and the exception.
Note:The report also lists incomplete supplier portal invoices that the supplier didn't submit yet.
-
Unaccounted Payments: Lists the supplier, supplier number, payment number, payment date, payment currency, payment amount, and exception.
This table describes some invoice and payment exceptions.
Exception |
Description |
---|---|
Distribution combination invalid |
The distribution combination on the invoice isn't valid. |
Distribution variance |
The total of the invoice distributions doesn't equal the invoice amount. |
Other hold names |
The invoice has a hold that prevents accounting. |
No rate |
The payment doesn't have a conversion rate. |
Not validated |
The invoice or distribution line isn't validated. |
Unaccounted |
The invoice or distribution line is unaccounted. |
Withholding tax |
The invoice distribution has a withholding tax group and tax can't be withheld, so a withholding tax hold was applied to the invoice. Several conditions can cause this hold including the following:
|
The report excludes invoices without distributions.