Planned end date changes when modifying percent complete on a Project Task.


Kingston Patch 3a, Kingston Patch 4, Kingston Patch 6, Kingston Patch 7


This recalculation is expected behavior.


The Actual Start Date is set when a Business Rule changes the state from Open to Work in Progress.

Planned End Date = Actual Start Date + Duration 

This is why a change is seen when percent is updated, because when the user updates percent, the project task moves from "Open" to "Work in Progress", causing "Actual Start Date" to be populated.

Once "Actual Start Date" is populated, then the calculation happens which says, "Take the Actual Start Date, add the duration, and take that value and set it as 'Planned end date'".


If an immutable point of reference is needed, the user can utilize the Original Start Date and Original End Date fields.


If the user does not want the OOB calculation to take place at all, there is a way to accomplish that (though it is unsupported). The user can add the "pm_project_task" table as an entry to the "planned_task_recalculation_exclusions" table. This way, whenever the user updates a percentage on a project task, the expected recalculation will not happen. 

Please note that making this change could cause other potential issues with natural recalculation of projects/tasks.

Article Information

Last Updated:2019-08-02 21:05:53