New User Experience: Manage Financial Plans

The new Financials page gives you quick access to financial plans of a project. As a financial manager and analyst, Rita gets a quick glance at all financial cost plans of a project as a list. Rita can also use the grid view for detailed analysis of the financial plans. Cost Plans are created in the Classic PPM but can be viewed in the ppmnew. The grid view lets Rita reorder, sort, and filter columns, like an Excel sheet. Rita can also view the detailed transactions behind any actual cost or aggregated cost of a cost plan. Because they appear as hyperlinks, Rita can click any actual cost to view the Transactions Review page. Moreover, unlike Classic PPM, Rita can view the transactions without navigating away from the current cost plan. 
ccppmop153
The new Financials page gives you quick access to financial plans of a project. As a financial manager and analyst, Rita gets a quick glance at all financial cost plans of a project as a list. Rita can also use the grid view for detailed analysis of the financial plans. Cost Plans are created in the Classic PPM but can be viewed in the
New User Experience
. The grid view lets Rita reorder, sort, and filter columns, like an Excel sheet. Rita can also view the detailed transactions behind any actual cost or aggregated cost of a cost plan. Because they appear as hyperlinks, Rita can click any actual cost to view the Transactions Review page. Moreover, unlike Classic PPM, Rita can view the transactions without navigating away from the current cost plan. 
Similar to the functionality available in Classic PPM, if you have viewing rights on the project, you can access the Financials tab.
View the Cost Plan List
By default, the Financials page displays the detail view of the
Plan of Record
cost plan. Click image2017-9-9 11:56:24.png
Plan List
to view other plans, if available.
  • The plan name, Created Date, Start and Finish period, total planned cost, and period type appear. The Period Type defines the type of time period for the plan, for example,
    Monthly
    ,
    Quarterly
    , and
    Annually
    .
  • By default, the list is sorted by the created date field, in descending order. You can change the list to sort by any other column. The changed sort persists even after navigating to another page, session time-out, page refresh, or application logout. The sorting happens on cost plans other than the plan of record where the plan of record is always displayed on the top.
  • You can click on any cost plan to view its details.
    If you have one or both of the following access rights, you can view the list of cost plans and the cost plan details:
    • Project - Cost Plan – View
    • Project - Cost Plan – Edit
Analyze Financial Plans
To view the financial status of projects, you can analyze financial plans. For example, you can compare actual costs with planned costs.
Follow these steps:
  1. In the main menu, click
    Projects
    .
  2. Open a project and click 
    Financials
    .
    By default, the cost plan that is designated as the Plan of Record (POR) appears.
  3. To view a list of other available plans, click  image2017-9-9 11:54:55.png
    Plan List
    . Click a plan or click
    Return to Plan Details
    .
     
  4. In the
    VIEW
    menu, select one of the following views:
    • Planned
      : This view displays planned cost by time period.
    • Planned to Actuals
      : This view helps you compare the planned and actual costs. This view also provides
      REMAINING 
      and
      % SPENT 
      data. The application performs the following calculations:
      • Remaining Cost
        =
        Planned Cost
        − 
        Actual Cost
      • % Spent Cost
        = (
        Actual/Planned
        ) × 100
    • Planned to Forecast: 
      This view helps you compare the planned and forecast costs.
       
      The
       
      Forecast cost is the total cost that will be incurred. The
       
      Forecast cost combines the Actual value from the past period with the planned cost for current and future time periods. The application performs the following calculations:
      • For past time period,
        Forecast
        =
        Actual
      • For current and future time periods,
        Forecast
        =
        Planned
      • Forecast
        (Calculated) =
        Actual
        +
        Forecast Remaining
      • Forecast Remaining
        =
        Actual Cost
        (posted through the last complete fiscal period) +
        Planned Cost
        (remaining in the cost plan of record after the last complete fiscal period)
        For example, the time period is set to
        monthly
        and the project as of date is 05/20/2018. The Forecast remaining is actual cost through 04/30/2018 plus planned cost in fiscal periods after the fiscal period ending 04/30/2018.
      • Variance
        =
        Planned
        Forecast
      • % Variance
        = (
        Variance
        /
        Planned
        ) × 100
    • Actuals
      : This view displays actual costs posted during the fiscal period.
  5. In Planned to Actuals and Planned to Forecast views, you can hide or show all columns of one type. Click on the respective color in the 
    SHOWING
     legend at top right.
  6. To view details for the current plan, click  image2017-8-14 14:56:14.png Settings. The plan name, description, ID, start and finish period, currency, decimal display, and time period, period type appear. 
    1. To change the appearance of decimal amounts, select a value in the
      DECIMAL DISPLAY
      field.
    2. To change the cost plan view to a different fiscal time period, select a value in the
      TIME PERIOD
      field.
Group Financial Data
You can group your data by any grouping attributes and can see the aggregated values for each group.
  1. Drag-and-drop the column headers that can be grouped to the
    Group By
    section. 
  2. Once the data is grouped, you can expand each group to view the individual rows. The aggregate of each row is shown in far right in the
    TOTALS
    column. The first three grouping attributes are pinned on the left and the
    TOTALS
    column is pinned on the right. 
    The following example shows the Plan List view and the grouping feature.
    CostPlan.gif
Review Transactions Associated with Actual Costs
In the Planned to Actuals or the Actuals view, you can view the transactions behind an actual cost. Every Actual Cost value appears as a hyperlink. You can click an individual cost and row level or column level actual aggregates. The transaction review window displays Transaction Date, Resource, and Task columns pinned on the left. Units, Unit Cost, and Actual Cost appear pinned on the right.  transaction.gif
Filter Line Items in a Cost Plan or Financial Transactions Grid
Both the financial grids (cost plan and transaction review) offer the following grid controls.
Follow these steps:
  1. On the grid, you can hover on any column header and view more options. You can pin columns to the left or right. You can also autosize or reset column width.
    image2017-8-16 12:13:58.png
  2. To view only specific data in a column, you can apply your own filter criteria. 
    If a grid has more than 200 rows, the filter applies only to the first 200 rows on the current page. The filter does not apply to the entire data set.
    • A numeric data filter is also available, as shown in the following image:
      image2017-8-22 15:7:58.png
    • You can apply text-based filters, as shown in the following example:
      image2017-8-22 15:9:3.png
      The data is paginated when it exceeds 200 rows, with up to 200 rows per page.
  3. You can show and hide columns on the cost plan. Select the columns that you want to see on the view and clear the ones that you want to hide.
    image2017-8-22 15:2:2.png