Actual Hours and Remaining hours not getting updated

V

VJ

We are using MS office Project 2003/SP3 and SQL2005 database. This is been happening to multiple user

Resource Enters 40 hours(8 hours a day) for a Task and submits it.
Project Manager rejects 40 hours for the resource.
When the Resource opens the PWA (Project Web Access), Resource doesn't see any hours in PWA (Resource should have seen 40 hours that were rejected)
In PWA Actuals Hours shows 40 hours and Remaining Hours as 40 hours, After PM rejected the hours, it should have shown Actual Hours as 80 and Remaining hours as 0

I think should have happen, Once the hours were rejected by PM, Resource has to zero out the hours in PWA and click on updateAll button. PM has to then accept the zeroed hours. Why is PWA not showing the rejected hour and also Actual Hours and Remaining hours are not getting updated

I found out that the following tables MSP_WEB_ASSIGNMENTS and MSP_WEB_WORK (Actual Hours and Remaining hours) are not getting updated when the PM Rejects the task, Any idea why the tables are not getting updated. Is there any trigger associated with those tables



Any help on this would be greatly appreciate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top