Hi,
I have a case where I need to do a direct routing when we make a sales order.
Condition:
- Have 4 warehouse: US, Europe, India, Japan
- Have several logistic plan:
- If sell from US, check stock on Europe, if not available India, if not available Japan.
- If sell from India, check stock on Japan, if not available Europe, if not available, US.
(Basically try to find the nearest warehouse)
- Product Tissue Box: With Quantity on Warehouse Europe: 2 and Warehouse Japan: 3
Case:
- Sell 4 Tissue Box from US, expected result, Odoo creates 3 picking:
1. From US -> Customer
2. From Europe -> US (2 qty)
3. From Japan -> US (2 qty)
- Sell 4 Tissue Box from India, expected result, Odoo creates 3 picking:
1. From India -> Customer
2. From Japan -> India (3 qty)
3. From Europe -> India (1 qty)
I did a little research before, and try to solve with Routing, Rules in Odoo, but some blocking point are:
1. Cannot make direct route, Odoo will always send the product sequentially. Like in Case 2 it will do Europe -> Japan -> India ->Customer, this imply longer lead time
2. Cannot take partial qty. Like in Case 2, Odoo will not Take 3 from Japan, instead wanted 4 in Europe and wait for stock in Europe to replenish.
Any help is appreciated. Thanks