Mango Report
Help Center
Search:
Contents
:
IndexBookmarkPrint

Home > MEGA Report > Ord Not Rep

MEGA Report - 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.
     Column Definitions