My Oracle Support Banner

E1: 09: XA Ledger Out of Balance for Voided Transactions if Exchange Rate Changed between Date of Entry and Date of Void (F0911, R11411) (Doc ID 2821081.1)

Last updated on NOVEMBER 12, 2021

Applies to:

JD Edwards EnterpriseOne General Ledger - Version 9.2 and later
JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When Detailed Currency Restatement (R11411) is run for the void of a transaction in the following scenario, the XA ledger is out of balance:

  1. The transaction, whether it’s a journal entry (JE), an A/R invoice, or an A/P voucher, is in domestic currency and is created with a future G/L Date. For example, it’s entered on October the 15th with a G/L date of October the 31st.
  2. At the time of entry, the only exchange rate for the domestic currency to the XA ledger currency is the one with an Effective Date of October the 15th.
  3. The transaction is posted and XA ledger entries are created.
  4. On October the 31st a new exchange rate is created for the domestic currency to the XA ledger currency (as a new one is created every day with the effective date equal to that day).
  5. On the same day, the transaction is voided and the void is posted.

The AA ledger is in balance, but the XA ledger is not. This is because for the void the exchange rate of Oct. 31st is used instead of the one from the original date of entry, Oct. 15th.

 

STEPS TO REPRODUCE

  1. P0010: company currency is USD.
  2. P0025: XA ledger is EUR.
  3. BV:
    1. Set up the R11411 version.
    2. Make sure this version is automatically launched from the Post (R09801).
  4. P0015A: EUR – USD exchange rates, last effective date is 15-Oct-2021.
  5. P0911: create a JE with GL date 31-Oct-2021 in USD.
  6. R09801: post the JE.
  7. P03B11: create an invoice with GL date 31-Oct-2021 in USD.
  8. R09801: post the invoice.
  9. Check the F0911 entries created for the JE and the invoice, both AA and XA ledger.
  10. P0015A: create a new exchange rate for EUR – USD with an effective date of 31-Oct-2021.
  11. P0911: void the JE with a Void GL date of 31-Oct-2021.
  12. P03B11: void the invoice with a Void GL date of 31-Oct-2021.
  13. R09801: post the voids.
  14. Check the F0911 entries created for the JE and the invoice, both AA and XA ledger.

 

DESIRED OUTCOME

R11411 should use the exchange rate that was valid on the original date of entry.

  

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.