Reports that are based on the timesheet hour templates are not able to pull data from the timesheet if there is no time entry

  • 1
  • Idea
  • Updated 3 months ago
  • Under Consideration
When the timesheet has 0 hours it is excluded from the report. This creates incorrect results.
It would be good to have a way of specifying whether these timesheets are to be included or excluded from the report.
Photo of Lees, John

Lees, John

  • 2 Posts
  • 0 Reply Likes

Posted 3 years ago

  • 1
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi John,

Welcome to the Replicon community!

Thank you for posting your idea. 

Our PM team will review the same. 

Thanks,
Lingaraj
Photo of Charlene Eriksen

Charlene Eriksen, Product Manager

  • 335 Posts
  • 37 Reply Likes
Hi John,

Can you please provide more details on why you want to report on timesheets with 0 hours?

Thanks,
Charlene
Photo of Lees, John

Lees, John

  • 2 Posts
  • 0 Reply Likes
Because even if there are no hours logged it is still representative of activities in that time period.
We use a custom method of time levelling and if a staff member is over on their hours they can then book zero time without penalty (thus drawing from the overage) for a time period.
Therefore, if we cannot include the 0 hour timesheets when we report on the balance, the calculations are incorrect.
Photo of Charlene Eriksen

Charlene Eriksen, Product Manager

  • 335 Posts
  • 37 Reply Likes
We've heard similar requests from other customers and have been looking to add support for this in the report. No firm plans as of yet, but I'll mark this under consideration and loop in the Product Manager responsible for reports.

Thanks,
Charlene
Photo of Michael Lindauer

Michael Lindauer

  • 14 Posts
  • 0 Reply Likes
Charlene,

I see that this thread is 2 years old, but we are still running into the exact issue described above.  At the end of the month, we want to run a simple report to confirm if all employees have submitted their timesheets and to show the total hours per week.  Currently, if an employee has not entered any data in a specific week, that employee is left out of the report entirely rather than showing "not submitted" or "0 hours entered."  This is quite frustrating.  Is there any way to set the report to pull the status of timesheets for all employees including those who may not have entered any data?
Photo of Jeff Hinzman

Jeff Hinzman

  • 5 Posts
  • 0 Reply Likes

Charlene,


We are in need of this as well.  We are allowing users to go back in to time and make changes.

It would be nice to get the zero row where they moved time from. 


-jeff

Photo of Charlene Eriksen

Charlene Eriksen, Product Manager

  • 334 Posts
  • 37 Reply Likes
Hi Jeff,

Would the timesheet audit trail report help with this? It will show you the changes to the time.

Charlene
Photo of Jeff Hinzman

Jeff Hinzman

  • 5 Posts
  • 0 Reply Likes

can we us a validation rule to prevent rows from being deleted? 

Photo of Charlene Eriksen

Charlene Eriksen, Product Manager

  • 334 Posts
  • 37 Reply Likes
I'll have to look into that. We don't have any pre-built validation rules that do that. However, the audit trail would show deleted time entries - if you clear out an entry it shows that the value was changed from "8.0" to "", for example. If a row with time entries is deleted, the audit trail shows the details of the deleted time entry. Would you need more than that?

Thanks,
Charlene
Photo of Jeff Hinzman

Jeff Hinzman

  • 5 Posts
  • 0 Reply Likes

Charlene,

I am working with the Timesheet audit report and I do get the deleted / modified hours but they are showing up as 7:30:00 I have hours format set to 7.5 but the hours in the audit are showing up as 7:30:00.  The hours that were extracted on the original time sheet are 7.5  I have another thread open in community but for this to work I need to see hours as selected in the format.


-jeff