Packaging Ratios are set up to help track parts that are sold individually, but ordered and received in bulk.
Order Parts with a Package Ratio
Set Up Packaging Ratios
- Open the Parts & Service module.
- Choose the Master Inventory option from the tools menu on the left side of the screen.
- Search for the part number and open the record.
- The Selling Packaging is used to show the way you sell the part. For example, the selling packaging may be "each" for items sold individually, "foot" for items sold by the foot, etc.
- The Purchase Packaging is used to show the way that you order and receive the part. For example, the purchase packaging may be "case" for items purchased by the case, "roll" for items purchased by the roll.
- The Packaging Ratio is the number of selling package units per one purchase package unit. For example, "12" items in the case, "50" feet on the roll.
Note: The selling and purchase packaging descriptions are set up in the Parts Pick List.
- Verify the part's Retail Price. This should be the price of the selling package item (each/foot).
- Verify the part's Cost. This should be the cost of the selling package item (each/foot).
Note: If the part is in a price book and the price/cost indicated in the price book is the bulk price/cost, then you will need to uncheck the Price Book Update boxes for the retail price and replacement cost.
Order Parts with a Package Ratio
When a part with a package ratio is added to the Order List, the Packaging Ratio field will show that there is a multiplier involved. In addition, the Ordering comments field will indicate how many individual items are being ordered.
Once the PO is created, those same fields carry over and the sub-total of the PO reflects the cost of the case.
Receiving a Packaged Part
- On the receiving ticket, add the part.
- Enter the Quantity Received.
- Set the Packaging Ratio. This may be automatically populated when you enter the part.
- Enter the Cost per selling package item (each/foot).
The extended cost will equal the cost multiplied by the quantity received. This should equal the full supplier's cost of the package (case/roll).