Ordered but not Replenished

This exception report lists SKUs which have a low likelihood of being replenished...these SKUs are eternally out of stock on your sales floor! This report shows SKUs likely being reordered over and over again (for at least 90 days) but are not being fulfilled from your warehouse. 

Steps to process this report:

    1.  Determine if the SKU is perpetually being ordered by looking at its purchase history in Inventory Maintenance (click on Last Receipt).
    2.  If the SKU is not being perpetually reordered and/or if the SKU is not desired then update its Location Code and set Store Closeout (Codes tab) to Y.
    3.  If the SKU has a replacement then order the replacement and update the canceled SKU's Location Code and set Store Closeout flag to Y.
    4.  If the SKU is showing a QOO Issue? then there might be an issue with a pending order in MPO.

    • In Inventory Maintenance, click on Qty On Order (stocking tab, left column)
    • Take note of the PO(s) for which the SKU is showing On Order (if there are no POs, then blank out Qty On Order and press Change).
    • Look up the PO in MPO, take note of the Date Due (middle left-hand column)
    • Decide if product shipment is delayed, canceled or received via another PO.
    • If shipment is delayed then type in the expected Date Due so that Qty On Order is moved to Qty on Future Order 
    • If shipment has been canceled or received via another PO then consider deleting the PO but check to make sure this is good for all other SKUs on the order.
    • Note: Option IDs: 8967, 104 (default Y), 9823 (default 7) control the behavior of Reverser POs, Future Order and Quantity on Order.

  • Warehouse Status
         Canceled = this item has been canceled from your warehouse and is no longer available.
         Closeout = this item is on closeout status which means it will be canceled when inventory is depleted at your warehouse.
         Restricted = this item cannot be sold to your store, likely for regulatory reasons.
         Seasonal = this item is out of stock for the season.
         Temporary = this item is listed as a Temporary Cancelled SKU in Acenet, whatever that means.
         QOO Issue? = was this an order (like a show order) that was canceled by the vendor? 

    Percentage Days Out Warehouse = the percentage of days the SKU was out of stock at your warehouse over the past 90 days. If a SKU was never in stock then it will show 100%. If a SKU was only in stock a few days then it will show as a low percentage.

MEGA Report Ordered but not Replenished.png