Canceled and Replaced - Office Exceptions

This report lists canceled warehouse SKUs and their corresponding replacement SKU. To be listed, the canceled/replacement pair must meet the following conditions: 

1. Canceled SKU's quantity-on-hand (QOH) is zero or less 
2. Canceled SKU's location code is "active" (begins with 0-9)
3. Replacement SKU is not in file (NIF) or has a QOH of zero
4. Replacement SKU is available at your warehouse 
5. Replacement SKU has some sales history in your peer group

The TR (Times Reported) column shows how many times (months) the SKU has shown up on this report.  A value of zero or blank will indicate a newly reported SKU.

​

You can find a full, multi-store listing in the MEGA Report located in your Data Import directory. Steps to download your report can be found here.

Steps to process this report

1. Determine if you want to replace the canceled SKU:

If you do -

a. Add the REP SKU to file if its REP QOH column showing NIF (you can use catalog (F2) from Inventory Maintenance to accomplish this).

b. If the SKU is already in your file then make sure the Store Closeout flag is set to "N" in the codes tab of Inventory Maintenance and the Order Indicator flag is blank (Stocking Tab).

c. Set the replacement SKU's location code to the appropriate location in your store.

        d. Make a scan tag and ensure the item can be put away when it comes in on the next delivery.

        e. Remove the canceled SKU's scan tag and hook from the sales floor.

        f.  Set the canceled SKU's location to your store's drop location code (e.g. DR19, CLOSE, ZZZZZ, etc.)

If you do not want to replace the SKU -

     a. Remove the canceled SKU's bin tag and hook from the sales floor.

     b. Set the canceled SKU's location to your store's drop location code (e.g. DR19, CLOSE, ZZZZZ, etc.)

Tools: Location Code Reference