Actuals gone

J

James

Hi,

We saved a project plan as an mpp file, deleted it from the database,
re-imported it and re-published all assignments.

BUT now the previously entered actuals for that project do not appear in
each users timesheet. Why not ?

And can we correct the problem ?

Thanks

James
 
K

Karl Kill, PMP

Here's the workaround I found for your situation. The Actual Hours are inserted into the Work Hours fields for each day in PWA. Then the resource would need to retype those hours in the days as shown and send the update to project manager. The project manager will accept and the project plan and timesheets are sync'd

To display the work hours on the PWA timesheet go to the view option and click Show scheduled work

Hope this helps.
 
J

JOhn

Does this work in 2003 with the close out periods?
Thanks
John
-----Original Message-----
Here's the workaround I found for your situation. The
Click to expand...
Actual Hours are inserted into the Work Hours fields for
each day in PWA. Then the resource would need to retype
those hours in the days as shown and send the update to
project manager. The project manager will accept and the
project plan and timesheets are sync'd.
To display the work hours on the PWA timesheet go to the
Click to expand...
view option and click Show scheduled work.
 
J

James

Hi Karl,

Yes but these actuals have already been entered and updates processed. You
can't seriously tell me that you are proposing that all our resources type
in actual hours al over again for the past six months ???

I think if I suggested that to my team and others I'd be lynched (or worse
!) - The actuals are already in the project plan - my point is that those
actuals don't appear on the timesheet, even after publishing the plan.

And in any event the work hours don't necessarily reflect the actual hours.
How do we know that for a task that is behind schedule which of these work
hours have been completed and which have not ?

Furthermore, any errors in this update process will be very hard to rectify.

There must be an easier way given that the actuals are already in the
project plan.....but in our case they just don't appear on the timesheet.

Regards

James


Karl Kill said:
Here's the workaround I found for your situation. The Actual Hours are
Click to expand...
inserted into the Work Hours fields for each day in PWA. Then the resource
would need to retype those hours in the days as shown and send the update to
project manager. The project manager will accept and the project plan and
timesheets are sync'd.
 
G

Gary L. Chefetz [MVP]

James:

Use Collaborate > Republish and republish all tasks selecting the Overwrite
actuals in PWA checkbox. That should do it if you're using PS2002 or PS2003
without protected actuals.
 
G

Guest

James,
When you delete the project and rebuild, the project
takes on a new Project id which is part of the key for
the assignments table. If you research the database you
will find those rows there. That doesnt offer much
consolation as tweaking the database to bring the actuals
from the assignments on original mpp to new mpp is not
recommended. (Unless you have resource and time to
develop a tight SQL script that will do that). Not easy.

The next time you find a need to del and recreate a
project, I would recommend what we do here...inserting
the Actual hours of each task row into a text column.
Save the project locally. Recreate the project on server
and then transfer the hours from the text column to the
actual column. You will get totals per task, not actuals
per day (unless your taks are one day duration). Always a
catch, but at least you preserve the actual effort spent
thus far. Maybe this helps.
 
P

Predrag

Hi,

Use Collaborate -> Publish -> Republish Assignments.
Make sure you select Overwrite actual work entered by
resources. It will work. I did it many times.

Predrag

When you are republishing the tasks just make sure you
select the opion
 
Top