Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

At completion Units Modification

5 replies [Last post]
Izam Zakaria
User offline. Last seen 4 years 7 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Guys,

At column "At completion Labor units" the amount keep increasing once we do update the schedule. Is any solution to change them back as same amount with budgeted labor units. I did so many time in excel spreadsheet but it doesn’t work.Even in global change.....

Replies

Richard Joshua Mance
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 13 Aug 2012
Posts: 6

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,

Zoltan Palffy
User offline. Last seen 15 hours 17 min ago. Offline
Joined: 13 Jul 2009
Posts: 2842
Groups: None

Hi

Abhijit Patil
User offline. Last seen 2 years 34 weeks ago. Offline
Joined: 27 Apr 2014
Posts: 2
Groups: None

Hi

Izam Zakaria
User offline. Last seen 4 years 7 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Thx

It’s working perfectly
Rodel Marasigan
User offline. Last seen 1 year 34 weeks ago. Offline
Joined: 25 Oct 2006
Posts: 1516
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.