the thing you told is OK, but is not solving my prob.
My prob is i have A (FG) which can be made from any one type of Raw material (RM) from 10 different RMs.
(Means I can use any 1 RM type from 10 diff. types depends upon the availability of RM).
e.g. A can be made from 10 Diff. RM, but i have to use only one in the BOM out of 10 by looking the available stock of other 9. So, My question is when i place a sales order for A system should show me the on hand inventory of all the 10 types with how much require to produce 100 of A (pl note: consumption of each RM is different), but that is not possible because i have to use only one type in BOM, and suppose i added all types in one BOM then system will create production order by considering all the type which i don’t want coz…it will increase my time to delete balance 9 items while production posting and secondly this will hamper by costing…(FG items are 400+)