Timesheets – The Timesheet Chain
BY: Collin Quiring
Having recently worked on two separate Project Server 2010 implementations where each organization used the Timesheet functions I have come across a few gotcha’s that I think might be helpful to document.
This article will discuss the Timesheet Chain. This is where the timesheet is approved but when the approver approves the timesheet they have to send it on to another approver. Even though they approved it, the timesheet still isn’t really approved until the last person in the chain does the approval. In one case, we had four people involved with three approvers.
For example, this is the way it worked:
Team Member — > Manager A — > Manager B — > Manager C
This is the way it worked “out of the box”. We didn’t set up any special groups or settings. In researching it, we had to first figure out why it did the chain approval. Each person’s Timesheet Manager was the person that the approval was going to and Manager C was their own Timesheet Manager. (They were all their own Default Assignment Owner.)
For example, from their user setup screens:
The Team Member:
The first manager:
The second Manager:
And the third and final manager:
So, that was easy enough to see WHY it was chaining. Since each Manager was the next manager’s Timesheet Manager it kept going through the process. But, this setup is correct in that we really did want Manager B to report to Manager C. We really did want the Team Member to report to Manager A. HOWEVER, we wanted it to stop at one approval.
The users were all setup in groups with no selected permissions in their own user setup. The default group settings were not changed. The Managers were all in the Resource Manager group, the Team Member in the Team member group. The RBS was setup but doesn’t appear to play a role in this situation. We searched high and low and were able to piece together the following three pieces that all work in tandem.
Here is gotcha number one:
The system needs to be setup so that the resource that you want to approve timesheets has the “Approve Timesheet” permission. (Note – there is an “Accept Timesheet” and an “Approve Timesheet” permission.) When an individual has the “Approve Timesheet” permission it should stop at that point. They need to have the “Accept Timesheets” permission set to allow in the Global Permissions for the group as well. In our case, no joy.
Here is gotcha number two:
In the timesheet settings you have to turn off (uncheck) the Fixed Approval Routing in the Timesheet Settings and Default screen. (Note – unchecking this only stops the Managers from “selecting” who the timesheet goes to, it does NOT stop the routing from happening.)
Here is gotcha number three:
The permissions for this are based on the Category within the group. The Manager who is approving the timesheet must have the Approve Timesheet permission IN THE CATEGORY that the Team Member has on their group.
Let’s walk through Manager A.
- Manager A was in the Resource Manager group.
- The Resource Manager Group global permissions had the “Accept Timesheets” permission:
- The My Resources Category had all Resource permissions checked, including the “Approve Timesheet”
- Still, when Manager A approved the timesheet, it went to Manager B.
- So, we looked at the Team Member. The Team Member had the Category “My Tasks” in the Team Member Group settings.
- Therefore, we went back to the Resource Manager and added My Tasks to the Category and gave it one permission – Approve Timesheets
And, finally, it stopped routing to the next manager.
Now, when Team Member updates the timesheet, Manager A approves it and it is done. Manager A’s timesheet is approved only by Manager B and Manager B by Manager C.