Unrealized FX Gain/Loss calculation

Unrealized FX Gain/Loss reflects the change in value of open Accounts Receivable (AR) balances due to currency fluctuations.

The calculation is based on a period-end snapshot of all open AR balances. To determine the unrealized amount, the system compares:

• The FX rate on the original transaction date

• The FX rate on the accounting period end date (adjusted by the configured Rate Offset, if applicable)

Because of this design, the system requires FX rates covering the period from the first transaction date through the end of the accounting period.

Role of Journal Run target dates

The Journal Run target dates only determine which journal entry transactions are included in the run. They do not affect how Unrealized FX Gain/Loss is calculated.

Even if the Journal Run targets a subset of dates, the unrealized FX calculation still requires the FX rate corresponding to the accounting period end date (plus any configured rate offset).

Rate offset behavior

If a Rate Offset is configured, the system looks for the FX rate on:

Accounting Period End Date - Rate Offset

For example, if the rate offset is -1 day, the system retrieves the FX rate for the day prior to the accounting period end date.

Resolution

Ensure that the required FX rate exists for the date determined by:

Accounting Period End Date - Rate Offset

If the FX rate for this date is missing, the Unrealized FX Gain/Loss calculation may fail during the Journal Run.