Paid to Date on Projects

Hi @jsheehan56 

Here is an older post that has good info and a work around for you:

https://community.acumatica.com/construction-120/how-to-generate-date-period-specific-paid-to-date-8296

@jsheehan56  We created two reports - AR Docs By Project with Paid Amt and AP Docs By Project with Paid Amt.  I can send you the files, they will not upload here.

@Heidi Dempsey I wanted to update this dialogue. Support has told me that both of the reports you mentioned are no longer offered by Acumatica as they only work correctly with Single Project per AP Document setting is in use. I only have a small minority of clients that use this setting.

They have also advised me that there are no designs in the 2023 R1 update that provide cash information on projects. Frankly I’m quite surprised that no one at Acumatica sees this as a need, it comes up in every single implementation I do. 

@jsheehan56 ,

If I recall, when the reports “with paid amount” were deprecated in 2021 R1, we added a paid/adjusted amount column to the AP Open Documents by Project (AP634100) and AR Open Documents by Project (AR634100).

This was added a part of our Paid Amount and line-level balances support in AP & AR Reports.

Understanding these show “Open” documents, we are also reviewing / designing some reports that will provide a Project Cash Flow.  No release assigned yet, but will keep everyone updated.

Thanks.

@joelhoffman any update here if Acumatica is going to start to track payment information (outgoing or incoming) on projects?

Comes up as a need in literally every implementation. Just came up today again, every client is shocked to find out that projects track cost and revenue at an accrual basis only. 

looks good ​@joelhoffman! Excited to see it.