The system uses price sheets to determine product prices. Every time you update the system with vendor or promotional price changes, the system creates new price sheet effective dates.
Purge price sheets with effective dates that are no longer valid to reclaim disk space for other uses. To run the purge, you need to specify one of the following parameters:
A cut-off date.
The number of price sheet effective dates to keep regardless of the cut-off date.
For example, price line ABC has a price sheet with the following three effective dates: 03/15/1997, 03/15/1998 and 03/15/1999.
If you specify 01/01/1998 in the Purge Price Effective Dates Before field, and 3 in the # of Price Effective Dates to Keep field, the system does not purge any effective dates. None of the existing effective dates meets both requirements.
If you specify 01/01/1998 in the Purge Price Effective Dates Before field, and 2 in the # of Price Effective Dates to Keep field, then the system purges prices for the effective date of 03/15/97.
The number of days entered in the Purge Age (days) field on the Price Sheet Entry screen does not affect this purge routine when creating a new effective date.
Use the following tasks to:
To purge expired price sheets:
From the Maintenance > Merge/Purge menu, select Purge Price Sheets to display the Product Prices Purging screen.
Note: If prompted, log on to the character-based system.
In the Purge Price Effective Dates Before field, enter the cut-off date before which to purge effective date prices for the specified price sheets.
In the # of Price Effective Dates to Keep field, enter the minimum number of price sheet effective dates to maintain for the indicated price sheets regardless of the cut-off.
In the Price Line field, enter the price line whose price sheet information to purge. To enter multiple price lines, use the Price Lines hot key.
You must enter at least one price line. By default, the system displays *ALL* in the Price Sheet field and deletes all expired price sheets in the designated price lines.
To delete a single expired price sheet, enter the price sheet ID in the Price Sheet field.
To delete multiple expired price sheets, use the Price Sheets hot key.
Use the Begin hot key to start the purge routine.
The system returns you to the Merge/Purge menu. When the routine completes, the system notifies you with a message.
To verify that all price sheet purges are complete:
From the Maintenance > Merge/Purge menu, select Purge Price Sheets to display the Product Prices Purging screen.
Note: If prompted, log on to the character-based system.
Use the Check Incomplete Purge hot key to list the purges that aborted before completion or are still running.
You can run the purges again, as needed.
Press Esc to exit the Purge Price Sheets screen and return to the Merge/Purge menu.
See Also: