Multiple suppliers for one item is great.
Multiple items from the same supplier would be nice.
For example, we sell spa (hot tub) supplies. One of the products we carry is basically spa perfume. It comes in four scents. I can order cases of
12--either 12 of each scent or an assorted case (3 each of all 4 scents).
More example Case of 12 Scents: Scent A = 1234A Scent B = 1234B Scent C = 1234C Scent D = 1234D
Assortment = 1234X
I don't have an induvidual item 1234X, only items 1234A-D.
I cannot add both reorder numbers to the items, as RMS won't let me add the same supplier twice for any given item.
I could use a parent-child relationship, but I don't think that will work exactly as needed in this scenario, either. With four items sharing the same parent and the parent containing 3 of each child, will the first child to sell out cause the parent to break into all four items?
Ideas?
Tom