This report provides an analysis of budget, actual, and forecast costs by investment manager. Amounts display in the currency that is set in the report parameter. For projects with a detailed budget, the forecast feature is used to determine Estimate at Complete (EAC) based on the following: (Actuals Posted + Remaining Forecast). Otherwise, a prorated simple budget is used to determine the remaining forecast.
This report can be run only from CA Clarity PPM. It cannot be run from BusinessObjects InfoView.
The graph shows the percentage of budget at completion by investment manager.
Run this report if you work with the following:
Note: See the Project Management User Guide for more information.
Note: See the Financial Management User Guide for more information.
Note: See the IT Service Management User Guide for more information.
Note: See the Demand Management User Guide for more information.
Note: See the Portfolio Management User Guide for more information.
Note: See the Project Management User Guide for more information.
Indicates the status of the investments that are to be included in the report. Select the appropriate status from the drop-down.
Identifies the investment manager whose data displays in the report. Click the Browse icon to select the investment manager's name.
Indicates the OBS unit by which the report is filtered.
Defines the currency type that appears on the report for amounts and totals.
Defines the start date of the report. To select a specific day, select the Specific Date option and type a date in the text field in the mm/dd/yyyy format or click the Date Picker to select a day from the calendar that displays. To select a relative date such as Start of Next Month, select the Relative Date option and select the relative date that applies from the drop-down list for the field.
Displays the percentage of the actual budget that has been spent to date.
Calculation: (Actual to Date /Budget Total) x 100
This is a calculated field. For more information, see the report's SQL statement.
Displays the amount spent as opposed to the amount budgeted.
Calculation: (EAC / Budget Total) x 100
This is a calculated field. For more information, see the report's SQL statement.
Displays the actual amount of the budget spent to date. The data is taken from the aggregated actuals posted in WIP.
ppa_wip_values.total_cost
Displays the total amount of the budget for the investment.
If the investment has a detail budget, this value is taken from fin_financials.budget_cst_total, else it is taken from fin_financials.planned_cst_total.
Displays the estimated actuals at completion.
Calculation: Actual to Date + Month (1 to 3) + Remainder
This is a calculated field. For more information, see the report's SQL statement.
Displays the budget forecast for selected months (1-3). The Forecast fields must have either a detail or a simple budget entered for the investment for data to appear in these fields.
If a detail budget exists, the forecast plan of record is used for the parameter Start Date and the totals posted in the fields.
If only a simple budget exists, the single budget amount is evenly distributed over the duration of the project. For example: If the simple budget=12,000 and the project duration is 6 months, the monthly budget/forecast is 2,000.
If the investment has a detailed budget, this value is taken from the slice table odf_ssl_cst_dtl_cost.slice.
If the investment has simple budget and has forecast cost, the report does its slicing during the runtime based on the forecast cost. If the forecast cost is not present, the same calculation is done based on the planned cost.
Displays the name of the manager whose projects are being reported on.
nbi_project_current_facts.manager_last_name
nbi_project_current_facts.manager_first_name
Displays the difference between the actuals budgeted and the actuals posted at completion.
Calculation: Budget Total - EAC
This is a calculated field. For more information, see the report's SQL statement.
Displays the project being reported on.
nbi_project_current_facts. project_name
Displays the remaining months where actuals have not yet been posted.
The same as Forecast (Months 1-3), but it includes the slice values remaining after month 3.
This GL-centric report provides a summary that shows debits and credits for a GL period. Below the summary-level presentation, a detailed presentation shows transactions. This report is used for auditing. The report provides different layouts, depending on the option selected for the Group-By parameter (Investment or Resource).
The report includes information on the following: active and inactive investments, all investment types, approved and unapproved investments (if transactions exist).
Note: See the Project Management User Guide for more information.
Indicates the end of the reporting period for the report. Click the Browse icon and select a date from the list that appears.
Indicates the start of the reporting period for the report. Click the Browse icon and select a start time from the list that appears.
Indicates how the information is to be grouped and presented on the report. Select an option from the drop-down to show how you want the information grouped.
Indicates the name of the investment that the report will provide data for. Click the Browse icon and select the investment from the list that appears.
Indicates the name of the resources that the report will provide data for. Click the Browse icon and select names from the list that appears.
Displays the account identifier.
cbk_gl_account.main_account_id
cbk_gl_account.sub_account_id
Displays in text what the corresponding account number represents.
cbk_gl_account.sub_account_id
Displays the share (or allocation) that a customer will be charged based on the transaction amount and the debit-rule, which may split the total transaction cost between accounts.
If cbk_gl_txns.chargeback_type = “ “ THEN cbk_scaled_gl_txns.scaled_amount
Displays the share of transactions of approved invoices that will be credited back to a provider. Total cost is split between provider accounts according to credit rules.
If cbk_gl_txns.chargeback_type = “ “ THEN cbk_scaled_gl_txns.scaled_amount
Displays the GL time period that the report covers using a yyyy/mm format.
biz_com_periods.period_name
Displays the name of the investment being reported on.
inv_investments.name
Displays the resource associated with charges at the detailed level in the report.
srm_resources.last_name
srm_resources.first_name
Displays a project task being reported on.
prtask.prname
Displays the date in mm/dd/yyyy format when the transaction listed occurred.
cbk_scaled_gl_txns.transaction_date
This report displays financial customer and provider portfolio status and chargeback information. By design, the report displays only one entity’s information at a time. It does not support displaying investments from multiple entities. GL periods are required field parameters, and they are tied to a specific entity. Therefore, only that entity’s details are displayed. If GL period start is from one entity and GL period end is from another entity, the report will display no results.
If not, the investment does not display in the report.
Indicates the department that will be charged with the investment cost according to the debit rule allocation. Click the Browse icon and select a name from the list that appears.
Indicates the end of the reporting period for the report. Click the Browse icon and select a date from the list that appears.
Indicates the start of the reporting period for the report. Click the Browse icon and select a start time from the list that appears.
Indicates how the information is to be grouped and presented on the report. Select an option from the drop-down to show how you want the information grouped.
Indicates the plan type to filter the report by. Select the plan type from the drop-down list in the field.
Indicates the department that is providing the service. Click the Browse icon and select a name from the list that appears.
Displays the prorated budget/planned cost for a specific customer based on the total investment budget split using the All-* debit rule.
fin_financials.budget_cst_total* odf_ssl_gl_all_dtl_pct.slice
Displays the department receiving and paying for a service.
departments.description
Displays the entity the investment belongs to.
entity.entity
Displays the prorated forecast (Actuals + Remaining Planned Cost) as of the current date, based on the total investment forecast split using the All-* debit rule.
fin_financials.forecast_cst_total* odf_ssl_gl_al_dt_pct.slice
Displays the GL time period that the report covers using a yyyy/mm format.
biz_com_periods.period_name
Displays all actuals charged to a customer from the beginning of an investment to the current date.
cbk_scaled_gl_txns.scaled_amount
Displays the name of the investment being reported on.
inv_investments.name
Displays the actuals charged to a customer from the beginning of an investment's start period to the current date.
cbk_scaled_gl_txns.scaled_amount
Displays the plan of record for the investment pro-rated using the All-* rule.
fin_financials.planned_cst_total* odf_ssl_gl_all_dtl_pct.slice
Displays the department responsible for the investment.
departments.description
Displays the actuals charged to a customer from the beginning of the year to the current date.
cbk_scaled_gl_txns.scaled_amount
This report is used to view customer invoices or credit memos by project, transaction, and class. It can be sent to a customer for billing purposes or to reprint an invoice previously sent to a customer.
This report can be run only from CA Clarity PPM. It cannot be run from BusinessObjects InfoView.
Run this report if you work with:
Note: See the Project Management User Guide for more information.
Note: See the Financial Management User Guide for more information.
Note: See the Project Management User Guide for more information.
Note: See the Project Management User Guide for more information.
Note: See the Financial Management User Guide for more information.
The following filtering parameters are associated with this report. These parameters define the data range with which the report should be run.
Defines the beginning invoice number range with which to filter this report. Click the Browse icon to select to the invoice.
Defines the ending invoice number range with which to filter this report. Click the Browse icon to select to the invoice.
Select the level of detail you want to see on the report from the drop-down list.
Defines the invoice date range with which to filter this report. You can define a Specific Date by clicking the Select Date icon, or a Relative Date from the drop-down.
Displays the charge code.
prchargecode.prName
Displays the administrative charge on an invoice.
invoiceheader_values.admincharge
Displays the amount associated with the invoice.
invoiceheader_values.invoiceamount
Displays the date the invoice was created.
invoiceheader.invoicedate
Displays the invoice number being reported on.
invoiceheader.invoiceno
Displays the company or customer name and address.
armaster.address_name
armaster.addr1
armaster.addr2
armaster.addr3
armaster.addr4
armaster.addr5
armaster.addr6
Displays whether an invoice was converted to a credit memo.
invoiceheader.invoiceno_applyto
Displays the name and address of the party the customer is to pay.
locations.locationdescription
locations.address1
locations.address2
locations.address3
locations.city
locations.stateprov
locations.zip
locations.countryid
locations.phone
Displays the project code
ppa_billings.project_code
Displays a description of the project.
srm_projects.name
Displays the number of units from the transactions.
ppa_billings.quantity
Displays the resource associated with charges at the detailed level in the report.
srm_resources.last_name
srm_resources.first_name
Displays the tax amount associated with the invoice.
invoiceheader_values.taxamount
Displays the transaction class associated with the charges on a customer invoice.
ppa_wip.transclass
Displays a description of the transaction class.
transclass.description
| Copyright © 2010 CA. All rights reserved. | Email CA Technologies about this topic |