Solved

Report to view Employee's hours per project for a given timeframe

  • 22 April 2022
  • 9 replies
  • 410 views

Userlevel 1

Is there a report in Acumatica that will show me an Employee’s hours worked per project for a given timeframe?

icon

Best answer by meganfriesen37 28 April 2022, 21:30

View original

9 replies

Userlevel 6
Badge +2

@MBillRJT050619 

The Employee Hours Report (PM622000) and Employee Hours by Project and Task (PM623000) Reports show the total hours worked per project / per employee, but not within a date range.  You can look at adding a filter to those reports, or possibly create a Generic Inquiry off of the PM Time Activity or PM Transaction tables.  There may be some sample GI’s in your current system that can be used as starting points.

Badge +16

Hello @MBillRJT050619 ,

Have you tried Project Cost Transaction History?  The Parameters allow selection of a project and offer the option to “Summarize Labor”. The Additional Filters can be used to choose an employee and range of dates:

 

Userlevel 7
Badge

Hi @MBillRJT050619 have you been able to resolve your issue? Thank you!

Userlevel 1

@Chris Hackett No, I was not able to add a date range to the Employee Hours Report and the Employee Hours by Project and Task report gave me no data no matter how I ran it. Even with no parameters. I tried the Project Cost Transaction History, but I can’t limit it to a date range. I am trying to edit the Employee Hours Report to add an Employee parameter and Start and End Date parameter, but it is saying “Object reference not set to an instance of an object.” I don’t know what part I am missing.

Userlevel 7
Badge +10

Hi, If you start with the DB Project Employee Time Generic Inquiry as a starting point, you should be able to get what you need.

  • Check the Grouping and remove the grouping by employee.  You may want to group by project if you want project totals, or no grouping if you want all the details.
  • Check the Parameters and Conditions, you may want to add start/end date parameters.
Userlevel 2

@meganfriesen37 where is the DB Project Employee Time Generic Inquiry?

Thx,

Userlevel 7
Badge +10

@linettesommerer it comes as part of the set of GI’s with the standard sales demo dashboards (chat with your VAR).  It will likely be GI000041  (if you have the standard dashboards, you can access this one through the “my billing ratio” on the Project Consultant dashboard.  

 

Userlevel 1

@Chris Hackett No, I was not able to add a date range to the Employee Hours Report and the Employee Hours by Project and Task report gave me no data no matter how I ran it. Even with no parameters. I tried the Project Cost Transaction History, but I can’t limit it to a date range. I am trying to edit the Employee Hours Report to add an Employee parameter and Start and End Date parameter, but it is saying “Object reference not set to an instance of an object.” I don’t know what part I am missing.

I am also struggling with this, I need to set a parameter of a period of time such as the last pay cycle and nominate the number of days previous. To capture only jobs that have had time added within the last pay week. Capturing labour/equipment hours on only those jobs active within that certain timeframe.

 

Further from that moving into to each individual job to view/print hours booked on them would be advantageous. 

Is the Employee Hours Report and the Employee Hours by Project and Task still advisable to begin from?

Userlevel 7
Badge +10

@Quest @Chris Hackett 

  1. The PM Time Activity table tracks the hours by the OwnerID (not Employee ID).  I usually link the PMTimeActivity table to the EPTimeCard Table and then the EPTimeCard Table to the EPEmployees table.  Time cards that are on hold are weird though and seem to be missing the timecardCD link.
  2. To calculate the costs related to the hours, you can convert the hours and minutes into a decimal and multiply by the rate in the generic inquiry. 

     

  3. The dates are tricky because any date that I’ve used to filter time automatically also includes a time stamp.  So to look for data for August 3, 2022 I acutally need to look for everything between 08/03/2022 12:00AM and 08/04/2022 12:00 AM.  I do this using a Date Add filter.  

     

Reply


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