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.

• 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.)

  • It's a struggle to keep on top of canceled SKUs! Fortunately, Ace has a procedure to help stores stay on top of these changes. The process is called Item Change Management or ICM and more can be learned on Acenet.

• 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 (Catalog--> View Catalog --> Search SKU --> Click Checkbox  ☑ --> Click the "Add to product" button)

  b. If the SKU is already in your file, then make sure the Store Closeout flag is toggled Off in the Stock & Sell tab of Products and the Product Source flag is blank (Buying 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.)

  • It's a struggle to keep on top of canceled SKUs! Fortunately, Ace has a procedure to help stores stay on top of these changes. The process is called Item Change Management or ICM and more can be learned on Acenet.