cancel
Showing results for 
Search instead for 
Did you mean: 

exchange rate

0 Kudos

Hi There,

We use BPC 10NW as a consolidation system and group multi-currencies (Yuan & USD). I only support the existing system. I have a question for exchange rates data.

What amount should I enter for Yuan, USD and INR?. The holding company will buy a new entity in India.

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

First - please accept the correct answer!

Second:

D means Divide

USD = 1 then you have to enter rate for Yuan=6.71 meaning that 1 Yuan is equal to 1 USD divided by 6.71

M means Multiply

USD=1 then you have to enter rate for Yuan=0.1490 meaning that 1 Yuan is equal to 1 USD multiplied by 0.1490

0.1490=1/6.76

D is preferable for accuracy if you have USD=1

If you decide to use INR=1 then M is preferable 🙂

Answers (6)

Answers (6)

former_member186338
Active Contributor
0 Kudos

There is no issue at all!!!

Number of consolidation currencies is ABSOLUTELY not related to rate table!

In rate table any single currency can be assigned value 1 and all other currencies have to be entered against this currency.

usd=1 & Yuan=1 is nonsense!

If usd=1 then Yuan=6.71

P.S. Currency conversion is performed using the formula:

Value in CUR1 = (Value in CUR2)*(Rate CUR1)/(Rate CUR2)

Sample: convert 10 USD to Yuan: CUR2=USD, CUR1=Yuan

10*6.71/1=67.1 Yuan

0 Kudos

Hi Vadim,

What is a reason to choose M or D in the property MD?.

former_member186338
Active Contributor
0 Kudos

Sorry again, but what is the issue???

If USD rate=1

Then you have to enter:

Yuan rate: 6.71 (Yuan for 1 USD)

INR rate: 71.14 (INR for 1 USD)

Multiply Divide property for mentioned currencies: D

P.S. Sample rate table with EUR=1

0 Kudos

Hi Vadim,

As I mentioned earlier about my issue. The current BPC system runs two consolidations, USD & Yuan.

1. Should I enter the amount 1 for USD & Yuan (usd=1 & Yuan=1)?.

2. I don't agree to use the divide(D) in the property MD. If users perform Yuan consolidation, currency translation will get trouble for USD company. Is it correct?.

Thanks

former_member186338
Active Contributor
0 Kudos
0 Kudos

Hi Vadim,

I had read this document before I posted my case. I couldn't find multiple group reporting currencies information in this document.

My current BPC system has two group reporting currencies. I do not how to input exchange rates data in Rates model. I used to input USD=1 since the previous system only had a group reporting currency.

Thanks

former_member186338
Active Contributor
0 Kudos

Sorry, I am completely lost! What is the issue?

What do you have in the RATES model???

former_member186338
Active Contributor
0 Kudos

Sorry, but not clear!

What rates do you have for Yuan & USD?

0 Kudos

Hi Vadim,

I should prepare CLO & AVG rate IDs for Yuan, USD, INR currencies.

In the dimension Group, I could see GROUP_CURRENCY: USD,YUAN.

thanks

former_member186338
Active Contributor
0 Kudos

Not clear! You have to enter rate related to the currency with the rate 1!

0 Kudos

Hi Vadim,

which exchange rate should I enter with the amount one?. Could you give a data example for that?.

We have two group reporting currencies in the BPC system, such as Yuan & USD.

Thanks