E1: 42: Intercompany Triangulation Generates Wrong Cost due to Contract Exchange Rate
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.
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.
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