Exchange rate issue?

[Former Member]

Hello Experts,

During Payment to Bank: The credit card transactions are
imported from bank through a set of MC files into the SAP buffer. For those
transactions made in a foreign currency, MC provides the exchange rate of the
day in which the transaction took place, & system automatically does a
conversion into USD.

But during employee(s) Expense report creation, our system automatically
re-calculates the USD amount of the transaction made in a foreign currency
using the SAP exchange rate of the day (TCURR)

Therefore, based on the exchange rate fluctuations, ER total
differs from the original sum of the charges.

Our issue is how do we use the transactions rates which are
passed into buffer, instead of using systems exchange rate of the day from (TUCRR)?

Thnks!!

[Lukas_Weigelt · Accepted solution]

Hi AB,

have you read Sally's Wiki concerning this topic?

Customizing Currency and Exchange Rates in Travel Management - ERP Human Capital Management - SCN Wi...

If not, please do so. Section 5 of the wiki mentions BADIs and Classes that can be used for coding based manipulations (which I think would be necessary in your case, because TCURR and TCURF are static after all).

Cheers, Lukas

[Former Member · Accepted solution]

Lukas! Thanks a Lot.. 

SAP note:1712292 should solve our issue.

Cheers,
AB

[Lukas_Weigelt · Accepted solution]

Indeed. Good you're pointing this out! Then maybe you can avoid the necessity for coding based manipulations. Nice!

Cheers, Lukas

[Former Member · Accepted solution]

Hi Guys,

After doing some coding changes, and implementing SAP Note: 1712292,
we were able to successfully achieve the desired results. However, when our changes
moved to Production we see that some users in expense Portal are encountering errors like ‘500 Internal server error ERROR: A row with the same key already exists (termination:RABAX_STATE)’ and in ST22 ITAB_Duplicate_key.

Since we never encountered the issue in other systems, this issue occurred in
Production itself. Am I missing something here? Also went through Sally’s Wiki
concerning this topic but need some direction.

Cheers,
A

[Former Member · Accepted solution]

Found SAP Note 1757489 which resolved above issue.

Cheers,
AB