Use Case - I have a group of customers from - state/province
I want model to pick only - 1 DC out of N DC ( i.e - all customers in that particular State/province -should get material from 1 DC (same DC))
N.B- I have - different drop size for each customers & also cost is different - basis DC & Customers.
Question - How can we model this case?
I am exploring the single sourcing - from customer product table & location product table