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

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

Ledger

Before Conversion

After Conversion

AA

4,397.70 CAD

3,000.00 USD

CA

3,000.00 USD

Record deleted.

XA

3,000.00 USD

3,000.00 USD

YA

YA record did not exist before the conversion.

3,000.00 USD

ZA

3,000.00 USD

ZA record does not exist after the conversion.

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

  • In the AA ledger, the system updates the base currency amount with the original foreign currency amount (3,000.00 USD).

  • In the CA ledger, the system deletes the original foreign currency amount (3,000.00 USD) because the new amount in the AA ledger is stated in the new base currency (USD).

  • In the XA ledger, the system retains the original alternate currency amount (3,000.00 USD).

  • In the YA ledger, the system writes a record, which is based on the AA amount.

  • In the ZA ledger, the system deletes the original ZA amount.