Currency translation using Spot/Daily rates..

[Former Member]

There is constant influx of Equity capital in Joint venture, and is it possible to translate

the non USD investment to group currency using daily rates?

What is 'Cons' in doing so.

[dan_sullivan · Accepted solution]

The only way I can think of to accomplish this is to have consolidation on a daily basis.

What are advantages doing so daily?

[Former Member · Accepted solution]

Or is it possible to translate this data in group currency in R/3 and bring it acrosss?

Or can we define in BCS that only for these specific items to use daily date or spot rate.. How does it look? because the argument is USGAAP require daily rate translation for Investment.

Also going forward the translation should not update the earlier month translation for this items.. how to handle that in BCS...

[dan_sullivan · Accepted solution]

It is my experience that transactions in ECC (R3) use daily spot rates. This way the posting level 00 data is at the desired rate without BCS translation.

[Former Member]

It's not so difficult to get the system to do spot rate translations. You need to add a subassignment based on an InfoObject with the appropriate mask (e.g. dd.mm.yyyy as mandatory format), then there is a BADI for the currency translation rate determination which you can use. You will need to read the required date from the environment variables and use that to fetch the exchange rate from TCURR (there is a function module for this).

We've set this up and it works perfectly.

[Former Member]

Hi Venkat,

If you want to do daily spot rate curr tran in BCS you are doing to build up huge work load and also bring in the date char which is going to make the BCS cube to bulge with data.

My recommendation is to do the curr tranlation in R/3 for this item and and exclude this item from BCS curr translation .

Thanks and best regards

Sekar