Compare three inventory reports:

• • Inventory Stock Status Report
  • Inventory Valuation Report
  • Inventory Detail Transaction Report or Lot Serial Transaction History Report (for lot/serial itemized items)

1. Open Inventory Management Reports, Inventory Stock Status Report
   • Uncheck, Print Zero Balances
   • Check, Warehouse Detail
   • Select, Item Code
   • Select, Warehouse
   • Click, Preview
   • Go to Last Page of the report
   • Note the Warehouse Quantity On Hand
2. Open Inventory Management, Reports, Inventory Valuation Report
   • Uncheck, Print Zero Quantity Cost Tiers
   • Print Zero Balances, No
   • Select, Item Code
   • Select, Warehouse
   • Click, Preview
   • Go to Last Page of the report
   • Note the Item Warehouse Total for Quantity On Hand
3. Open Inventory Management, Reports, Inventory Detail Transaction Report or Lot Serial Transaction History Report
   • Selection Criteria, By Date
   • Starting Date, 01/01/1900
   • Ending Date, 12/31/9999
   • Check, Print Lot/Serial Information
   • Select, Item Code
   • Select, Warehouse
   • Select, Lot/Serial number, if applicable
   • Click, Preview
   • Go to Last Page of the report
   • Note the Quantity Detail Total
4. Compare the three total quantities
   • If the quantities are out of balance, run the balancing utility
   • In Sage 100 ERP Launcher, click, File and select Run
   • Run the IM Clear Utilities.  How to run the IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_utl utilities in versions 4.40 and higher
   • Type, *utl
   • Select, Balance Inventory Quantity and Cost
   • Click, OK
   • Answer Yes to ALL update questions
5. Recalculate Item History:
   • Open Inventory Management, Utilities, Recalculate Item History