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

Result :

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