Hello,

Have you tried Grouping the GI by the Project, aggregating the AR totals (Sum CuryRevisedAmount, CuryUnpaidBalance, and CuryRetainageUnreleased )?  Example:

Laura

@Laura02 Hi Laura, thanks for the suggestion. I just tried it, and my contract amount is still being multiplied based on how many times the project has been invoiced. If I remove either the PMProjectRevenueTotal or ARInvoice tables everything is correct, but it doesn’t give me all the data I need. I’m 99% sure it has to do with the tables both having the same parent/child fields, but there don’t seem to be any other fields I can choose to make the relationship work.

I’m wondering if there might be another report already in Acumatica that would show the information we’re needing to see. We need an overview of project contract amount, total amount billed to date, including any unreleased retainage, and total amount paid to date. I looked at the AR Open Documents by Project report, but it doesn’t give all the information I’m looking for. My guess is if I add the additional tables needed, I’ll run into the same issue I’m having with the GI.

Any thoughts? Thanks! 

After some testing and viewing some other reports, I was able to come up with a solution. I ended up clearing out all the tables and relations to start over. From the Tables tab, I started with ARInvoice and added PMProject as a related table. Then from PMProject, I added PMProjectRevenueTotal as a related table. So far all my amounts seem to be pulling in the correct numbers. Doing it this way is only showing me projects that have invoices attached to them, verses all projects. However, this works for what I'm needing the GI for.

Thank you for sharing your solution with the community @mnecaise!