We are trying to develop Time Management Solution in ERPNext,for that we need complete domain knowledge on Shift Management,if anybody can share the domain expertise,it will be heavily useful to integrate time Management in ERPNext.
There are many things to look into.
Like the following:
Timetable
Shift
Schedule
Timetable consist of
Check In Start Time
Check In Time
Check In End Time
Check Out Start Time
Check Out Time
Check Out End Time
Late Arrival Grace time
Early Exit Grace Time.
Start and end time here is the window in which, if the employee punch between this window the system will automatically understand if it is Check in or Check Out. Only if the given shift is assigned to that employee.
Shift consist of the the Days of the week and the timetables assigned to these days.
1 Day can have multiple time tables but cannot have any overlapping one.
Schedule Consist of Employee and the shifts.
Shifts will be assigned to the employee from Start date till End date.
If you need more details you can access the demo server online.
Link: http://80.227.52.78:8080
Login: admin
Password: admin
Please note that the Shift doctype is removed since we already have Shift Details doctype in the ERPNext now. Also the roster is removed as we have Shift Assignment in ERPNext.
Check my customizations for these two docs in my repo. Let me know if you have any queries since my things are working perfectly without the two custom doctypes
No there is no link between zkteco biotime and erpnext.
If the shift is predefined then it will follow the time table n doesn’t matter if it is over night or not
And in case using flexible method then a cut off time needs to be assigned to each flexible shift.
EDIT :
I have recently written a script in ms sql to take raw data from the device into ms dynamics so i was thinking that we can pull the raw logs directly from the device free software and it’s mssql db
And let the erp hr scheduling do the shift, hours calculation.
what we were fetching from raw log see the following columns
Userid (numerical)
Department name
Checktime (punch date time)
Check type (in or out) this is done by user before registering their punch.
Device sn
Device IP
from the above we just need userifd, check time and check type to enter in erp timesheet or attendance data
Lets work on this. I am very much interested in this, as last year we made an excel macro for the and software and turn the output of timeattendance report into erpnext input directly to timesheet and using this timesheet payroll was done with formula in salary against working hours