on 02-22-2019 2:38 PM
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,
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 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Please read old, but still useful: https://archive.sap.com/kmuuid2/6052a57b-8c64-2c10-b3a5-b0378ff21243/How%20to%20do%20Currency%20Tran...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Sorry, I am completely lost! What is the issue?
What do you have in the RATES model???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but not clear!
What rates do you have for Yuan & USD?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not clear! You have to enter rate related to the currency with the rate 1!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.