Rates and Costs not Populating in MSP
Article ID: 130280
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
Rates and costs are not populating correctly in Microsoft Project for newly added resources. The costs are being calculated using an incorrect rate of $0 or $1 depending on the project.
Steps to Reproduce:
1. Create a project and associate it to a rate matrix
2. Staff a resource to the team (having a rate of $50 in the rate matrix)
3. Create a task and assign a resource with 2 hours of ETC (or any other non-zero ETC amount)
4. Export the project to Microsoft Project
Expected Results: The rate on the resource sheet is $50 and the calculated cost for the task is $100.
Actual Results: The rate on the resource sheet as well as the calculated cost for the task is $0.
Note: The rate on the actual results will be either $0 or $1 depending on where the resource was added (either in MSP or PPM) and whether other resources on the same project have records in the NBI_PROJ_RES_RATES_AND_COSTS table.
Steps to Reproduce:
1. Create a project and associate it to a rate matrix
2. Staff a resource to the team (having a rate of $50 in the rate matrix)
3. Create a task and assign a resource with 2 hours of ETC (or any other non-zero ETC amount)
4. Export the project to Microsoft Project
Expected Results: The rate on the resource sheet is $50 and the calculated cost for the task is $100.
Actual Results: The rate on the resource sheet as well as the calculated cost for the task is $0.
Note: The rate on the actual results will be either $0 or $1 depending on where the resource was added (either in MSP or PPM) and whether other resources on the same project have records in the NBI_PROJ_RES_RATES_AND_COSTS table.
Environment
Release:
Component: PPMMSP
Component: PPMMSP
Resolution
This is working as designed and is due to there not being a rate in the NBI_PROJ_RES_RATES_AND_COSTS for the resource and project combination. A rate must exist in the NBI_PROJ_RES_RATES_AND_COSTS table prior to exporting the project to MSP so that the resource rate can be exported as well. Once rates are populated in this table and exported to MSP, MSP will reflect the correct rate and calculate the expected costs.
In order to populate the NBI_PROJ_RES_RATES_AND_COSTS table, the Rate Matrix Extraction job will need to run. Alternatively, the on-the-fly Rate Matrix setting can be enabled under Administration - Health Report - Application tab. This is a system wide setting. When the on-the-fly Rate Matrix setting is enabled, the rates will populate in the NBI_PROJ_RES_RATES_AND_COSTS table as soon as the resource is added to the team AND Update Cost Totals is run from the Actions drop down menu on the Team tab.
In order to populate the NBI_PROJ_RES_RATES_AND_COSTS table, the Rate Matrix Extraction job will need to run. Alternatively, the on-the-fly Rate Matrix setting can be enabled under Administration - Health Report - Application tab. This is a system wide setting. When the on-the-fly Rate Matrix setting is enabled, the rates will populate in the NBI_PROJ_RES_RATES_AND_COSTS table as soon as the resource is added to the team AND Update Cost Totals is run from the Actions drop down menu on the Team tab.
IMPORTANT: Impact of enabling this on-the-fly setting:
-
If using PPM to track time, the post timesheets job can take a long time to run. See KB000005886 and Tech Tip: Post Timesheets job slow on 14.3, 14.4 and 15.1 for more details on this issue.
Additional Information
KB000025696: Clarity PPM: What does the Rate Matrix Extraction job do and how is it used?
Feedback
Yes
No
Powered by
