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).
Available Quantity vs On Hand Quantity
Userlevel 7
+19
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.
Userlevel 7
+8
Hi 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,
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.