RE: RMS Purchase Orders - Committing different values
Sounds like to accomplish what you're looking for, you'll have to use the Parent - Child feature.
In your case, the "Parent" item would be the case of food and is what would be entered on the purchase order.
The "Child" item would be the individual can of food and what is actually sold.
When you receive the Purchase Order, you receive the case (Parent item). As your individual cans of food are sold, RMS will automatically "break" one Parent into its children components.
For example:
I have a child item code CANS and a parent item code BOX. There are 12 CANS in each BOX.
At the moment I have 6 CANS on hand and no full cases (0 BOX).
I want to order another case, so I add 1 BOX to a purchase order. When I receive that purchase order, my quantity of 6 CANS will stay unchanged and my quantity of 0 BOX will go up by to 1 BOX.
When I sell those 6 individual cans, RMS will take the BOX quantity to 0 and take the CANS quantity to 12.
Make sense?
MPQ won't help you with what you want to do unless you want to enter each individual can of food to the purchase order as opposed to cases. That's more for your reference so you know how many come in a full case.