Attendance - Unique check based on Employee and Date excluding cancelled docs (#15556)
diff --git a/erpnext/hr/doctype/attendance/attendance.py b/erpnext/hr/doctype/attendance/attendance.py
index 9f8cea8..74a5303 100644
--- a/erpnext/hr/doctype/attendance/attendance.py
+++ b/erpnext/hr/doctype/attendance/attendance.py
@@ -13,7 +13,7 @@
class Attendance(Document):
def validate_duplicate_record(self):
res = frappe.db.sql("""select name from `tabAttendance` where employee = %s and attendance_date = %s
- and name != %s and docstatus = 1""",
+ and name != %s and docstatus != 2""",
(self.employee, self.attendance_date, self.name))
if res:
frappe.throw(_("Attendance for employee {0} is already marked").format(self.employee))
@@ -89,4 +89,4 @@
"docstatus": d.docstatus
}
if e not in events:
- events.append(e)
\ No newline at end of file
+ events.append(e)