My Oracle Support Banner

E1: 43/11: R11411 Doesn't Create Exchange Rate Variance Journal Entry in XA Ledger When Exchange Rate of OV and PV are different in Exchange Rate Master (P0015A) (Doc ID 2859460.1)

Last updated on MAY 09, 2022

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.

Symptoms

When there is exchange rate variance between OV and PV, no exchange rate variance journal entry is added in XA ledger.

This happens when Service/Tax Date (receipt date) of OV is later than Service/Tax Date (invoice Date) of PV in account ledger (F0911).

For example, Service/Tax Date (receipt date) of OV is 2022/05/30 and Service/Tax Date (invoice Date) of PV is 2022/05/25.

Steps:

1.Detailed Currency Setup program (P11410)

Intercompany Settlements is 2.

2.Companies program (P0010)

Domestic Currency is AUD. Set 1 to detailed currency restatement.

3.Currency Exchange Rates program (P0015A)

Currency AUD to USD

Effective Date 2022/05/20, Exchange rate is 1.3224015

Effective Date 2022/05/30, Exchange rate is 1.3271400.

4.Ledger Type Rules Setup (P0025). XA ledger currency is USD.

5.Processing option of Detailed Currency Restatement Program (R11411)/ named version RS

6.R09801 named version RS

7.Create a purchase order (P4310).

Branch/Plant is 61010 (company 00610)

Order currency is AUD

Line type is J

Extended cost is 791.00 (AUD)

Account Number is 610.1469

Request Date and GL Date is 2022/05/30

8.Receive PO (P4312). Receipt Date and GL date are 2022/05/30.

9.Run R09801/RS

OV journal entries are created in XA ledger.

10.Match Voucher (P4314)

Branch/Plant is 61010

Supplier

Invoice Date is 2022/05/25

GL Date is 2022/06/06

Currency is AUD

Note that Invoice Date is earlier than Receipt Date -2022/05/30

Click Receipt to Match exit to Form and OK button.

11.Run R09801/RS. PV journal entries are added in XA ledger.

12.Check Received Not Voucher account of OV and PV in XA ledger using Account Ledger (P09200).

1 OV and 1 PV records exist.

For OV,

Service/Tax Date is 2022/05/30. Exchange rate is 1.3271400. Amount is 596.02- (USD)

For PV,

Service/Tax Date is 2022/05/25. Exchange rate is 1.3224015. Amount is 598.15 (USD)

Ledger total is 2.13 instead of zero. This is the issue. Exchange variance journal entry with 2.13 should be created in XA ledger. And ledger total should be zero.

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!


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