Skip to main content
Question

Employee Hours Report


bzelinski
Varsity II
Forum|alt.badge.img

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.

17 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • October 9, 2023

HI @bzelinski 

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?


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 525 replies
  • October 9, 2023

@bzelinski what i noticed with acumatica updates is that some custom reports get reverted back to the out of the box version.  i like to emphasize that those type of reports and/or inquiries should be reviewed in detail in the sandbox prior to upgrading. this is something i learned the hard way. 

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? 


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • October 9, 2023

Hi @kandybeatty49,

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.

 


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • October 9, 2023

@iqraharrison48 Thanks for the ideas. I tried recalculating the project balances and it still doesn’t work. 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • October 9, 2023
bzelinski wrote:

Hi @kandybeatty49,

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

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. 


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • October 9, 2023

@kandybeatty49 

Here are the report perameters with no additional sort or filters. It looks the same as yours.:

 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • October 9, 2023
bzelinski wrote:

@kandybeatty49

Here are the report perameters with no additional sort or filters. It looks the same as yours.:

 

Hi @bzelinski 

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)

 


joelhoffman
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 275 replies
  • October 10, 2023

Hi @bzelinski 

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.

 


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • October 10, 2023

Good Morning @joelhoffman 

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. 

 


joelhoffman
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 275 replies
  • October 10, 2023

@bzelinski ,

If you would kindly enter a support case, we can dive deeper into your situation.

Thanks.

 


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • October 10, 2023

Thanks, @joelhoffman. I’ve been in touch with Aktion who usually submits the cases for us.


Forum|alt.badge.img
  • Varsity II
  • 85 replies
  • October 10, 2023

I’ve never been able to make this report work. I’ve already resorted to custom reporting. 


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • October 16, 2023

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.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • October 16, 2023

Hi @bzelinski - I spoke to support and they updated your profile to access it. You should log out to refresh and try again.


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • October 16, 2023

@Chris Hackett 

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.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • November 29, 2023

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


bzelinski
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 61 replies
  • November 30, 2023

Hi @Chris Hackett,

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, @Chris Hackett for keeping your eye on it. :-)

 


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