Use the Invoice on Hold Report to identify invoices on hold. The report provides you the total number and amount (in your ledger currency) of invoices on hold, which can be helpful for your accounts payable metrics. Run the Invoice Validation process before submitting this report to obtain the most up-to-date hold information. To obtain additional detail and help research invoices on matching hold, you can use the Matching Detail Report or the Matching Hold Detail Report.
The Invoice on Hold Report is divided into four sections:
The first section gives you information about all invoices that have a hold name assigned to them.
If the hold on the invoice is related to the invoice being matched to a purchase order, then the report shows the purchase order number.
If the hold is related to one or more invalid distribution account number(s) and the parameter Display Invalid Account Number is set to Yes, each unique invalid account number will be shown in the Description column.
Payables subtotals the invoices on hold by hold name or supplier, depending on how you choose to order the report.
The second and third sections of the report print only if you do not specify a hold name for the Hold Name parameter. These two sections show invoices held for payment at the scheduled payment or supplier site level. These holds do not cause a hold name to be placed on the invoice.
The Invoices with Scheduled Payment Holds section lists invoices with one or more scheduled payments on hold.
The Invoices with Supplier Site Set to Hold All Payments section, lists invoices held and the site name where the hold condition is set.
The fourth section, Invoice Hold Name Descriptions, lists all predefined and user-defined hold names and their descriptions, and it shows whether the hold allows accounting. This section serves as a reference for understanding holds placed on your invoices.
You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Hold Name. If you want to review only invoices with a specific hold applied, enter the name. Leave this parameter blank if you want the report to include the Invoices with Scheduled Payment Holds section and the Invoices with Supplier Site Set to Hold All Payments section.
Order By. This parameter controls the sorting for the first report section. You can choose to sort and subtotal by hold or supplier.
On Hold by Period Option. Enter Yes to subtotal the invoices by the period of their invoice date.
From/To Entered Date. Payables displays invoices with holds that were applied on and between the From Entered Date and the To Entered Date.
Include Due or Discount Date. The report includes invoices that have a due or discount date within a range you specify, using the From/To Due or Discount Date parameters.
Due. Payables lists only invoices that have a due date within the range you specify.
Discount. Payables lists only invoices that have a discount date within the range you specify.
Include Hold Descriptions. Change this parameter to No if you do not want to include the last section of the report as a reference of hold descriptions.
Display Invalid Account Number. Change this parameter to Yes if you would like to see each unique invalid account combination displayed in the description column for each invoice.
PO Number. If the hold on the invoice is related to the purchase order match, then Payables displays the purchase order number.
Functional Currency Original Amount. Invoice amount expressed in your ledger currency. No value appears if the invoice is in a foreign currency and does not have an exchange rate.
Functional Currency Amount Remaining. Remaining amount due for payment on an invoice, expressed in your ledger currency. The amount remaining is equal to the original amount, unless you partially paid an invoice. No value appears if the invoice is in a foreign currency and does not have an exchange rate.