At completion Units Modification

R
Robin Reyes 👤 Member for 19 years 8 months
The post was already more than ten years ago, but no solution was posted.
I encountered the same problem, wherein the At Completion keeps changing whenever I calculated the schedule after I update the actual units.
 
I discovered the solution from Rodel's post. The straightforward solution is to:
Go to Project Window>Calculations Tab>Resource Assignments. Then uncheck the condition [Recalculate Actual Units and Cost when Duration % complete changes. And Voila, the problem is solved.
 
I speculate that 10years ago, this option is not yet available in the previous version of P6. My P6 version using now is Primavera Release 8.3.0
R
Richard Joshua Mance 👤 Member for 13 years 10 months

Hi Mr. Rodel,

 

Its been 10 years, but i still want to reply on this post to improve my knowledge.

I encountered Similar problem as the above wherein whenever i update my Programs my Resource Assignment Changes.

My work around in this is to Check my BL loading and compare with the Updated Program to correct the Budgeted Units.

After that since my Reporting system is based on At Completion units. I also have to correct the At Completion Units.

What happens is that whenever i actualize activities, the Actual, Remaining and At Completion is displaying zero which gives me wrong data. Therefore, (for my solution) i use below steps in the Updated Program after i export:

1. Budgeted Units = At Completion units

2. Actual Units = At Completion - Remaining Units.

I hope to understand why this happens in the Primavera Program. Hope you can give Advice.

 

Thanks,

R
Rodel Marasigan 👤 Member for 19 years 7 months

Izam,

First change the setting on Project Windows-> Calculation Tab-> Resource Assignments. Make sure Subtract Actual from At Completion is selected or tick.

Then run Global Change

Select Subject Area: Activity Resource Assignments

If

Resource Type equals Labor

Then

Remaining Labor Unit = Budgeted Labor Unit - Actual Labor Units



Do the same on all Resource Type use or assign on current Projects.



Alternatively export Resource Assignment to excel spreadsheet with the following Fields: Activity ID, Activity Status, Resource ID, Roles ID, Account ID, Budgeted Units, Actual Units, Remaining Units and At Completion Units.

Update Remaining Units = Budgeted Units - Actual Units and At Completion Unit = Actual Units + Remaining Units

Then import it back.

Forum Sponsor

Top Posters

Lee Mallek
23 posts
Syed Shoeb
0 posts
Viet Tran
8 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts
Haque Nawaz
10 posts
EViLL1
1 posts
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts