Difference in Qty on hand, Qty available and available for shipping for a stock item

  • 10 August 2023
  • 7 replies

Userlevel 4

The QTY on hand shows 0, Available QTY is 5 and available for shipping read 0 also, what is might be the course of this difference


Best answer by ricoybanez 10 August 2023, 11:46

View original

7 replies

Userlevel 3

Check your Availability Calculation Rules, this will determine how your calculation behaves.

Userlevel 7
Badge +13

Agree with @ricoybanez if you still feel it is wrong then run the Recalculate Inventory (IN505000) and see if that fixes it

Userlevel 1

Can someone explain the process on how to complete the recalculation of inventory 

Userlevel 7
Badge +8

Hello, here is a nice graphic from Acumatica help on how Qty on Hand vs Qty Available vs Qty Available for Shipping is calculated. 


If you need to Recalculate Inventory use the (IN505000) after business hours as it can be process intensive. 

  1. Navigate to the Screen
  2. Select a Warehouse that Contains the Item(s) to Recalculate
  3. Limit by an Item Class or Inventory ID
  4. Select the Rows (Inventory Items) to Recalculate OR use Process All at the top of the page. 


You can also use the following settings on the Recalculate Inventory screen as needed. 

Rebuild Item History Since A check box that indicates (if selected) that the system builds the history of items based on the available open and released documents starting from a specified financial period.
Replan Back Orders A check box that indicates (if selected) that the system will update the plans for back orders if the available quantities of stock items have been detected during the recalculation. Applicable only to sales orders that do not require allocation.
Exclude Items Without Allotted Plan Types A check box that indicates (if selected) that items without any item plan are excluded from the recalculation of availability data.
For details on items plans, see Availability Calculation Rules: General Information.
Userlevel 7
Badge +12

Hi @helpdesk37 

As @ricoybanez Check your Availability Calculation Rules, this will determine how your calculation behaves.

  • Available: The item’s available quantity  is based on the entire available quantity of the item in Acumatica ERP.
  • Available for Shipping: The item’s available quantity based on the quantity available for shipping in Acumatica ERP.
  • On Hand: The item’s available quantity is based on the on-hand quantity in all warehouses or only specific warehouses.

Recalculate Inventory :

Userlevel 1

Hi there, I had a question to add onto this thread. Can anyone confirm that the quantity available for shipping is what syncs to shopify as quantity available? If that is correct how could I change this?

Userlevel 5

Hi @mralyea ,

If you are syncing Product Availability, I believe the default setting is under the Inventory Settings Tab of the Shopify Store. Hope this helps.



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