Skip to main content
Solved

Inventory Inconsistencies

  • January 6, 2026
  • 2 replies
  • 38 views
Y
Freshman I

Hello,

Can someone please explain to be how and why inventory inconsistencies occur in the system which gets rectified when the inventory recalculation is executed. 

I have seen in many client instances where the quantities are sitting in SO booked or SO backorder however when looking into the inventory allocation details no transactions are available for these quantities. and once the inventory recalculation is executed the quantities refreshes to the correct value.

Can anyone explain to me why this happens in the system please?

thank you so much in advance and appreciate your kind support in this. 

 

Best answer by travislawson

The inventory recalculation goes back through all of the actual transaction history and rebuilds the inventory from that data.  

 

As things move in/out of Acumatica this information is stored in various tables.  Sometimes things happen where the data is cached but not actually committed and updated in other tables such as INSiteStatus.  Could be a temporary loss of connectivity or resource contention where one rolls back and the other didn’t.  I’ve seen partial writes to the database in that case where everything goes through but the last piece.  

 

So as practice, I usually had that on an automation schedule to run on a weekend so that there wasn’t resource contention with users.  

    2 replies

    T
    Pro I
    Forum|alt.badge.img+1

    The inventory recalculation goes back through all of the actual transaction history and rebuilds the inventory from that data.  

     

    As things move in/out of Acumatica this information is stored in various tables.  Sometimes things happen where the data is cached but not actually committed and updated in other tables such as INSiteStatus.  Could be a temporary loss of connectivity or resource contention where one rolls back and the other didn’t.  I’ve seen partial writes to the database in that case where everything goes through but the last piece.  

     

    So as practice, I usually had that on an automation schedule to run on a weekend so that there wasn’t resource contention with users.  

    🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀 ➡️ www.linkedin.com/in/-travis-lawson-/
      Y
      Freshman I

      ​@travislawson, Thank you so much for your time and effort in this! 
      That gave me clarity on what's actually happening. Really appreciate it. 

        Terms & ConditionsCookie settingsAccessibility 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