E1: 04: Overview Multi Currency within Automatic and Manual Payments in Accounts Payable (P04571/P0413M)
(Doc ID 1432621.1)
Last updated on AUGUST 03, 2023
JD Edwards EnterpriseOne Accounts Payable - Version XE and later Information in this document applies to any platform.
A foreign currency payment is a payment that is in the foreign (transaction) currency of the voucher. You specify the foreign currency of a payment at the time the payment is entered. When entering a foreign currency payment:
The foreign currency of a payment must be the same as the transaction currency of the voucher.
The base currency of the payment must be the same as the domestic (base) currency of the voucher.
For example, the domestic currency of a voucher is U.S. dollars (USD). The foreign currency payment must be for a company with a base currency code of USD and the payment and the transaction currency of the voucher must be the same. If the bank account is a monetary account, the company currency for the bank account must also be USD. If the company currency for the bank account is different from the base currency of the payment, the system issues an error message.
Prior to writing foreign currency payments, the following setup must be completed:
Assign currency codes to supplier records
Each supplier record contains these currency code fields:
Default Code (CRRP). Currency in which you enter vouchers for the supplier. Can be overriden when entering the voucher. If you leave this field blank, the system uses the currency of the company assigned to the supplier record as the default.
A/B Amount Code (CRCA). Currency in which you track address book amounts for the supplier, including amounts invoiced this year and the prior year. If you leave this field blank, the system uses the value of the Amount Currency Code field if it is specified in the processing options for the Supplier Master program (P04012). Otherwise, it uses the currency code of the company assigned to the Business Unit field on the Address Book Revision form.
Caution: Once you have assigned an A/B Amount Code (CRCA) it CAN NOT be changed or you will have meaningless amounts in the F0401 table because of mixed currencies
Set up currency specific automatic accounting instructions
Multicurrency AAI items are optional and are used to automatically calculate and distribute currency gains and losses to the correct general ledger account. The potential for a currency gain or loss is due to exchange rate fluctuations that occur between either:
The time a voucher is entered and payment is issued (realized gain/loss).
The time a voucher is entered and the end of a period if the voucher is still open (unrealized gain/loss).
Unrealized Gains and Losses - These AAI items define the accounts that the system uses for unrealized gains and losses on foreign currency vouchers that are open at the end of a period:
PVxxx - foreign currency unrealized gain.
PWxxx - foreign currency unrealized loss.
PRxxx - foreign currency unrealized gain or loss offset.
To create an unrealized gain or loss amount, the system compares the amount of the original voucher to the amount of the open voucher (which is revalued based on the exchange rate at the end of the period) and creates a gain or loss for the difference. The system uses the account number assigned to PV and PW to create foreign currency unrealized gains and losses on open vouchers when you run the A/P Unrealized Gain/Loss Report (R04425). The system uses the account number assigned to PR to create foreign currency unrealized gain or loss offsets when you run the A/P Unrealized Gain/Loss Report. The xxx represents the currency code, which is optional, and xxxx represents the value of the G/L Offset field on the voucher.
Realized Gains and Losses - These AAI items define the accounts that the system uses for realized gains and losses on foreign currency payments:
PGxxx - foreign currency realized gain.
PLxxx - foreign currency realized loss.
To create a gain or loss amount, the system multiplies the voucher amount by the difference in the exchange rate between the original voucher and the foreign currency payment. The system uses the account number assigned to PG and PL to create foreign currency gain and loss amounts. The system creates a gain or loss entry when the payment is posted. The xxx represents the currency code, which is optional, and xxxx represents the value of the G/L Offset field on the voucher.
This document discusses multi currency Automatic Payments and manual payments within Oracle JD Edwards EnterpriseOne Financial system.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!