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 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. 

  Please contact us if you have any questions!

  • REP COST: The SKU’s Replacement Cost (in your E4W system)

    AVG COST: The SKU’s Average Cost (in your E4W system)

    AVG EXT COST: The Extended value of the SKU by multiplying its QOH times its Average Cost.

  • Example: QOH Error

    

    Example: Cost Error

    

    Example: Placeholder misconfiguration

    

    Note: the placeholder above needs to be configured in a way that it can be identified by Mango.

• 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 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 Last Count Date in Stock & Sell (Step 6), and these SKUs should fall off the report. 

  Please contact us if you have any questions!

  • REP COST: The SKU’s Replacement Cost (in Propello)

    AVG COST: The SKU’s Average Cost (in Propello)

    AVG EXT COST: The Extended value of the SKU by multiplying its QOH times its Average Cost.

  • Example: QOH Error

    

    Example: Cost Error

    

    Example: Placeholder misconfiguration

    

    Note: the placeholder above needs to be configured in a way that it can be identified by Mango.