Changing Activity % Complete Back Zero and remove actuals

H
Henry Chiu 👤 Member for 14 years 10 months

Hi Everyone,

 

I have encountered a problem in P6 update wherein I made a mistake for the previous week update. I want to change the percent complete of an activity back to zero and remove the actual date. The P6 wont allow me to change. Can somebody advise the steps to revert back the percent complete of an activity to zero percent and remove the actual date.

 

thanks

Z
Zoltan Palffy 👤 Member for 16 years 10 months
How to de-status a schedule
1. Choose Enterprise, Projects and select the Calculations tab. Choose to "Link Budget and
At Completion for not started activities" and "Reset Remaining Duration and Units to
Original
2. Choose View, Columns and add the columns for Actual Labor Units, Actual Nonlabor
Units.
3. Choose Tools, Schedule and set the data date equal to the Project Start Date and schedule.
To find the Project Start date, choose Enterprise, Projects. Click on the Dates tab and
note the Planned Start date.
4. For the first activity in the list, set the Actual Labor Units to 0. Highlight the activities in
this column and choose Edit, Fill Down.
5. For the first activity in the list, set the Actual Nonlabor Units to 0. Highlight the activities
in this column and choose Edit, Fill Down.
6. Choose Tools, Global Change and run the 1st Global Change. This will set the Actual
Material Units to zero.
7. Run the 2nd global change which sets the activity status to Not Started.
 
1st Global Change:
Subject Area:  Activity Resource Assignments
If:      
Where Resource Type           equals   Material
Then:  Actual Material Units      =          0
 
2nd Global change
Subject Area: Activities
If:
Where Activity Status     is not equal to   Not Started
Then:  Activity Status     Equals              Not Started
V
Vishal Gourgonda 👤 Member for 13 years 9 months

Hi all...

is there any short cut to change all activity 'completed' to 'not started'?

 

Regards

S
SM PUM 👤 Member for 14 years 6 months

use following;

When activity Status   is not equal to     not started 

Then;

Actual labour units         equal to        zero

Actual non labour unit    equal to        zero

activity status                equa to         not started.

 

Always keep a copy of your origional project before applying the global change because it can not be undone.

 

Regards; 

M
Michael Jubilo 👤 Member for 14 years 11 months

Hi SM PUM, yes it will take years to remove actuals of thousands activities. What operation in global change should be done then?

S
SM PUM 👤 Member for 14 years 6 months

For Removing Actual you will have to apply global change.Removing actuals one by one will be waste of time

M
Michael Jubilo 👤 Member for 14 years 11 months

Hi gentlemen, how about changing % complete to zero and removing actuals for multiple activities in P6? I tried global change however I was not able to find the right operation. Perhaps someone knows the trick. TIA

Z
zhang ting 👤 Member for 14 years 9 months

First convert % complete to zero,and then change tick off “started”

H
Henry Chiu 👤 Member for 14 years 10 months

Hi Roland,

 

I did the same thing as I do in P3, unfortunately the same message appears "Cannot Set Status to Not Started if Activity Has Actuals". Is there something wrong in my settings or any options that I need to do just to clear this problem.

 

Thanks

H
Henry Chiu 👤 Member for 14 years 10 months

Gary,

 

Thanks for your reply, but one thing bothered me is I have an activity that is 20% complete with an actual start of 01 oct as an example. When I update the following week I noticed that I made a mistake on the activity that was updated, so I want to change the percent complete to zero and remove the tick in the actual start but a message will appear "Cannot Set Status to Not Started if Activity Has Actuals". I never encounter this problem in P3.

Thanks

G
Gary Whitehead 👤 Member for 17 years 2 months

Just to add you have to do this in the right order -eg if you try and uncheck the stated box with the finished one still checked, you would get an error saying something like "activity cannot have an actual finish without an actual start"

 

Uncheck your finsh, then any % completees / actual durations / actual resources, then the start date.

 

Also,  double check the relationships to ensure doing this won't cause any OOS (out of equence) working

R
Roland Payawan 👤 Member for 23 years

Hi Henry,

Just go to the activity status, untick the STARTED and FINISHED date and put the Percent (%) back to zero and there you go.

Hope this wull do.

Cheers,

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts