Currency Conversion Error: Server Error

[deepika55]

Dear SAC Community,

I am currently facing an issue with currency conversion while attempting to convert USD to INR. Surprisingly, I encounter an error when converting to INR, whereas converting to EURO works without any problems. I have ensured that the target currency is correctly maintained. Could someone please assist me in resolving this issue?

The error message I receive is as follows: "Server Error: The currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table 'SAP_ALL_CURRENCY'."

I understand that this issue may seem basic to experienced individuals, but as a newcomer, I would greatly appreciate any help in gaining a better understanding of this matter.

Thank you,

Deepika

[N1kh1l · Accepted solution]

deepika55

deepika55The rates you maintained is only for USD to INR. So any entity with USD as currency will work for conversion. If you use entity whose currency is other than USD, you will face missing rates error. You have not shown the table with data so I cannot say what source currency were being used.

Hope this helps !!

Nikhil

[deepika55]

Thank you Nikhil

[deepika55]

Wow, Nikhil! It worked perfectly! I'm truly amazed.

Can you explain the scenario from the beginning, and I would appreciate it if you could guide me through it properly.

Thank you once again

Deepika

[N1kh1l]

deepika55

Currency Conversion works like this

• You have one or more dimension in model with currency property. In your case you have sales Org and Entity. Any data against these members will be treated as local currency value (currency of the member)
• You have Accounts members like Gross margin, Price etc which have Rate Type property. Depending on Account type you either have closing or average types.
• You have rates maintained in the table with effective date and currency pairs which is used for conversion.

Hope this helps !!

Please accept and upvote if it was helpful.

Nikhil

[deepika55]

Hi nikhil here is Sales org , Entity still i m getting the error when i try to convert

[N1kh1l]

deepika55

Expand the error and click on Add missing rates and add the rates system proposes. You can take rates from google or just maintain something dummy

Once you maintain the rates you can see conversion

Nikhil

[deepika55]

Hi Nikhil,

I just wanted to take a moment to express my heartfelt gratitude for your incredible support and help to our community. Your dedication and expertise have made a significant impact on all of us, and we are truly fortunate to have you.

I have encountered an issue with a conversion . Specifically, I need to add INR (Indian Rupee) as a currency entity. I believe your guidance and assistance will be immensely valuable in resolving this matter.

Thank you for your ongoing support .

Warmest regards

Deepika

[N1kh1l]

deepika55

Thanks

You have maintained the rates for USD to INR, so this rate can be used by sales org whose currency is USD to convert its local currency value to INR.

So in your model, if you check the sale org dimension, only SO0001 has USD as currency so in your table if you use this conversion will work. If you use any other highlighted in green it will give you missing rate error as rates for those currency w.r.t INR is not existing.

Hope this helps !!

Nikhil