SAP Three-Way Match and Invoice Tolerance Calculator
Three-way match compares the purchase order, the goods receipt and the vendor invoice before payment. This calculator models the price and quantity checks so you can see why an invoice blocks in SAP before you try to fix it.
Your numbers
Price on the purchase order item
Upper limit in percent (like a PP tolerance key)
Allowed excess over received quantity (like a DQ tolerance key)
Your results
Simplified model. Real SAP tolerance keys include several checks (price variance, quantity variance, small differences, order price quantity variance), absolute and percentage limits and upper and lower bounds. Confirm your limits in customizing (transaction OMR6).
Blocked invoice monitoring
Want blocked invoices and GR/IR differences explained automatically from SAP data? We can show a demo.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Enter the PO price, quantity received and the figures from the vendor invoice, then set your price and quantity tolerance in percent. The tool calculates the value difference, price variance percentage and the quantity billed beyond what was received. It then indicates whether the invoice would exceed tolerance. Use it to explain a blocked invoice to a buyer or to test whether a proposed tolerance is too tight or too loose.
The method behind it
In logistics invoice verification, MIRO compares invoice quantity to the quantity still to be invoiced, which is the goods receipt quantity less what is already invoiced, and compares invoice price to the order price. Tolerance keys define the allowed variance, with separate keys such as price variance (PP) and quantity variance (DQ). If a variance exceeds the limit, the system blocks the invoice for payment, and someone releases it in MRBR after checking.
- Price variance = |invoice price - PO price| / PO price
- Quantity excess = invoiced quantity above received quantity
- Blocked invoices are released in MRBR
- Limits are set in customizing, not by the buyer
Reading results and common mistakes
A value difference with no price or quantity variance usually means a rounding or price unit issue. Invoices that block on quantity often mean the goods receipt was not yet posted, so check timing before changing tolerances. Setting tolerances too wide hides pricing errors, while too tight produces blocked invoices that burn accounts payable time. Also remember that real tolerance rules can combine absolute and percentage limits, so use this tool as an explainer rather than a replica.
Frequently Asked Questions
What is three-way match?
It is the control that compares the purchase order, the goods receipt and the vendor invoice. If price and quantity agree within tolerance, the invoice can be paid. Otherwise the invoice is blocked or rejected until a person decides what to do.
Where are tolerances configured in SAP?
In customizing for invoice verification, tolerance limits are defined per tolerance key and company code, commonly reached with transaction OMR6. Keys cover price variance, quantity variance, small differences and similar checks.
How do I release a blocked invoice?
Use transaction MRBR to list invoices blocked for payment, review the reason, and release them if the variance is acceptable. Authorization for release should be restricted and separate from the people who enter invoices.
Does this match SAP exactly?
No. It models percentage price and quantity checks only. SAP tolerance keys can also use absolute amounts and different upper and lower limits, and other checks apply, such as order price quantity. Use it for explanation, then confirm in your configuration.
If blocked invoices and GR/IR differences eat accounts payable time, we can build read-only monitoring over your SAP data that flags the cause for each blocked invoice.
Related Tools
SAP PO Item Category, Account Assignment and Special Stock Reference
Searchable list of the codes you choose on a PO line: item category, account assignment category and special stock indicator.
SAPSAP MM Transaction Codes Reference
Searchable list of the SAP MM transaction codes consultants and buyers use daily, grouped by purchasing, inventory, invoice verification and MRP.
SAPSAP Open PO Items ABAP SELECT Generator
Fill in plant, document type and dates to generate ABAP Open SQL that lists open PO items with received quantity from EKBE.
SAPSAP Physical Inventory Count Checklist
Step-by-step checklist for planning, counting, recounting and posting physical inventory differences in SAP MM.
More SAP tools
See allKeep exploring
Free tools
- SAP Invoice Verification Tolerance CalculatorSimulates the price and quantity variance checks behind MIRO invoice blocks so you can test tolerance limits before changing OMR6.
- SAP Material Valuation and Price Unit WorksheetA fill-in worksheet that recomputes inventory value per material from quantity, price and price unit, so you can reconcile with MBEW or migration loads.
- SAP Open PO Items ABAP SELECT GeneratorFill in plant, document type and dates to generate ABAP Open SQL that lists open PO items with received quantity from EKBE.
ERP fixes and how-tos
- SAP MIRO: invoice blocked for price variance, and how to release it in MRBRWhy SAP MIRO blocks an invoice for price or quantity variance, how tolerance keys in OMR6 decide it, and how to release or reject it in MRBR safely.
- SAP PP Tolerance Keys: Overdelivery, Underdelivery and OMR6Where tolerances are set in SAP PP: over- and underdelivery on the material master, confirmation tolerances in the IMG, and tolerance keys in OMR6 for invoices.
Runs with your ERP
- Esker Accounts Payable Automation with SAP S/4HANA and ECCHow Esker Accounts Payable Automation captures supplier invoices, matches them to POs and posts to SAP S/4HANA and ECC, plus setup steps, pitfalls and options.
- AI Invoice Management and SAP S/4HANA Cloud: OCR capture and AP processingHow the AI Invoice Management SAP Store app captures invoice data with OCR and imports it into S/4HANA Cloud, plus setup steps, pitfalls and alternatives.
- Nagarro Invoice Scanner for SAP S/4HANAHow Nagarro's Invoice Scanner handles scanning, OCR, monitoring and posting release for incoming invoices in SAP S/4HANA: setup, pitfalls and AI help.
AI on your ERP
- AI for accounts payable invoice matching in your ERPOn-prem AI reads vendor invoices, runs 3-way match against your ERP PO and receipt, and routes only real exceptions to your AP team. No invoice data leaves your network.
- AI for SAP S/4HANA Procurement (MM) That Reads POs, Receipts and Invoices TogetherAI for SAP S/4HANA procurement: query purchase orders, goods receipts and invoice matching in plain English, on-prem if needed, read-only by default.
Integrations
- How to add document OCR to SAP Business ByDesignCapture invoices, packing slips and certificates into SAP Business ByDesign with OCR, confidence thresholds, three-way matching and a human review step.
- How to add document OCR to SAP S/4HANACapture invoices, packing slips, certificates of conformance and drawings into SAP S/4HANA with OCR, confidence thresholds, 3-way match and human review.