View resource assignments Actual Hours incorrect

[dendo151]

I'm viewing a resource in Resources>View Resource Assignments and I added the
Actual Work field in the view. I noticed that the Actual Hours do not match
the actual hours worked. I viewed the time sheets and even queried the
msp_web_work db for the actual hours submitted. What is entered and approved
in the db table has more hours than what is displayed in View Resource
Assignments. Any ideas why?

 

[dendo151]

Additional note I noticed/discovered. If I change the view from Gantt to
Timesheet, and change the duration to the whole timeline that the Gantt chart
is looking at, the Actual Work column amount is different than the Actual
Work amount that totals the Timesheet. Shouldn't those be the same total?

Thanks,

Dave

 

[Dale Howard [MVP]]

dendo151 --

By chance, did you manually enter actuals in the Microsoft Project plan?
And if so, did you click Collaborate - Publish - Republish Assignments,
select the "Overwrite actual work entered by resources" option, and click OK
after manually entering those actuals? The failure to do the republish
assignments step is almost always the cause of work being "out of synch"
between the Microsoft Project plan and PWA, or between two different parts
of PWA. Let us know if this helps.

 

[dendo151]

Dale,

I did not manually enter the actuals in the project. Actually the project
plan and timesheet (PWA) match the number of hours of actual work for the
resource in question. I'm questioning where does View Resource Assignments
get the Actual Hours from? I would think it would have to pull it from the
MSP_WEB_WORK table since that is the table where the hours are broken down by
day and individual. Unless there is a summary table by resource and task
that I haven't found that is used by PWA. I could republish and overwrite
just to get the data in synch, but I don't think that is a valid action since
the timesheet and project plan match.

Thanks,

Dave

 

[Dale Howard [MVP]]

Dave --

I do not know specifically where the View Resource Assignments page draws
its data, but I have assumed that both the View Resource Assignments page
and the View My Tasks page draw their data from exactly the same location in
the Project Server database. I would love to hear from a SQL Server expert
who could solve this mystery for us. Sorry I cannot be of more help.