Overtime compensation using different hourly rates

celiko · December 12, 2024, 5:42pm

Our company operates with employees working in shifts. Occasionally, they work overtime on weekends and public holidays. In ERPNext documentation, when calculating compensation based on the Timesheet, a fixed hourly rate is used. However, I want to calculate compensation using different hourly rates for weekdays, weekends, and public holidays. I need your assistance with this matter.

mohsininspire · December 12, 2024, 6:22pm

Please check out this PR

github.com/frappe/hrms

feat: Over time feature

frappe:develop ← iamejaaz:over-time

opened 11:19AM - 20 Oct 24 UTC

iamejaaz

+1338 -12

TODO: - [x] Write Test Case - [x] Add limit of Maximum overtime hours allowed… per day ### Overtime Type Doctype - All the settings will be in this doctype - User can define which component to take for Overtime calculation - If a user wants to define a different multiplier for weekends or holidays, they can. - Overtime Salary Component: User can define the component in which the overtime amount will be added to salary slips. - Option to define maximum overtime hours to limit them if the user wants. ![image](https://github.com/user-attachments/assets/79a77fd4-3929-4f6b-8ea4-76fa37fe45a7) ### Changes in Shift Type Doctype - Add one section as Overtime - If the "Allow Overtime" checkbox is checked, then the "Overtime Type" field will be visible and the user can select an overtime type. ![image](https://github.com/user-attachments/assets/aa0fa36d-8816-4584-9a13-cd5334e110de) ### Attendance Doctype changes - Add one section to show Overtime details - Overtime Duration: It shows the overtime hours and minutes. - Calculation: Overtime Duration = (Total Working Hours - Standard Working Hours) - Standard Working Hours: Fetch from Shift type to show the standard working hours of an employee (Out Time - In Time). - Overtime Type: Which Overtime Type is applied to this attendance(Link type field for Overtime Type) - E.G: If Week off then 1.25 as defined in Overtime Type - If Holiday then 1.50 as defined in Overtime type - else standard multiplier ![image](https://github.com/user-attachments/assets/0a34527d-7b0c-49f0-b235-f30290a0a1d7) ### Overtime Slip - Basic Details of Employee - Once the user selects an employee, a from date, and a to date, the overtime details child table will automatically populate and fill in all the overtime details. These details will be fetched from attendance. - (pending): We can automate overtime slip creation by adding a button(”Generate Overtime Slip”) to the Shift Type. This button will generate an overtime slip for the entire shift, similar to the "Mark Attendance" button in shift type. - Once the overtime slip is approved and submitted, the amount will be automatically added to the salary slip when it is created. A reference to the overtime slip can also be added to the salary component. ![image](https://github.com/user-attachments/assets/c68ac196-cb37-4b16-abba-87b926f4fcbd) ### Salary slip ![image](https://github.com/user-attachments/assets/cf4369c2-49c4-4257-903f-49d6d949fe15) ![image](https://github.com/user-attachments/assets/63130f08-addb-422b-821b-5ab4fe37cce8)