{"id":19197,"date":"2026-06-19T11:21:22","date_gmt":"2026-06-19T11:21:22","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=19197"},"modified":"2026-07-07T07:37:01","modified_gmt":"2026-07-07T07:37:01","slug":"po-invoice-receipt-matching-scenarios-in-idempiere-for-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/po-invoice-receipt-matching-scenarios-in-idempiere-for-retail\/","title":{"rendered":"PO, Invoice &amp; Receipt Matching Scenarios in iDempiere for Retail"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Matching PO-Receipt-Invoice process in iDempiere links Purchase Orders, Material Receipts, and Vendor Invoices at the line level. Used across retail procurement operations, this three-way match confirms that what was ordered was received and correctly billed. It drives accounting entries for inventory receipts, invoice price variances, and vendor payment accuracy \u2014 making it essential for audit compliance and period-end close.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Full Three-Way Match on PO Completion<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Overview<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Used for standard retail procurement when a vendor delivers and invoices the full ordered quantity in one go. Triggered when both the receipt and invoice are completed with PO Order Line references.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Key Setup \/ Inputs<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td><strong>Field in iDempiere<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Business Partner<\/td><td>CHENNAI SUPPLIERS<\/td><td>Identifies the vendor for all three documents<\/td><\/tr><tr><td>Document No (PO)<\/td><td>PO2026<\/td><td>Links receipt and invoice lines back to PO<\/td><\/tr><tr><td>Line \u2013 Order Line (Receipt)<\/td><td>PO2026_800002_06\/15\/2026_10_1000000<\/td><td>Links receipt line to PO line; triggers auto-match<\/td><\/tr><tr><td>Line \u2013 Order Line (Invoice)<\/td><td>PO2026_800002_06\/15\/2026_10_1000000<\/td><td>Links invoice line to PO line; triggers Matched Invoice creation<\/td><\/tr><tr><td>Document Status<\/td><td>Completed<\/td><td>Matching only occurs when both receipt and invoice are Completed<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create and complete the Purchase Order (PO2026) for CHENNAI SUPPLIERS with the correct product, quantity (10,000 units), and unit price (100).<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create the Material Receipt \u2014 on each receipt line, populate the Order Line field with the corresponding PO line (PO2026_800002_06\/15\/2026_10_1000000).<\/li>\n\n\n\n<li>Set the Material Receipt Document Action to Complete and confirm.<\/li>\n\n\n\n<li>Create the Vendor Invoice \u2014 on each invoice line, populate the Order Line field with the same PO line reference.<\/li>\n\n\n\n<li>Set the Vendor Invoice Document Action to Complete and confirm.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>System Behavior<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On Material Receipt completion, iDempiere automatically creates a Matched Purchase Order record linking the receipt line to the PO line.<\/li>\n\n\n\n<li>On Vendor Invoice completion, iDempiere automatically creates a Matched Invoice record linking the invoice line to both the receipt line and the PO line.<\/li>\n\n\n\n<li>The Matching tab on the PO is updated to show the receipt line and confirmed quantity.<\/li>\n\n\n\n<li>The Matched POs tab and Matched Receipts tab on the Vendor Invoice are populated.<\/li>\n\n\n\n<li>Accounting entries for Inventory Receipt (NIR) and Liability are posted automatically.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Retail Example<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Chennai Electronics Store orders 10,000 units of Cinthol Soap from CHENNAI SUPPLIERS at 100 per unit (PO2026). The full stock arrives and is receipted as 10,000 units. The vendor&#8217;s invoice for 10,000 units at 100 is then posted. iDempiere creates both the Matched PO and Matched Invoice records automatically on completion of each document \u2014 confirming the full three-way match.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Outcome<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The PO line is fully matched and closed \u2014 no open receipt or invoice quantity remains.<\/li>\n\n\n\n<li>Accounts Payable liability is correctly recorded against the invoice.<\/li>\n\n\n\n<li>Inventory stock is updated and valued at the PO price.<\/li>\n\n\n\n<li>Full audit trail exists across PO, receipt, and invoice via matched records.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Partial Receipts Against a Single Purchase Order<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Overview<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Used when a vendor delivers goods in multiple shipments against one PO. Each partial delivery creates a separate receipt, all referencing the same PO line.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Key Setup \/ Inputs<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td><strong>Field in iDempiere<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>PO \u2013 Line Qty<\/td><td>10,000<\/td><td>Total quantity ordered from vendor<\/td><\/tr><tr><td>Receipt 1 \u2013 Line Qty<\/td><td>4,000<\/td><td>First partial delivery received<\/td><\/tr><tr><td>Receipt 2 \u2013 Line Qty<\/td><td>6,000<\/td><td>Second partial delivery received<\/td><\/tr><tr><td>Line \u2013 Order Line (each receipt)<\/td><td>PO2026_800002_&#8230;<\/td><td>Each receipt line must reference the same PO line<\/td><\/tr><tr><td>PO \u2013 Document Status<\/td><td>Completed<\/td><td>PO remains open until all receipt quantities are matched<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Complete the Purchase Order for 10,000 units of Cinthol Soap from CHENNAI SUPPLIERS.<\/li>\n\n\n\n<li>When the first shipment (4,000 units) arrives, create a new Material Receipt and set the receipt line quantity to 4,000.<\/li>\n\n\n\n<li>Populate the Order Line field on the receipt line with the originating PO line.<\/li>\n\n\n\n<li>Complete the first Material Receipt \u2014 iDempiere creates a Matched PO record for 4,000 units.<\/li>\n\n\n\n<li>When the second shipment (6,000 units) arrives, create a second Material Receipt with qty 6,000 and populate the same Order Line reference.<\/li>\n\n\n\n<li>Complete the second Material Receipt \u2014 iDempiere creates a second Matched PO record for 6,000 units.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>System Behavior<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Each completed Material Receipt generates an independent Matched Purchase Order record.<\/li>\n\n\n\n<li>The Matching tab on the PO displays both receipt lines with their individual matched quantities.<\/li>\n\n\n\n<li>The PO line remains in open status after the first receipt \u2014 it closes only when total matched quantity equals the ordered quantity.<\/li>\n\n\n\n<li>Separate accounting entries (NIR) are posted for each individual receipt.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Retail Example<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">CHENNAI SUPPLIERS ships Cinthol Soap in two batches \u2014 4,000 units on June 10 and 6,000 units on June 15. The store creates two separate Material Receipts (MR-001 and MR-002), each referencing PO2026. After both are completed, the PO Matching tab shows two matched receipt lines totaling 10,000 units \u2014 the PO is now fully received.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Outcome<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Multiple receipt records are independently matched to a single PO line.<\/li>\n\n\n\n<li>Inventory is updated in real time with each delivery, not just after full receipt.<\/li>\n\n\n\n<li>PO open quantity is tracked accurately \u2014 purchasing can see what is still outstanding.<\/li>\n\n\n\n<li>Each receipt posts its own accounting entry, enabling period-accurate financial reporting.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Partial Invoicing Against a Received Purchase Order<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Overview<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Used when a vendor sends separate invoices for goods already received. Each invoice references the same PO line, and the system tracks the billed quantity against what was received.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Key Setup \/ Inputs<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td><strong>Field in iDempiere<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Invoice 1 \u2013 Line Qty<\/td><td>5<\/td><td>First invoice covering partial delivery<\/td><\/tr><tr><td>Invoice 2 \u2013 Line Qty<\/td><td>5<\/td><td>Second invoice for remaining quantity<\/td><\/tr><tr><td>Line \u2013 Order Line (each invoice)<\/td><td>PO2026_800002_&#8230;<\/td><td>Both invoice lines must reference the same PO line<\/td><\/tr><tr><td>Matched Receipts \u2013 Matched Qty<\/td><td>5 \/ 5<\/td><td>Shows how quantities are split between the two invoices<\/td><\/tr><tr><td>Invoice \u2013 Document Status<\/td><td>Completed<\/td><td>Each invoice must be Completed separately for matching to trigger<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Complete the Material Receipt for the full 10 units ordered, with the Order Line field referencing PO2026.<\/li>\n\n\n\n<li>When the vendor sends the first invoice for 5 units, create a Vendor Invoice and populate the Order Line field on each invoice line with the PO line reference.<\/li>\n\n\n\n<li>Complete Invoice 1 \u2014 iDempiere creates a Matched Invoice record for 5 units.<\/li>\n\n\n\n<li>When the vendor sends the second invoice for the remaining 5 units, create a second Vendor Invoice with the same PO line reference.<\/li>\n\n\n\n<li>Complete Invoice 2 \u2014 iDempiere creates a second Matched Invoice record for 5 units.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>System Behavior<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Each completed Vendor Invoice creates an independent Matched Invoice record.<\/li>\n\n\n\n<li>The Matched POs and Matched Receipts tabs on each invoice show only the quantities linked to that specific invoice.<\/li>\n\n\n\n<li>The PO line remains partially invoiced until both invoices are completed and matched.<\/li>\n\n\n\n<li>Accounts Payable liability is posted separately for each invoice on completion.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Retail Example<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">CHENNAI SUPPLIERS ships 10 Cinthol Soap units in one delivery against PO2026. The vendor then sends two separate invoices, Invoice A for 5 units and Invoice B for 5 units. The store creates two Vendor Invoices, each referencing PO2026. After both are completed, the PO is fully invoiced and the Matched Receipts tab on each invoice shows the matched quantity of 5 units.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Outcome<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Both invoices are independently matched to the same receipt and PO \u2014 no duplication of liability.<\/li>\n\n\n\n<li>Finance can track partial billing accurately and pay each invoice on its own terms.<\/li>\n\n\n\n<li>PO invoiced quantity is updated incrementally \u2014 purchasing sees the outstanding invoice balance.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Manual Matching When Order Line Was Not Populated<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Overview<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Used when a receipt or invoice was completed without the Order Line field populated, causing auto-match to fail. The Matching PO-Receipt-Invoice window corrects this exception.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Key Setup \/ Inputs<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td><strong>Field in iDempiere<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Matching PO-Receipt-Invoice \u2013 Document Type<\/td><td>Purchase Order<\/td><td>Starting point selection for manual matching<\/td><\/tr><tr><td>Purchase Order No<\/td><td>PO2026<\/td><td>Identifies the PO to match against<\/td><\/tr><tr><td>Material Receipt No<\/td><td>1000018<\/td><td>Receipt to be linked to the PO and invoice<\/td><\/tr><tr><td>Invoice No<\/td><td>1000003<\/td><td>Invoice to be linked to the receipt and PO<\/td><\/tr><tr><td>Process Button<\/td><td>Process<\/td><td>Creates the matching records after lines are selected<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identify that the Matching tab on the PO or the Matched POs tab on the Invoice is blank after document completion.<\/li>\n\n\n\n<li>Select &#8216;Purchase Order&#8217; as the starting document type and choose PO2026.<\/li>\n\n\n\n<li>The system displays the PO lines and available receipts and invoices for selection.<\/li>\n\n\n\n<li>Select the receipt line (1000018) and invoice line (1000003) to be linked to the PO line.<\/li>\n\n\n\n<li>Click Process \u2014 iDempiere creates the matching records manually.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>System Behavior<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>iDempiere creates the Matched Purchase Order and\/or Matched Invoice records on Process.<\/li>\n\n\n\n<li>The Matching tab on the PO is updated to show the newly created matched receipt.<\/li>\n\n\n\n<li>The Matched POs and Matched Receipts tabs on the Invoice are populated after processing.<\/li>\n\n\n\n<li>Accounting entries associated with the match are posted based on the documents involved.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Retail Example<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A purchasing clerk at Chennai Electronics Store created a Material Receipt manually without selecting the Order Line field. After completion, the PO Matching tab showed no matched records. The finance team used the Matching PO-Receipt-Invoice window to link Receipt 1000018 and Invoice 1000003 to PO2026 manually \u2014 restoring the three-way match and ensuring correct accounting.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Outcome<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Missing matched records are corrected without reversing completed documents.<\/li>\n\n\n\n<li>PO, receipt, and invoice are linked retroactively \u2014 audit trail is restored.<\/li>\n\n\n\n<li>Accounting entries for the match are posted correctly after manual processing.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Matching PO-Receipt-Invoice process in iDempiere links Purchase Orders, Material Receipts, and Vendor Invoices at the line level. Used across [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67,75],"tags":[],"class_list":["post-19197","post","type-post","status-publish","format-standard","hentry","category-retail","category-purchase-retail"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=19197"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19197\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=19197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=19197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=19197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}