ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Incorrect Costs for Non Labor Resources in MSP
Article ID: 129175
Updated On:
Products
Clarity PPM SaaS
Issue/Introduction
The user enters a cost against a non labor resource in Microsoft Project and this saves successfully to PPM with the correct cost amount. Upon reopening the MPP file, the cost is found to be different than what was saved. This occurs when the cost amounts near or exceed $4,800,000.
Steps to Reproduce:
0. Install the MSP new driver
1. Create a Rate Matrix with a catch all row of $1 for all resources
2. Create a project with any dates and associate this project to the Rate Matrix
3. Staff a Material (or any other non-labor resource) to the Team
4. Create a one day duration task, and assign the Material Resource
5. Run the RME job with first three options checked
6. Back on the task assignment, enter 100 ETC
7. Export the project to MSP
Note: Units = 100, Cost = $100 as expected
8. Change the Assignment Units to 4,800,000 in MSP
Note: In PPM, the ETC = 4,800,000 as expected
9. Export to MSP again
Expected Results: The Assignment Units and Cost still equal 4,800,000
Actual Results: The Assignment Units and Costs now equal 23,888,743.54
Steps to Reproduce:
0. Install the MSP new driver
1. Create a Rate Matrix with a catch all row of $1 for all resources
2. Create a project with any dates and associate this project to the Rate Matrix
3. Staff a Material (or any other non-labor resource) to the Team
4. Create a one day duration task, and assign the Material Resource
5. Run the RME job with first three options checked
6. Back on the task assignment, enter 100 ETC
7. Export the project to MSP
Note: Units = 100, Cost = $100 as expected
8. Change the Assignment Units to 4,800,000 in MSP
Note: In PPM, the ETC = 4,800,000 as expected
9. Export to MSP again
Expected Results: The Assignment Units and Cost still equal 4,800,000
Actual Results: The Assignment Units and Costs now equal 23,888,743.54
Cause
Caused by DE48273
Environment
Release: PPM 15.4.1 - 15.6.1
Component: CA PPM MICROSOFT PROJECT (MSP)
Resolution
DE48273 is fixed in the Clarity PPM PPM 15.7 release.
Workarounds:
- Split the tasks with higher ETC/Cost values into multiple tasks so that the amount is lower than the 4,800,000 range
- In at least one case, the issue didn't occur if the ETC was XOGed in using a custom process, so using XOG may help avoid the issue.
Feedback
Yes
No
Powered by
