delcroip/dolibarr_project_timesheet

Feature Request: Time accounting for employees

Closed this issue · 9 comments

We are tracking the flexible working hours of our employees with timesheet. So each employee has a personal project with a task for each month that has a planned time equal to the working time from their contracts.

However, with this approach, it is difficult to track overtime and undertime at the end of the month. Ideally, we'd like to have a balance of working hours at the end of the month that is automatically set off with the working hours in the next month. So, each employee would easily see if he or she owes hours or can take a day off based on overtime. Right now, overtime/undertime are not propagated to the project for the next month automatically.

Is this somehow possible with timesheet?

I could add a delta : Total of day worked * hour per day OR core hour per week * nb week - holiday prorata temporis (Y day = 1 week) - time registered for the last X month

But it means that all holiday should be either booked as dolibarr holiday OR in a Holiday project and so far we don't have personal time support

And I don't know how sick day are registered (I am not using dolibarr anymore since 3 years)

And X and Y should be somehow defined, I don't have time to do it per employee and I fear that a general setting won't do it ....

Are you aware of dolibarr feature to plan employee time/schedule/workday ?

br

Well, we actually use the Dolibarr holiday feature, so this wouldn't be an issue.

Isn't the contracted work time already available per employee? (In the employee's setting I can set his or hers regular working hours.) Maybe this could be the basis for the calculation?

Our main problem is actually overtime: If somebody has a contract with 40 hours/week and in week 1 he actually works 45 hours, he gets +5 hours on his time balance. If he then, in the next week, only works 38 hours, he gets -2 hours on his time balance, i.e., he has a total of +3 hours. Maybe in the week after he only works 35 hours, so he gets another -5 hours, totaling to a balance of -2 hours. In week 4 he works 39 hours, so finally at the end of the month he has a time balance of -3 hours. He still receives is standard salary but at the beginning of the next month he starts with the time balance of -3 hours.

To try something out I will simply create a BOX on the home page then you can tell if its working (boxes are easy to changes) Le lun. 20 déc. 2021 à 20:37, Maximilian Stein @.***> a écrit :

Sounds great! Thank you very much.

here the result so far

image

I have no timesheet in my demo database of the delta is huge, the 30 week are from config

here the result so far

This looks great, thanks a lot. I am going to test this soon and will get back to you then.

This has actually basically worked in our test so far.

However we are a bit unsure now, whether the timesheet module is the correct place for the implementation (we got a bit confused about which parts are core-Dolibarr and which parts belong to the timesheet module) since we probably will need a daily-based calculation. E.g. there are not only public holidays and employee vacations but also sick leave days and changes in the contract. So, an individual employee might work 20 hrs/week in one month and 25 hrs/week in the other month.
I guess, this simply beyond what timesheet can offer and should offer, isn't it?

Hi,

I started a module to manage employement contract https://github.com/delcroip/Dolibarr_employment_contract but I dropped it because of the lack of time but there is module available

https://www.dolistore.com/fr/modules/1234-Gestion-avanc--e-des-ressources-humaines---GRH---All-In-One.html?search_query=contrat&results=68

you might check with them if they can add this feature.

br

https://www.dolistore.com/fr/modules/1234-Gestion-avanc--e-des-ressources-humaines---GRH---All-In-One.html?search_query=contrat&results=68

you might check with them if they can add this feature.

Sounds interesting, we'll have a look at it.