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

icon

Best answer by Naveen Boga 5 May 2022, 02:44

View original

2 replies

Userlevel 7
Badge +17

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.

Userlevel 7
Badge +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


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved