Forum Discussion
Actual Task Hours "Auto-populating" in Resource Timesheet
- 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 & 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.
- Interesting. I do not have access to PowerBI, but I should be able to use postman to do the API requests. I will see if I can get that actual work data and let the PMs know how to update.
Thanks for that info!Okay, I think I got the query to work. I am a little confused on what I am seeing. I am guessing that the query pulled all timesheet data where the following is true?
- ActualWorkBillable > 0
- ActualWorkNonBillable > 0
However, within the results I am not sure how to interpret what I am seeing. For example, The "Project Managment" task in question has an "Actual Work" value of 201.36. When I run the query provided, I get back two results for that Project/Task combination.
{
"ActualWorkBillable": "10.000000",
"ActualWorkNonBillable": "0.000000",
"AssignmentId": "a3f133f6-0c6a-ee11-b81d-5084928c8376",
"PeriodStartDate": "/Date(1710115200000)/",
"TaskName": "Project Management"}
{
"ActualWorkBillable": "5.000000",
"ActualWorkNonBillable": "0.000000",
"AssignmentId": "a3f133f6-0c6a-ee11-b81d-5084928c8376",
"PeriodStartDate": "/Date(1702857600000)/",
"TaskName": "Project Management"}
Both of the tasks above have the same TimesheetOwner. Is this saying that only 15 hours were entered via the timesheet, so they would overwrite the 201.36 with just 15?