What had to work
Engineering teams needed date-effective resource assignments and reliable timesheets while preventing overlapping personnel allocation and preserving verified operational records.
How Odoo was shaped around it
- Historical project-manager and staff assignments
- Cross-project overlap validation and employee-relief controls
- Equipment and vehicle allocation/retrieval workflows
- Monthly timesheet grid with holidays, shifts and extra hours
- Invoice, vendor bill and project-finance links
Technical implementation
- Custom OWL, JavaScript and QWeb timesheet interface
- Transient wizards for assignments, relief and responsibility transfer
- PostgreSQL uniqueness constraints and Python business validations
- Stored computed availability/current-assignment fields
- Role-based views and pivot-based timesheet analysis
Operational result
The module centralized project staffing, field assets, timesheets and finance references while protecting verified entries and assignment history.