Skip to main content
Solved

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

  • Sep 9, 2025 6:17 PM UTC
  • 5 replies
  • 133 views
  • Translate All
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.

View original

5 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • angierowley75
  • Acumatica Moderator
  • Sep 9, 2025 9:03 PM UTC

Did the quantity for the item get down to zero?

Translate
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
    • Sep 9, 2025 10:19 PM UTC

    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.

    Translate
      Jr Varsity III
      Forum|alt.badge.img
      • ldjmarcog
      • Author
      • Jr Varsity III
      • Sep 10, 2025 11:03 AM UTC

      ​@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.

       

      Translate
        dcomerford
        Captain II
        Forum|alt.badge.img+16
        • dcomerford
        • Captain II
        • Sep 10, 2025 3:18 PM UTC

        ​@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

        Translate
        Dermot Comerford
          Jr Varsity III
          Forum|alt.badge.img
          • ldjmarcog
          • Author
          • Jr Varsity III
          • Sep 10, 2025 3:22 PM UTC

          Thank you all for the your help.

           

          Translate
            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