E1: 42: 43: Incorrect Foreign Unit Cost on Copied and Amended Direct Ship Order with Different Exchange Rate
(Doc ID 1991151.1)
Last updated on MAY 27, 2020
Applies to:JD Edwards EnterpriseOne Sales Order Management - Version 9.1 to 9.1 [Release 9.1]
JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.
When copying and modifying a sales direct ship order, with foreign currencies on both SD and OD orders, the system is wrongly updating the Foreign Unit Cost and Domestic Unit Cost if the exchange rate changed between the old and new SD.
No manual intervention, but the same issue occurs also when the exchange rate is manually changed.
Steps to replicate:
Scenario: A company located in Europe is selling an item to a customer in US, and the item is sent to the customer by the supplier, also in US.
The customer’s currency is USD, the supplier’s currency is USD, and the selling company’s currency is EUR.
P4210 Enter a sales direct ship order in foreign currency (USD - EUR) at an earlier date. A foreign OD is also generated (USD-EUR).
Case a) Copy the SD and a New SD. The exchange rate changed between the old and new orders.
This scenario happens frequently as users prefer copying a similar order to reduce efforts. However, as the old order is created in previous period, the exchange rate is most likely not the same as current period.
Check the new SD and the old SD costs.
The New SD has the same Domestic Unit Cost with that of Old SD while Foreign Unit Cost is recalculated. This is not correct as it is expected that Foreign Unit Cost should be kept equal during COPY.
As per document: E1: 42: Direct Ship Orders (P4210/P4310/P4312) (Doc ID 625588.1)
“Managing Currency Fluctuations on Direct Ship Orders
The supplier of the direct ship item determines what the cost is of supplying the item.
If the supplier is a foreign supplier and the SD Foreign Unit Cost was manually entered based upon a price negotiation with the foreign supplier, do not run R42950 to recalculate the Foreign Unit Cost, the goal is to recalculate the Domestic Unit Cost and leave the Foreign Unit Cost alone when the currency has changed.”
Compare NEW SD and NEW OD costs.
The system keeps the same domestic unit cost on the New SD and New OD and the Foreign unit cost is different. This is not correct as it is expected for the Foreign Unit Cost from the SD and OD to match.
Case b) Change the qty on the NEW SD from 1 to 10
Compare NEW SD and REVISED SD.
The Foreign Unit Cost and Domestic UC are kept the same, while the extended amounts are multiplied by 10. This is correct.
Compare REVISED SD and REVISED OD
The REVISED SD has the same Domestic Unit Cost with REVISED OD while their Foreign Unit Costs are different. This is not good as it is expected that Foreign Unit Cost should be kept equal between SD and OD like that in COPY.
Note: The same occurs when the exchange rate is manually added on the new sales direct ship order header.
When copying a sales direct ship order and the exchange rate is different between the original and new SD order, the foreign unit cost on the old and new SD should match, while the domestic unit cost should be recalculated based on the exchange rate.
Also, when modifying the copied SD, the Foreign Unit Cost on the OD should be kept.
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