Use Allocated Accounting to Split Project Online Timesheet Actual Work

v-jiascu-msft Dale,

This is great to allocate project cumulative actual work by cost center, but what I am trying to accomplish at the timesheet line level is to display a table showing all timesheet lines in a certain month that splits the resources' actual work for a project based on the cost center and number of cost centers using the CCPercent fields.

Using your example for the 0620 PR Complex project with the following cost center percentage allocations:

Instead of showing a cumulative view of actual work for the project by cost center:

Display a table that takes a resource's actual work from timesheets and split them into separate lines for each cost center from this:

To this:

And just to throw a big wrench into the mix... If the 0620 PR Complex project schedule's task, Conduct needs analysis, has a task-level field that is not blank (field name: Task Cost Center), the entire actual work for that task would be allocated to the cost center that is listed in the Task Cost Center field and ignore the project-level cost centers. So all other tasks in the 0620 PR Complex project that has actual work reported would follow the allocations at the project-level, but the tasks where the Task Cost Center is not blank would have actual work allocated to the one cost center in that task-level field.

What is the best way to accomplish this?