Project Hierarchy Financial Rollup Detail View Planned Cost and Planned Benefit amounts only display values up to 12 months in future

Document ID : KB000022562
Last Modified Date : 18/07/2018
Show Technical Document Details
Issue:

The Planned Cost and Planned Benefit amounts are not shown correctly on the Project, Hierarchy Tab, Financial Rollup (Detail) View. I would expect to see the monthly values distributed evenly for the entire 3-year period. For example: with a simple budget planned cost equal to 360,000 -- for monthly, the 'Detailed Planned Cost' amount should appear as 10,000 per month x 36 months = 360,000. For Yearly, the amount should appear as 120,000 x 3 years = 360,000. For Quarterly, the amount should be 30,000 per quarter x 12 quarters = 360,000. Instead, the application is displaying values only beginning in the current month, in the current year or beginning in the 'next' quarter.

Steps to Reproduce:

  1. Log in to PPM as an administrator user
  2. Create a new project
    Project Name = 'My Master Project'
           Schedule Start = 1/1/2015 
           Schedule Finish = 12/31/2017 
  1. Navigate to the Project > Financial Summary page
    Planned Cost = 360,000.00
    Planned Cost Start = 1/1/2015 
    Planned Cost Finish = 12/31/2017 
    Planned Benefit = 36,000.00
    Planned Benefit Start = 1/1/2015 
    Planned Benefit Finish = 12/31/2017 
  2. Create a new sub-project
    Project Name = 'My Subproject #1'
    Schedule Start = 1/1/2015 
    Schedule Finish = 12/31/2017 
  3. Navigate to the Project > Financial Summary page
    Planned Cost = 3,600.00
    Planned Cost Start = 1/1/2015 
    Planned Cost Finish = 12/31/2017 
    Planned Benefit = 360.00
    Planned Benefit Start = 1/1/2015 
    Planned Benefit Finish = 12/31/2017 
  4. Navigate back to 'My Master Project', Properties, Subprojects
  5. Click 'Add' button
  6. Select 'My Subproject #1', Click 'Add' button
  7. Navigate to the Project, Hierarchy Tab, Financial Rollup (Detail)
    No values are shown yet as the 'Investment Allocation' job has not executed
  8. Navigate to Reports and Jobs, Jobs,  Available
  9. Select 'Investment Allocation' job, execute the job immediately
  10. Go back 'My Master Project' then Hierarchy Tab > Financial Rollup (Detail)
  11. From the Options icon, select 'Configure'
  12. From the List Column Layout : Available Columns, select the following columns
    (this will show the amount entered on the Simple Budget page)
    Planned Cost
    Planned Benefit
  13. Click 'Save and Return'.
  14. The Planned Cost and Planned Benefit amounts are shown correctly. I would expect to see the monthly values distributed evenly for the entire 3-year period -- so for monthly, the 'Detailed Planned Cost' amount should appear as 10,000 per month x 36 months = 360,000. For Yearly, the amount should appear as 120,000 x 3 years = 360,000. For Quarterly, the amount should be 30,000 per quarter x 12 quarters = 360,000.

Expected Result: I should see the values distributed evenly over the 3-year period for any TSV (Time Scale Value) configuration.
Actual Result: Values only appear beginning in the current month, year or beginning in the 'next' quarter.

Resolution:

This is working as expected within the limitations of the internal, insta-slices for Hierarchy Detail page.

The data only shows up for current month plus next 12 months, and the values are all 0 for Cost or Benefit start date until current month - 1 as well as for current month + 12 until Cost or Benefit end date. This is due to the design limitation that the internal time slices are only generated from today to today+360 days only. These are internal time slices: These slice types do not appear in the UI under Administration, Time Slices, so they're not public and thus not configurable.

Additional Information:
Reference TEC606258 : Project Hierarchy Financial Rollup Detail Time Slice Dates and Data showing only future data for Cost Plans