Eternal Outs

Mango Report
Help Center

Search:

Contents

IndexBookmarkPrint

MEGA Report - Eternal Outs

This exception trap shows SKUs being counted (during your shooting outs process) at zero on hand at least twice during the last three months. During this period the SKU has not exhibited any sales nor purchase activity. This can indicate a condition where an empty hook/bin is being counted at zero over and over, but the product is not being replenished. This can happen when an item is canceled from your warehouse or an errant code (Inventory Maintenance) has been applied to the SKU which is blocking it from being reordered. Note: this section excludes SKUs that are out of stock at your Ace warehouse (Ace SKU's only).

Guidance for shooting outs in your store can be found here.

Steps to process this Report:

Determine if the SKU is available from your RSC (type the SKU into Acenet and look for its status) and desired to be replenished.
If the SKU is not desired or not available from the vendor then remove the tag and hook and update its location code and Store Closeout flag if applicable.
If the item or its replacement is available and desired then order the item and/or set its codes (see below) so that it can be reordered.
If the SKU is showing a QOO Issue? then there might be an issue with a pending order in MPO.
If the row is showing ICMBlok then replenishment is being blocked by ICM until the replaced SKU's quantity-on-hand is depleted.

Report Column Definitions

Store Closeout - if a SKU's Store Closeout flag is set to Y (Yes) or U (Temporary) then the item will be excluded from its reorder report (RSO). Multi-Store: this is a store specific code. (Codes tab of Inventory Maintenance)

Disc Flag - if a SKU's Disc flag is set to Y then the item will be excluded from its reorder report (RSO). Note: this flag is usually controlled by Ace (Ace SKUs). Multi-Store: this is master data. (Codes tab of Inventory Maintenance).

ROP Protect - if a SKU is ROP Protected (ROP Protect = Y) and its Order Point is zero then it will not be reordered; set ROP Protect to N. Multi-Store: this is store specific. (Codes tab of Inventory Maintenance).

Warehouse (RSC) Status / additional info:

Active - SKU is an active (reorderable RSC SKU).
AN Direct - SKU is available via Acenet Direct (not replenished via regular RSC order).
- If the replacement SKU has a "D" suffix then the item does not have a suggested RSC replacement.
- If the replacement SKU does not have a "D" suffix then then the suggested replacement SKU is RSC backed.
Blank QOH - the SKU has a blank quantity-on-hand in Inventory Maintenance therefore it will not be ordered via MPO/RSO. Change the QOH to zero for it to be ordered.
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.
ICM Block - (see ICMBlok below)
New - this is a newly added SKU in your RSC and it may be orderable now.
Non-Ace - this SKU is not reorderable via your RSC.
Not in RSC - this SKU is not reorderable via your RSC (it may be available in other RSCs).
QOO Issue? - Check for undelivered or unreceived purchase orders that are blocking this SKU from being reordered.
Recall - item has been recalled. Check Acenet for availability.
Restricted - item is not allowed to be sold in your store for regulatory reasons. Check Acenet for details.
Seasonal - item is seasonally not available via your RSC.
Stop Sale - item has a defect and is not available via your RSC until resolved. Check Acenet for details.
Temporary - item is temporarily not available in your RSC but is expected to be supplied in the future.

Rep SKU:

SKU Number - this is the replacement SKU number.
ICMBlok - this SKU's will not be replenished via RSO/MPO until the corresponding ICM SKU is sold (ICM Blocking SKU). The blocking SKU can be found by clicking the Additional Codes hyperlink in the lower right-hand corner of the Codes tab in Inventory Maintenance).
QOO = XXX - this is the number of units showing as Quantity on Order in your system and may be blocking the SKU from being reordered.

Order Indicator - non-blank values will keep SKUs from showing up on regular RSO reports.

PO Season - shows if a SKU has a PO Season Code which might be keeping this SKU from being reordered.

Times Reported - shows how many times the SKU has shown up on this report trap over the past six months.