PO, Invoice & Receipt Matching Scenarios in iDempiere for Retail

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 — making it essential for audit compliance and period-end close.

Full Three-Way Match on PO Completion

Overview

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.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Business Partner	CHENNAI SUPPLIERS	Identifies the vendor for all three documents
Document No (PO)	PO2026	Links receipt and invoice lines back to PO
Line – Order Line (Receipt)	PO2026_800002_06/15/2026_10_1000000	Links receipt line to PO line; triggers auto-match
Line – Order Line (Invoice)	PO2026_800002_06/15/2026_10_1000000	Links invoice line to PO line; triggers Matched Invoice creation
Document Status	Completed	Matching only occurs when both receipt and invoice are Completed

Process Flow

• Create and complete the Purchase Order (PO2026) for CHENNAI SUPPLIERS with the correct product, quantity (10,000 units), and unit price (100).

• Create the Material Receipt — on each receipt line, populate the Order Line field with the corresponding PO line (PO2026_800002_06/15/2026_10_1000000).
• Set the Material Receipt Document Action to Complete and confirm.
• Create the Vendor Invoice — on each invoice line, populate the Order Line field with the same PO line reference.
• Set the Vendor Invoice Document Action to Complete and confirm.

System Behavior

• On Material Receipt completion, iDempiere automatically creates a Matched Purchase Order record linking the receipt line to the PO line.
• On Vendor Invoice completion, iDempiere automatically creates a Matched Invoice record linking the invoice line to both the receipt line and the PO line.
• The Matching tab on the PO is updated to show the receipt line and confirmed quantity.
• The Matched POs tab and Matched Receipts tab on the Vendor Invoice are populated.
• Accounting entries for Inventory Receipt (NIR) and Liability are posted automatically.

Retail Example

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’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 — confirming the full three-way match.

Outcome

• The PO line is fully matched and closed — no open receipt or invoice quantity remains.
• Accounts Payable liability is correctly recorded against the invoice.
• Inventory stock is updated and valued at the PO price.
• Full audit trail exists across PO, receipt, and invoice via matched records.

Partial Receipts Against a Single Purchase Order

Overview

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.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
PO – Line Qty	10,000	Total quantity ordered from vendor
Receipt 1 – Line Qty	4,000	First partial delivery received
Receipt 2 – Line Qty	6,000	Second partial delivery received
Line – Order Line (each receipt)	PO2026_800002_…	Each receipt line must reference the same PO line
PO – Document Status	Completed	PO remains open until all receipt quantities are matched

Process Flow

• Complete the Purchase Order for 10,000 units of Cinthol Soap from CHENNAI SUPPLIERS.
• When the first shipment (4,000 units) arrives, create a new Material Receipt and set the receipt line quantity to 4,000.
• Populate the Order Line field on the receipt line with the originating PO line.
• Complete the first Material Receipt — iDempiere creates a Matched PO record for 4,000 units.
• When the second shipment (6,000 units) arrives, create a second Material Receipt with qty 6,000 and populate the same Order Line reference.
• Complete the second Material Receipt — iDempiere creates a second Matched PO record for 6,000 units.

System Behavior

• Each completed Material Receipt generates an independent Matched Purchase Order record.
• The Matching tab on the PO displays both receipt lines with their individual matched quantities.
• The PO line remains in open status after the first receipt — it closes only when total matched quantity equals the ordered quantity.
• Separate accounting entries (NIR) are posted for each individual receipt.

Retail Example

CHENNAI SUPPLIERS ships Cinthol Soap in two batches — 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 — the PO is now fully received.

Outcome

• Multiple receipt records are independently matched to a single PO line.
• Inventory is updated in real time with each delivery, not just after full receipt.
• PO open quantity is tracked accurately — purchasing can see what is still outstanding.
• Each receipt posts its own accounting entry, enabling period-accurate financial reporting.

Partial Invoicing Against a Received Purchase Order

Overview

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.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Invoice 1 – Line Qty	5	First invoice covering partial delivery
Invoice 2 – Line Qty	5	Second invoice for remaining quantity
Line – Order Line (each invoice)	PO2026_800002_…	Both invoice lines must reference the same PO line
Matched Receipts – Matched Qty	5 / 5	Shows how quantities are split between the two invoices
Invoice – Document Status	Completed	Each invoice must be Completed separately for matching to trigger

Process Flow

• Complete the Material Receipt for the full 10 units ordered, with the Order Line field referencing PO2026.
• 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.
• Complete Invoice 1 — iDempiere creates a Matched Invoice record for 5 units.
• When the vendor sends the second invoice for the remaining 5 units, create a second Vendor Invoice with the same PO line reference.
• Complete Invoice 2 — iDempiere creates a second Matched Invoice record for 5 units.

System Behavior

• Each completed Vendor Invoice creates an independent Matched Invoice record.
• The Matched POs and Matched Receipts tabs on each invoice show only the quantities linked to that specific invoice.
• The PO line remains partially invoiced until both invoices are completed and matched.
• Accounts Payable liability is posted separately for each invoice on completion.

Retail Example

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.

Outcome

• Both invoices are independently matched to the same receipt and PO — no duplication of liability.
• Finance can track partial billing accurately and pay each invoice on its own terms.
• PO invoiced quantity is updated incrementally — purchasing sees the outstanding invoice balance.

Manual Matching When Order Line Was Not Populated

Overview

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.

Key Setup / Inputs

Field in iDempiere	Sample Value	Purpose
Matching PO-Receipt-Invoice – Document Type	Purchase Order	Starting point selection for manual matching
Purchase Order No	PO2026	Identifies the PO to match against
Material Receipt No	1000018	Receipt to be linked to the PO and invoice
Invoice No	1000003	Invoice to be linked to the receipt and PO
Process Button	Process	Creates the matching records after lines are selected

Process Flow

• Identify that the Matching tab on the PO or the Matched POs tab on the Invoice is blank after document completion.
• Select ‘Purchase Order’ as the starting document type and choose PO2026.
• The system displays the PO lines and available receipts and invoices for selection.
• Select the receipt line (1000018) and invoice line (1000003) to be linked to the PO line.
• Click Process — iDempiere creates the matching records manually.

System Behavior

• iDempiere creates the Matched Purchase Order and/or Matched Invoice records on Process.
• The Matching tab on the PO is updated to show the newly created matched receipt.
• The Matched POs and Matched Receipts tabs on the Invoice are populated after processing.
• Accounting entries associated with the match are posted based on the documents involved.

Retail Example

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 — restoring the three-way match and ensuring correct accounting.

Outcome

• Missing matched records are corrected without reversing completed documents.
• PO, receipt, and invoice are linked retroactively — audit trail is restored.
• Accounting entries for the match are posted correctly after manual processing.