Forum Discussion
Timesheet Single Entry Mode
We have been using timesheet single entry mode to decouple actuals from the MS project file and user timesheet actuals. We plan to evaluate the users actuals from their timesheets in BI to reassess our baselines (specifically focusing on effort) and will ignore the actuals from the mpp file. This has worked as expected except for one scenario. When a PM marks a task complete in the project file and a user has logged any amount of time to the task in their timesheet, no project actuals push to the users timesheet (as expected/desired); however if a user has not yet logged any time against that specific task, the assignment planned work in the project file (now actuals) will push up to the users timesheet. We do not want any project actuals pushing to a users timesheet regardless of whether they have filled in their timesheet yet or not. We need the work actuals completely decoupled [timesheet work inputs do not update the project task status and project work inputs do not update the users timesheets]. Please help.
Hello jamieb775
Although I don't know the method you describe, you can experiment by deselecting "Updating Task status updates resource status" option in Menu > File >Options > Schedule > "Calculation options for this project:"
Ignacio
Thank you for your suggestion. We already have this deselected. This only seems to impact the task within the project file at completeness levels under 100%. The issue we are having almost seems like a glitch or oversight from MS. The behavior isn't logical to me.
I've seen this before. At the resource assignment level, when the Actual Work for the assignment doesn't match the hours entered in a user's timesheet MS pre-populates the timesheet with Actuals. It distributes the Remaining Work over the duration and applies it to the current and future timesheet when they are opened.
To identify these issues, we created a Power BI report that compares the Assignment level Actual Work to Timesheet hours. When there is a difference just open the plan and update assignment level Actual Work to match Timesheet hours submitted.
