13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions
Key Takeaways
- Accounts payable invoice matching (Accounts payable > Setup > Accounts payable parameters > Invoice validation) verifies unit prices, quantities, price totals, and charges across Purchase Orders, Product Receipts, and Vendor Invoices to ensure accurate vendor disbursements and inventory valuation.
- Dynamics 365 Finance supports two primary matching policies: 2-way matching (validates Net Unit Price between Purchase Order and Invoice) and 3-way matching (validates Net Unit Price between PO and Invoice, AND validates Invoiced Quantity against Product Receipt Received Quantity).
- Line matching policy resolution follows a strict four-level hierarchy: Purchase Order Line (highest priority) -> Item Master -> Vendor Master -> Accounts Payable Parameters / Legal Entity (lowest priority).
- Price tolerances can be configured as Percentage Tolerances or Unit Price Amount Tolerances across Table, Group, and All scopes to define acceptable variance bands before an invoice fails matching.
- When matching discrepancies exceed configured tolerances, the invoice status displays a failed matching icon, preventing posting until authorized via the 'Authorize posting with matching discrepancies' workflow or manual approval with audit reason codes.
13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions
Quick Summary: Accounts Payable invoice matching is a critical financial control framework in Microsoft Dynamics 365 Finance that protects organizations from overpaying vendors, billing for unreceived inventory, and absorbing unauthorized price increases or shipping charges. Configured under Accounts payable > Setup > Accounts payable parameters > Invoice validation, invoice matching automates the cross-verification of Purchase Orders, Product Receipts, and Vendor Invoices, enforcing strict 2-way or 3-way matching rules and configurable tolerance thresholds.
1. Invoice Matching Validation Framework & Master Parameters
The Accounts Payable invoice matching framework provides automated validation at the line level, charge level, and document total level.
+---------------------------------------------------------------------------------------------------------+
| Invoice Matching Core Configuration Matrix |
+---------------------------------------------------------------------------------------------------------+
| Parameter (`AP parameters > Invoice validation`) | Configuration Options | Operational Impact |
| :----------------------------------------------- | :------------------------ | :---------------------- |
| **Enable invoice matching validation** | Yes / No | Master toggle for engine|
| **Automatically update invoice header status** | Yes / No | Live matching evaluation|
| **Match invoice totals** | Yes / No | Header amount validation|
| **Invoice totals tolerance percentage** | E.g., 1.00% / $50.00 | Allowable total variance|
| **Line matching policy** (Legal Entity Default) | Not required / 2-way / 3-way| Company baseline policy |
| **Price tolerance** | Percentage / Group link | Unit price variance band|
| **Match charges** | Yes / No | Freight & fee validation|
| **Require authorization for discrepancies** | Yes / No | Enforces approval lock |
+---------------------------------------------------------------------------------------------------------+
Core Validation Engines
- Line Matching (2-Way / 3-Way): Compares unit prices and received physical quantities against invoice lines.
- Price Totals Matching: Compares line extended net price totals against PO expected net totals.
- Invoice Totals Matching: Compares gross invoice document totals (including taxes and charges) against purchase order expected totals.
- Charges Matching: Compares miscellaneous markup/freight charges added to the invoice against approved purchase order charges.
2. 2-Way vs. 3-Way Matching Mechanics
Dynamics 365 Finance supports two primary matching policies that align with different procurement scenarios:
+---------------------------------------------------------------------------------------------------------+
| 2-Way vs. 3-Way Matching Comparison |
+---------------------------------------------------------------------------------------------------------+
| Feature / Dimension | 2-Way Matching | 3-Way Matching |
| :------------------------ | :------------------------------------ | :--------------------------------- |
| **Documents Compared** | 1. Purchase Order | 1. Purchase Order |
| | 2. Vendor Invoice | 2. Product Receipt (Packing Slip) |
| | | 3. Vendor Invoice |
| ------------------------- | ------------------------------------- | ---------------------------------- |
| **Validation Criteria** | - Net Unit Price (PO vs. Invoice) | - Net Unit Price (PO vs. Invoice) |
| | - Line Amount Tolerance | - Quantity (Receipt vs. Invoice) |
| | | - Line Amount Tolerance |
| ------------------------- | ------------------------------------- | ---------------------------------- |
| **Physical Receipt Req.** | **No.** Product receipt not required. | **Yes.** Invoiced Qty cannot exceed|
| | Invoices can post prior to receipt. | posted Product Receipt quantity. |
| ------------------------- | ------------------------------------- | ---------------------------------- |
| **Best-Fit Procurement** | - Non-stock expense items | - Stocked inventory products |
| | - Professional service contracts | - Physical raw materials & assets |
| | - Procurement categories (Consulting) | - Tangible goods with warehouse flow|
| ------------------------- | ------------------------------------- | ---------------------------------- |
| **Matching Status Check** | `Invoice Net Price <= PO Net Price` | `Invoice Price <= PO Price` AND |
| | (within configured price tolerance) | `Invoice Qty <= Receipt Qty` |
+---------------------------------------------------------------------------------------------------------+
[!NOTE] A third option, Not required, completely bypasses invoice line matching validation. It is typically used for intercompany transactions or specialized service vendors where payment validation is performed externally.
3. Line Matching Policy Precedence Hierarchy
When a line item is added to a Purchase Order, Dynamics 365 Finance determines the effective line matching policy by evaluating a strict four-level hierarchy from most specific to broadest:
+---------------------------------------------------------------------------------------------------+
| Line Matching Policy Resolution Hierarchy |
+---------------------------------------------------------------------------------------------------+
| Precedence Level | Configuration Location | Scope / Description |
| :---------------- | :---------------------------- | :------------------------------------------- |
| **1 (Highest)** | **Purchase Order Line** | Explicit override on the specific PO line. |
| **2** | **Item Master (Released Prod)**| `Released product > Purchase fasttab` |
| **3** | **Vendor Master** | `Vendor master > Invoice and delivery fasttab`|
| **4 (Lowest)** | **AP Parameters** | `AP parameters > Invoice validation` (Company)|
+---------------------------------------------------------------------------------------------------+
+---------------------------------------------------------------------------------------------------+
| Hierarchy Resolution Decision Matrix Example |
+---------------------------------------------------------------------------------------------------+
| Scenario | AP Parameter | Vendor Master | Item Master | PO Line Override | Effective Policy Applied|
| :--- | :----------- | :------------ | :---------- | :--------------- | :-----------------------|
| **1**| 3-way | [Blank/Null] | [Blank/Null]| [Blank/Null] | **3-way** (From Parameter)|
| **2**| 3-way | 2-way | [Blank/Null]| [Blank/Null] | **2-way** (Vendor wins) |
| **3**| 3-way | 2-way | 3-way | [Blank/Null] | **3-way** (Item wins) |
| **4**| 3-way | 3-way | 3-way | 2-way | **2-way** (PO Line wins)|
+---------------------------------------------------------------------------------------------------+
[!IMPORTANT] On the MB-310 exam, remember that PO Line always overrides Item, Item overrides Vendor, and Vendor overrides the legal entity AP Parameters default.
4. Price & Charges Tolerances Configuration
Tolerances establish allowable variance thresholds so minor penny variances or agreed-upon shipping uplifts do not stall invoice processing.
1. Price Tolerances Setup
Navigate to Accounts payable > Setup > Invoice matching > Price tolerances.
- Configure tolerances using Percentage (e.g., 5.0%) or Unit price tolerance amount (e.g., $2.00).
- Uses the Table / Group / All structure:
- Table: Specific Item and Vendor combination.
- Group: Item Price Tolerance Group or Vendor Price Tolerance Group.
- All: Enterprise-wide fallback price tolerance.
+---------------------------------------------------------------------------------------------------+
| Price Tolerance Mathematical Calculation |
+---------------------------------------------------------------------------------------------------+
| Parameter / Field | Numerical Values |
| :-------------------------------- | :------------------------------------------------------------- |
| **Purchase Order Line Net Price** | $100.00 / unit |
| **Configured Price Tolerance %** | 5.00% (Allowable range: $95.00 to $105.00) |
| **Scenario A: Invoice Net Price** | **$104.00 / unit** -> **PASSED** (Variance +$4.00 is <= 5%) |
| **Scenario B: Invoice Net Price** | **$108.00 / unit** -> **FAILED** (Variance +$8.00 exceeds 5%) |
+---------------------------------------------------------------------------------------------------+
2. Charges Matching Tolerances Setup
Navigate to Accounts payable > Setup > Invoice matching > Charges tolerances.
- Matches miscellaneous charges (e.g., Freight, Handling, Insurance) entered on the vendor invoice against charges on the original PO.
- Allows defining maximum allowable charges variance percentages or fixed amounts per charge code.
3. Invoice Totals Tolerances Setup
Navigate to Accounts payable > Setup > Invoice matching > Invoice totals tolerances.
- Validates the overall invoice gross amount against the expected PO total, catching unexpected roundings, unassigned fees, or miscalculated tax subtotals.
5. Handling Discrepancies, Matching Details & Authorization Workflow
When a vendor invoice is created in Pending vendor invoices (Accounts payable > Invoices > Pending vendor invoices), the system automatically computes matching results.
+---------------------------------------------------------------------------------------------------------+
| Invoice Matching Status Icons & Indicators |
+---------------------------------------------------------------------------------------------------------+
| Status Icon | Technical Status | Operational Meaning & Posting Eligibility |
| :---------------- | :------------------- | :----------------------------------------------------------- |
| 🟢 **Green Check** | **Passed** | All prices, quantities, and totals match PO / Receipts. |
| | | **Eligible for immediate posting or touchless automation.** |
| 🟡 **Yellow Sign** | **Passed w/ Warning**| Discrepancy exists but falls strictly within tolerances. |
| | | **Eligible for posting without manual override.** |
| 🔴 **Red X** | **Failed Matching** | Price, quantity, charge, or total exceeds allowable tolerance.|
| | | **BLOCKED FROM POSTING until officially authorized.** |
+---------------------------------------------------------------------------------------------------------+
Investigating Variances: The Matching Details Form
To inspect a failed matching status:
- Open the pending invoice and click Review > Matching details on the Action Pane.
- The Invoice matching details form displays side-by-side comparisons:
- Unit Price Comparison: PO Price vs. Invoice Price vs. Tolerance Amount.
- Quantity Comparison: Ordered Qty vs. Product Receipt Qty vs. Invoiced Qty.
- Match Status Highlights: Red highlights pinpoint the exact line item and variance type causing failure.
Resolving Discrepancies & Authorization Workflow
When an invoice fails matching, organizations have four operational resolution paths:
+---------------------------------------------------------------------------------------------------+
| Discrepancy Resolution Pathways |
+---------------------------------------------------------------------------------------------------+
| Resolution Path | Action Taken in D365 Finance |
| :-------------------------- | :------------------------------------------------------------------ |
| **1. Correct Invoice Data** | If clerk miskeyed price/qty, edit pending invoice line to match PO. |
| **2. Post Pending Receipt** | If goods arrived but receipt unposted, post Product Receipt first. |
| **3. Update Purchase Order**| Buyer amends PO (e.g., approved price increase) and re-confirms PO. |
| **4. Authorize Override** | Authorized manager toggles 'Approve posting with matching |
| | discrepancies' and submits Reason Code into audit log. |
+---------------------------------------------------------------------------------------------------+
[!TIP] Enabling the Vendor invoice matching discrepancy approval workflow (
Accounts payable > Setup > Accounts payable workflows) automatically routes failed invoices to designated department managers or procurement leads for electronic review, comment, and digital sign-off.
6. Critical Exam Traps & MB-310 Best Practices
| Scenario / Exam Trap | Common Misconception | Correct D365 Finance Behavior |
|---|---|---|
| 2-Way Match Quantity Check | 2-Way matching checks whether the invoiced quantity matches the product receipt quantity. | False. 2-Way matching validates only Net Unit Price against the PO. Product receipt quantity is validated exclusively under 3-Way matching. |
| Tolerance Precedence | Table price tolerances apply only if Group and All tolerances are blank. | False. D365 Finance evaluates Table tolerances first. If a Table rule matches the Item/Vendor, it is applied immediately, ignoring Group and All rules. |
| Posting Blocked Invoices | An AP clerk can post an invoice with a Red X matching status if they have General Ledger posting rights. | False. Posting is completely locked until the discrepancy is resolved, the PO/receipt is updated, or an authorized user approves the override. |
| Charges Tolerance Scope | Charges tolerances apply to the entire invoice total. | False. Charges tolerances validate individual miscellaneous charge codes (e.g., Freight code vs. PO Freight code). Invoice Totals tolerances validate overall document totals. |
A procurement organization configures Accounts Payable parameters in Dynamics 365 Finance with a company-wide default Line Matching Policy of '3-way matching'. A procurement category item 'CONSULT-01' (IT Consulting Services) has its item master line matching policy set to '2-way matching'. A purchase order line is created for vendor 'Fabrikam' (whose vendor master has line matching set to '3-way matching') purchasing item 'CONSULT-01'. The PO line itself has no explicit override specified. Which line matching policy is enforced when the vendor invoice is validated?
A manufacturing facility orders 50 units of raw material SKU-100 at a confirmed PO price of $200.00/unit under 3-way matching. The company has a configured Price Tolerance of 2.0% for this item group. The warehouse posts a Product Receipt for 50 units. When the vendor invoice arrives, the invoice line states 50 units at $207.00/unit ($7.00/unit price increase, or 3.5%). How does Dynamics 365 Finance handle this pending invoice during validation?
An Accounts Payable clerk enters a vendor invoice for $10,000 against a 3-way matched purchase order. The warehouse has only received and posted a Product Receipt for 60% of the goods ($6,000 value), but the vendor has invoiced the full 100% ($10,000 value). The AP clerk attempts to post the full invoice. What occurs in Dynamics 365 Finance, and what is the proper operational resolution?