|
|
I am about to do an installation where a significant number of the products
are identical, but come from the manufacturer with small modifications and a
new manufacturers part number.
The old products are discontinued, but the company wants to continue to sell
of old merchandise on a fifo basis.
I have currently a single part number for all the variations with different
ProductInventory records for each group. The fifo is enforced by putting
older merchandise in front.
However, it is possible for sales people to need to look up the older
variations and I want them to be able to find the newer inventory.
Does anyone have an idea on how to model this without having a separate
productId for each variation?
Skip
|
Locked
