E1: 43: PO Entry (P4310) Does Not Use 7 Decimal Exchange Rate to Calculate Large Domestic Amounts
(Doc ID 2962981.1)
Last updated on JULY 21, 2023
Applies to:
JD Edwards EnterpriseOne Procurement and Subcontract Management  Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
PO Entry (P4310) does not use 7 decimal exchange rate to calculate large domestic amounts.
Steps to Duplicate
 The Currency Exchange Rate field (CRR) has 7 decimal places in the PO Detail (F4311) table.
 The Dictionary Item CRR has 7 File Decimals.
 Set Currency Exchange Rates (P0015A) for USD to AUD using all 7 decimal places.
 Multiplier Rate is 1.4692918 AUD per USD.
 Divisor Exchange Rate is 0.6806000.
 Create a Purchase Requisition (P4310) with an Amount that is 7 digits to the left of the decimal (in millions).
 Enter AUD Currency Branch Plant.
 Enter USD Currency Supplier.
 Quantity Ordered 500,000.00.
 Unit Cost 2.0000 (USD) – four decimals.
 Extended Cost = 1,000,000.00 – seven digits to the left of the decimal.
 Review Requisition Header Inquiry.
 USD Foreign Amount = 1,000,000.00
 AUD Domestic Amount = 1,469,300.00 (exchange rate was rounded up to 1.4693)
 Using Calculator with Multiplier Rate Domestic Amount is 1,469,291.80 (1,000,000.00 x 1.4692918)
 AUD Amount Difference due to rounding = 8.20
 Using Calculator with Divisor Rate Amount is 1,469,291.801351748 (1,000,000.00 / 0.6806000)
 AUD Amount Difference due to rounding still 8.20
Exchange Rate has 7 Digits to the Right of The Decimal 1.4692918.
In Purchase Order Domestic Amount is calculated with Exchange rate Rounded to 4 Digits to the Right of the Decimal.
Using Calculator with Multiplier Rate Domestic Amount should be 1,469,291.80 (1,000,000.00 x 1.4692918).
Using Calculator with Divisor Rate Amount is 1,469,291.801351748 (1,000,000.00 / 0.6806000)
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 