Creating a Lot Matrix Item?

Apr 06, 2010 2 Replies

I buy oil by the case, 12 bottles per case. I would like to sell them by the bottle but i can't figure out how to do it. In RMS I have a case of oil entered as a standard item. Any help would be greatly appreciated


If you don't sell the case of oil, it seems a parent/child relationship might work better.

- Set up the individual bottle of oil as well, as a standard item.

- In the SPECIAL tab of the individual bottle's properties, assign the case of oil as the parent item - the child qty is 12.

- In the OPTIONStab of the individual bottle, check mark "may not be placed on purchase order" if you cannot buy the individual bottle from your supplier.

- Buy by the case, sell by the bottle. The system will automatically recalculate quantities as you crack > I buy oil by the case, 12 bottles per case. I would like to sell them by the

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required