Skip to Content

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,

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Feb 23, 2019 at 11:46 AM

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

    Add a comment
    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!

    Add a comment
    10|10000 characters needed characters exceeded

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

    Sorry, but not clear!

    What rates do you have for Yuan & USD?

    Add a comment
    10|10000 characters needed characters exceeded

  • 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???

    Add a comment
    10|10000 characters needed characters exceeded

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

    • 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

  • 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)
    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • 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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.