Calculating Overtime Hours on a per shift basis?

Epicor ERP 10
1

I need to be able to use a baq to present the hours spent by an employee on a particular job, with regular hours and overtime hours separated. Has anyone here done something similar? I’ve been working on this for the past week, but haven’t made much progress as of yet. Any help would be appreciated

2

While it may not be out of the box, a bpm can detect the shift and set the appropriate overtime logic.

1 Like
3

Create a calculated field using a CASE statement to check if total hours > 40, if so then reg hours are 40 and the rest is OT.

4

We need some more details. Is it a per day OT or per week OT? Are there mutliple clock in/outs in a given day?

5

There are multiple clock in/outs per day. If the hours worked in a week exceed 40 hrs, all of the hours after 40 must be considered OT. I need to be able to assign those OT hours to the individual shift that they were worked on. The big picture goal is to be able to see how many OT hours were spent on a project, but I also need to break that down on a per employee basis.

So far, I’ve managed to calculate how many hours in a day each employee spent working overtime, but that information is not useful to me yet until I can tie that information to a job.