Matching Hold Detail Report (Oracle Payables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Matching Hold Detail Report

Use the Matching Hold Detail Report to review detailed accounts payable and purchasing information for invoices with matching holds and matching hold releases. You can print this report before initiating a payment batch to determine whether to manually release any invoices for payment. You can print this report for all invoices with matching holds and releases during a time period you specify, or you can print this report to review only invoices with matching holds applied or released since the last time you submitted Approval.

This report can assist you in identifying suppliers that frequently have invoices on matching hold. This report can also help you to respond to supplier questions on delayed payments.

Attention: You must install and implement Purchasing before you can submit this report. In addition, we suggest you enter purchase orders in Purchasing, match invoices to the purchase orders, and approve the invoices before you submit the report, because the report lists only invoices with matching holds and/or releases. To review invoices with matching and other types of holds, you can use the Invoice on Hold Report.

The report may display more than one match status for an invoice because more than one match rule can be violated. Each invoice can be matched to more than one purchase order line, and each matching hold can have a release reason.

Payables displays the match status and detail invoice information. For example, a matching status of Qty Ord means that the quantity billed exceeds the quantity ordered. Payables displays both these quantity amounts so you can identify the variance. If a hold exists on one or more purchase order lines, the invoice status is HELD. If all holds have been released, the invoice status is RELEASED.

The Matching Hold Detail Report also provides you with a listing of matching status and matching release codes with descriptions.

Report Submission

You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

Selected Report Parameters

Matching Hold Status. Enter the Matching Hold Status for the invoices you want to review in this report.

Hold. Print this report only for invoices on matching hold.

Release. Print this report only for invoices released from matching hold.

Null. Print this report for all invoices, regardless of whether they are held or released.

If you select Release or leave this field blank, the report includes matched invoices that you have cancelled. Cancelled invoices have a Matching Hold Status of Released. Payables displays zero for the invoice amount of a cancelled invoice.

Supplier Name. If you want to limit the report to one supplier's invoices, enter the supplier name.

Active Period Start/End Date. Payables lists the invoices with matching holds and releases created or updated on or between the Active Period Start Date and Active Period End Date.

Matching Hold Detail Report

All Approvals. Payables prints all invoices with matching holds and releases with invoice dates in the range between the Active Period Start Date and the Active Period End Date.

Selected Report Headings

Description. Partial description of an invoice.

Batch Name. If you use the Batch Control Payables option, Payables prints the name of the invoice batch for an invoice.

Invoice Amount. Amount of invoice. If it is a foreign currency invoice, Payables prints the invoice amount in the foreign currency.

Invoice Status. The status is Held for an invoice on matching hold. The status is Released for an invoice released from all matching holds.

Line. Purchase order line number.

Release. Release number if a line is a blanket purchase order line. A release is a subset of a blanket purchase order. It is a set of shipments for specific goods or services that you request from a supplier. You enter the release number when you enter a blanket purchase order.

Location. Ship-to location of a purchase order shipment.

Item Number. Item number from a purchase order line. You can use this information to compare items ordered with items billed.

Description. Description of the item from the purchase order line. You can use this information to compare items ordered with items billed.

Tax Code - P.O./Invoice. Tax name of the purchase order/invoice. Payables compares the tax name of the purchase order with the tax name of the matched invoice. If they are not the same, Payables applies a Tax Diff matching hold to the invoice.

Currency - P.O./Inv. The currency of a purchase order. Payables compares the currency of the purchase order with the currency of the matched invoice. If they are not the same, Payables applies a Currency matching hold to the invoice.

Attention: Payables only allows matching an invoice to a purchase order of the same currency. So, you should never have a currency matching hold.

Unit. Unit of measure in which the item on a purchase order line was ordered.

Unit Price - P.O./Invoice. Unit price of the item from the purchase order line/invoice. Payables compares the unit prices for a purchase order and matched invoice and applies a Price hold to an invoice distribution if the invoice unit price exceeds the purchase order unit price by more than the tolerance level you allow.

Quantity - Ordered/Received/Billed/Accepted. Quantity details for a purchase order detail line. You can compare the quantity ordered with the quantity received, quantity billed, and quantity accepted.

Payables uses the quantity received for 3-way matching only if you require receipt for a purchase order shipment. Payables uses the quantity accepted for 4-way matching only if you require inspection for a purchase order shipment.

Match Status. Status of the match:

Held Status:

If the invoice status is Held and the invoice line is on matching hold, the match status may be one of the following:

Can't Close PO. Cannot close the purchase order before the shipment is fully delivered. Approval applies this hold if you enable the Final Matching Payables option.

Currency Difference. Invoice currency differs from the purchase order currency.

Final Matching. You are trying to match to a purchase order that was permanently closed by final matching.

Matching Required. The invoice is not matched to a purchase order, although the supplier site on the invoice requires matching.

Max Qty Ord. Quantity billed exceeds quantity ordered by tolerance amount.

Max Qty Rec. Quantity billed exceeds quantity received by tolerance amount.

Max Rate Amount. Exchange rate variance between purchase order and invoice exceeds tolerance amount limit.

Max Ship Amount. Variance between invoice and shipment amount exceeds tolerance amount limit.

Max Total Amount. Sum of invoice and exchange rate variances exceeds tolerance amount limit.

PO Not Approved. The purchase order is not approved. This could occur if someone updates a purchase order after an invoice is matched to a purchase order.

Price. Invoice price exceeds purchase order price.

Qty Ord. Quantity billed exceeds quantity ordered by tolerance percentage.

Qty Rec. Quantity billed exceeds quantity received by tolerance percentage.

Quality. Quantity billed exceeds quantity accepted.

Rec Exception. Purchasing enables a receipt exception flag on a purchase order shipment you match to.

Tax Difference. Invoice tax name differs from the purchase order tax name. If the purchase order shipment is non-taxable and is matched to an invoice distribution that has a tax, Payables also applies this hold.

RELEASED Status:

If the invoice status is Released, the match status may be:

Matched. Passed matching condition during Approval.

You can optionally define your own release reasons using the Invoice Approvals window. You can also manually release any matching hold using the Invoice Holds window or the Invoice Actions window. If you manually release a matching hold, the match status may be:

Match Override. You manually release any matching hold.

Invoice Quick Released. You released all holds from one or more invoices using a QuickRelease reason.

Holds Quick Release. You released all holds from a particular invoice by using a QuickRelease reason.