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).
Solved
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.