web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / 3-way-match with diffe...
Finance | Project Operations, Human Resources, ...
Suggested Answer

3-way-match with different Net Amount passed

(0) ShareShare
ReportReport
Posted on by Afonso Rodrigues 215

Hi all

I have a 3 way match validation set:

pastedimage1634740588895v1.png

I also have set D365 so that I can post a Product Receipt with over delivery. 

I then created a PO with quantity = 10, unit price = 100, net amount = 1000. 

I posted a Product Receipt for a quantity = 15 (it posted because I allow over delivery). 

When the Invoice arrives, for the 15 items, I expect the 3-Way-Match to fail because of the different net amount between the PO and the Invoice. However, although D365 recognizes that different on the Net Amount, the matching passes. 

pastedimage1634740863727v2.png

Is there any configuration that I am missing? My expectation is for this to fail. Why does D365 returns an Invoice Net Amount of 1500 against an PO Net Amount of 1000 but says that it is a pass?

I appreciate all the help in advance. 

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    HI Afonso,

    In this example, the unit price is not deviating from the PO unit price. The quantities will be checked with the product receipt and the price from the PO. So, in this example, the standard behavior is correct.

    You probably need to setup Invoice totals matching to meet your requirement. You can read more about the invoice validations here: Accounts payable invoice matching overview - Finance | Dynamics 365 | Microsoft Docs

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Moderator on at

    Is there any specific rule defined for this combination in AP > Setup > Invoice matching

  • Afonso Rodrigues Profile Picture
    Afonso Rodrigues 215 on at

    Hi André, thank you for your reply.

    Based on the link you've shared, I can see that:

    "Two-way matching and three-way matching always match price information by the unit price. You can also configure these matching policies to match price information by the price total.

    • Net unit price matching – Match price information for two-way matching or three-way matching by comparing the net unit price for each line on the invoice with the corresponding net unit price on the purchase order. The net unit price is determined by the following formula: Net amount of the line / Quantity of the line
    • Price totals matching – Match price information for two-way matching or three-way matching by comparing the net amount (price total) for each line on the invoice with the corresponding net amount on the purchase order. The net amount is determined by the following formula: (Unit price * Line quantity) + Line charges - Line discounts. When matching price totals by percentage, the system compares values using the transaction currency. When matching price totals by amount, the system compares the values using the accounting currency. When you partially invoice a purchase order line, the validation of price-total matching occurs on the last invoice for that line."

    This seems to me that there is a way to set 3-way-match so that it compares the net amount (price total) for each line, which is exactly what I want: If in my example the net amount was compared, the matching would fail.

    However, the article seems to fail the explanation on how to do this setup active in D365. Can you help me with that? 

    Thank you.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Afonso,

    On the Accounts payable parameters, there is a tab called 'Invoice validation'. On this tab, there is a section called 'Price and quantity matching'. Try a different value in the 'Match price totals' field.

  • Afonso Rodrigues Profile Picture
    Afonso Rodrigues 215 on at

    Hi André,

    I have already tried that but without success. However, on another scenario, I had a net value in the PO of 1000£ and on the invoice I changed it to 2000£. The net value was the only thing different between the PO and the Invoice, and the matching failed (as expected).

    Could it be that, in my scenario, although the net amount is different, the matching does not fail because d365 recognizes that the difference is a result of the over delivery that I have previously accepted through configuration?

    Thank you.

  • aalexander2130 Profile Picture
    aalexander2130 21 on at

    Afonso, did you ever receive an explanation for this. I am fighting the same issue!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans
Liquid error: parsing "/blogs/post/?postid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.