Resource Allocations and Assignments Report seems to have incorrect assignment data

Document ID : KB000033568
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

Data for the Resource Allocations and Assignments report does not seem to have the correct data displayed. We’ve discovered that we have some allocations populating in the assignment, and assignments pulling through erroneously. Please look at our report and see resource, his allocations are posted in the assignment and his November assignment are not accurate.

Resolution:

The 'Assignments' is reporting more than just ETC Hours/FTE.  It includes Actual Hours/FTE.

Assignments = Actuals + ETC

The 'Resource Allocations and Assignments' report can be compared to the Team Details page as follows:

Configure your Project Team Detail page so that the Time-Varying attribute includes both Actuals and ETC values for each month.

Execute the report beginning with the same month as the first month on the Team Details list.

At first glance you might think the report 'Assignments' value is too high, but when you add up both the 'Actuals' and 'ETC' values for that month you will see that it matches.

Example:

Cheryl Amos has 48 hours posted in the month of November for one project and remaining 51.23 ETC hours.

Project Team Detail Page showing Allocation Actuals ETC hours

Compare November Team Details page to the report.

For Cheryl Amos, in November, if you add Actual hours plus ETC hours from the Team Detail list, it equals the total Assignment hours as shown in the report.

48.00 + 51.23 = 99.23

Resource Allocation and Assignments Report