Nov 09, 2016 at 08:36 PM | 306 Views | Last edit Nov 09, 2016 at 08:39 PM 2 rev.
I have a BI query in which I am performing the conversion from 'amount in document currency' to 'amount in local currency' with exchange rate as on today. I am using currency translation variable with below setting.
I have transferred all the 'exchange rates' as well as 'global settings for currencies' into my BW system from the source system. When I run the query, I am getting all the records i.e. 'amount in document currency' converted to 'amount in local currency' with 'exchange rate as on today' except one conversion (EUR to GBP). I have checked TCURR table and it has the appropriate conversion rate maintained for this conversion too.
I am getting this error message when I run the query and EUR amount does not get converted in to GBP and gets displayed only in EUR.