Skip to Content
Menu
This question has been flagged
2 Replies
282 Views

Hi, we are implementing Odoo so I'm a newbie here....


I'm trying to prevent a pull rule from triggering in a route based on the virtual quantity available in the warehouse. I read that this might be achievable using domain filters (maybe I missunderstood)

What I want to do is create a route with two pull rules originating from the partners/customers location. The first rule, with higher priority, should try to take stock from warehouse A. If not available in Warehouse A, maybe it will trigger  the second rule from warehouse B.

This approach would allow me to reduce the number of routes and make the sales process more user-friendly without using virtual warehouses.


The route I want to achieve would something like this (simplified to explain what I need)

A/Stock -> A/Packing -> A/Out -> Partners/Customers

But if there is no stock in A/Stock, execute:

B/Stock -> B/Packing -> A/Out -> Partners/Customers


This is because I want to transfer already packed products to avoid reception process and I don't want to sales people to select from too many routes (We have several warehouses) 


Can this be achievable? 

Avatar
Discard
Author

Thank you, Jaideep, your explanation was very clear. I have one more question for you.

Using the logic you showed me, is there a way to auto-cancel the items from order WH/PICK/00002 that were requested from WH2 to avoid accidentally duplicating the delivery?

The operation would not reserve the items that are not available, so I guess the only way to duplicate pick would be to manually change the done qty.

The case in your post might be representing only 1 of many scenarios. I would believe in practice a sales order might have multiple products with availability across WHs or maybe partial quantities of a product available in main WH.

These might require decisions on how and where these orders would be fulfilled prior leading to canceling the operation.

If I understand correctly your intention is to modify the demand qty of the product in the 1st operation. Am not certain if that is possible.

Author Best Answer

Exactly, for example, if I create a sales order for 10 units and there are 5 in warehouse A and 2 in warehouse B, I would like a picking order to be generated for 8 units in A and another for 2 units in B. Then, when processing the 5 units from A, a backorder for 3 units would be generated.

Avatar
Discard

The demand qty on an operation can be modified by unlocking. This option is available in the action menu -- (gear icon top left on the operation)

In your example above 2 pick operation is triggered with demand qty 10 in WH1 and demand 5 in WH2. Unlock these 2 operations and modify demand to 8 in WHA and 2 in WHB

Best Answer

Yes, it is possible. 

The latest version accomplishes multi step deliveries using Push rules, ensuring the subsequent operations are created on based on the arrival of products to destination location, also there is flexibility to change destination location on the operations. 

1.Enable 3step delivery on both the WHs Inventory > Configuration > Warehouses

2.On the rule WH: Stock → Customers (main WH) change supply method to Take from stock if unavailable trigger another rule

3.Create new route WH2 to WH 

Pull from - WH2/stock to WH/Stock

Operation - Warehouse 2: Pick (this is critical so a Pick is created in WH2 from stock to Packing zone)

Supply method - In this example take from stock, but you would add multiple rules eg. if stock not in WH2, then pull from WH3 etc..

4. Select this route on the product or product category.

On confirming the sales order (where products are not available in WH) 2 routes would be created. a. Pick in WH from WH/stock to WH/packing locations and b. Pick in WH2 from WH2/Stock to WH2/packing. The 1st operation Pick in WH can be cancelled. Subsequent routes would be created based on the destination locations selected. In practice the product route could be WH2/Stock -> WH2/Packing -> Wh2/Output -> Customer as well

Here is an example of a sale

In the above example, route was as asked in your post.

Please do treat this above as a proof of concept and not a final solution which would I believe need to be specific to your business circumstances.

Avatar
Discard
Related Posts Replies Views Activity
0
May 25
498
1
Jul 24
1211
1
May 24
2313
1
Nov 22
4573
2
Jul 22
3351