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 table (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.

Field

Description

Purge SKUs with no orders for xxx days

The number of days to retain SKUs that are not 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:

Selected (default) = Print the SKU Purged List only.

Unselected = Print the SKU Purged List and purge the items and SKUs that display on the report.

When you select Submit 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.

MPSK OMSCS 19.0 December 2019 OHC