Given the following:
1. Subsidiary Hierarchy:
Subsidiary A - in US Dollars
Subsidiary B - in Euro currency
2. Sales Order Account's General Rate Type is Average.
3. Exchange Rate from Euro to US Dollars = 1.00
4. Consolidated Current Exchange Rate = 1.35319996
Consolidated Average Exchange Rate = 1.37065836
A Sales Order was created on 1/31/2014 for Subsidiary B. Its GL Impact (Actions > GL Impact) reflects:
Debit Sales Orders account for 186,000
Credit Revenue for 16,909.09
Credit Deferred Revenue for 169,090.91
First, get the Consolidated Exchange Rate found in Lists > Accounting > Consolidated Exchange Rates.
Set the Period to January 2014, and the following:
From Subsidiary = Subsidiary B
To Subsidiary = Subsidiary A
Current Consolidated Exchange Rate = 1.35319996
Average Consolidated Exchange Rate = 1.37065836
Since Sales Order account's General Rate Type is Average, multiply the Revenue, 16,909.09 to the Consolidated Average Exchange Rate of 1.37065836; and multiply the Deferred Revenue, 169,090.91, to the Consolidated Current Exchange Rate of 1.35319996. Then, Total are added together.
16,909.09 * 1.37065836 = 23,176.59
169,090.91 * 1.35319996 = 228,813.81
23,176.59 + 228,813.81 = 251,990.39 or 251,990