We are manufacturing a assembly using alternate raw materials say RM1 or RM2 or RM3.
We want to define these three raw materials alternately in such a way that;
1. If stock of RM1, RM2 & RM3 is available, then system should consume the RM1 first always.
2. If required qty is 100. Stock of RM1 is 40, RM2 is 30 and RM3 is 100. In such condition, system should consume the 40 qty of RM1, 30 qty of RM2 and 30 qty of RM3.
3. If stock of RM1 is zero, then system should consume the stock of RM2.
4. If stock of RM1 and RM2 is zero, then system should consume the stock of RM3.
Please guide how to create a BOM to fulfill above requirements.