Set up formula on salary rule to get attendance data

Attendance data will be linked to the payroll based on the formulas established on the salary rule. Go to Payroll ‣ Configuration ‣ Salary Rules, at the General tab, you can set up the condition and formula for the salary rule by writing Python code.

You can refer how to access attendance data from salary rules:

# to get the employee attendance entries during the payslip period
attendance_entries = payslip.attendance_ids
# to get total attendance hours
total_attendance_hours = payslip.total_attendance_hours
# to get valid attendance hours
valid_attendance_hours = payslip.valid_attendance_hours
# to get total late coming hours
late_attendance_hours = payslip.late_attendance_hours
# to get total early leave hours
early_leave_hours = payslip.early_leave_hours
# to get number of late comes
late_attendance_count = payslip.late_attendance_count
# to get number of early leave
early_leave_count = payslip.early_leave_count
# to get number of times the employee forget to checkout
missing_checkout_count = payslip.missing_checkout_count

An example of basic wage computation based on total valid attendance:

result = 0.0
# Loop over the payslip's working calendar lines that link to contract for wage calculation
for line in working_month_calendar_lines.filtered(lambda l: l.contract_id):
    result += line.contract_id.wage * line.valid_attendance_hours / line.calendar_working_hours

An example of missing checkout penalty:

Assume each missing checkout would cost $5

result = 5 * payslip.missing_checkout_count

Information on payslips

This module is a combination of Attendances and Payroll applications, all employee attendance data will be linked to payslips at Attendance Summary. Go to Payroll ‣ Payslips ‣ Payslips ‣ Create , additional information includes:

• Late Coming Hours: The total number of hours late for work compared to the start time on the Working schedule. It is calculated based on employee attendance data.
• Early Leave Hours: The total number of hours early for work compared to the start time on the Working schedule. It is calculated based on employee attendance data.
• Late Comings: The number of late comings compared to the regulation.
• Early Leaves: The number of early comings compared to the regulation.
• Missing Check-outs: The number of times that you forgot to check out.
• Total Attendance Hours: Total attendance hours based on the employee attendance data.
• Valid Attendance Hours: Total valid attendance hours based on the work schedule and attendance data.