Three-Way Matching in Dynamics 365 Business Central

By -

Three-Way matching is an Accounts Payable process that is used to verify a vendors invoice by checking it against its corresponding purchase order and receipt.

Three-Way Matching Concept

  • Purchase order - authorizes a purchase. Typically an itemized list of types, quantities, and prices of an order as agreed to by the buyer and supplier. The PO has a unique number to associate this order and should be used by the supplier for tracking and invoicing purposes.
  • Delivery receipt - confirms that the items on the purchase order were delivered. Typically completed by someone in the warehouse.
  • Vendor invoice - lists how much the buyer owes the supplier. Should match the agreed upon purchase order and items received.

Three-Way Matching Process

Typically this process is handled by an Accounts Payable (AP) user. Vendor invoice is sent to AP and that person verifies the delivery receipt in the system prior to entering the invoice. I will go through the basics of this process.
  • Purchase order is issued by Purchasing user. 


  • Delivery receipt has been entered into the system. One of the easiest ways for AP to know if the PO has been received but not invoiced is to add the Amount Received Not Invoiced column to the Purchase Orders screen. Here you can see this PO has been received but not invoiced.


  • Vendor invoice matches the PO quantities and pricing. Next I'll walk through the process of entering a vendor invoice that is using the three-way matching process.



Entering Vendor Invoice

  1. Start a Purchase Invoice and complete the General section:
    1. Vendor Name
    2. Document Date
    3. Vendor Invoice No.




  2. Next is to select the PO and receipt lines that you need to match to this invoice. You won't see lines for anything that isn't received yet. 
    1. Line > Functions > Get Receipt Lines


  3. Select the correct PO and lines you'd like to add to the purchase invoice.


  4. Verify the lines items, quantities, and pricing match the invoice. Make any changes needed and add any item charges that may be applicable. Make sure the Total Excl. Tax field matches the total on the vendor invoice.


  5. Post




------
Kristen Hosman is a Microsoft MVP in Denver. She works with Dynamics 365 Business Central and related technologies. You can also connect with her through this link: Kristen Hosman | Linktree

Comments

Post a Comment

Popular posts from this blog

Invited External Accountant in Dynamics 365 Business Central now what?

By -
Image
This blog describes what comes next after you invite an External Accountant. If you need to invite an External Accountant than visit this blog:  Invite External Accountant in Dynamics 365 Business Central (kristenhosman.com) You've invited an External Accountant now what? What happens after you've successfully invited an External Accountant? You receive the below message in Dynamics 365 Business Central and your external accountant receives an email.  Steps your External Accountant should take Have your external accountant look for an email with a subject line: You have been invited to Microsoft Dynamics 365 Business Central. The external accountant should click on the link provided in the email. They will be redirected to a Microsoft sign in window. In my case the external accountant email isn't listed so I'm going to select use another account. Enter email. Next window suggests that a code was sent to email. Go pull code from email and enter into next window. Accept t
Read more

Microsoft Dynamics 365 Business Central: adding new licensed users to BC

By -
Image
Adding a new licensed user isn't hard to do within Business Central (BC).  Prerequisite: license is purchased and available to assign to user. You also must be an Internal Admin or have proper security within BC to complete these tasks.  Microsoft 365 admin center Assign BC license to user. Dynamics 365 Business Central Navigate to Users page. Select Process > Update users from Microsoft 365 Update users from Microsoft 365 > Next Update users from Microsoft 365 > Next Update users from Microsoft 365. Review the updates within this window and click finish. Lastly assign user group or permission sets and assign company access.  Version: US Business Central 22.1 (Platform 22.0.58213.0 + Application 22.1.55890.56216) Written by: Kristen Hosman, Microsoft MVP
Read more

Applying posted credit memos to posted invoices in Microsoft Dynamics 365 Business Central

By -
Image
Applying posted credit memos to posted invoices isn't a hard task to complete in Microsoft Dynamics 365 Business Central. The example I use below is for a vendor credit, but the same process applies to customers.  Version: US Business Central 20.0 Open up the vendors list. Search for vendor that you'd like to apply the credit memo to an invoice for.  Click on Balance field to open up Vendor Ledger Entries window. This will show all the 'open' documents on the vendor ledger. Select the line for the Credit Memo that you want to apply to a posted invoice. Click Process > Apply Entries Within the Edit - Apply Vendor Entries window select the line(s) that you'd like the credit memo applied to.  Click Process > Set Applies-to ID This will put the users name into the Applies-to ID field on the line selected. To post the application select Process > Post Application. Written by: Kristen Hosman, Microsoft MVP
Read more