I have a product which can be made by two different subcontractors. Each subcontractor uses raw material supplied by me but each uses a different raw material. I can't figure out how to split the demand between the two supply routes - it always selects the first vendor...
So..
Product A can be made by Vendor X using Material ABC
Product A can be made by Vendor Y using Material DEF
It doesn't matter which subcontractor makes the order or which raw material is used - the finished product is the same and is stocked and sold as Product A.
Anyone have tips on how to set this up?