You can set a buy or sell matrix cell to expire when the amount of on-hand product reaches a set quantity. For example, if you run a promotion on an item and want to end the promotion after you sell 100 pieces of the item, set the matrix cell to expire after 100 are sold.
With the exception of an O-type matrix, expiration quantities are designed to work only with pricing and not costing. Therefore, if an O-type matrix cell contains expiration quantities on it and is being used for costing, the remaining quantities should be reduced. However, if the costing comes from an N-type matrix cell and that matrix cell is not used for pricing, then the remaining quantity is not reduced.
From the Maintenance > Price Maintenance menu, select Sell Matrix or Buy Matrix to display the Sell or Buy Matrix Maintenance window.
Enter the required information to display the list of matrix cells containing those cells to copy.
In the Matrix Type field, enter the matrix type for this cell.
In the Expire Quantities area, enter the following:
In the Original field, enter the amount of product, dollar value, or unit value of items available for this pricing matrix. After that quantity is sold, the matrix cell expires. For example, if you run a promotion on an item and want to end the promotion after you sell 100 pieces of the item, set the matrix cell to expire after 100 are sold.
The Remaining field displays the same amount entered in the Original field. This quantity decreases as product is sold.
In the Type field, enter one of the following to apply a unit of measure to the quantity:
U-Unit - Applies the unit of measure from the product record to the quantity.
W-Weight - Applies the product weight (lbs.) from the product record to the quantity.
L-Load Factor - Applies the load factor from the product record to the quantity.
D-DFLT LIST - Applies the default LIST amount to the value in the Expire Quantity field. This makes the entry a dollar value.
The results of running the Expire Quantity option depends on whether you are setting up a buy or sell matrix cell:
For costing on the buy matrix cell - As products are sold, the remaining quantity on the matrix cell reduces by the quantity bought. When this value reaches zero, the matrix cell expires.
For pricing on the sell matrix cell - As products are sold, the remaining quantity on the matrix cell reduces by the quantity sold. If a customer orders more than the remaining quantity, the items are priced depending on the setting in the Split Quantity Pricing area:
No- The system prices items according to the normal matrix cell applicable to the product and the customer entered in the matrix cell.
Yes - The system prompts you in order entry to override split pricing for the item. Enter one of the following at the prompt:
Yes - The remaining quantity is priced at the special price and the number of items over that quantity is priced according to the normal matrix cell.
No - Items are priced according to the normal matrix cell applicable to the product and the customer.
See Also:
Copying Override Pricing to the Matrix