Skip to main content
Solved

How to get qty on hand in inquiry

  • July 15, 2022
  • 3 replies
  • 796 views
S
Freshman II
Forum|alt.badge.img

Hello. Im trying to make GI getting Qty on hand from warehouse

Wat tables and fields should I use for this GI?

Thanks.

Best answer by Naveen Boga

Hi @skater4  There are two ways of fetching the Qty OnHand from DAC/Table.

 

  • If you wanted to fetch On Hand Qty based on the warehouse, you can fetch the Qty On Hand from the INSiteStatus Table/DAC.
  • Or If you wanted to fetch Qty On Hand from the Warehouse and Location-wise, you need to fetch the value from the INLocationStatus Table/DAC.

Here is the screenshot for reference.

 

3 replies

jinin
Pro I
Forum|alt.badge.img+11
  • jinin
  • Pro I
  • July 15, 2022

Hi @skater4,


you can get the warehouse Qty availability, On hand Qty detail from the InSitestatus table. I’ve attached a sample GI for your reference.

1 Attachments
Jini N
S
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • Answer
  • July 15, 2022

Hi @skater4  There are two ways of fetching the Qty OnHand from DAC/Table.

 

  • If you wanted to fetch On Hand Qty based on the warehouse, you can fetch the Qty On Hand from the INSiteStatus Table/DAC.
  • Or If you wanted to fetch Qty On Hand from the Warehouse and Location-wise, you need to fetch the value from the INLocationStatus Table/DAC.

Here is the screenshot for reference.

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
S
S
Freshman II
Forum|alt.badge.img
  • skater4
  • Author
  • Freshman II
  • July 15, 2022

Hi @skater4,


you can get the warehouse Qty availability, On hand Qty detail from the InSitestatus table. I’ve attached a sample GI for your reference.

Hi @skater4  There are two ways of fetching the Qty OnHand from DAC/Table.

 

  • If you wanted to fetch On Hand Qty based on the warehouse, you can fetch the Qty On Hand from the INSiteStatus Table/DAC.
  • Or If you wanted to fetch Qty On Hand from the Warehouse and Location-wise, you need to fetch the value from the INLocationStatus Table/DAC.

Here is the screenshot for reference.

 

Thanks a lot, it worked for me

Terms & ConditionsCookie settingsAccessibility statement
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