Project Actual in Resource Aggregate Daily/ Resource Aggregate Monthly table

SK51
Tera Contributor

Hi All, 

Realised that there are tables known as Resource Aggregate Daily and Resource Aggregate Monthly in PPM. 

There are multiple categories there - Availability, Capacity, Non-Project Time, Project Actual, Project Allocated, Project Confirmed. 

 

Would like to know how are the number of hours/ number of FTE get generated for 

  1. Availability
  2. Capacity
  3. Non-Project Time
  4. Project Actual - for this, I have tried clocking in timesheet against the project, however it is not shown. 
  5. Project Allocated
  6. Project Confirmed

Thanks. 

1 ACCEPTED SOLUTION

Rae Ann Prasnic
ServiceNow Employee
ServiceNow Employee

Let's break this down to see where things aren't working as you expect. Are you doing the following?

  1. Create a project
  2. Add a resource plan to the project and allocate
  3. Create a time card for the user on the resource plan, submit and approve
  4. The time card should appear in the related list of the project as processed and an expense line should be generated
  5. Navigate to the resource plan and you should see actuals

find_real_file.png

Also verify the time sheet policy Update actual hours and cost in resource plan/reports is enabled. 

find_real_file.png

 

Please let me know if this is helpful and/or answers your question. Rae Ann

View solution in original post

4 REPLIES 4

Rae Ann Prasnic
ServiceNow Employee
ServiceNow Employee

Did you see this article - Resource Aggregates - All that you need to know?

 

Please let me know if this is helpful and/or answers your question. Rae Ann

Hi Rae Ann, 

 

Good article. Thanks for sharing. 

I have question specific to Project Actuals - it is generated when time card task is a project, project task, story or project type demand. 

However - I have tried clocking time card on project and submitted. Yet I do not see project actuals in resource aggregate monthly/ daily table. 

 

Is there anything else needs to be done? Any background scheduled script? 

 

find_real_file.png

Rae Ann Prasnic
ServiceNow Employee
ServiceNow Employee

Let's break this down to see where things aren't working as you expect. Are you doing the following?

  1. Create a project
  2. Add a resource plan to the project and allocate
  3. Create a time card for the user on the resource plan, submit and approve
  4. The time card should appear in the related list of the project as processed and an expense line should be generated
  5. Navigate to the resource plan and you should see actuals

find_real_file.png

Also verify the time sheet policy Update actual hours and cost in resource plan/reports is enabled. 

find_real_file.png

 

Please let me know if this is helpful and/or answers your question. Rae Ann

Hi Rae Ann, 

 

Tried checking the "Update actual hours and cost in resource plan/ reports". 

We are finally seeing project actuals being generated in resource aggregate table. 

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/task-table/task/create-time-sheet-policy.html

Not sure why the option is not selected by default. 

 

Thanks a lot. 

Still have a lot more to learn in ITBM ServiceNow. 

 

Cheers.