Converted Rates rounding in GCP

Products

• Clarity PPM SaaS

Issue/Introduction

In the GCP environment set up to use multi-currencies, when a foreign rate is converted to the project rate, it is rounding. 

 

Setup:

     A. Use a project with US Currency 
     B. Use a Rate Matrix with USD Default Currency 
     C. Uncheck Apply currency precision for rate/costs 

STEPS TO REPRODUCE: 

1. Create a new exchange rate 
    INR to USD   Multiply by 0.013 
    USD to INR   Multiply by 73.62 

    Set Effective Date back to before the project dates 
 
2.  Add a row in the matrix using INR currency 
    Make the matrix have the 'Resource' as a column and use a specific resource 
    Add Rate and Cost of 115.50 INR 
 
3.  Add the resource to the USD currency project 
    - Make sure they have some allocation 

4.  Run the 'Rate Matrix Extraction' job with options 2,3 

5.  Check the table and fields: nbi_proj_res_rates_and_costs.PROJECT_BILL_RATE
    and nbi_proj_res_rates_and_costs.PROJECT_COST_RATE 
  
6.  Check the costs on the project as well 
 
Expected Results:  Table Fields = 1.5015. Project costs calculated based on the conversion rates. 
Actual Results: Table  Fields = 2.   Project costs calculated based on the rounded amount for the conversion rates. 

Environment

Release : 15.9

Component : CA PPM SAAS FINANCIAL MANAGEMENT

Cause

Reported as  DE59671

Resolution

DE59671 fix targeted for 15.9.2