My Oracle Support Banner

E1: 42: AP Ledger Gross Amount Wrong on Intercompany Voucher (Doc ID 2480185.1)

Last updated on FEBRUARY 04, 2019

Applies to:

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

Symptoms

Sales Update (R42800)

Loss of functionality
When Sales Update (R42800) is run on an Intercompany Sales Order, the Gross Amount of the Voucher created is calculated incorrectly. The AP Ledger (F0411) record created by Sales Update (R42800) for the Voucher 1801309 P2 shows the incorrect calculation:

Sequence of events

  1. The client entered an Intercompany Sales Order (SI) on August 16, 2018 (Julian Date 118228). The Customer and the Header Branch used CAD Currency, so there was no Currency on the SI Sales Order. The Detail Branch and USD Currency.
  2. In the Exchange Rate Table (F0015) the currency exchange rate in effect on August 16, 2018 (Julian Date 118228) was 1.314242/0.760895.
  3. The client ran Create Intercompany Orders (R4210IC) on August 21, 2018 (Julian Date 118233) Exchange Rate applied was 1.3061734/0.7655951.
  4. In the Exchange Rate Table (F0015) the currency exchange rate applied to the SL order 1.3061734/0.7655951 was in effect on August 20, 2018 (Julian Date 118232).
  5. Before running Sales Update the Version of Voucher Match has Currency Tab Option #1 (Effective Date) set to 2 (Invoice Date)
  6. The client ran Sales Update (R42800) on August 21, 2018 (Julian Date 118233).
  7. Sales Update processed the RI invoice for the SI order and the P2 Interbranch Voucher/Invoice for the Intercompany Purchase Order. Both of these Invoices had an Invoice Date of August 21, 2018 (Julian Date 118233).
  8. The AP Ledger (F0411) record created by Sales Update (R42800) for the Voucher 1801309 P2 shows the incorrect calculation:
    1. The Gross Amount is 5,699,826.00
    2. The USD to CAD Exchange Rate is 1.3061734
    3. The Foreign Currency Amount is 4,336,967
    4. Foreign Currency Amount 4,336,967 times 1.3061734 equals 5,664,830.93
    5. The Gross Amount 5,699,826.00 is wrong. It should be 5,664,830.93



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
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.