Changing the planned start and end date in Project task is changing the planned dates in Project

Bala13 · ‎08-03-2020

Hello All,

In project management, i am creating a Project with some planned start and end date and saved the record.

Now i am creaeting a Project Task under the project. The planned start and Planned end date of Project task is reflecting same as Project planned start and end date.

I wanted to make the Planned start date of pm_project_task needs to be editable.

So, i have made teh Time constraint field default value as "strat_on" instead of "asap".

Now i can able to edit the planned start date of "pm_project_task". But when i am specifying the date in task and saving it, the same date is updating in pm_project. Which is totally incorrect,

PLease explain me why this is udpaing in pm_prject tavble when i am changing the date in pm_project_task table.

Please reply me as soon as possible.

Thanks

Lalitha

Miguel Donayre · ‎08-03-2020

Hello

you can try this

Planned Date roll-ups are calculated through the business rule 'Recalculate', where the business rules check against the table of exclusions and then apply the recalculation.

Either you modify the business rule or include the 'Project' table to be excluded from the 'Planned task Recalculation Exclusions (planned_task_recalculation_exclusions) ' table.

Go to - planned_task_recalculation_exclusions.list

and add the project table to the list

Try that and see if that works.

I tested it on my instance and it seems to work for me

View solution in original post

Ankur Bawiskar · ‎08-03-2020

Hi Lalitha,

please check any after business rule on that pm_project_task table is setting value on project field

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Bala13 · ‎08-03-2020

Ankur,

Even i checked in my PDI, the same thing its happening.

Can u pls check, actually it should not happen like that right?

Task can be performed whenever we can, but changing of date in task is changing in Project.

Please help me

asifnoor · ‎08-03-2020

Hello Lalitha,

could you check if fhe fields that you see getting updated in project table are the fields of project or task table fields only visible there?

Bala13 · ‎08-03-2020

PLanned start date and PLanned end date field of pm_project_task is getting updated in pm_project table.

Those fields are from planned_task table.