We are trying to download a report of all Available Qty but can only seem to find a report that shows On Hand Quantity. Any suggestions? I want the available qty as that shows everything that is available to sell where as the on hand quantity will show all inventory (even inventory allocated to a sales order).
Answer
Available Quantity vs On Hand Quantity
Best answer by Naveen Boga
HI,
You can get the Available Qty details for each stock item from the “INSiteStatus” table. You can create a GI and get the report.
If you need the Available Qty details for each Stock Item with Location-wise, we can get it from the “INLocationStatus” table.
+19HI,
You can get the Available Qty details for each stock item from the “INSiteStatus” table. You can create a GI and get the report.
If you need the Available Qty details for each Stock Item with Location-wise, we can get it from the “INLocationStatus” table.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
+7Hi Ana,
This should get you started. It will display each item by location with the Available Qty. You can modify this to group by Inventory ID and sum the Qty Available if needed.
Thanks,
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*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.