Item Matrix Receipts
In many industries, products often have several variations though they share the same basic properties. Using broccoli as an example, the head diameter varies between the first and second harvests. When a mature head is first cut, the head might be seven inches in diameter and only 12 heads can fit into a box. Ten days later, when you cut the side shoots, the heads are 4 inches in diameter and you can fit 18 heads into a box. The broccoli remains the same in its basic properties, such as requirements for storage conditions, shipping, and pricing. But the number of heads contained in each box changes based on the diameter of the each head. In this example, the parent item is the broccoli and the matrix (children) items are the 12-count and 18-count broccoli heads.
The system enables you to use the item matrix functionality when receiving a harvest with a matrix item. When you enter a weigh tag operation for a matrix item, use the Item Matrix option to create multiple detail lines on the purchase order. When you close the operation, the system:
Creates a purchase order line for the parent item for the full quantity on the harvest (providing one doesn't exist).
Creates detail lines for the matrix (children) items based on the weigh tag quantity.
Receives the lines for the matrix (children) lines.
This table shows the system action, affected item, and impact on the item availability:
System Action |
Item |
Quantity |
Item Availability |
|---|---|---|---|
Purchase Order Detail line generated |
Parent item |
Full quantity on the harvest record |
Increases the on-receipt quantity |
Purchase Order Detail lines generated Receipt generated |
Matrix (children) item |
Quantity received on the weigh tag |
Increases the on-hand quantity |
After you have entered all the receipts for the harvest, you must manually cancel any remaining quantities on the purchase order.