Skip to main content
Solved

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


Forum|alt.badge.img

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

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

View original
Did this topic help you find an answer to your question?

8 replies

ricoybanez
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 36 replies
  • Answer
  • August 10, 2023

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


dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 584 replies
  • August 10, 2023

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


cervantes09
Freshman I
Forum|alt.badge.img
  • Freshman I
  • 10 replies
  • August 10, 2023

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


Robert Sternberg
Captain II
Forum|alt.badge.img+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.

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

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 :https://www.augforums.com/forums/everything-else/validate-inventory-process/


Forum|alt.badge.img
  • Jr Varsity III
  • 34 replies
  • November 1, 2023

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?


Connor Morse
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 50 replies
  • November 1, 2023

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.

 


Forum|alt.badge.img
  • Jr Varsity III
  • 67 replies
  • October 9, 2024

Hello, 

We have our Shopify connector setup to show Available quantity. We also have Locations in our warehouse set up to not be included in Qty Available because it’s our Quality Control location. 

However, Shopify is showing the total quantity on hand instead of the available number. 

Any ideas?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings