Skip to content
ProjectControls.com
Oracle Primavera - PM6

Expense % Complete = Activity % Complete ?

In the Open Standard
Mohammed WasiuddinMember for 17 years 7 months
Created
3
1
0
Dear superiors
Could anyone suggest me in deatail regarding,in P6/6.2 how can i equal the Expenses % comp. = Activity % comp.
I tried with global change from the subject select area of Project Expenses but it won’t work(i meant to say there is no parameter/value ragarding Activity % complete in the project expenses).
Thanking you.
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Mark Porter ·
    #1
    Hi Mohammed,

    As you will possible be aware, a planner is able to associate multiple expenses to an activity & therefore this is the reason that you cannot use a global change to assign the Expense % complete as the activity % complete. (i.e. Expenses are the children to activities, just like resources are children as well)

    To achieve what you are asking, a work around is to export the activity data out to excel with both the expense cost % complete & the activity % complete columns showing, then copy the Expense cost % complete column across to the activity % complete column & re-import back into Primavera.

    Hope this helps

    Kind Regards

    Mark Porter
    Report
  2. 0
    Andrew Taylor ·
    #2

    To add to Mark's

    To add to Mark's workaround:

    As far as I know, you can't import [Expense % Complete] from Excel to P6. You can however import [Actual Cost].

    If you want to match your [Expense % Complete] to your existing [Activity % Complete] you can:

    1. Export both data sets to Excel (Activities AND Expenses);
    2. Use a vlookup to change all [Expense % Complete] values to the [Activity % Complete] value;
    3. Recalculate the [Actual Cost] value using [Expense % Complete] /100 x [Budgeted Cost];
    4. Import the new Expense data to P6.

    Now, P6 will calculate the [Expense % Complete] using [Actual Cost] / [Budgeted Cost].

    (If this isn't clear let me know and I'll add detail to the steps).

    Cheers

    Andrew.

    Report
  3. 0
    Zoltan Palffy ·
    #3

    create a UDFthen make the UDF

    create a UDF

    then make the UDF % complete equal the expenses % complete

    then make the UDF % compelte equal the activity % Complete

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?