Timesheet unsubmitted but also turned off

[Karine Johannesen]

Hi,

Under "Admin/Server Configuration" we decided to set the following global
properties to DENY because we don't want to use the timesheet approval
process:
-Timesheet Approval -> Deny
-Approve Timesheets for resources -> Deny

However, every time that a managed periods ends, the team members keep
receiving a message on their home page stating that their timesheet has not
been submitted. These messages stay there forever even though the team
members do press Update All at the end of the manages period to submit their
task updates.

If the timesheet approval process is turned off why do we keep receiving
these messages about timesheets??

Thanks,
Karine

 

[FaisalM]

Try this:

http://www.faisalmasood.com/blog/msproject/2005/12/removing-unsubmitted-timesheets.html

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Karine Johannesen]

Thanks for the link, but where am I suppose to type that query.... ?

 

[FaisalM]

Run this query in Query Analyzer against your Project Server database.

You may consult your SQL DBA for some help on that. Let us know if that helps.

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Karine Johannesen]

Hi!
I found similar queries on the Microsoft website with instructions.
I was able to run the queries in the Query Analyzer and it fixed the problem.
However it looks like I might have to run these queries on a weekly basis...
From what I understand the queries removed the unwanted messages from past
timesheets, but they don't prevent future messages.

Here is a link to the queries:
http://support.microsoft.com/?kbid=897769

Thanks a lot!
Karine