E1: 42: Intercompany Triangulation Generates Wrong Cost due to Contract Exchange Rate (Doc ID 2223622.1)

Last updated on JANUARY 16, 2017

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.

Symptoms

When 3 currencies are used and contract rates are in place, the unit cost will differ between intercompany orders due to contract rates.

Steps to reproduce:
1. Enter SI order with header B/P A (base currency USD) and detail B/P B (base currency JPY) customer is in EUR
2. Enter markup 5%
3. Run shipment confirmation for the SI order
4. Run R4210IC to create intercompany SK/OK transactions
5. Unit cost SI (USD) will be converted to EUR using Contract rate, EUR amount will be the unit price in SK/OK order.
6. OK order is created, daily rate EUR-USD is used to calculate the USD unit cost.
7. Unit Cost (USD) of SI order do not match the Unit Cost (USD) of OK order, this means that InTransit account do not net to zero.

Note: Bug 17210976 changed the exchange rate logic in triangulation process. After that change, the InTransit account does not net to zero if several currencies are involved. In this case, three different currencies are being used.

Cause

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 hundreds of Community platforms