## Saturday, July 13, 2019

### Compute for the consolidated foreign currency amount when a sales transaction consists of Deferred Revenue?

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

Calculation:

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