Inventory Average Cost

SUGGESTED

We have a number of inventory items which utilize standard cost as the valuation method.  Due to a number of reasons, the average cost fields in the CI_Item and IM_ItemCost tables are way off.  The system utilizes the standard cost when posting to the GL, but the tables show extended valuation at the quantity times the average cost. 

 

How do we reset average cost and is there a utility to run monthly to clear this problem out?