I am trying my luck here:
Now we have a customer that only wants A's (produced), but our remaining customers continious to be OK with either A or B.
I get we have to split our warehouse from A & B's to handle the first customer, but my questions is:
And also handle the other customers that want either or?
Could you add something on the master data, or somehow add in the order from the customer that IF(customer=OnlyA's -> look at storage location A), OR IF(customer=AnyOther -> look at storage location A or B).
I hope you get the challenge..