View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Timesheet - Cannot find source of huge number of hours - ProjeQtOr
 

Timesheet - Cannot find source of huge number of hours

More
06 May 2025 14:22 - 06 May 2025 15:07 #1 by fxandrei
Timesheet - Cannot find source of huge number of hours was created by fxandrei
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 :))
Last edit: 06 May 2025 15:07 by fxandrei.

Please Log in or Create an account to join the conversation.

More
14 May 2025 09:18 #2 by Arkhanje
Replied by Arkhanje on topic Timesheet - Cannot find source of huge number of hours
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! 
File Attachment:

Please Log in or Create an account to join the conversation.

More
14 May 2025 09:56 #3 by fxandrei
Replied by fxandrei on topic Timesheet - Cannot find source of huge number of hours
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.

Please Log in or Create an account to join the conversation.

More
16 May 2025 16:16 #4 by babynus
Replied by babynus on topic Timesheet - Cannot find source of huge number of hours
If you can check the DB:
SELECT * FROM work WHERE idResource=[id of the resource] and refType='Activity' and refId=[id of the activity]
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.044 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form