Skip to main content

We recently migrated all our SKUs from average to standard costing due to average costs getting all mixed up. We did this by issuing out all of the inventory, updating costing to standard and entering a receipt back in.

 

I am running the inventory valuation report but continuing to see the inventory valued at average cost rather than the new standard cost of the SKU for many items.

 

One example is the following SKU:

L175:

Standard Cost - $42

QTY on Hand - 425

Expected Cost - $17,850

 

Cost per Valuation Report

Average Cost - $235

QTY on Hand - 425

Cost on Inventory Valuation Report - $99,875

 

This appears to be an issue for all SKUs with an INCost ValMethod of “A”.

Any reason why this INCost ValMethod would remain as average despite the SKU having been changed to Standard Cost?

@jwarren The update standard cost process should create an inventory adjustment that revalues your on hand inventory. 

 

Try putting $42.08 in the pending cost field but pushing the effective date further back in time and then run the update standard cost function again. Then check inventory adjustments to see if one gets created. 

 

If that doesn't work then I’d put in a case with Acumatica.


@jwarren Can you elaborate on what you mean by “average costs getting all messed up”?


Hi @jwarren were you able to find a solution? Thank you!


Yes the items have been updated through standard cost process. This is out of the box valuation report.

 

Here’s the SKU:

 


Did you run the update standard cost process? Are you looking at the out of the box inventory valuation report or is it a custom GI?


Reply