Enable Dark Mode!
3-way-matching-in-odoo-v13.png
By: Antony Francis

3-Way Matching in Odoo 13

Functional Odoo 13 Purchase

There are certain times in the business where you will receive a merchant's vendor bill before receiving the ordered goods. The bill may not, however, be paid until the quantity is provided. 3-Way matching functionality comes in handy to determine the validity of the vendor bill and to determine whether it should be paid. The feature allows you to compare the data appearing on the purchase order, receipt and vendor's bill. It also prevents the customer from paying fake vendor bills.


Here we go to the configuration of 3-Way Matching

Firstly we have to enable it from the settings of Purchase Module.
Go to  Purchase > Configuration > Settings > Invoicing > 3-way matching


3-way-matching-in-odoo-v13


Then click the “Save” button.

When we activate this option in the settings, data will be updated in the vendor bill, whether the bill ‘should be paid’ or not.  

We have three default options here.


* Yes: Pay the bill, you have received the quantity of product. 

* No: Don't pay the bill because you have not received the product.

* Exception: Difference in the ordered, billed and received quantities of products.


Let's check all the three cases.

First of all, we need to create a product and keep its Control policy as Received quantities which means create bills based on the quantity received.


3-way-matching-in-odoo-v13


Now let's create a purchase order for this product.


3-way-matching-in-odoo-v13


Let’s save and confirm it.

Now we shall receive the products by clicking on “Receive Products”.


3-way-matching-in-odoo-v13


After receiving the products we shall create the bill for the product. Click on “Create Bill”.


3-way-matching-in-odoo-v13


Create the bill and save it. Now click on the “Other Information” we shall see the status of the bill.


3-way-matching-in-odoo-v13


Here we can see the status of the bill “should be paid” is “Yes”. So from this, we can understand that the bill is created for the received quantity of products.


Here, the demanded quantity, received quantity and the billed quantity are the same.


Now let us create another purchase order. Mention the vendor, product, demanded quantity and unit price. Save and confirm the order.

Now before receiving the products, we shall create the bill. Now let us see the status of the bill clicking on “Other info”.


3-way-matching-in-odoo-v13

 

Here the status of the bill is “No”. The reason is that we have not received the products.


3-way-matching-in-odoo-v13


Here we can see that the quantity demanded and billed are the same but the quantity received is 0.


Again we shall create a purchase order. We shall mention the vendor, product, unit price and quantity.

Here we shall receive the product in a quantity and bill the product in different quantity.


3-way-matching-in-odoo-v13

 

Here we can see that the demanded quantity is 2, billed is 2 but the received is 1.

Then, 

 

3-way-matching-in-odoo-v13


The status of the bill in “Should be Paid” is “Exception”.


If we want to manually change the status of the bill, we can do it by clicking on the down arrow there. Then a drop-down list will come. There you can select the bill status as we wish.

 

3-way-matching-in-odoo-v13


Here we can change the status manually. Then a “force status” will appear there.


3-way-matching-in-odoo-v13


This is all about the “Three-way matching” in Odoo v13.



If you need any assistance in odoo, we are online, please chat with us.



0
Comments



Leave a comment

 


whatsapp
location

Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635

location

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

location

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message