Investment Transaction Inquiry

ccppmop159
The Investment Transaction Inquiry report displays actual quantity and cost, by resource and day, for each investment. The report and pie charts can be grouped by various options, making it a dynamic report.
The following image shows the Investment Transaction Inquiry report displaying actual quantity and cost.
 
Image displaying the Investment Transaction Inquiry report displaying actual quantity and cost.
 
Image displaying the Investment Transaction Inquiry report displaying actual quantity and cost.
 
 
Report Prerequisites
 
Verify that you have completed the following prerequisites before you run this report:
 
  • The 
    Load Data Warehouse
     and 
    Load Data Warehouse Access Rights
     jobs must be run before you run this report. If the Data Warehouse is not populated, the report displays a message that there are no matching records. Also, most of the report parameters do not display options.
  • The investment must have the financial fields populated to post transactions to financials for the investment. These fields are in the financial section of the settings properties on the project and include financial status, type, billing currency, department, location, and charge code. Alternatively, the resource can select a charge code in the timesheet if the timesheet is configured to display this field. The financial status field must be set to open to post financial transactions. If the financial status is hold or closed, the product does not post transactions for the investment.
  • The resource must have the financially active field checked and the financial fields populated to post transactions to financials. These fields are in the financial properties of the resource and include financial department, financial location, transaction class, and resource class. The resource must also have the input type field completed in the time tracking section of the settings properties on the resource. Alternatively, the resource can select an input type code in the timesheet if the timesheet is configured to display this field.
  • The investment and resource must have a department OBS unit that is associated to them to process financial transactions. For a department OBS to be available to associate to an investment and resource, first set up a department OBS and a location OBS (Administration/Organization and Access-OBS) and associate them to the investment objects (for example, Application, Project, and so on) and resource object for which you can enter transactions. Next, create an entity (Administration/Finance-Setup/Entities) and associate the department OBS and location OBS to the entity. The entity determines the home currency of the investment when you associate the department to the investment.
  • There must be a rate matrix created (Administration/Finance-Manage Matrix) and associated as a system default rate matrix (Administration/Finance-Setup/Defaults/Project Transaction Entry Defaults) or an investment-specific rate matrix for calculation of cost amounts. The matrix is required to calculate cost, if posting timesheets as financial transactions. The matrix is optional if entering transactions through transaction entry or importing from an external system. In those cases, the cost rate can be entered or imported with the transaction.
  • Financial transactions can be initiated from timesheets, transaction entry, or imported from external systems.
  • The investment must have at least one resource that is assigned to a task for the resource to enter time against the investment. For projects, the resource must be assigned to a task in the Gantt unless the project has an effort task with resources automatically assigned. For investments other than the project, resources added to the team are automatically assigned to an effort task for the investment.
    Note
    : Effort task is a task with the Task ID of '~rmw'.
  • There must be charge codes that are created (Administration/Project Management-Charge Codes) and associated to the investment to post timesheets as financial transactions. For projects, the transaction charge code is determined in the following order, whichever it finds first: based on the task charge code; then, based on a parent task charge code by walking up the work breakdown structure; and lastly, based on the project charge code. For non-project investments, the transaction charge code is determined by the charge code that is entered on the investment. If the transaction is entered through transaction entry or imported from an external system, the charge code can be entered or imported with the transaction.
  • There must be transaction classes that are created (Administration/Finance/Setup-Transaction Classes) and associated to the resource to post timesheets as financial transactions. If the transaction is entered through transaction entry or imported from an external system, the transaction class can be entered or imported with the transaction.
  • There must be resource classes that are created (Administration/Finance/Setup-Resource Classes) and associated to the resource to post timesheets as financial transactions. If the transaction is entered through transaction entry or imported from an external system, the resource class can be entered or imported with the transaction.
  • There must be input type codes created (Administration/Project Management-Input Type Codes) and associated to the resource to post timesheets as financial transactions. If the transaction is entered through transaction entry or imported from an external system, the input type code can be entered or imported with the transaction.
    Note
    : The input type code is not on the financial properties of the resource; it is in the time tracking section of the settings properties on the resource.
 
Report Properties
 
The following values list the report properties:
 
Name
: Investment Transaction Inquiry
 
Resource ID
: CSK_FIN_InvTransactionInquiry
 
Description
: Financial Management (PMO Accelerator)
 
Folder
:
Clarity
/Reports/Financial Management/Investment Transaction Inquiry
 
Path
: /ca_ppm/reports/financial_management/CSK_FIN_InvTransactionInquiry
 
Data Source
:
Clarity
Bean Data Source
 
Report Parameter Options
 
The following table lists the report parameter options.
 
Prompt Text
Parameter Name
 
 
Type
 
 
Input Control Name
Input Control Resource ID
 
 
Mandatory
Default Value
 
Investment OBS Type
investmentOBSTypeKey_1
Single-select
Query
Investment OBS Type
investmentOBSTypeKey_1
No
Investment OBS Unit
investmentOBSUnitKey_1
Single-select
Query
Investment OBS Unit
investmentOBSUnitKey_1
No
Investment Type
investmentTypeKey_1
Multiple-select
Query
Investment Type
investmentTypeKey_1
Yes
All
Investment Manager
investmentManagerKey_1
Multiple-select
Query
Investment Manager
investmentManagerKey_1
No
Investment
investmentKey_1
Multiple-select
Query
Investment
investmentKey_1
No
Start Date
startDate
Single Value
Date
Start Date
startDate
Yes
End Date
endDate
Single Value
Date
End Date
endDate
Yes
Transaction Entry Number
transactionEntryNumber
Single Value
Number
Transaction Entry Number
transactionEntryNumber
No
Transaction Status
transactionStatus
Single-select
List of Values
Transaction Status
transactionStatus
No
Graph 1 Group By
groupChartFinAttributes1
Single-select
List of Values
Graph 1 Group By
groupChartFinAttributes1
Yes
Charge Code
Graph 2 Group By groupChartFinAttributes2
Single-select
List of Values
Graph 2 Group By groupChartFinAttributes2
Yes
Transaction Class
Transaction Group By 1
groupTransactionFinAttributes1
Single-select
List of Values
Transaction Group By 1
groupTransactionFinAttributes1
No
Transaction Type
Transaction Group By 2
groupTransactionFinAttributes2
Single-select
List of Values
Transaction Group By 2
groupTransactionFinAttributes2
No
Report Column 1
groupColumnFinAttributes1
Single-select
List of Values
Report Column 1
groupColumnFinAttributes1
Yes
Resource
Report Column 2
groupColumnFinAttributes2
Single-select
List of Values
Report Column 2
groupColumnFinAttributes2
Yes
Resource Role
Report Column 3
groupColumnFinAttributes3
Single-select
List of Values
Report Column 3
groupColumnFinAttributes3
Yes
Task
Report Column 4
groupColumnFinAttributes4
Single-select
List of Values
Report Column 4
groupColumnFinAttributes4
Yes
Charge Code
Report Column 5
groupColumnFinAttributes5
Single-select
List of Values
Report Column 5
groupColumnFinAttributes5
Yes
Transaction Class
Include Inactive Investments?
includeInactiveInvestments
Boolean
Include Inactive Investments?
includeInactiveInvestments
No
Unchecked
Show Graphs?
showGraphs
Boolean
Show Graphs?
showGraphs
No
Checked
Database Schema
ppmDBSchema
Hidden
Not Applicable
Yes
Passed through 
Classic PPM
 
UI Theme
ppmUserUITheme
Hidden
Not Applicable
Yes
Passed through 
Classic PPM
 
Language
ppmUserLanguage
Hidden
Not Applicable
Yes
Passed through 
Classic PPM
 
User ID
ppmUser
Hidden
Not Applicable
Yes
Passed through 
Classic PPM
 
 
Parameter Lookup Values
 
The following values list the lookup values:
 
Investment Type
: All, Application, Asset, Idea, Other Work, Product, Project, Service
 
Transaction Status
: Posted, Unposted
 
Graph 1 and 2 Group By
: Charge Code, Cost Type, Department, Input Type, Location, Resource Class, Resource Role, Transaction Class, Transaction Type, User Value 1, User Value 2
 
Transaction Group By 1 and 2
: Charge Code, Cost Type, Department, Input Type, Location, Resource, Resource Class, Resource Role, Task, Transaction Class, Transaction Type, User Value 1, User Value 2
 
Report Column 1-5
: Charge Code, Cost Type, Department, Input Type, Location, Resource, Resource Class, Resource Role, Task, Transaction Class, Transaction Type, User Value 1, User Value 2
 
Parameter Explanations
 
The following list describes the parameters:
  • The Investment OBS Type is a cascading parameter and determines which units are listed in the Investment OBS Unit parameter. This parameter is not used to control which investments display in the report.
  • The Investment OBS Unit parameter displays values that are based upon the Investment OBS Type selected. When you select an OBS unit in this parameter, the report displays the investments that are attached to the OBS unit and descendants of the unit you select.
  • The Start Date and End Date parameters determine which transaction dates are included in the report.
  • The Transaction Entry Number parameter is a text field which allows you to display only transactions that are related to a specific transaction entry number. The text field is case-sensitive so you must capitalize letters in the parameter if they are capitalized in the entry number. The parameter supports a wildcard character (star) being entered at the end of the string; the report displays all matching records that meet the criteria entered preceding the wildcard character.
  • The Transaction Status parameter allows you to select which transactions to include in the report and works as follows:
    •  
      Posted
      . This option includes financial transactions that have been posted via the Post to WIP (Home/Financial Management-Post to WIP).
    •  
      Unposted
      . This option includes timesheets and transactions that are imported from external systems that have been posted to financials for processing via the Post Transactions to Financials job (Home/Personal-Reports and Jobs) or entered in transaction entry, but are not yet posted via the Post to WIP (Home/Financial Management-Post to WIP).
  • The report has Graph 1 Group By and Graph 2 Group By parameters that allow you to control how each chart in the report is grouped. You can group each chart by the following grouping options:
    •  
      Charge Code
      . This option groups the chart by charge code.
    •  
      Cost Type
      . This option groups the chart by cost type.
    •  
      Department
      . This option groups the chart by department.
    •  
      Input Type
      . This option groups the chart by input type code.
    •  
      Location
      . This option groups the chart by location.
    •  
      Resource Class
      . This option groups the chart by resource class.
    •  
      Resource Role
      . This option groups the chart by resource role.
    •  
      Transaction Class
      . This option groups the chart by transaction class.
    •  
      Transaction Type
      . This option groups the chart by transaction type.
    •  
      User Value 1
      . This option groups the chart by user value 1.
    •  
      User Value 2
      . This option groups the chart by user value 2.
  • The report has Transaction Group By 1 and Transaction Group By 2 parameters that allow you to control how the body of the report is grouped. You can group the report by up to two options, which can be any combination of the following grouping options:
    •  
      Charge Code
      . This option groups the body of the report by charge code.
    •  
      Cost Type
      . This option groups the body of the report by cost type.
    •  
      Department
      . This option groups the body of the report by department.
    •  
      Input Type
      . This option groups the body of the report by input type code.
    •  
      Location
      . This option groups the body of the report by location.
    •  
      Resource
      . This option groups the body of the report by resource.
    •  
      Resource Class
      . This option groups the body of the report by resource class.
    •  
      Resource Role
      . This option groups the body of the report by resource role.
    •  
      Task
      . This option groups the body of the report by task.
    •  
      Transaction Class
      . This option groups the body of the report by transaction class.
    •  
      Transaction Type
      . This option groups the body of the report by transaction type.
    •  
      User Value 1
      . This option groups the body of the report by user value 1.
    •  
      User Value 2
      . This option groups the body of the report by user value 2.
  • The report has Report Column 1-5 parameters that allow you to control the columns that display in the report. You can  select up to five columns to display in the report and control the order in which they display. Report column 1 displays first and report column 5 displays last. The report column options are as follows:
    •  
      Charge Code
      . The charge code column displays in the report.
    •  
      Cost Type
      . The cost type column displays in the report.
    •  
      Department
      . The department column displays in the report.
    •  
      Input Type
      . The input type code column displays in the report.
    •  
      Location
      . The location column displays in the report.
    •  
      Resource
      . The resource column displays in the report.
    •  
      Resource Class
      . The resource class column displays in the report.
    •  
      Resource Role
      . The resource role column displays in the report.
    •  
      Task
      . The task column displays in the report.
    •  
      Transaction Class
      . The transaction class column displays in the report.
    •  
      Transaction Type
      . The transaction type column displays in the report.
    •  
      User Value 1
      . The user value 1 column displays in the report.
    •  
      User Value 2
      . The user value 2 column displays in the report.
  • The Show Graph parameter controls whether the cost charts display on the report. If the parameter is checked, the charts display at the top of each investment transaction section in the report. If the parameter is not checked, the charts will not display.
 
Report Fields and Calculations
 
The report has two pie charts showing the cost distribution according to the graph group by options that are selected when running the report. The amounts in the charts are a summary of all transactions meeting the parameter criteria of the report.
The report displays the investment name, investment ID, start date, finish date, investment manager, financial status, company name, and objective at the top of the report. The body of the report displays the following investment transaction information: transaction date, report columns 1 through 5 selected using the parameters, posted date, quantity, actual cost rate, and total cost. The report adjusts the column headings and content according to the values selected in the Report Column 1-5 parameters, which can be any combination of the following: charge code, cost type, department, input type, location, resource, resource class, resource role, task, transaction class, transaction type, user value 1, and user value 2. In the preceding screen capture, resource name, resource role, department, location, and task were the columns that are selected when running the report.
The transactions can be grouped by up to two options in the report body, which can be any combination of the following: charge code, cost type, department, input type, location, resource, resource class, resource role, task, transaction class, transaction type, user value 1, and user value 2.
Actual financial transaction cost amounts only include transactions that are processed and posted. Any other status is a transaction that is adjusted, reversed, or updated and those transactions are excluded. Actual financial transaction cost amounts are in the currency that is the entity  home currency of the department that is associated to the investment.
At the bottom of each investment section in the report, there is a summary for labor, non-labor, and total amounts of all transactions included in the report for the investment. The labor amounts include chargeable hours, non-chargeable hours, total hours, chargeable cost, non-chargeable cost, and total cost. The non-labor and total amounts include chargeable cost, non-chargeable cost, and total cost. The chargeable amounts represent transactions that were processed with the chargeable option checked. The chargeable option can be checked if the transaction is entered through transaction entry or imported from an external system. If the transaction originates with a timesheet, then the chargeable option defaults from the input type code that is associated to the resource. The input type code has a chargeable option that you select when setting it up in administration.
 
Report Security
 
Security is determined by investment view rights.