I am trying to create a GI in Acumatica to display all Vendors and the total sum of all PO $ amounts by item. Here is the result I am looking for, but as I investigated each PO and item, the totals are not correct for the Sum of Gross $.
Here is what currently exists in the GI
I also tried using AVG aggregate function and that did not work either. Any suggestions/advice on how to pull the proper amounts?
Thank you!
Best answer by sbond84
I see you are using the total from the PO Order. I believe you are going to need to use an amount field from the PO line, so it’s linked to the item, not the whole PO.
I thought the same thing! I tried that as well by using CuryLineAmt for POLine with aggregate function SUM and got the same number results.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
