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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Set up 2, 3 ways matching PO, Receipt, Invoice

(0) ShareShare
ReportReport
Posted on by 297

Can we set up 2 or 3 ways matching in PO ?

I try to find the instruction but I could not find out.

I have the same question (0)
  • Pushparaj P Profile Picture
    205 on at

    can you elaborate more? what do you mean by Matching? 

  • Suggested answer
    JAngle Profile Picture
    133 on at

    2 way is PO to purchase invoice. Search for the vendor and any provided reference at the time. Attach a copy of the invoice. Fill in the vendor invoice number field. Post invoice

    3 way would be create a purchase invoice. Use the “Get Receipt Lines” button in the lines area of the page. Highlight each relevant line to the provided invoice. Add the vendor invoice number, attach and post. This updates the original PO too. You can perform an approval as well

  • Hoang Ng Profile Picture
    297 on at

    Can we set up in order to system control Matching Policy automatically ?

    In Microsoft AX 2012, I could configure it. But in BC, I have not found out yet:

    pastedimage1659607845191v1.png

  • Alfredo_Iorio Profile Picture
    1,262 on at

    BC and AX are very different.

    It would help if you can describe the business requirements.

  • Hoang Ng Profile Picture
    297 on at

    My management wants to control some specific PO follow 3 way matching:

    - Qty PO = Qty Receipt = Qty Invoice

    - Price PO = Price Invoice.

    If user enter wrong, the system will raise warning

  • Alfredo_Iorio Profile Picture
    1,262 on at

    Strictly speaking, there is no matching of a PO to an Invoice in BC.

    You either create the invoice from the PO, therefore all the fields will match or you create a blank invoice and pull in receipt lines.  Either way, there is no need for the user to type in data and match anything.

    You might want to refer to Microsoft for basic BC functionalities docs.microsoft.com/.../ui-post-purchases

  • Quentin Turban Profile Picture
    6 on at

    Can I ask you what was your approach on this topic please?

    I consider this to be a big loophole in Business Central, especially if you want to use the "Incoming Document" functionality. Because in this case, the purchase invoice lines are automatically integrated to BC (so "Get Receipt Lines" can't really be used) and there should be a standard function allowing, with the Vendor Order No, to match automatically the draft invoice with the purchase order before approving it and posting it.

  • Jun Wang Profile Picture
    8,200 Super User 2025 Season 2 on at

    agree with previous expert what is the business requirements? why does the management trying to use the approach to resolve? what you described here doesn't answer the question because. user could create a po for 10 items, received 5, invoiced 3. As long as the receipt doesn't exceed the order qty, BC is able to receive or invoice. That is why there are bunch of fields on the PO line to show user such as

    depending on what data user enters, but most of the cases it's a user training issue, not on BC side. e.g. If user use get receipt lines to post invoice for 10 items out of 10 on PO. BC will tell user the Qty to invoice shouldn't not more than 0. My personal impression is BC is quite robust on this area of functionality and user needs to figure out suitable processes/control to reduce mistakes. 

  • Quentin Turban Profile Picture
    6 on at

    I see 3 limitations but maybe I'm missing something:

    1) If you use "Incoming Document" (or any other feature allowing to directly retrieve the draft supplier invoice - header and lines - in your Business Central database) then the purchase lines are arleady filled in and therefore I don't see the interest of clicking on "Get Receipt Lines" it would just overwrite the purchase lines that have just been imported.

    2) Second issue is that you assume the receipts and invoicing are done at 2 different moments. But in many cases, it is managed simultaneously and users don't want to manually receipt mutliple POs just to be able to do "Get Receipt Lines" after that. So basically there should a function from the draft purchase invoice allowing you to match this invoice with the PO and when you post that it automatically books the receipt, the invoice and update the PO accordingly.

    3) Last point is very similar to point 2, but what if we are talking about subcontracting invoices or non-inventory items? In this case, you just don't care about the receipt (from a user perspective). But maybe this last point is again another missing feature because basically in BC everything revolves around quantities. Therefor, there is no OOB feature allowing you to manage a purchase order with 1 line and 1 whole amount and after to book multiple purchase invoices which are progressively matched to this PO until the whole amount has been invoiced (it can be managed sometimes by tricking the quantity field but definitively not user friendly).

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…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans