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
Solved
Difference in Qty on hand, Qty available and available for shipping for a stock item
Best answer by ricoybanez
Check your Availability Calculation Rules, this will determine how your calculation behaves.
+5Check your Availability Calculation Rules, this will determine how your calculation behaves.
+16Agree with
Can someone explain the process on how to complete the recalculation of inventory
+7Hello, 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.
- Navigate to the Screen
- Select a Warehouse that Contains the Item(s) to Recalculate
- Limit by an Item Class or Inventory ID
- 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. |
+16Hi
As
- 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/
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?
+1Hi
If you are syncing Product Availability, I believe the default setting is under the Inventory Settings Tab of the Shopify Store. Hope this helps.
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?
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.