Clarity

Expand all | Collapse all

Updating Actual Cost in Cost Plans and Hierarchy Page

  • 1.  Updating Actual Cost in Cost Plans and Hierarchy Page

    Posted 01-10-2017 06:45 PM

    Is there a particular PPM job that needs to run in order to post ACWP to the Actual Cost displayed in the 1) Cost Plan, and 2) the Financial Rollup of the Investment's Hierarchy page?

     

    I have configured the Investment (Project in this case) Settings so that it has:

    1. Financial Status = Open
    2. Cost Type = Operating
    3. Type = Standard
    4. Department, Location and Charege Code all = valid values
    5. Labour Transaction Matrix Rate and Cost Source(s) both set appropriately to look at our Rate Matrix

    The Project's Team has been built with Resources, aligned with appropriate Roles and non-zero Allocations.

    Timesheets have been entered, Submitted, Approved and Posted so that review of the Task Assignments page's details shows that Actuals (in hours) is the sum of the Resources' Timesheets processed, with the ETC reduced appropriately.

    Review of the Task Properties shows details of each of the Assigned Resources with their Actuals (in hours) with the ACWP (as a product of their Rate times their Timesheet Hours).

     

    For some reason, the sum of the detailed ACWP from each of the posted Timesheets is not consolidating into the display of the Financial Plan, and so the (Planned) Cost displayed for each record in the Plan shows no Actual Cost, and the Cost Variance is simply the same value as the (Planned) Cost.

     

    As well, the Financial Rollup portlet on the Hierarchy page also shows an Actual Cost of zero, so the Remaining Cost simply shows the same value as the Planned Cost field.

     

    Is there an additional job that I should schedule to pick up the ACWP to post it to the Investment's Actual Cost? I have reviewed Appendix C of the PPM Administration Guide to determine what job might be responsible for this, but nothing has lept out at me.

     

    Suggestions would be welcomed.

     

    Thanks,

    Will



  • 2.  Re: Updating Actual Cost in Cost Plans and Hierarchy Page

    Posted 01-11-2017 12:47 AM

    The actuals and costs are pulled from the WIP tables on the cost plans

     

    Transaction tree

    https://communities.ca.com/thread/241697504 

     

    Once this is done, run the "Update Aggregated Data" job

     

    NJ



  • 3.  Re: Updating Actual Cost in Cost Plans and Hierarchy Page

    Posted 01-11-2017 01:55 PM

    Thank you, I will step through this to see if it resolves the issue.