Changing Matrix Cell Effective and Expiration Dates

You can change the effective or expiration dates on several matrix cells at once using Quick Matrix Maintenance.

This topic includes the following procedures:

• Changing effective dates

• Changing expiration dates

To change the effective date:

1. From the Maintenance > Price Maintenance  menu, select Quick Buy Matrix or Quick Sell Matrix to display the Quick Buy Matrix Maintenance window or the Quick Sell Matrix Maintenance window.

2. Enter the necessary information to display the matrix cells you want to change.

3. Select Adjustments > Adjust Effective Dates, enter the new effective date at the prompt, and click OK.

4. At the load prompt, enter one of the following:

• Yes - Loads all matrix cells in the matrix, not just those defined in the minimum number of display lines option.  If you have hundreds of matrix cells in the matrix, this could take a few minutes.

• No - Loads the minimum number of matrix cells, as defined in the minimum number of display lines option.

The Matrix Cell Selection window displays.

5. In the Selected column, deselect the boxes for the matrix cells you do not want to change.

6. Exit the dialog box, and save your changes.

7. At the prompt, enter your reason for changing the matrix cells.

The system changes the effective date for all of the selected cells.

To change the expiration date:

1. From the Maintenance > Price Maintenance  menu, select Quick Buy Matrix or Quick Sell Matrix to display the Quick Buy Matrix Maintenance window or the Quick Sell Matrix Maintenance window.

2. Enter the necessary information to display the matrix cells you want to change.

3. Select Adjustments > Adjust Expiration Dates to display the Adjust Expiration Date dialog box.

4. In the Change Expire Date For area, select one of the following:

• All Selected Cells - The system prompts for a new expiration date.

• Cells in a Date Range - Activates the Change Expire Dates fields in the Dates area where you enter the starting date and ending date of the range of cells to change.

5. In the Enter New Date for Selected Cells field, enter the new expiration date and click the Adjust button.

The Matrix Cell Selection window displays.

6. In the Select column, deselect the boxes for the matrix cells you do not want to change.

7. Exit the dialog box, and save your changes.

The system changes the expiration date for all of the selected cells.

See Also:

Copying Matrix Cells

Adjusting Formulas in Quick Matrix