Cost/QOH Errors - Office Exceptions

This report identifies Cost and/or QOH errors in your system affecting Dollar Accuracy. These errors occur when QOH values seem excessive or Retail, Average or Replacement costs are misaligned. This report, along with your Store Supply and Persistent Negative QOH Reports are your Level 2 - Dollar Accuracy Boundary reports. SKUs will be reported every month until corrected. 

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. Start with the first SKU on your Cost/QOH error report.

2. Verify the SKU's physical QOH.

3. If the QOH is out of line then correct it in PIP.

4. Verify and correct the SKU's Retail, Average, and Replacement Costs in the Pricing tab of Inventory Maintenance.

   1. In Eagle Browser, open Inventory Maintenance.

   2. Enter the SKU from your Cost/QOH Error report and click the Display button.

   3. Click on the Pricing Tab.

   4. Retail, Average, and Replacement costs can be aligned if out-of-whack. (for stores with columnar pricing grids, you can edit costs in the 2nd or 3rd column).

5. Update the SKU's "Date of Last Physical" in Inventory Maintenance.

Special Cases

There may be a few SKUs on your list that have the correct pricing and QOH info:

• Placeholder - (holds the value of an entire department or class of goods) then please see our Setting Up Placeholder SKUs page to set this SKU up in a Mango-compatible way.
  
  

• Low Turns  - SKUs with high inventory value and low (or no) sales history can sometimes be falsely listed on this report. This is especially true for stores new to Mango that have large quantities of out-of-season inventory (ice melter, fertilizer). You can update the SKU's Date of Last Physical in Eagle Inventory Maintenance and these SKUs should fall off the report.