Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

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.

Changing "rate type" triggers Auto Compute Actuals and also erases Actual Material Cost: how to stop it?

9 replies [Last post]
Bryon McConnell
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 20 Mar 2016
Posts: 13
Groups: None

In Primavera P6 version 8.2, for only some of my projects, when I change the "rate type" for the resources assigned to the project, P6 assigns actual costs to the activities, even though I have shut off every instance I can find of the "Auto Compute Actuals" option, and I have shut off the "Recalculate Actual Units and Cost when duration % complete changes" option for the project.

I don't wish to have P6 auto-compute the actual costs, because I am manually typing in the actual costs based on data from the corporate accounting system:  I put that data into activities that hold actual costs within a work element, but have no resources.  

At the same time, in the projects that have the Auto Compute Actuals problem, I also find that I cannot make actual costs stick for materials.  What I type in for Actual Labour and Actual Non-Labour will stay put, but P6 resets the Actual Materials to zero after changing the rate type.

It would appear that there is a connection between these two peculiar behaviours, but I am stumped as to what it is.  Not all of my projects have this aberrant behaviour, but I cannot find the key difference between the well-behaved and ill-behaved projects.

Is there some setting that I'm missing, or some interaction between settings that I don't yet understand?

You might wonder why I am changing the rate type.  It is because I need to do analysis in three sets of rates:  direct costs, costs marked-up to cover overheads, costs marked-up to deliver profit.

Replies

Zoltan Palffy
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

that should work 

Bryon McConnell
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 20 Mar 2016
Posts: 13
Groups: None

Thank you, Zoltan.  I have sent a note to my Project Management Office colleagues, asking for their support to do the exporting/importing exercise of resources via Excel.

Zoltan Palffy
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

Byron as I mentoned the setting that were in effect at the time that the resources were added remain in effect. That is why after you changed the settings and then dleted the resource and then added it back in it worked properly with  the new settings.

The solution would be to export the resources to excel then delete them in p6 then import the resources back inot p6 under the new settings. 

Zoltan Palffy
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

Byron was I mentoned the setting that were in effect at the time that the resources were added remain in effect. That is why after you changed the settings and then dleted the resource and then added it back in it worked properly with  the new settings.

The solution would be to export the resources to excel then delete them in p6 then import the resources back inot p6 under the new settings. 

David Kelly
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

Bryon,

Export all of the resources using the built-in export to XLS, just export all resources assigments. You will need to add "Budgeted Quantity (or "Planned" depending on the industry selected at software installation. Sigh.)

Then in the "Resource Assignments" window delete all resources.

Then import your spreadsheet.

Bryon McConnell
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 20 Mar 2016
Posts: 13
Groups: None

Zoltan, I have tested one activity, and have found that deleting and then re-adding the resources indeed prevents the auto-compute of actuals.  (I wonder if deleting and then re-creating the activities in which I put actual costs will solve the problem of erasure of Actual Materials costs.)

This begs the next question:  I am fearful now that there is no good way to delete and then re-create the resources en masse.  This particular project has 1204 resource assignments across 374 activities.  Am I doomed to hours and hours of manual electronic labour?

Bryon McConnell
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 20 Mar 2016
Posts: 13
Groups: None

David, I'll ask our Project Management Office if we can try out the idea of pushing the file to a fresh database.

Zoltan Palffy
User offline. Last seen 3 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

also in the activity directory under the resources tab right click and add a column for auto comout actuals and make sure that the box is unchecked.

basically the rules that were in effect when you assigned the resource remain in effect. The other option is if you are sure that you have changed all of the settings is to delete the resource and add it again with the new settgin in effect.  

David Kelly
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

Bryon,

I can't replicate this.

I have had a client who did exactly your process for internal/external costing with projects of 10k+ activities with external timesheet system actual manhours unaffected. 

If you XER a project that exhibits the bad behavoir into a fresh database, does that change things?