Is it possible to adjust exchange rate variance in payment accounting?

Summary

How to set-up exchange rate in Payables for transaction over accounting year.

Content

Oracle Payables recognizes exchange rate difference between invoice date and payment date and also generates realized gain/loss journal lines at payment. Those functions are good in mid-accounting year.

But after accounting year closed, we need to reflect additional rule in realized gain/loss accounting.

For any foreign currency payments for invoiced in previous year, we have to calculate realized gain/loss between previous close date and payment date (not between invoice date and payment date).

(Any gains/losses occurred by exchange rate fluctuation in previous year are already reflected in the Income statements as unrealized gains/losses.)