Negative Value - Office Exceptions

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.

You can find a full, multi-store listing in the MEGA Report located in your Data Import directory. Steps to download your report can be found here.

Steps to Process this Report: 

1. Determine if the SKU is a "dump SKU", or if the SKU was not received correctly. 

Dump SKUs should have their "Keep Stock Info" set to N in the codes tab of Inventory Maintenance. This will blank out the SKU's QOH but keep sales information. This is the correct setting for SKUs like your general fastener sales (or dump) SKU.