My Oracle Support Banner

E1: 03B: Currency Restatement (R11411) called by the Draft Post (R09801 ZJDE0020) incorrectly does not create an Exchange Rate Gain/Loss entry (Doc Type RG) for a Draft Collected batch created by A/R Draft Collection (R03B680) (Doc ID 2631591.1)

Last updated on JANUARY 23, 2020

Applies to:

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

Symptoms

Transactions are being restated to the XA ledger which has a currency code of CAD for example.

When running Draft Collection (R03B680) for a domestic currency draft (USD for example), created and remitted for a domestic currency invoice, the Post (R09801) does not create a gain/loss entry, RG doc type, if the exchange rate has changed between the draft remittance and the draft collection.

Step

USD Value

CAD Value

Exchange Rate
Used

RG Created
Y/N

Invoice

100.00

129.98

1.2997519

n/a

Draft Created

100.00

129.99

1.2999400

Yes (for 0.01)

Draft Remitted

100.00

129.99

1.2999400

n/a

Draft Closed/Collection

100.00

130.64

1.3063700

No
(R11411 should have created one for 0.65)

 

STEPS TO REPRODUCE

  1. P0000: Multi-Currency Conversion Constant set to Z.
  2. P0010 for both company 00000 and company 1: Detailed Currency Restatement constant set to Y. Domestic Currency Code is USD.
  3. P0025: Reinstatement Currency Code for XA ledger is CAD.
  4. P0015A: set up 3 different exchange rates for USD-CAD for 4-Jan-2020, 5-Jan-2020 and 17-Jan-2020.
  5. P0012: Set up AAI CR for both companies.
  6. R11411: Set processing options for Currency Restatement to create balancing JEs.
  7. R09801: Set processing options for Invoice Post and Draft Post versions to call R11411.
  8. P03B2002: Enter a $100 Domestic USD Invoice dated 04-Jan-2020.
  9. R09801: Post the invoice bath and the currency restatement batch.
  10. P03B602: Create a draft with date 5-Jan-2020.
  11. R09801: Post the draft batch and post the currency restatement batch.
  12. R03B672: Remit the draft to the bank using GL date 5-Jan-2020.
  13. R09801: Post the draft batch and post the currency restatement batch.
  14. R03B680: close the draft using GL date 17-Jan-2020.
  15. R09801: Post the draft batch and post the currency restatement batch.

 

DESIRED OUTCOME

R11411 should always create a gain/loss record if the exchange rate has changed between when a draft is remitted and collected.

 

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.