Skip to main content
Solved

Paid to Date on Projects

  • 20 September 2022
  • 5 replies
  • 162 views

Forum|alt.badge.img

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?

Best answer by Kandy Beatty

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

View original
Did this topic help you find an answer to your question?

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2137 replies
  • Answer
  • September 20, 2022

Heidi Dempsey
Community Manager
Forum|alt.badge.img+2
  • Community Manager
  • 244 replies
  • September 20, 2022

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


Forum|alt.badge.img
  • Author
  • Varsity I
  • 82 replies
  • June 28, 2023

@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
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 272 replies
  • July 6, 2023

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


Forum|alt.badge.img
  • Author
  • Varsity I
  • 82 replies
  • June 6, 2024

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings