Skip to main content
Solved

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

  • September 9, 2025
  • 5 replies
  • 100 views
L
Jr Varsity III
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
  • angierowley75
  • Acumatica Moderator
  • September 9, 2025

Did the quantity for the item get down to zero?

If I have helped you, please ~ *Like* my post. If I have provided an answer to your question, please mark it as *Best Answer* . Thank you!
    bwhite49
    Captain II
    Forum|alt.badge.img+12
    • bwhite49
    • 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.

      L
      Jr Varsity III
      Forum|alt.badge.img
      • ldjmarcog
      • 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+16
        • dcomerford
        • 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

        Dermot Comerford
          L
          Jr Varsity III
          Forum|alt.badge.img
          • ldjmarcog
          • Author
          • Jr Varsity III
          • September 10, 2025

          Thank you all for the your help.

           

            Terms & ConditionsAccessibility statement
            About Acumatica ERP system
            Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
            © 2008 — 2024  Acumatica, Inc. All rights reserved