Item Setup Issues

This report lists SKUs exhibiting setup issues in your system. These item settings can result in: 

  • persistent shrink/swell caused by order multiple and/or unit multiple variances.
  • inventory value errors caused by inaccurate cost calculations when the inventory is received.

What is an Item Setup issue:

Setup issues occur when an item's Order Multiple (the vendor's ordering and shipping unit) differs from the way your customers buy the item AND the SKU is not set up correctly in your system to translate this difference, or vice versa. 

  • Steps to process this report:

    1. Display the SKU in Inventory Maintenance.
    2. Type in the report's Ace OM number into your SKU's Standard Pack and Order Multiple.
    3. Select the report's Ace suggested Purchasing U/M in Inventory Maintenance.
    4. Select the report's Ace suggested Stocking U/M in Inventory Maintenance.
    5. Press Change.

    • The example below shows a balsa airplane assortment delivered with 48 separate airplanes at $3.49 (retail) each. If we look at the (outlined in red) OM/RU section, we see 1/48. This means the vendor OM (Order Multiple) is 1 unit made up of 48 sellable units (Retail Units or RU). When there is a mismatch between vendor OM and vendor RU then we need to set our Eagle system up to translate the vendor OM (of 1 in this example) to the Retail Units of 48. That is, when we order and receive 1 from the vendor, our store QOH needs to increase by 48 or the Retail Unit.Item_setup_issues_acenet.pngItem_setup_issues.png

    • Your Mango exception page shows your store OM, Purchasing U/M and Stocking U/M along with how it needs to be set up to be compatible with Acenet (Ace columns). All you need to do is set the SKU's setting to match the report's Ace column and you will be all set!

      Item_setup_issues_report_example.png Item_setup_issues_fix.png

  • 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 General tab, click the Units of Measure hyperlink (right-hand side).
      4. ​Update the Stocking UOM field to match the S U/M Ace column from the report.
      5. Update the Default Purchasing Unit of Measure field to match the P U/M Ace column from the report.
      6. Press Save in the upper-right.
      7. Repeat these steps for each SKU listed.

    Propello_Item_Setup_Issues.png