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!
