none
Update Actual Cost Field Via PSI RRS feed

  • Question

  • Is it possible to update a timephased field like Actual Cost using PSI?  I have searched high and low and cannot seem to find a way to do it.  Any help would be greatly appreciated. I am using Project Server 2007.
    Wednesday, January 4, 2012 10:54 PM

All replies

  • Hi heavywoody,

    The PSI cannot edit timephased data directly in the schedule. But you can use the PSI to enter values through the statusing web service.

    For what type of resource do you want to do this?

    For a work resource, Actual Cost is calculated as Actual Work * Standard rate. So you have to update Actual Work.

    For a material resource, Actual Cost is calculated as Units * Unit cost. So you have to update the actual units.

    For a cost resource, timephased values cannot be entered (using PSI).

    I hope this helps,
    Hans


    My EPM blog: Projectopolis
    Thursday, January 5, 2012 10:03 AM
    Moderator
  • Agree with Hans.  You might want to consider VBA....that will pull Actuals
    in and allocate it as of the Status Date, which effectively books the Actuals
    when they are incurred.  You can also use VBA incur the Actuals as of a specific
    date, presumably imported from some LOB system.
     
    You may run into issues if the Actual Cost is incurred outside of the date
    range of the task.  In some circumstances, that may affect task duration
    - which you may/may not want.
     
    Perhaps you could define your specific scenario in more detail...?
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Thursday, January 5, 2012 12:49 PM
    Moderator
  • Agree with Hans.  You might want to consider VBA....that will pull Actuals
    in and allocate it as of the Status Date, which effectively books the Actuals
    when they are incurred.  You can also use VBA incur the Actuals as of a specific
    date, presumably imported from some LOB system.
     
    You may run into issues if the Actual Cost is incurred outside of the date
    range of the task.  In some circumstances, that may affect task duration
    - which you may/may not want.
     
    Perhaps you could define your specific scenario in more detail...?
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    I have looked at VBA and actually posted another thread.  What I was trying to do is automate the entire process through VBA or C# via Object Model.  The problem is, I can't figure out how to sign into an account, then checkout a project to update and then check back in.

     

     

     

    Friday, January 13, 2012 2:52 AM
  • I might mention that since I figured out how to checkin/checkout the project using C# and Office Interop, I am able to do far more than what PSI allows me to do. I would still be interested in finding how PSI would do this, but look at my other post if you are having the same problem.
    Thursday, January 19, 2012 7:10 PM