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 :)
Not clear! You have to enter rate related to the currency with the rate 1!
Sorry, but not clear!
What rates do you have for Yuan & USD?
Sorry, I am completely lost! What is the issue?
What do you have in the RATES model???
Please read old, but still useful: https://archive.sap.com/kmuuid2/6052a57b-8c64-2c10-b3a5-b0378ff21243/How%20to%20do%20Currency%20Translation%20for%20Financial%20Application%20using%20SAP%20BusinessObjects%20Planning%20and%20Consolidation%207.0%20for%20the%20SAP%20NetWeaver%20Platform
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
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