Example: Foreign Transactions That Are Not In the Currency of the New Base Currency

The example provides a foreign currency transaction that is not in the currency of the new base currency and corresponding alternate currency transactions before and after the conversion.

Before the conversion, the GBP (British pound) to CAD exchange rate (2.34849) from the F0015 table was used to calculate the original domestic amount and the CAD to EUR rate (0.61752) was used to calculate the original alternate currency amount:

Ledger	Before Conversion	After Conversion
AA	4,696.98 CAD	3,204.80 USD
CA	2,000.00 GBP	2,000.00 GBP Rate changes to 1.6024 3,204.80 / 2,000.00
XA	2,900.48 EUR	2,900.48 EUR Rate changes to 1.1049 3,204.80 / 2900.48
YA	YA record did not exist before the conversion.	YA record does not exist after the conversion.
ZA	2,900.48 EUR	2,900.48 EUR Rate changes to 1.1049 3,204.80 / 2,900.48

When you run base currency conversion, the system converts and deletes the following amounts in the F0911 table:

• For the AA ledger, it converts the original domestic amount (4,696.98 CAD) to the new base currency amount (3,204.80 USD).

  The conversion program uses the CAD to USD exchange rate (0.68231) from the F0015 table and the multiplier method.

• For the CA ledger, it retains the original foreign amount (2,000.00 GBP) but changes the rate on the record to a calculated rate (1.6024) between the converted AA amount and the CA amount 3,204.80 / 2,000.00.

• For the XA ledger, it retains the original alternate currency amount (2,900.48 EUR) but changes the rate on the record to a calculated rate (1.1049) between the converted AA amount and the XA amount 3,204.80 / 2,900.48.

• For the ZA record, it retains the original ZA amount (2,900.48) but changes the rate on the record to a calculated rate (1.1049) between the converted AA amount and the ZA amount 3,204.80 / 2,900.48.

  This rate is the same as the AA to XA rate.