How to Correct Out-of Balance Inventory Items for Average Cost items in versions 4.40 and higher

The Average Cost is incorrect on versions 4.40 and higher or:

• There are differences between the Inventory Valuation, Trial Balance and Stock Status reports
• Item Code has a negative or incorrect Average Cost
• Inventory Reports have an Item Code with zero QOH, but has an Extended Total Inventory Value
• Stranded values in the IM_DataEntryCostCalcCommit.M4T table or the CostCalcQtyCommitted or CostCalcCostCommitted fields in the IM_ItemCost.M4T or IM_ItemWarehouse.M4T tables

1. Make a copy of the live Company Code into a test company (i.e. Company Code TST)
2. In the TEST company, run the IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_utl utilities to clear stranded values in the IM_ItemWarehouse, IM_ItemCost and IM_DataEntryCostCalcCommit files.
3. Go to File, Run and type in *UTL and select the Balance Quantity and Cost utility in the test company
4. Open Inventory Management , Utilities , Recalculate Item History utility and click Proceed.
5. Compare costs between the Inventory Valuation, Trial Balance and Stock Status reports and the total Quantity On Hand on the Stock Status report vs. the Trial Balance report. Verify and review specific items in Item Maintenance as well as the reports by grand total and by Item Code.
6. Once the results have been reviewed and verified, create a copy or backup the current live Company Code and repeat these steps in the live Company Code.