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
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.