E1: 43: Incorrect Landed Cost Amounts when Exchange Rate With Address Number defined - P4312 (Doc ID 2135414.1)

Last updated on SEPTEMBER 11, 2016

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

The landed cost portion of a receipt is using default exchange rate though the exchange rate for specific contract(addr) is defined exchange rate revisions(P0015A)

The issue can be reproduced at will with the following steps:

1. Define a Supplier "9022" in Supplier Master having currency "INR"
2. Go in P0015A and set regular exchange rate ( blank contract) from EUR to INR to with multiplier rate 75.0220000
3. Go in P0015A and set contract exchange rate from EUR to INR for contract/address book number 9100003 with multiplier rate 72.0000000
4. Define the Landed Cost Rule "SUN" with two components(3 - Harbor Fee and 5 - Brokerage Fee) in the following way
3 - Percent or cost - 2%, Supplier Number is blank
5 - Percent or cost - 5%, Based on Level : 3, Supplier Number : 9022 Currency : INR
5. Create a purchase Order with Base currency "INR" and Supplier currency as "EUR"
System defaults Exchange as 75.0220000
6. Enter the order details for a qty of 3.0000 and Unit Cost : 89.9736 applying the LCR. Save the order
7. Receipt the purchase order applying the LCR
Base Cost : 89.9736
Freight : 1.7995
Import Duty : 344.2501

The correct calculation is [(89.9736+1.7995)*5%*72.0]=330.3832

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