Can a resource be removed from a task after posting hours on it?

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

Problem:

There are times when a resource has mistakenly posted time to a task and later needs to be removed from the task, removing a resource from a task even after adjusting timesheets to 0 hours, or after deleting the timesheets still result in an error "PRJ-07580: One or more staff members cannot be removed. This may be due to security, committed actuals or booked requisition."

Why is this and what would it take to remove the resource from the task, or further remove the resource from the project?

Resolution:

Per the current product design it is possible to achieve this goal, however the steps impact a larger amount of data than what you may initially expect: you should be ready to remove all timesheets that fall within the affected time reporting periods, and all financial transactions on the project from not just for a specific resource but all resources. Therefore we recommend that you carefully review the steps below and decide if they are feasible given the scope of the problem and the impact area:

  1. Adjust the timesheets where hours have been posted from, zeroing out the hours from the task and post the adjustment timesheets. If project is enabled for financial, new transactions will be generated from the adjustment timesheets to back out the quantities in WIP. Complete the financial posting so that these new transactions are posted to WIP. If you query the WIP tables where the status = 0 (zero status = current record) you should come up to a net zero units for the assignment. At this point the resource will now show zero actuals on the task assignment
  2. Close the time reporting periods in which the timesheets for the unwanted assignments fall; mark the periods for deletion. Run the Delete Investments job.

    *** IMPORTANT *** This job run will delete ALL timesheets from ALL resources that fall within the time reporting periods closed at this step. The impact area is all resources, on all projects, within the chosen time periods.
  3. If the project and the resource were financially enabled and financial transactions have been posted to WIP, you would need set the project financial status to CLOSED and run one job against this project: Purge Financial Tables job

    *** IMPORTANT *** This job will delete ALL financial WIP transactions for the projects. The impact area is all resources on the selected project

    You should now be able to remove the resource from the task, and remove the resource from the project team as well.

Additional Information:

  • TEC479241  Can you delete an assignment or task with actual units entered?

  • TEC444517  How to create, edit or delete a time reporting period for timesheets

  • In some situations a data cleanup of such large scale is not feasible for the purpose of correcting just one or a few assignments. Therefore our Product Management team is looking to collect 'use cases' and business impact of this limitation of the product design. Please promote and comment on the existing Idea on the Global User Community through the link below:

    Need a way to remove team members from a project even after actuals and transactions are associated to them