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.”
Best answer by cmoreland
I eventually moved this out of Acumatica and used our tableau reporting to develop the solution.
+7Hmmm… 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
Hi
I eventually moved this out of Acumatica and used our tableau reporting to develop the solution.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.