Analyze the results of the Adjust Exchange Rates batch job

Completed

The Adjust Exchange Rates batch job can affect customers, vendors, and bank accounts.

Effect on customers and vendors

For customer and vendor accounts, the Adjust Exchange Rates batch job performs the following tasks:

  • Adjusts the currency by using the exchange rate that is valid on the posting date that is specified in the batch job.

  • Calculates the differences for the individual currency balances.

  • Posts the amounts to the general ledger account that is specified in the Unrealized Gains Acc. field or the Unrealized Losses Acc. field on the Currencies page.

  • Posts balancing entries to the receivables/payables account in the general ledger automatically.

The batch job processes all open customer ledger entries and vendor ledger entries. If an exchange rate difference exists for an entry, the batch job creates a new detailed customer or vendor ledger entry with an Entry Type of Unrealized Gain or Unrealized Loss, which reflects the adjusted amount on the customer or vendor ledger entry.

The adjustment entries are assigned the dimensions from the customer or vendor ledger entries, and the adjustments are posted for each combination of dimension values.

Effect on bank accounts

For bank accounts, the Adjust Exchange Rate batch job performs the following tasks:

  • Adjusts the currency by using the exchange rate that is valid on the posting date that is specified in the batch job.

  • Calculates the differences for each bank account that has a currency code.

  • Posts the amounts to the general ledger account that is specified in the Realized Gains Acc. field or the Realized Losses Acc. field on the Currencies page.

  • Posts balancing entries to the general ledger bank accounts that are specified in the bank account posting groups automatically.

  • Calculates one entry for each currency for each posting group.

The adjustment entries for the bank account's general ledger account and for the gain/loss account are assigned the bank account's default dimensions.

Exchange rate adjustment registers

The Exchange Rate Adjustment Registers page provides an overview of all the exchange rate adjustments that are made by the Adjust Exchange Rates batch job.

Each line on the page displays an exchange rate adjustment with the following information:

  • Type of entries that are adjusted

  • Currency and base amount that are adjusted

  • Adjustment amount

Screenshot of the Exchange Rate Adjustment Registers page.