Skip to main content
Solved

Paid to Date on Projects

  • 20 September 2022
  • 5 replies
  • 144 views

My clients frequently request an ability to show Paid to date values for a specific project (AP and PR), and dollar received on a job (AR)

 

cash entries are not job costed in the current iteration of the system. 

 

What workarounds do other partners utilize to satisfy client requests for paid to date values on a project?

5 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

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

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Heidi Dempsey
Rank
Userlevel 7
Badge +2

@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.

J
Rank
Userlevel 5
Badge

@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. 

joelhoffman
Rank
Userlevel 6
Badge +2

@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.

Joel Hoffman
J
Rank
Userlevel 5
Badge

@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. 

Reply


Terms & ConditionsCookie settings