Dates and Exchange Rates for Automatic Payments

When you write automatic payments, you specify the exchange rate to use based on:

• The general ledger date of the payment and its corresponding rate.

  The system retrieves the exchange rate for the general ledger payment date from the F0015 table. A gain or loss might be calculated.

  For this example, the general ledger payment date is June 15 and the exchange rate for that date is 2.27542.

  Transaction	Foreign Amount	Exchange Rate	Domestic Amount
  Voucher	500.00 GBP	2.27650	1,138.25 CAD
  Payment	500.00 GBP	2.27542	1,137.71CAD

  The domestic voucher amount is 1,138.25 CAD and the domestic payment amount is 1,1371.71 CAD, which results in a realized gain of + 0.54 CAD.

• The specific effective date and corresponding rate.

  The system retrieves the exchange rate for the date you specify from the F0015 table. A gain or loss might be calculated.

  In this example, you specify an effective date of June 30 and the exchange rate for that date is 2.28551.

  Transaction	Foreign Amount	Exchange Rate	Domestic Amount
  Voucher	500.00 GBP	2.28478	1,142.39 CAD
  Payment	500.00 GBP	2.28551	1,142.76 CAD

  The domestic voucher amount is 1,142.39 CAD and the domestic payment amount is 1,142.76 CAD, which results in a realized loss of –0.37 CAD.

• The voucher exchange rate.

  The system uses the exchange rate that was in effect at the time you entered the voucher. There is no gain or loss calculated because the voucher domestic amount is equal to the payment domestic amount.

  In this example, the exchange rate for the voucher is 2.67823. That same exchange rate is used for the payment.

  Transaction	Foreign Amount	Exchange Rate	Domestic Amount
  Voucher	500.00 GBP	2.67823	1,339.12 CAD
  Payment	500.00 GBP	2.67823	1,339.12 CAD

You specify the date and exchange rate in the processing options for the Work with Payment Groups program.