This report identifies SKUs in your system that have significant negative value or have negative quantity on hand month after month. This condition can indicate a purchasing issue or a Keep Stock Info misconfiguration. Significant negative value in ending inventory can obscure dollar value and can cause erroneous shrinkage to be reported. Generally, stores exclude negative value from their reported ending inventory by utilizing an option within their RIV report. However, this option is not consistently set across stores or even within the same store (different options for month-end and year-end). Because of these adverse accounting risks, negative value should be minimized. This report is part of Level 2 - Dollar Accuracy Boundary reports.

• • The Keep Stock Info 'N' field is used for SKUs that the system doesn't order automatically or when QOH info doesn't need to be kept. Examples of this: Dump SKUs (for fasteners or screen repair), General Department ring SKUs (30, 40, 50).

  

  • A - Store: Eagle store ID.

    B - SKU: Item Number.

    C - Description:

    D - Location: Primary Location.

    E - QOH: Current as of the 1st of the month.

    F - Last Sale: last time the item was sold.

  

• • The Track Inventory toggle is used for SKUs that the system doesn't order automatically or when QOH info doesn't need to be kept. Examples of this: Dump SKUs (for fasteners or screen repair), General Department ring SKUs (30, 40, 50).

  

  • A - Store: Propello store ID.

    B - SKU: Item Number.

    C - Description:

    D - Location: Primary Location.

    E - QOH: Current as of the 1st of the month.

    F - Last Sale: last time the item was sold.