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.
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.
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.
OV journal entries are created in XA ledger.
10.Match Voucher (P4314)
Branch/Plant is 61010
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.
Service/Tax Date is 2022/05/30. Exchange rate is 1.3271400. Amount is 596.02- (USD)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!