You can update multiple matrix cell expire dates to extend their effective date. Organize the cells by customer, class, product, or group and update the entire selection.
Determine which matrix cells are about to expire by running the Matrix Cell Expiration Report. Then use Matrix Cell Expire Date Maintenance to change those expiration dates if necessary.
To update a matrix cell expire date:
From the Maintenance menu, select Price Maintenance > Matrix Cell ExpireDate to display the Matrix Cell Expire Date Maintenance window.
In the Branch/Territory field, enter the branch or territory you want to query. Enter All to query all branches and territories.
In the Customer field, enter a customer's name to restrict the matrix cells to that customer, or enter multiple customers. If you enter a customer, you cannot enter a class.
In the Class field, enter a class to restrict the matrix cells to that price class, or enter multiple price classes.
Leave the Customer and Class columns blank to include both customer and price class matrix cells.
In the Product column, enter a product to restrict the matrix cells to that product, or enter multiple products. If you enter a product, you cannot enter a group.
In the Group field, enter a sell group to restrict the matrix cells to that group, or enter multiple groups.
Leave both the Product and Group fields blank to include both product and sell group matrix cells.
Note: If you leave the Customer, Class, Product and Group fields blank, the system selects all customer/product, customer/group, class/product, and class/group matrix cells that fall within the effective date.
In the Report field, enter one of the following:
Include - Updates the matrix cells and sends a report containing a list of the updated matrix cell records to the Hold file containing a list of the updated matrix cell records.
Exclude - Updates the matrix cells, but does not send a report to the Hold file.
Only - Does not update the matrix cells, but does send a report to the Hold file containing a list of the matrix cells.
In the Expire Dates area enter the following:
Old - The expiration date of the matrix cells you want to update.
New - The new expiration date.
In the Effective Dates area, enter the following:
Start - A date to limit the search for matrix cell to those that went into effect after this date.
Ending - A date to limit the matrix cells to those that went into effect before this date.
See Also: