Forum

Timesheet - Cannot ...
 
Notifications
Retirer tout

Timesheet - Cannot find source of huge number of hours

4 Posts
3 Utilisateurs
0 Reactions
1,059 Vu
(@fxandrei)
Posts: 45
Trusted Member
Début du sujet
 
[#9845]

So i have some activities defined, and some users.
One activity shows 3700 hours, real work, for one user associated to it, but cannot find where exactly it is set.
So i go to the activity, select Progress, then on Assigment, i see the user, and it has real h 3700 .

How can i find from where it is comming from ?
Maybe in the tables ?

EDIT:
Seems it has something to do with initial planned and real start and end date. They are very big, and it seems that it take the hours per day and calculates that big hour value.
But i see i cannot change those fields.
Hmmm... i think i need to check the manual :))


 
Posté : 06/05/2025 4:22 pm
(@marylene)
Posts: 592
Membre Admin
 

Indeed. The planned and real dates are automatically populated by the application. The planned date is based on the workload you have assigned to the resource and their availability, and the real date is manually populated via timesheet by the resource.

The real date indicates the date of the first assigment. This gives you the correct assignment week to check.
Right-clicking on a bar showing real work will give you details of the resource's work.
Validating allocations can also be a good way to check data as well as certain reports on actual work.

You can't modify them directly, but you can use the control levers to adjust the planned dates and delete or modify timeheet for the real work.

Hmmm... I think I need to check the manual :))

Very good idea! 


 
Posté : 14/05/2025 11:18 am
(@fxandrei)
Posts: 45
Trusted Member
Début du sujet
 

So ive been looking around for quite some time and i just cannot figure out where those values are coming from.
I can see the value in the timesheet for this resource, on the "real" column, at the front, and also on the revised column.. But i dont know from what its actually calculated.


 
Posté : 14/05/2025 11:56 am
(@babynus)
Posts: 14952
Membre Admin
 

If you can check the DB:

SELECT * FROM work WHERE idResource=[id of the resource] and refType='Activity' and refId=[id of the activity]

 
Posté : 16/05/2025 6:16 pm
Share:
Retour en haut