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.

• 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 might be a SKU or two on your list that has 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 an Mango compatible way.
    
    
  • Low Turns  - SKUs with high inventory value low (or no) sales history can sometimes be falsely listed on this report. This is especially true for stores new to Mango who have large quantities of out-of-season inventory (ice melter, fertilizer). These SKUs will disappear from this listing once they start selling.

  • 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 - Rep Cost: Replacement Cost.

    G - Ext. Rep Cost: QOH multiplied by replacement cost.

    H - Avg Cost: Average Cost.

    I - Ext. Avg Cost: QOH multiplied by average cost.

    J - Retail: Retail price for the item at POS.

  

• Steps to process this report:

  1. Select the Products Menu.
  2. In the search box, type a SKU from your report and press Enter.
  3. In the Stock & Sell tab, verify the SKU's physical QOH.
  4. If the QOH is out of line then correct it in Physical Inventory.
  5. Verify and correct the SKU's Retail, Average, and Replacement Costs in the Prices & Cost tab.
  6. Update the SKU's "Last Count Date" in Stock & Sell.
     
     1. Select Actions in the upper-right.
     2. Adjust Inventory.
     3. Set Toggle to Variance.
     4. Enter a Count of 0.
     5. Select Finalize.

  Special Cases
  There might be a SKU or two on your list that has 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 an Mango compatible way.
    
    
  • Low Turns  - SKUs with high inventory value low (or no) sales history can sometimes be falsely listed on this report. This is especially true for stores new to Mango who have large quantities of out-of-season inventory (ice melter, fertilizer). These SKUs will disappear from this listing once they start selling.

  • 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 - Rep Cost: Replacement Cost.

    G - Ext. Rep Cost: QOH multiplied by replacement cost.

    H - Avg Cost: Average Cost.

    I - Ext. Avg Cost: QOH multiplied by average cost.

    J - Retail: Retail price for the item at POS.