Solved

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

  • 29 May 2023
  • 2 replies
  • 111 views
S
Rank

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!

 

icon

Best answer by manikantad18 29 May 2023, 18:12

View original
1 Attachment

2 replies

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

1 Attachment
Manikanta Dhulipudi If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*
S
Rank

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.

Reply


Terms & ConditionsCookie settings
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