Hi All
I need further clarifications on Suite Answer 7711.
Based on the simplified example in Suite Answer 7711, has anyone ever able to manually work out the System Calculation of Consolidated Exchange Rates using the formulas explained in Suite Answer 7711 with live data financial result?
It seems tedious to manually sum up each Foreign Currency Transactions Total for all GL Accounts of the same General Rate Type every day if the daily rate is different? Transactions Total here means Debit less Credit Amounts or Debit plus Credit Amounts?
The Currency rate described in SA7711 is Default Exchange Rate from Setup and not necessary equal to the actual rate (if the rate has been manually edited in transaction before posting) posted in transaction right?
The transactions during the period of January for the U.K. subsidiary are listed in the following table:
Transaction Date | Currency Exchange Rate | Amount | Posting Account General Rate Type |
|---|
January 1 | 2 | 100 GBP | Average |
January 1 | 2 | 300 GBP | Historical |
January 15 | 2.5 | 200 GBP | Average |
January 15 | 2.5 | 200 GBP | Historical |
January 31 | 3 | 300 GBP | Average |
January 31 | 3 | 100 GBP | Historical |
When you click Calculate at the top of the Consolidated Exchange Rates page, the consolidated exchange rates from the U.K. subsidiary to the U.S. Subsidiary are derived as follows:
- Current rate uses the GBP to USD rate from the Currency Exchange Rates list as of the end of the period (January 31).
Current rate = 3
- Average rate is a weighted average based on transactions amounts posted to all accounts with a general rate type of Average. The currency exchange rate for each transaction is the GBP to USD rate in effect on the transaction date.
Average rate = (2 × 100 + 2.5 × 200 + 3 × 300) ÷ 600 = 2.6666667
- Historical rate is a weighted average based on transactions amounts posted to all accounts with a general rate type of Historical. As for the average rate, the currency exchange rate for each transaction is the GBP to USD rate in effect on the transaction date.
Historical rate = (2 × 300 + 2.5 × 200 + 3 × 100 ÷ 600 = 2.3333333