XA, YA, and ZA Example: Domestic Currency Transaction Before and After the Conversion

Review this example to understand how the base currency conversion converts and updates a domestic-only transaction in the F0911 table. This example provides amounts before and after the conversion for the alternate currency ledgers (XA, YA, and ZA), as well as the actual amount (AA) and foreign currency (CA) ledgers.

In this example, a company with a base currency of Canadian dollars (CAD) converts to U.S.dollars (USD).

The CAD to USD exchange rate is 0.68231, which is derived from the F0015 table, and the multiplier method is used:

Ledger

Before Conversion

After Conversion

AA

1,000.00 CAD

682.31 USD

CA

CA record did not exist before the conversion.

1,000.00 CAD

XA

617.52 EUR

617.52 EUR

Rate changes to 1.1049

682.31 / 617.52

YA

1,000.00 CAD

Deletes record

ZA

ZA record did not exist before the conversion.

682.31 USD

The base currency conversion converts and writes amounts in the F0911 table:

  • For the AA ledger, it converts the original domestic amount (1,000.00 CAD) to the new base currency amount (682.31 USD).

  • For the CA ledger, it writes a foreign currency amount, which contains the original domestic amount before the conversion (1,000.00 CAD).

  • For the XA ledger, it retains the original alternate currency amount; however, the conversion program changes the rate on the record to a calculated rated between the converted AA amount and the XA amount.

  • For the YA ledger, it deletes the record.

  • For the ZA ledger, it writes a record, which is based on the XA amount and calculated rate.

    Note: For illustration purposes, the table in the example provides amounts and currency codes before and after the base currency conversion. Remember that the conversion does not change the actual currency code in the Currency Code (CRCD) field, but instead retains the currency code of the original transaction.