E1: 42: Extended Price Incorrect With Multi-Currency Intercompany Order (Doc ID 2138988.1)

Last updated on MAY 17, 2016

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.0 version, Sales

ACTUAL BEHAVIOR
---------------
When an SI order is entered with header company in Mexican Peso and the detail company shipping the product is US in USD and the customer is transacting in USD, the extended price on the SK order is incorrect after running R4210IC.

EXPECTED BEHAVIOR
-----------------------
The extended price on the SK order should be quantity X unit price.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) P0015A. Set up an exchange rate from USD to MXP of 19.9595.
2) P0010. Verify company 00801 exists and is set to use MXP currency.
3) P0006. Verify BU 80180102 is attached to company 00801.
4) P41001. Verify BP 80180102 exist in BP constants. If not copy BP 30 to BP 80180102.
5) P4101. Create a stock item.
6) P41026. Add item to BP 30 and BP 80180102 as follows.
 
BP 30 Cost = .8232
 
BP 30 Price = 2.0000
 
BP 80180102 cost = 13.9617
 
BP 80180102 price = 33.9190
 
7) P4210. Enter a one line intercompany order for a quantity of 20250 using BP 80180102 in the header and BP30 in the detail.
8) P4205. Confirm the order.
9) R4210IC. Run R4210IC over the order to create the SK/OK orders.
10) P4210. Inquire on the SK order and note the quantity x unit price does not equal the extended price. In this case the results are 20250 x .8232 = 16669.85 whereas it should be 20250 x .8232 = 16669.80.
11) P4310. Inquire on the OK and note the extended cost is correct. 20250 x .8232 = 16669.80.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the extended price on the SK order is incorrect.

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