# exchange rate

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,

10|10000 characters needed characters exceeded

### Related questions

Posted on Feb 23, 2019 at 11:46 AM

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 :)

10|10000 characters needed characters exceeded
• Posted on Feb 22, 2019 at 05:03 PM

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

10|10000 characters needed characters exceeded

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

• Posted on Feb 23, 2019 at 07:30 AM

Sorry, but not clear!

What rates do you have for Yuan & USD?

10|10000 characters needed characters exceeded

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

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

thanks

• Posted on Feb 23, 2019 at 10:11 AM

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

What do you have in the RATES model???

10|10000 characters needed characters exceeded
• Posted on Feb 23, 2019 at 10:24 AM
10|10000 characters needed characters exceeded

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

• Posted on Feb 23, 2019 at 10:50 AM

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

rate.png (38.7 kB)
10|10000 characters needed characters exceeded

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

• Posted on Feb 23, 2019 at 11:20 AM

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