{"id":19004,"date":"2026-06-19T11:23:48","date_gmt":"2026-06-19T11:23:48","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=19004"},"modified":"2026-07-14T05:13:29","modified_gmt":"2026-07-14T05:13:29","slug":"how-does-po-invoice-material-receipt-matching-works-idempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-po-invoice-material-receipt-matching-works-idempiere-retail\/","title":{"rendered":"How Does PO, Invoice & Material Receipt Matching works iDempiere Retail"},"content":{"rendered":"\n

In iDempiere, the matching of a Purchase Order (PO), Material Receipt, and Vendor Invoice is performed automatically by the system there is no manual matching step required. When documents are completed in the correct sequence, iDempiere creates matching records that link all three documents at the line level.<\/p>\n\n\n\n

Two types of matching records are generated: a Matched Purchase Order (linking the Material Receipt line to the PO line) and a Matched Invoice (linking the Material Receipt line and Invoice line to the PO line). Both records are created automatically when documents are completed, provided the PO reference is populated on the receipt and invoice lines.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • iDempiere automatically creates a Matched Purchase Order record when a Material Receipt is completed \u2014 provided the Receipt Line references a PO Order Line.<\/li>\n<\/ul>\n\n\n\n
      \n
    • iDempiere automatically creates a Matched Invoice record when a Material Receipt or a Vendor Invoice is completed \u2014 provided the PO Order Line field is populated on the respective line.<\/li>\n\n\n\n
    • When automatic matching is not possible, the Matching PO-Receipt-Invoice window can be used to create matching records manually.<\/li>\n\n\n\n
    • Matched records are view-only \u2014 they cannot be edited after creation.<\/li>\n\n\n\n
    • Matched records are visible from the Purchase Order window (Matching tab), the Vendor Invoice window (Matched POs and Matched Receipts tabs), and the Material Receipt window (Matched POs and Matched Invoices tabs).<\/li>\n\n\n\n
    • A single PO line can have multiple matched receipts if goods are received in partial shipments.<\/li>\n\n\n\n
    • A single receipt line can be matched to multiple invoice lines if the vendor bills partially.<\/li>\n<\/ul>\n\n\n\n

      Prerequisites<\/strong><\/h2>\n\n\n\n

      Ensure the following are in place before expecting automatic matching to occur in iDempiere:<\/p>\n\n\n\n

        \n
      • Purchase Order is created, approved, and in Completed status.<\/li>\n\n\n\n
      • The PO Line contains the correct product, quantity, and unit price.<\/li>\n\n\n\n
      • Material Receipt is created with the Order Line field on each receipt line pointing to the originating PO line.<\/li>\n\n\n\n
      • Vendor Invoice is created with the Order Line field on each invoice line pointing to the originating PO line.<\/li>\n\n\n\n
      • Both Material Receipt and Vendor Invoice are in Completed status.<\/li>\n<\/ul>\n\n\n\n

        Navigation<\/strong><\/h2>\n\n\n\n

        Matched records can be accessed from three entry points in iDempiere:<\/p>\n\n\n\n

        Entry Point<\/strong><\/td>Menu Path<\/strong><\/td>What It Shows<\/strong><\/td><\/tr>
        Matched PO Window<\/td>Menu \u2192 Requisition-to-Invoice (Purchasing) \u2192 Matched Purchase Orders<\/td>All matched PO, Invoice, Receipt pairs across the system<\/td><\/tr>
        PO Window \u2014 Matching Tab<\/td>Menu \u2192 Requisition-to-Invoice (Purchasing) \u2192 Purchase Order \u2192 open a PO \u2192 Matching (Tab)<\/td>Receipt lines matched to this specific PO<\/td><\/tr>
        Invoice \u2014 Matched POs Tab<\/td>Menu \u2192 Requisition-to-Invoice (Purchasing) \u2192 Purchase Invoice and Credit\/Debit Note \u2192 open an Invoice \u2192 Matched POs (Tab)<\/td>PO lines matched to this specific invoice<\/td><\/tr>
        Invoice \u2014 Matched Receipts Tab<\/td>Menu \u2192 Requisition-to-Invoice (Purchasing) \u2192 Purchase Invoice and Credit\/Debit Note \u2192 open an Invoice \u2192 Matched Receipts (Tab)<\/td>Receipt lines matched to this specific invoice<\/td><\/tr>
        Matching PO-Receipt-Invoice<\/td>Menu \u2192 Requisition-to-Invoice (Purchasing) \u2192 Matching PO-Receipt-Invoice<\/td>Manual matching form \u2014 used only when auto-match fails<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Step-by-Step: How iDempiere Creates Matching Records<\/strong><\/h2>\n\n\n\n

        Step 1: Create and Complete the Purchase Order<\/strong><\/h3>\n\n\n\n

        The Purchase Order is the source document for all matching. Every receipt and invoice line must reference the PO line for automatic matching to work.<\/p>\n\n\n\n

          \n
        • Click New Record (+) and select the Business Partner (vendor).<\/li>\n\n\n\n
        • Add PO lines with the correct product, quantity, and unit price.<\/li>\n\n\n\n
        • Set Document Action to Complete and click OK.<\/li>\n\n\n\n
        • The PO is now in Completed status and ready to receive receipts and invoices.<\/li>\n<\/ul>\n\n\n\n
          Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
          Document No<\/td>PO2026<\/td>System-assigned unique PO reference<\/td><\/tr>
          Business Partner<\/td>CHENNAI SUPPLIERS<\/td>Vendor supplying the goods<\/td><\/tr>
          Document Status<\/td>Completed<\/td>PO must be Completed before receipts can reference it<\/td><\/tr>
          Line \u2013 Product<\/td>SGS25_Samsung Galaxy S25<\/td>Product being procured<\/td><\/tr>
          Line \u2013 Qty<\/td>10,000<\/td>Ordered quantity<\/td><\/tr>
          Line \u2013 Unit Price<\/td>85,000.00<\/td>Agreed price \u2014 used for PPV and IPV calculations<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          Step 2: Create and Complete the Material Receipt<\/strong><\/h3>\n\n\n\n

          When creating the Material Receipt, the Order Line field on each receipt line must reference the corresponding PO line. This is the key field that enables automatic matching.<\/p>\n\n\n\n

            \n
          • Click New Record (+) and select the same Business Partner as the PO.<\/li>\n\n\n\n
          • In the receipt lines, select the product and enter the received quantity.<\/li>\n\n\n\n
          • In the Order Line field on each receipt line, select the corresponding PO line.<\/li>\n\n\n\n
          • Set Document Action to Complete and click OK.<\/li>\n<\/ul>\n\n\n\n
            Auto-Match Triggered: <\/strong>On completion, iDempiere automatically creates a Matched Purchase Order record linking this receipt line to the PO line.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
            Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
            Document No<\/td>1000018<\/td>System-assigned receipt reference<\/td><\/tr>
            Business Partner<\/td>CHENNAI SUPPLIERS<\/td>Must match the PO vendor<\/td><\/tr>
            Document Status<\/td>Completed<\/td>Must be Completed for matching to occur<\/td><\/tr>
            Line \u2013 Product<\/td>SGS25_Samsung Galaxy S25<\/td>Must match the PO line product<\/td><\/tr>
            Line \u2013 Qty<\/td>1<\/td>Quantity physically received<\/td><\/tr>
            Line \u2013 Order Line<\/td>PO2026_800002_06\/15\/2026_10_850000000<\/td>CRITICAL \u2014 links this receipt line to the PO line; required for auto-match<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Step 3: Create and Complete the Vendor Invoice<\/strong><\/h3>\n\n\n\n

            Similar to the receipt, each Vendor Invoice line must reference the PO line in the Order Line field for iDempiere to generate a Matched Invoice record automatically.<\/p>\n\n\n\n

              \n
            • Click New Record (+) and select the Business Partner.<\/li>\n\n\n\n
            • Enter the Invoice Date and the vendor’s Invoice No.<\/li>\n\n\n\n
            • Add invoice lines \u2014 in the Order Line field on each line, select the corresponding PO line.<\/li>\n\n\n\n
            • Set Document Action to Complete and click OK.<\/li>\n<\/ul>\n\n\n\n
              Auto-Match Triggered: <\/strong>On completion, iDempiere automatically creates a Matched Invoice record linking this invoice line to the receipt line and the PO line.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr>
              Document No<\/td>1000003<\/td>System-assigned invoice reference<\/td><\/tr>
              Business Partner<\/td>CHENNAI SUPPLIERS<\/td>Must match the PO and receipt vendor<\/td><\/tr>
              Invoice Date<\/td>06\/15\/2026<\/td>Date on the vendor’s paper invoice<\/td><\/tr>
              Document Status<\/td>Completed<\/td>Must be Completed for matching to occur<\/td><\/tr>
              Line \u2013 Product<\/td>SGS25_Samsung Galaxy S25<\/td>Must match the PO product<\/td><\/tr>
              Line \u2013 Qty<\/td>1<\/td>Quantity billed by the vendor<\/td><\/tr>
              Line \u2013 Unit Price<\/td>85,000.00<\/td>Vendor’s billed price<\/td><\/tr>
              Line \u2013 Order Line<\/td>PO2026_800002_06\/15\/2026_10_850000000<\/td>CRITICAL \u2014 links this invoice line to the PO line; required for auto-match<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              \"\"<\/figure>\n\n\n\n

              Step 4: View Matched Records on the Purchase Order<\/strong><\/h3>\n\n\n\n

              After the Material Receipt is completed, the Matching tab on the Purchase Order displays the matched receipt lines. This confirms that the PO quantity has been updated correctly.<\/p>\n\n\n\n

                \n
              • Search for the PO by document number.<\/li>\n\n\n\n
              • Click the Matching tab (sub-tab at the bottom of the PO window).<\/li>\n\n\n\n
              • The tab displays all Material Receipt lines that have been matched to this PO’s lines.<\/li>\n\n\n\n
              • Verify the Matched Qty matches the received quantity.<\/li>\n<\/ul>\n\n\n\n
                Column<\/strong><\/td>Description<\/strong><\/td><\/tr>
                PO Line<\/td>The Purchase Order line number being matched<\/td><\/tr>
                Receipt Line<\/td>The specific receipt line matched to the PO line<\/td><\/tr>
                Product<\/td>Product on the matched line<\/td><\/tr>
                Qty<\/td>Quantity confirmed as received against this PO line<\/td><\/tr>
                Posted<\/td>Indicates whether the matching accounting entry has been posted<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                \"\"<\/figure>\n\n\n\n


                Step 5: View Matched POs and Matched Receipts on the Vendor Invoice<\/strong><\/h3>\n\n\n\n

                After the Vendor Invoice is completed, two tabs on the Invoice window display the matching results: Matched POs and Matched Receipts. These confirm the three-way link between PO, receipt, and invoice.<\/p>\n\n\n\n

                  \n
                • Search for the invoice by document number.<\/li>\n\n\n\n
                • Click the Matched POs tab to see PO lines linked to this invoice.<\/li>\n\n\n\n
                • Click the Matched Receipts tab to see receipt lines linked to this invoice.<\/li>\n\n\n\n
                • Both tabs together confirm the complete three-way match.<\/li>\n<\/ul>\n\n\n\n

                  Matched POs Tab \u2014 Key Fields:<\/p>\n\n\n\n

                  Column<\/strong><\/td>Description<\/strong><\/td><\/tr>
                  PO Line<\/td>Specific PO line matched<\/td><\/tr>
                  Product<\/td>Matched product<\/td><\/tr>
                  Receipt Line<\/td>Specific receipt line matched<\/td><\/tr>
                  Qty<\/td>Quantity confirmed between PO and Invoice<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

                  Matched Receipts Tab \u2014 Key Fields:<\/p>\n\n\n\n

                  Column<\/strong><\/td>Description<\/strong><\/td><\/tr>
                  Receipt<\/td>Material Receipt document linked to this invoice line<\/td><\/tr>
                  Receipt Line<\/td>Specific receipt line matched<\/td><\/tr>
                  Product<\/td>Matched product<\/td><\/tr>
                  Matched Qty<\/td>Quantity confirmed between Receipt and Invoice<\/td><\/tr>
                  Matched Amount<\/td>Value confirmed \u2014 used for IPV and NIR posting<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n

                  Step 7: Manual Matching via Matching PO-Receipt-Invoice<\/strong><\/h3>\n\n\n\n

                  The Matching PO-Receipt-Invoice window is used only when automatic matching fails \u2014 typically because the Order Line field was not populated on the receipt or invoice line at the time of completion.<\/p>\n\n\n\n

                    \n
                  • Navigate to Menu \u2192 Requisition-to-Invoice (Purchasing) \u2192 Matching PO-Receipt-Invoice.<\/li>\n\n\n\n
                  • Select the document type to match: Purchase Order, Material Receipt, or Invoice.<\/li>\n\n\n\n
                  • Select the specific document and line to match.<\/li>\n\n\n\n
                  • The system displays eligible lines from the other documents for selection.<\/li>\n\n\n\n
                  • Select the matching lines and click Process to create the matching record.<\/li>\n<\/ul>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n

                    Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
                    Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr>
                    Matching tab on PO shows no records<\/td>Receipt was not linked to this PO at receipt entry<\/td>Check the Material Receipt line \u2014 if Order Line is blank, use manual matching window<\/td><\/tr>
                    Matched POs tab on Invoice is empty<\/td>Invoice was created without that PO reference on the line<\/td>Reverse the invoice, re-enter with Order Line populated, then complete<\/td><\/tr>
                    Matched Receipts tab on Invoice is empty<\/td>Receipt was not matched to this invoice<\/td>Verify receipt Order Line field references the same PO; use manual matching if needed<\/td><\/tr>
                    Partial match \u2014 PO line still shows as open<\/td>Vendor has not billed the full PO quantity<\/td>Expected behavior for partial invoicing; PO remains open until fully invoiced<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

                    Best Practices<\/strong><\/h2>\n\n\n\n
                      \n
                    • Create Material Receipts directly from the Purchase Order using the Generate Receipts function to auto-populate the Order Line field.<\/li>\n\n\n\n
                    • Create Vendor Invoices from the Purchase Order or Material Receipt to auto-populate the Order Line and avoid manual entry errors.<\/li>\n\n\n\n
                    • Use the Matched Purchase Orders window weekly to identify any PO lines with missing or incomplete matching records.<\/li>\n\n\n\n
                    • Use the Matching PO-Receipt-Invoice window as an exception tool only not as part of the standard procurement workflow.<\/li>\n<\/ul>\n\n\n\n

                      Next Steps<\/strong><\/h2>\n\n\n\n

                      After understanding PO\u2013Invoice\u2013Material Receipt matching in iDempiere, proceed with:<\/p>\n\n\n\n

                        \n
                      • Configure the Payment Selection window to generate vendor payment batches.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                        In iDempiere, the matching of a Purchase Order (PO), Material Receipt, and Vendor Invoice is performed automatically by the system […]<\/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-19004","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\/19004","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=19004"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19004\/revisions"}],"predecessor-version":[{"id":20538,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/19004\/revisions\/20538"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=19004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=19004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=19004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}