Incorrect Rate Being Returned in Investment Idea/Project Cost Plan

Products

• Clarity PPM On Premise

Issue/Introduction

Steps-to-reproduce:

1. Set up Rate Matrix with date ranges and rate.

2. Go to Modern > Idea > Staff
   Populate Staff with Roles
   Allocate the roles in the Month grid.
3. Go to Idea > Financials > Cost Plans 
  Add Grouping Attributes(Resource, Role, Transaction Class)
  Click 'Populate from Allocations'
  Review the Cost(planned cost),Units fields

Actual Results: The Planned Cost shows amount is incorrect and the rate is calculated by (Planned cost dividedby Units)
Expected Results: The Planned Cost should be reflecting the correct rate.

Environment

Release : All

 

Resolution

This usually happens when there is another match in the matrix which the cost plan row is actually matching.

Get the unit cost and then check in the rate matrix for the cost which is being returned.

You can sort on the cost field and then find the records that have that cost and see if your row is actually matching to that row (or if it returns several rows one of them)

Then you can determine if the cost returned is correct or if you need to make changes to the matrix or  the financial settings.

 

You can also use the following query to check if the investment or idea has the correct cost:

SELECT
i.id, i.name, i.code,
PROJECT_ID, RESOURCE_ID, TASK_ID, TEAM_ID, TASK_ROLE_ID, CHARGE_CODE, from_date, to_date, last_modified_date, bill_rate, cost_rate
FROM
NBI_PROJ_RES_RATES_AND_COSTS r,
INV_INVESTMENTS i
where and r.project_id = i.id
--and PROJECT_ID = x
--and resource_id = x
order by RESOURCE_ID