My Oracle Support Banner

E1: 42: Cost Variance(F43121.VARC) Is Incorrectly Calculated When Run Sales Update (R42800) for Intercompany(SK/OK) Process (Doc ID 2750099.1)

Last updated on FEBRUARY 09, 2021

Applies to:

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

Symptoms

The system did not calculate correctly the Cost Variance(F43121.VARC) when it has been modified the Exchange Rate before to run Sales Update for Intercompany process.

 

Steps:

  1. Choose an item with the following configuration: Primary UOM = EA, Secondary UOM = CA, Purchasing UOM = EA, Unit cost for branch 30 = 3.7570, -Base Price in EA = 2.4 EUR
  2. Standard UOM conversion P41003 is 1 CA = 6 EA.
  3. Set Exchange Rates P0015A : EUR ¿ USD with Divisor Rate = 1.7733289.
  4. Enter an Intercompany SI order using P4210 ZJDE0027 for the branch 70 in header and the branch 30 in line. The Quantity Ordered is 60 CA. Base currency for company of the branch 70 (header) is EUR. Base currency for company of the branch 30 (line) is USD.
  5. Currency Cod for 70 as customer(for branch 30) P03013 is USD. Also, Currency Cod for 6031 as customer(for branch 30) P03013 is EUR.
  6. Run Ship Confirm P4205 for SI order.
  7. Run R4210IC(Create Intercompany Sales Orders) and generate SK/OK orders. The OK order has Base currency = EUR and Foreign currency = USD with Exchange rate = 1.7733289.
  8. Add a new Exchange rate P0015A EUR - USD (1.7758608) before running the Sales Update for Intercompany flow. The difference between this new value and the previous Exchange rate is very small.
  9. Set Sales update R42800 in order to process the SI, SK and OK together. Also, R42800 has to call a version of R42950 (Sales Price/Cost Update) in order to update the Exchange Rate.
  10. Run Sales update R42800.
  11. Check F43121(Purchase Order Receiver File) for OK order and notice that the system generated a huge Cost Variance(VARC).

 

Cost Variance(F43121.VARC) has to be correctly calculated when it has been modified the Exchange Rate before to run Sales Update for Intercompany process.

 

Changes

 

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