Odoo Help


How to handle delivery from warehouse to transit location to customer's location

Simon Lee
on 11/10/16, 9:53 AM 819 views

I am using Odoo 9. I want to set up odoo to mimic our delivery routines as followed.

Here's the actual scenario. We have a physical warehouse. After a customer order is picked, the goods will leave our warehouse according to the customer's PO. When the goods arrived at the customer, some of the goods may be rejected. The rejected goods will be sent back to our warehouse and will reentered our warehouse. We then need to adjust the delivered quantity to match the final accepted quantity.

For example, the warehouse may have the following goods:

1) Product A, Lot=20170303, Qty=100 pcs

Product B, Lot=20170404, Qty=100 pcs

2) Customer placed an order with the following quantity:

Product A, Qty=20 phs

Product B, Qty=20 pcs, 

3) So an SO is created, confirmed, and picked with the following quantity and lot:

Product A, Qty=20 pcs, Lot=20170303

Product B, Qty=20 pcs, Lot=20170404

4) At this stage, the delivery is not "validated" but when checking the inventory, it should show the following:

Product A, Qty=80 pcs, Lot=20170303

Product B, Qty=80 pcs, Lot=20170404

5) Only the following is accepted by the customer.

Product A, Qty=20 pcs, Lot=20170303

Product B, Qty=5 pcs, Lot=20170404

6) The rejected goods is sent back to our warehouse. We updated the delivery note in our system to match exactly what the customer has accepted as followed:

Product A, Qty=20 pcs, Lot=20170303

Product B, Qty=5 pcs, Lot=20170404

Then clicked "validate" to complete the delivery.

7) The inventory now should have the following quantity:

Product A, Qty=80 pcs, Lot=20170303

Product B, Qty=95 pcs, Lot=20170404


I realise odoo can achieve this out of the box if I use the "reverse" button. But what we want is to adjust the actual qty of the goods accepted by the customer and not the qty that has been sent back. Also, I don't want to have to re-pick the returned goods by selecting the lot information again (this has been done when the goods was originally picked. Picking the rejected goods is repetition).

What is the right way to set up the above? Should I use route? Should I move the goods to an intermediate location liked a transit location, then wait to get the actual delivered quantity before moving the goods to the customer's location after clicking on "validate"? Is there some way to do this thru the odoo UI or do I need to do it thru coding by implementing a custom module?

If someone has an example of a similar set up, please share it with me.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 11/10/16, 9:53 AM
Seen: 819 times
Last updated: 11/10/16, 11:15 AM