E1: 04: Unrealized Gain/Loss on Vouchers created from Procurement Does Not Clear Out (Doc ID 1663818.1)

Last updated on OCTOBER 13, 2016

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version XE and later
JD Edwards EnterpriseOne Procurement and Subcontract Management - Version XE and later
Information in this document applies to any platform.

Symptoms

When creating a foreign voucher from procurement and there is a difference in exchange rate between the time of receipt and voucher creation, the system creates a gain/loss using DMAAI 4340.   The account for DMAAI records an unrealized gain and loss.  

When the voucher is subsequently paid and there is a difference in exchange rate between the voucher creation and the time the payment was issued, a realized gain/loss is created using AAI PG/PL.  This is a realized gain or loss.  

The two sets of AAIs do not correlate; i.e. the AAIs do not clear out. JD Edwards E1 does not provide a solution to clear out the unrealized gain/loss created by DMAAI 4340.

If the account associated with DMAAI 4340 is for unrealized gains/loss, the amount stays in the account forever.
If the account associated with DMAAI 4340 is for realized gains/loss, the amount is still unrealized to an account that is called "realized".

Once the voucher is paid, all variances are realized but the amount in the unrealized account never clears from that account.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms