Clarity

  • 1.  Underlying query for Investment cost by period

    Posted Nov 23, 2016 08:27 PM

    Hi, is there away for me to know the underlying query/fields behind the Portfolios>Financials>Investment cost by period?

     

    Thanks



  • 2.  Re: Underlying query for Investment cost by period

    Posted Nov 28, 2016 11:01 AM

    Investment Cost by Period Portlet

    The Investment Cost by Period portlet displays planned, actual, remaining, and forecast costs for investments in a portfolio. The amounts are displayed in total and by period. The portlet filters include: Investment Name, Investment ID, Manager, Forecast As Of Date, Investment Type, Above Waterline, Approved, and Active. The Forecast As of Date filter in the portlet is used to calculate Actual and Forecast Remaining amounts. It is also used to calculate amounts that reference Actual and Forecast Remaining amounts in their calculations.

    To view this portlet, open the portfolio and click the Financials tab. If the page is maximized to display only one portlet at a time, select Investment Planning by Period from the portlet drop-down.

    The following fields display on the portlet:

    Investment

    Displays the name of the investment. Click an investment name to view the portfolio investment properties for that investment. The portfolio investment properties page shows all attributes that are copied from the investment when the portfolio contents are synchronized. It gives visibility into the state of the investment at the point in time when it was synchronized.

    Planned Cost

    Displays the planned cost of the investment within the portfolio planning horizon.

    Actual Cost

    Displays the actual cost posted to the investment within the portfolio planning horizon. If a date is entered in the Forecast As Of Date filter, then the actual cost includes only posted transactions that have a transaction date on or before the Forecast As Of Date.

    Remaining Cost

    Displays the difference between the planned cost and the actual cost.

    Forecast Cost

    Displays the forecast cost of the investment within the portfolio planning horizon. The forecast cost is the sum of actual cost and forecast cost remaining. If a date is entered in the Forecast As Of Date filter, then the actual cost includes only posted transactions that have a transaction date on or before the Forecast As Of Date. The forecast cost remaining includes only planned cost amounts for dates after the Forecast As Of Date. In summary, forecast cost is actual cost plus forecast cost remaining where actual cost includes amounts thru the Forecast As Of Date and forecast cost remaining includes amounts after the Forecast As Of Date.

    Planned (by Period)

    Displays the planned cost by period of the investment, including values outside the portfolio planning horizon.

    Actual (by Period)

    Displays the actual cost by period of the investment, including values outside the portfolio planning horizon. If a date is entered in the Forecast As Of Date filter, then the actual cost includes only posted transactions that have a transaction date on or before the Forecast As Of Date.

    Remaining (by Period)

    Displays the difference between the planned cost and the actual cost by period.

    Forecast (by Period)

    Displays the forecast cost by period of the investment, including values outside the portfolio planning horizon. The forecast cost is the sum of actual cost and forecast cost remaining. If a date is entered in the Forecast As Of Date filter, then the actual cost includes only posted transactions that have a transaction date on or before the Forecast As Of Date. The forecast cost remaining includes only planned cost amounts for dates after the Forecast As Of Date. In summary, forecast cost is actual cost plus forecast cost remaining where actual cost includes amounts thru the Forecast As Of Date and forecast cost remaining includes amounts after the Forecast As Of Date.

    The following aggregate amounts are provided for the portfolio at the bottom of the portlet:

    Planned

    Displays the sum of planned cost in total and by period, for the portfolio investments.

    Actual

    Displays the sum of actual cost, in total and by period, for the portfolio investments.

    Remaining

    Displays the difference between planned cost and actual cost . A negative variance value indicates the actual cost exceeds the planned cost.

    Forecast

    Displays the sum of forecast cost, in total and by period, for the portfolio investments.

    This portlet is based on the Portfolio Investment Financial Performance provider. Fields included in the system provider are available to this portlet and may be added through the configure option. For more information, see the Basics User Guide.

     

     

    NJ