Bait
July 27, 2022, 7:54am
1
First, calculate the late
How is the employee’s total lateness brought up?
It is calculated as follows within the salary components
IF late_entry == True
in_time - start_time else ( start_time in Shift )
0
and get sum all late for employee
How is that done?
second overtime
Is added checkbox as late entry in attendance
If the selection was done manually on Overtime checkbox
Overtime is calculated
IF overtimecheck == True
out_time - exit_time else ( exit_time in Shift )
0
and get sum all overtime for employee
How is that done?
2 Likes
I am new in this forum. I have some questions about this forum. These questions shown below :
Hallo, coming from a classic Projectmanagement i tryed to understand ERPNext - especially Timesheets.
I learned, that a time sheet is not a log. I understand, that a timesheet is like a daily or weekly or however list of logs.
I can open a new timeheet and I can add activity types. Inside the AT i can set the project and the task - fine.
And in this way i can work on projext 1 and project 2 and so on at my daily workhours and “log” all i do for the projects - in a mixture.
Poor is, that i ca…
If anyone has information about this thread. please guide me below. I am very confused about that:disappointed_relieved: .
1 Like
Bait
July 31, 2022, 10:41am
4
How to get the total late from the attendance
Hi @Bait ,
OT payment and late ‘check in’ deduction discussion has been there since 2017 and I still could not find a solution after reading almost all the discussion threads.
There are different alternatives like Timesheet feature under the Projects module which I find impractical in reality for the HR/ employee to update by looking at the attendance report.
There is anyway a Github development for OT which is yet to be tested by my team (link below).
frappe:version-13-hotfix
← Anurag810:overtime-feature
opened 01:18PM - 14 Jun 21 UTC
TODO:
- [x] Test cases
- [ ] Documentation
<h3>Settings:</h3>
Checkout dei… ffrent new settings for Overtime.
![Screenshot 2021-06-15 at 3 13 24 PM](https://user-images.githubusercontent.com/32095923/122033117-dc2fde80-cded-11eb-80cc-85d0a2ac2698.png)
<h3>Master Document Type:</h3>
**Overtime Type:**
Users can define multiple parameters like Multipliers, Salary components contributing towards overtime Amount, etc.
![Screenshot 2021-06-15 at 2 58 00 PM](https://user-images.githubusercontent.com/32095923/122029090-3c248600-cdea-11eb-8911-8658ee8a8534.png)
<h3>Transactional Document Type:</h3>
**Overtime Slip(Based on timesheet):**
![image](https://user-images.githubusercontent.com/32095923/122029832-dab0e700-cdea-11eb-8485-5d8a59806746.png)
**Overtime Slip(Based on Attendance):**
![image](https://user-images.githubusercontent.com/32095923/122030326-4f842100-cdeb-11eb-89a8-2505a6f6282c.png)
**Salary Slip:**
Automated to calculate overtime Allowance Based on overtime Slip generated, which will be reflected In Earnings table with references.
![Screenshot 2021-06-15 at 3 10 37 PM](https://user-images.githubusercontent.com/32095923/122031157-11d3c800-cdec-11eb-8af3-d2c8ad80d71b.png)
**Timesheet:**
You can define Overtime Duration In Time logs in Timesheet
![image](https://user-images.githubusercontent.com/32095923/122031874-bbb35480-cdec-11eb-86d9-96229e2f40d3.png)
**Attendance:**
Defined Multiple parameters to capture Overtime duration.
![image](https://user-images.githubusercontent.com/32095923/122031740-9888a500-cdec-11eb-865b-2a97b48ae2da.png)
**Shift Type:**
Added Dependent Feilds like Standard Working Time and Allow overtime to automate it through Biometric.
![image](https://user-images.githubusercontent.com/32095923/122033302-06819c00-cdee-11eb-9c94-84df077568e6.png)
<h3>Workflow:</h3>
- Overtype Creation:
- HR Manager/User need To define Overtime Type, which can be applicable for Department, Employee, Employee Grade.
- he/she now select Applicable Salary Components which will contribute towards overtime calculation, and define Multipliers.
- Save the documents
- **Workflow if overtime calculation is based on Timesheet**
- User will create Timesheet. In Time logs, He will check Is Applicable for Overtime.
- When checked System Will automatically Fetch Overtime based on the defined Overtime Type.
- Use need to define, Overtime duration and date.
- **Workflow if overtime calculation is based on Attendance**:
- Through Biometric Integration and employee check-in.
- Employee Check-ins Will be automatically Fetch From Biometric Device.
- System is automated to create Employee Checkin in your ERPNext instance.
- Based on Employee Check-ins Scheduler will create Attendance and will also calculate Overtime duration.
- If Shift Management is not being used in your instance you can also Define Overtime Duration manually.
- After the Creation of Attendance/Timesheet. HR Manager/user will create Overtime slip during Payroll.
- HR User will Select Employee Based on that System Will Automatic fetch All details like Payroll Frequency, Overtime details.
- These Overtime Slip will automatic Fetched and the amount will be calculated in the salary slip during payroll.
This maybe the solution for OT but since this topic has being there for sometime now I believe its time that ERPNext teams should come up with a development to configure OT settings (like rates, eligibility etc.), capture OT hours, and capture late hours from late entry and early exit which should be ideally deducted from the monthly salary.
@Reema_Mehta @michelle
Thanks,
Dakshitha