Forum Discussion
Solved
Actual Task Hours "Auto-populating" in Resource Timesheet
Hello! I have a question about tasks that seem to have time actual values "auto-populate" in them on an employee's timesheets. Basically, when looking at a timesheet in Project Online (PWA), what...
- Cleymay300 --
If the project manager opens the enterprise project in Microsoft Project, and then manually enters a % Complete value on a task with resources assigned to it, the software will automatically calculate the Actual Work for each resource assigned to the task. If the PM then publishes the project, the Actual Work will automatically show up on each resource's Timesheet page in PWA. Have you quizzed your PMs to determine whether any of them are doing what I just described? If they are, tell them to stop doing this, as it appears you want all progress to be entered from the Timesheet page in PWA. The only exception for your PMs is that they can manually mark the % Complete value to 100% on only Milestone tasks. Hope this helps.
Clemay300 --
When Actual Work values appear automatically on the Timesheet page for one or more users, this indicates that the project manager has manually entered Actual Work for those tasks in the Microsoft Project schedule. Otherwise, there should never be Actual Work values that are automatically populated for a user. Would that explain them mystery? Let us know and we will try to help you.
When Actual Work values appear automatically on the Timesheet page for one or more users, this indicates that the project manager has manually entered Actual Work for those tasks in the Microsoft Project schedule. Otherwise, there should never be Actual Work values that are automatically populated for a user. Would that explain them mystery? Let us know and we will try to help you.
Thank you for the quick reply!
To clarify, if a project manager manually manipulating the "Actual Work" values for the tasks in questions, where would they have done that?
Looking at the task in the project in question I can add the "Actual Work" field, however, our PMs are not very adventurous in poking around the app, so I do not think they would have added that field and then updated it. Would they be doing these manual edits elsewhere?
- Cleymay300 --
If the project manager opens the enterprise project in Microsoft Project, and then manually enters a % Complete value on a task with resources assigned to it, the software will automatically calculate the Actual Work for each resource assigned to the task. If the PM then publishes the project, the Actual Work will automatically show up on each resource's Timesheet page in PWA. Have you quizzed your PMs to determine whether any of them are doing what I just described? If they are, tell them to stop doing this, as it appears you want all progress to be entered from the Timesheet page in PWA. The only exception for your PMs is that they can manually mark the % Complete value to 100% on only Milestone tasks. Hope this helps.- This certainly seems like it is most likely the case for what the PMs are encountering. I will check with them and confirm if they are doing what you described above. Thanks again for the information!
Clemay300 & Dale_HowardMVP It's possible to fix this issue. The steps below worked for me, but I'd recommend you try this on a test project and task. The key is getting the Actual Work value set to what the user actually entered in their timesheet. Let me know how it goes.
- You need to retrieve the total Actual Work the user entered in their timesheet. You can connect Power BI to the TimesheetLines table and sum the ActualWorkBillable or Actual lWorkNonBillable depending on how your site is configured.
- This OData query should get you that information, but you'll need to sum it https://<Your PWA>/_api/ProjectData/TimesheetLines?$filter=(ActualWorkBillable gt 0 or ActualWorkNonBillable gt 0)&$select=AssignmentId, PeriodStartDate, ProjectName, TaskName, ActualWorkBillable, ActualWorkNonBillable, TimesheetOwner, TimesheetOwnerId, TimesheetApproverResourceName
- Open project containing the auto-populating tasks
- Open Resource Usage view
- Set the Actual Work value to the value found in step 1 above for each task/resource.
- Ensure the Remaining Work value and Finish dates are valid.
- Publish project
- Have user go to Manage timesheets, select problem timesheet then click Delete. This does not delete entered actuals.
- Click the Click to Create option for the timesheet you just deleted.
- Timesheet is opened and the actuals are no longer auto-populated.
- You need to retrieve the total Actual Work the user entered in their timesheet. You can connect Power BI to the TimesheetLines table and sum the ActualWorkBillable or Actual lWorkNonBillable depending on how your site is configured.
