Rates and costs are not populating correctly in Microsoft Project (MSP) for newly added resources. The costs are being calculated using an incorrect rate of $0 or $1 depending on the project.
Steps to Reproduce:
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 Clarity) and whether other resources on the same project have records in the NBI_PROJ_RES_RATES_AND_COSTS table.
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.