Hi Frappe Community,
We’ve been running ERPNext internally at our software company for project and employee management, and I wanted to share a couple of customizations we’ve built that have significantly improved our day-to-day operations.
1. Employee “My Profile” Dashboard
We created a consolidated profile page that pulls together:
- Biometric sync - total check-in hours synced from our biometric attendance machine
- Monthly attendance summary
- Leave summary (taken, remaining, pending)
- Upcoming holidays
- Birthday reminders for team members
- Coordinated leave applications (leaves that overlap with teammates)
This was built using custom doctypes and a dashboard page override. The biometric sync uses a middleware to push attendance logs into ERPNext via the REST API.
2. Modified Timesheet Calendar View
The default calendar view wasn’t giving project managers enough information, so we extended it with:
- Employee-filtered view - PMs can filter by specific employees
- Color-coded status indicators:
Green = Timesheet submitted & approved
Red = Timesheet pending or missing (also flags absent/leave pending)
Yellow = Leave applied/pending- Distinct colors for Full Day vs. Half Day leave
- Attendance events (Absent, Leave approved, etc.) rendered directly on the calendar
3. Timesheet Lockout & Late Fillup Tracking
We added a validation rule that prevents employees from creating timesheets beyond a configurable backdate window (we use 7 days). After that:
- Employee must raise an “Open Timesheet” request
- Manager reviews and approves the request
- The late fillup event is recorded and visible in the employee performance report
This has drastically improved on-time timesheet submission and gives us a transparent audit trail for late entries.
Happy to discuss implementation details if anyone is doing something similar. Would also love to hear if others have tackled biometric sync or timesheet lockout policies in ERPNext.
