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.”
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
@cmoreland were you able to find a solution? Thank you!