We have a europe project with FY18 values for Cost & Budget plans(01/04/2018 to 31/03/2019) and In our Financial Module under setup menu, our currency is for the project EUR(Europe) and we want to convert as JPY(Japan) currency.
From Currency To Currency Conversion Rate Rate Calculation Method Exchange Rate Type Effective DateEUR JPY 150.000000 Multiply Average 01/04/18EUR JPY 151.000000 Multiply Average 01/04/19EUR JPY 152.000000 Multiply Average 01/04/20
The problem is, project calculates the budget & Cost values with FY20 conversation rate(130.815640 instead of calculating FY18 Currency rate(129.000000). Why does it calculate the value with (01/04/20) conversion rate specifically? Is this calculating based on recent/latest exchange rate creation? because when i entered to the screen, it checked by default "Show current rate only" Check box. Hope this is multiplying because of recent effective date exist.
Do we overcome this issue? As this is a FY18 project, it should calculate/Multiply with FY18 Conversion rate. Should not multiply with FY19, FY20 conversion rate or any other latest Fiscal year conversion rate.
I tested this and mine used the exchange rates for the correct year. I do not think the checkbox Show Current Rates has anything to do with this, as that is just for the list view of the rates.
Has anyone else seen this behavior?Karthik, I suggest you open a case with support to look into this further.
Where are you viewing the conversion? The Billing Currency view? How are the costs spread out? Meaning which periods have the costs been defined for? If the costs are for period prior to 2020 and yet the conversion is being applied based on the effective date of 2020, then there is a problem and you will have to log a case with product support.
If possible, you will check exchange rate directly by using below query.
SELECT ID,FROM_CURRENCY_CODE,TO_CURRENCY_CODE,FROM_DATE,TO_DATE,RATEFROM CMN_EXCHANGE_RATESWHERE FROM_CURRENCY_CODE='EUR'AND TO_CURRENCY_CODE='JPY';