Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Timesheet - Cannot ...
 
Notifications
Clear all

Timesheet - Cannot find source of huge number of hours

4 Posts
3 Users
0 Reactions
1,108 Views
(@fxandrei)
Posts: 45
Active Member
Topic starter
 
[#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 :))


 
Posted : 06 May 2025 16H22
(@marylene)
Posts: 592
Contributor 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! 


 
Posted : 14 May 2025 11H18
(@fxandrei)
Posts: 45
Active Member
Topic starter
 

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.


 
Posted : 14 May 2025 11H56
babynus
(@babynus)
Posts: 14966
Main Contributor 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]

 
Posted : 16 May 2025 18H16
Share:

Scroll to Top