Seven Invoices Trapped on a Quantity Hold at a New Supplier Site
Vision Operations runs three-way matching for direct materials. A new supplier site, ABC Industries–Phoenix, was created last quarter from a template that carries invoice match tolerances of 0% for quantity and 0% for amount. Buyers now route every ABC delivery through a receipt routing of 'Inspect', because the commodity team wants quality checks on machined parts before they reach the warehouse. Accounts payable reports seven invoices totaling $46,200 that have sat in 'Needs Revalidation' for eleven days with the hold name 'Qty Received'. Each invoice references a valid purchase order and an existing receipt, and the receiving clerk confirms all quantities were physically delivered to the dock. The AP supervisor proposes raising the quantity tolerance to 10% and the amount tolerance to 5% so the invoices clear, and wants your approval today. The supplier is threatening to stop shipments and month-end close begins in four days.
1. Identify the most likely root cause of the 'Qty Received' hold, and name at least three alternative causes you would rule out before changing any configuration.
Read the worked answer
Most likely cause: the receipt routing. The quantity hold is raised by the matching engine when the matched delivered receipt quantity is less than the invoiced quantity. Receipts routed to 'Inspect' land in the receiving inspection location but are not delivered, so the delivered quantity available for matching is zero or partial. The clerk confirming physical arrival does not change the receipt's delivered quantity.
Rule these out before changing configuration:
- PO line status and quantity - a closed or finally closed line, or a line quantity below the invoiced quantity, produces the same hold.
- Unit of measure mismatch - PO line in Eaches, invoice line in Cases, with a conversion that nets a short quantity.
- Reversed or duplicate receipts on the same line, so the net matched quantity is short.
- Wrong PO or line referenced on the invoice (data entry error), which leaves the intended line unmatched.
Open the invoice's matching details and compare PO quantity, received quantity, delivered quantity and invoiced quantity side by side. The gap identifies which of these applies. If received quantity is full but delivered quantity is not, routing is confirmed.
2. Evaluate the AP supervisor's proposal to raise the tolerances to 10% quantity and 5% amount, and state what you would approve instead.
Read the worked answer
Reject the tolerance change as a remedy. Tolerances govern how much variance the match will accept; they do not create delivered quantity. If the receipts are sitting in inspection, a 10% quantity tolerance only helps where the shortfall happens to fall inside 10%, and it silently accepts under-delivery on every future ABC invoice - the exact control the 0% setting was protecting. The 5% amount tolerance is unrelated to this symptom; it would start paying price variances that today are blocked, which is a second, unrequested control change.
Tolerance changes also apply going forward and require change control and audit evidence. Approving them under supplier pressure, without a documented business case, is a weak control posture.
What to approve instead:
- Correct the routing for the machined-parts category - either move it to 'Standard' receipt so goods are delivered on receipt, or keep inspection but require the inspector to deliver promptly. Quality can retain the check without blocking matching.
- Keep the 0% tolerances until there is a documented commercial reason to change, then review the specific supplier site rather than the global default.
- Escalate the supplier communication to procurement.
3. How would you clear the seven invoices already stuck, and what would you change to prevent recurrence?
Read the worked answer
Clear in this order:
- Get the inspector to record the delivery for the seven receipts (deliver from inspection), so the delivered quantity matches the invoice quantity.
- Revalidate the invoices so the match runs again. The 'Qty Received' hold should be released automatically when the quantity condition is met.
- Where a receipt genuinely cannot be delivered, resolve it with the supplier or receiving, not with a manual hold release. A manual release of a system hold is possible for a privileged user but leaves the subledger with an unmatched invoice and no quantity trail; use it only with documented approval and a note on the invoice.
Prevention:
- Change the supplier site / category default routing so inspection and matching are not mutually blocking.
- Add a receiving dashboard or alert for receipts in inspection older than two days.
- Review the supplier template that propagated 0% tolerances plus a routing that prevents receipt delivery - the combination is the defect.
- Require change requests for tolerance edits with business justification, and log who approved them.