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.
+1Check your Availability Calculation Rules, this will determine how your calculation behaves.
Rico P. Ybanez
+15Agree with
Dermot Comerford
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. |
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
+13Hi
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/
Acumatica Functional Consultant & Customer Experience Supervisor
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?
Hi
If you are syncing Product Availability, I believe the default setting is under the Inventory Settings Tab of the Shopify Store. Hope this helps.
Connor Morse, Kensium - Please *Like* if our support has helped. Please mark it as *Best Answer* if we have provided an answer to your question.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.