Any suggestion on below scenario:
Let’s take a discrete manufacturing firm produces a Finished Goods product in 3 stages like (Fabrication, Module Assembly, and Final Assembly). Hence physically the production plant is divided into 3 WIP warehouses as the Fab-WIP, MA-WIP, FA-WIP and One Main Warehouse, One Quarantine and one Transit warehouse.
According to the above requirement configured master planning. Main Warehouse refilling to 3 WIP warehouses. There are some raw materials are used in multiple WIP warehouses. Master planning works very well according to the setup and it suggests material planning and capacity planning.
The issue I come across, for instance XYZ raw material item demand in Fab-WIP of 3 Pcs. In MA-WIP XYZ the same item free stock exist of 10 pcs. When I run Master Planning system suggests fulfilling demand by creating a planned purchase order to Main warehouse and a planned transfer order created MW to FAB-WIP, refilling demand in the Fab - WIP warehouse. Master plan does not consider same item free stock in MA-WIP. I understand based on warehouse refilling setup it works accordingly. There is no functionality to consider any free stock in other WIP warehouses. I tried a couple ways to map this process by changing storage dimension coverage by site only or Coverage by Site and Warehouse etc.., But there is no solution map right way.
Could you please suggest according to the above requirement the above mapping is valid. Please advise me if any suggested right solution based on above requirement.