I have 4 warehouse and all are under same company but at different places. I have product “ABC” and it's stock level is set as follows at different warehouses :
Warehouse MAIN : 200
Warehouse W1 : 30
Warehouse W2 : 35
Warehouse W3 : 40
Total : 305 ( from all warehouses )
Warehouses like W1, W2, W3 can't direct ask to supplier but if they need the stock for “ABC” then they can ask to “MAIN” warehouse. If at “MAIN” warehouse stock goes below level then automatic purchase order will be placed to supplier.
Now any customer at warehouse W1 asks for 100 Qty. So at W1 30 qty available and 70 needed to request from MAIN warehouse.
Efforts on Odoo I have done so far :
In the pull rule of Warehouse W1, I set action as “Move from another location”. So system asked me for to set “Move Supply Method” and “Source Location”. I have set them as follows,
Move Supply method : Take from Stock
Source Location : MAIN
When Sale Order of 100 gets confirmed ( SO420 for example ), all 100 Qty requested from “MAIN” warehouse whereas I need only 70 Qty from there because I have already 30 Qty available at warehouse W1.
If I make minimum stock rule of Product “ABC” for W1 warehouse then as per Run Scheduler it replenish the required Qtys. But I don't want to keep the stock anymore at W1 for ABC. ( in short, I don't want to configure minimum stock rule for W1 warehouse because main warehouse is not providing me stock in advance )
What I want :
When product ABC is asked by customer at “W1” warehouse, system should check whether it is already available or if there partial qty available then it should only ask remaining qty to warehouse “MAIN”. So is there any kind of configuration I am missing by doing so at procurement Qty will be separated automatically ?? For example by confirming SO420 there shall be 2 procurement orders.
1. W1 --> 30 Qty
2. Main --> 70 Qty
You can apply a trick (tested in V8), pseudo MTO (Make To Order).
1. Use method MTS (Make To Stock)
2. Create Reordering Rule in W1 with Minimum Quantity=0 and Maximum Quantity=0
With these settings, product will first be taken from the stock, if no stock, procurement on requested quantity difference is immediately (after run scheduler!) generated.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/6/15, 6:08 AM|
|Seen: 628 times|
|Last updated: 9/8/15, 6:33 AM|