Skip to main content
Answer

What would cause the Average Cost of an item to go to 0?

  • September 9, 2025
  • 5 replies
  • 60 views

Forum|alt.badge.img

There is no history in transactions of the item showing anything bringing it to zero.  Is there a utility in Acumatica that I can run to recalculate the Average Cost of an item?

Best answer by bwhite49

There is no history in transactions of the item showing anything bringing it to zero.  Is there a utility in Acumatica that I can run to recalculate the Average Cost of an item?

Yeah, the average cost is always zero when qty on hand is zero. In these cases, your last cost should be your last “average” cost.

5 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • September 9, 2025

Did the quantity for the item get down to zero?


bwhite49
Captain II
Forum|alt.badge.img+10
  • Captain II
  • Answer
  • September 9, 2025

There is no history in transactions of the item showing anything bringing it to zero.  Is there a utility in Acumatica that I can run to recalculate the Average Cost of an item?

Yeah, the average cost is always zero when qty on hand is zero. In these cases, your last cost should be your last “average” cost.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • September 10, 2025

@angierowley75 Yes, it did.  

@bwhite49 the cost that Acumatica pulled up when the user did an adjustment was “0” but he did enter the last cost displayed in Stock Item PRICE/COST tab.

 


dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • September 10, 2025

@ldjmarcog Yes unfortunately the way Acumatica works ….. strange to me as other ERPs still hold the old average if the stock is 0. Only way you are going to find it is to check the Inventory Transaction Details or History Inquiry


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • September 10, 2025

Thank you all for the your help.