Has anyone had challenges with the out of the box reports in Acumatica when they do a system update?
I always used the “Employee Hours" Report in the Construction Module to keep track of the amount of labor in the jobs. This is just one example of a report that no longer works after Acumatica did an update.
It now produces nothing:
Another report that I copied, edited, and saved on my own no longer shows the cost in projects.
Acumatica updates can be frustrating.
+16
HI
What version did you recently update to?
Also, are there any customizations related to Construction that are published?
Did you customize this report in the old version?
+6
also, sometimes recalculating project balances help refresh some of the information. i noticed this works well with the WIP report but it might be worth a shot?
Hi
They called it the Minor Update 8. They were trying to resolve an issue that we had in the service module, so they created this update for us which actually didn’t solve the issue yet. :-) One of the reports I did not customize. It’s still the out-of-the-box Employee Hours report in Construction. The other one was a customized one.
+16
Hi
They called it the Minor Update 8. They were trying to resolve an issue that we had in the service module, so they created this update for us which actually didn’t solve the issue yet. :-) One of the reports I did not customize. It’s still the out-of-the-box Employee Hours report in Construction. The other one was a customized one.
HI
For the out of the box report, what are your report parameters and Additional Sort features?
I would have your Acumatica partner (if you are a customer) log a ticket with Acumatica. I know this has been an issue in the past with updates and upgrades where out of the box reports do not work.
Here are the report perameters with no additional sort or filters. It looks the same as yours.:
+16
Here are the report perameters with no additional sort or filters. It looks the same as yours.:
Hi
It may be due to a large number of records being returned. If that’s the case, you would need to have someone look at the SQL.
You could try uploading a prebuilt report from Acumatica. (It won’t let me upload one here for you)
+2
Hi
I looked at some history on this report, and something that seems ancillary, but may be the culprit.
In our User Configuration, there is a “linked entity”, which is typically an employee. That makes the user login / employee relationship. When the ‘linked entity’ was blank, the employee hours report was blank as it could not verify the user running the report had permission to see other employee labor figures.
I also found some comments about report tables. Since the report is driven by time activities, there was a point where the logic changed, CRPMTimeActivity to PMTimeActivity.
Hope this helps.
Good Morning
Thanks for your input. I checked all of our employees, and they all have “Linked Entities”. It the report schema it already has the PMTimeActivity.
I am a system administrator with access to everything in the system, so I would think I should be able to see the results of this report. It’s probably something simple, but this report still comes up blank.
+2
If you would kindly enter a support case, we can dive deeper into your situation.
Thanks.
Thanks,
I’ve never been able to make this report work. I’ve already resorted to custom reporting.
Is there any way I can submit a support case myself on this issue, or do I always have to do it though our VAR? When I try to submit a support case it appears that I am only allowed to submit cases related to an Acumatica University course.
Hi
Thank you for the way you keep your eye on this forum and do your best to see that we eventually get answers. Much appreciated.
Hi
Hi
Our VAR had an open case about it already, so I did not open another case, but no, it has not been resolved yet. The last that I heard on it from our VAR:
“Acumatica is currently looking into this report challenge, and I will let you know as soon as I hear a resolution for this report discrepancies.”
Thanks,
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.