web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 295

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)
  • Quentin Turban Profile Picture
    6 on at
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    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).

  • Jun Wang Profile Picture
    8,154 Super User 2025 Season 2 on at
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    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
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    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.

  • Alfredo_Iorio Profile Picture
    1,262 on at
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    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

  • Hoang Ng Profile Picture
    295 on at
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    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
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    BC and AX are very different.

    It would help if you can describe the business requirements.

  • Hoang Ng Profile Picture
    295 on at
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    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

  • Suggested answer
    JAngle Profile Picture
    115 on at
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

    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

  • Pushparaj P Profile Picture
    205 on at
    RE: Set up 2, 3 ways matching PO, Receipt, Invoice

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

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 3,070

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans