How to create a GI to show Qty on Hand and Sold Qty

  • 29 May 2023
  • 2 replies

Hi Team,

We have a requirement where we have to create a GI and have to show Qty on Hand across all warehouses and Sold Qty (Qty across all released Invoices) for stock items. We created a GI and for all new products it is working fine but for existing products the values are incorrect. I am attaching the created GI, can you please review and suggest the best way possible to achieve it.

Thank you!



Best answer by manikantad18 29 May 2023, 18:12

View original

2 replies

Userlevel 7
Badge +11

Hi @santhu3242 

Please find the attached GI which pulls sold and Onhand qty which helps to fulfil your requirement or compare the GI with your GI.

Thank you @manikantad18  for the response, we verified with suggested input and getting the data as expected 

Now the details are showing based on individual warehouse but we need to show one line for one product and have to show sum of Qty on Hand across all warehouses and sum of all sold qty across all warehouse and released invoices.

Can you suggest to achieve this and help with that please.


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 — 2023  Acumatica, Inc. All rights reserved