Skip to main content
Solved

Project WIP Report

  • October 7, 2024
  • 5 replies
  • 185 views

i.m currently on an older version of Acumatica, testing in the sandbox for version 2024R1. I am using the Construction module and crated an invoice for a project. The invoice appears in all of the modules correctly, however, the issue i am having is with the Project WIP Report and Project WIP Detail Report. The Project WIP Report headings Revenue Recognized and Billings in Excess of Costs is showing the correct amount but the Period Billings and Billings to Period are showing credit amounts.

In the two test scenario billings created and posted for the two projects, there were no debit or credit memos to cause a credit balance. It appears the credit balance is equal to the tax amount on each billing. In reading through the notes this is a known problem after the 2023R1 release. The proposed solution to run Recalculate Project Balances doesn’t seem to be working.

Any ideas as to whatelse i could try?

Best answer by RBoudakian

Hi Chris,

yes I was able to find a solution. Working with Acumatica Support, they let me know the issue was due to the chart of accounts and how the AR account 1200 was also included as part of an Account Group which it was not supposed to be. Once the Account Group was removed, all future generated billings were appearing correctly on the report.

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

5 replies

iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 561 replies
  • October 11, 2024

@RBoudakian on the parameters screen, are the periods specified the same as the period the test invoice was created: 

 

 


  • Author
  • Freshman II
  • 2 replies
  • October 17, 2024

hi,

 

yes, the periods on the parameter screen were the same as the period the test invoice was created.

I did a little more investigation and appears the issue may be related to use account groups when creating invoices, however, i need the account groups to handle local taxes.


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 561 replies
  • October 21, 2024

@RBoudakian ahh, are the invoices or amounts missing in an account group that’s either asset or liability?


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2759 replies
  • December 24, 2024

Hi ​@RBoudakian were you able to find a solution? Thank you!


  • Author
  • Freshman II
  • 2 replies
  • Answer
  • March 17, 2025

Hi Chris,

yes I was able to find a solution. Working with Acumatica Support, they let me know the issue was due to the chart of accounts and how the AR account 1200 was also included as part of an Account Group which it was not supposed to be. Once the Account Group was removed, all future generated billings were appearing correctly on the report.


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