Skip to main content
Solved

Available Quantity vs On Hand Quantity


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

Best answer by Naveen Boga

HI, @Ana  Which report looking into?

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.

View original
Did this topic help you find an answer to your question?

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • May 5, 2022

HI, @Ana  Which report looking into?

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.


Robert Sternberg
Captain II
Forum|alt.badge.img+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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings