Solved

Paid to Date on Projects

  • 20 September 2022
  • 4 replies
  • 105 views
J
Rank
Userlevel 4
Badge

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?

icon

Best answer by Kandy Beatty 20 September 2022, 23:39

View original

4 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 4
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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved