0

# Currency conversion issue

Sep 04, 2017 at 04:30 AM

59

Former Member

Hi All,

I have scenario where currency conversion is taking place from Russian Ruble(RUB) to British Pound( GBP). The value being converted is 0.15 RUB, exchange rate being 0.013 . So 0.15 RUB should be 0.002 GBP . But SAP gives 0.15 GBP. Below is what i found .

After the call to conversion FM, the result is as below

Converted value is 0 as per SAP . Exchange rate is 0.0137 .

On the condition screen value for this shows as 0.15 GBP as SAP is copying RUB value since conversion resulted in 0.

It looks like there is issue with truncation and number of decimals . If you have encountered similar issue , please help out on how to get this resolved.

untitled.png (69.8 kB)
untitled.png (69.0 kB)
untitled.png (2.7 kB)
untitled.png (2.7 kB)
untitled.png (9.0 kB)

Jürgen L
Sep 04, 2017 at 04:47 AM
0

Why don't you just recalculate it in Excel or on paper?

if 1 RUB = 0.01371 GBP

then 0,15 RUB = 0.01371/15 = 0,000914 GBP = rounded to two decimals: 0,00

Do you get a different value if you change the quantity to 1000 just for test purpose?

Share
Veselina Peykova
Sep 04, 2017 at 05:42 AM
0

You are using a formula (in the customer name range) to calculate values, which could potentially influence the way currency conversions are applied.

Check the logic in it with the help of your developers.

Another set of test cases, which are worth trying out is conversion between currencies with different decimal places - e.g. between USD and COP.

There are ways to achieve higher precision in pricing (more decimal places for currencies), but considering the low value of the article I am not sure whether this is a valid business case.

What happens if you sell 1000 items instead of just one? Does calculation produce better results?

Share