The matrix cell effective and expiration dates work with the price date on an order to determine which matrix cell the system uses to calculate the cost or price of a product. You can set up multiple matrix cells for the same vendor or customer and product combination, but each must have different effective dates.
If two matrix cells are set up for the same customer and product classifications, and one has an effective date that overlaps the other's current expire date, the system chooses the cell whose effective date is closer to the price date on the order. For example:
Two sell matrix cells set up for a class 5 customer and sell group FITTINGS:
One is dated 10/15/03 (effective) and 10/31/03 (expire).
The other is dated 10/15/03 (effective) and 10/31/03 (expire).
A class 5 customer orders a product from group FITTINGS.
The price date entered on this order is 10/20/03.
The system uses the sell matrix cell with effective date 10/15/03 because the effective date is closest to, but not after, the price date entered on the order.
Note: If you attempt to create a sell matrix cell identical to another matrix cell, and the new matrix cell's effective date is within the existing cell's effective and expire range, the system informs you that an identical cell exists and displays the dates associated with that matrix cell.
See Changing Prices Using a Pricing Override to see how to override the normal matrix selection routine in Sales Order Entry.
See Also: