Lock a task - prevent of booking on it

[Hans Wurst]

Hi there,

in our company we have the following problem:

A task is finished. Everyone knows it's finished. Still there are people
booking their actuals on it. Can I prevent them from doing it?

My idea is to set a flag in the project plan and apply a filter to the
timesheet. It's a good idea - except that you can't apply a filter to the
timesheet.

Has anyone an idea how I can do it? I know it's possible, because you can
buy an Add-In that does the same.

Best regards

Michael

Time to make friends..... ;-) we won!

 

[clin341]

Hans,

I'm having a similar problem. The solution I have found was to modify the
database directly by setting the WASSN_DELEG_PENDING field in the
msp_web_assignments table to 1. Keep in mind that the msp_web_assignments
table contains a row for each assignment. That means that there is a row for
each resource and task. If you want to lock a task, you would have to set
the value for each resource and task.

It seems to work for me but since I just found this yesturday, I've posted
on the developer discussion list to see if anyone knew whether toggling this
field will cause any negative impact.

If you are unfamiliar with SQL or have other questions, please ask.

CLin

 

[Hans Wurst]

Hi CLin,

thanks a lot for your post!

For me as I know SQL it will be no problem to manipulate that table, but
it's not practicable for all the PM's. Maybee the developers have another
idea - can you tell me with someone answers your post?

Best regards

Michael

 

[clin341]

I'm glad to help. There's no replies yet but I'm hoping someone from
Microsoft will respond.

CLin

 

[Regis]

I have the same situation and I'm very curious if this is possible without
playing with SQL manipulation.