Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good.

Is there a way to fix the average cost? There was an adjustment done a few months back that was in error. But now if I take the quantity and cost out to 0 then put the quantity and cost back correct, the average will just average it, not bring the average in line with the actual cost.

The reason they need this is because the COGS calculations use the Average cost. On the Income statement for they had sales of $9,000 for the 2nd quarter and a COGS of $59,000. That is how they found the error.

Any suggestions?