Purging SKUs (MPSK)

Purpose: Use Purge SKUs to remove items or SKUs based on item status from the system, and to print the Purged SKU List.

The system uses the SKU Purge Days (F11) system control value to determine how long an item/SKU must have been inactive (an order has not been entered for the item/SKU) to be eligible for purging. For example, if you define 365 as the SKU purge days, a SKU will be eligible for purging if the last order date on the SKU record is older than one year.

The system will not delete an item/SKU if the following records exist:

• the on hand quantity, On order quantity or Backorder quantity is greater than 0 in the Item Warehouse file (fast path = WWHS)

• an order detail line exists for the item/SKU

• an open or closed purchase order detail line exists for the item/SKU

SKU Purge Screen

How to display this screen: Enter MPSK in the Fast path field at the top of any menu or select Purge SKUs from a menu.

INR1129 ENTER SKU Purge 3/04/98 11:18:19 The KL Mail Order Company Purge SKUs with no orders for 30 days Select status codes for SKUs to be purged Print only (do not update) Y (Y/N) F3=Exit F9=Submit F12=Exit

Field	Description
Purge SKUs with no orders for xxx days	The number of days to retain SKUs that are not contained on any existing order. This number defaults from the SKU Purge Days (F11) system control value. Numeric, 7 positions; display-only.
Select status codes for SKUs to be purged	The item status of the items and SKUs you wish to purge. Item status codes are defined in and validated against Work with Item Status (fast path = WIST). Alphanumeric, five 1 position fields; one field required.
Print only do not update	Indicates whether you wish to purge the items and SKUs that meet the selection criteria or print the SKU Purged List report only. Valid values are: Y (default) = Print the SKU Purged List only. N = Print the SKU Purged List and purge the items and SKUs that display on the report. Alphanumeric, 1 position; required.

When you press F9 to process the SKU Purge, the system also prints the Purged SKU List, which lists each item/SKU that is available to purge.

The system purges an item that contains SKUs if all of the SKUs are available to purge.