Summing qty on hand in formula

  • 9 December 2022
  • 2 replies

Userlevel 3
Badge +1

I have a GI that has several calculated fields. I need to take the qty on hand from one Warehouse and add it to the qty on hand form another to show total qty on hand.

I tried grouping by inventory ID however this causes issues in my calculated fields.

Example Error: “Column 'INSiteStatus.QtySOBackOrdered' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.”




2 replies

Userlevel 5
Badge +1

Hmmm… good question, I am working on something similar and I am looking at joining a table to itself and using the new alias table (with the join condition of SITEID = Target WH Site ID to sum the different values I need.  


If you want to attach your GI (xml export) I will be happy to take a look.  Thanks

Userlevel 7

Hi @cmoreland  were you able to find a solution? Thank you!


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