P6 Budget cost actuals

A
Ahmed Farag 👤 Member for 9 years 11 months

Hi;

Can anyone help with the following.

My previous actual units changes everytime I update (Schedule Project). I'm Sure I Untick the mark next to "Recalculate Actual Units & Cost when duration % complete changes" at project level.

note:- the actual changes to be linear change (for ex. if actual units are 24 for 4 periods each period changes to be 6 units)

A
Arnold Puy 👤 Member for 19 years 1 month

Hi Kevin,



Everytime you will update weekly, your actual units/cost will change when you did not untick the "Recalculate Actual Units and Cost when duration % complete changes".



Perform "Store Period Performance" every week. You can track actual units and costs to date each time the schedule is updated.



You can edit the data in financial period columns of the Activity Table, Resource Assignments window, and the Resources tab of Activity Details.



Hope this helps.



Cheers,



Arnold

K
Kevin Markham 👤 Member for 19 years 1 month

Thanks that helped. Another problem I am having is when I dump down my actual costs from one of the reports into excel on a weekly period after updating and analysing my schedule. P6 changes all the previous weeks data making my actual history curve change each week. If I just take the last period and ignore the rest and put that into my excel sheet the cummulative value/percent doesn’t match the plan and CSV files cummualtives ?

A
Arnold Puy 👤 Member for 19 years 1 month

Hi Kevin,



The reason why the actual qty/cost set to zero it is because:



1. The Remaining Duration is equal or greater than Original Duration.

2. The "Recalculate Actual Units & Cost when duration % complete changes" in Project Detail --> Calculation Tab.



Untick the mark next to "Recalculate Actual Units & Cost when duration % complete changes". And put the Actual Units manually.



Hope this helps.



Regards,



Arnold






Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts