E1: 45: Adjustment Rounding Variance With Multi Currency
Last updated on FEBRUARY 17, 2016
Applies to:JD Edwards EnterpriseOne Advanced Pricing - Procurement - Version 9.0 and later
Information in this document applies to any platform.
On : 9.0 version, Advanced Pricing
DESCRIPTION OF PROBLEM
In certain instances, depending on the unit cost involved, advanced pricing
creates an incorrect calculation of unit cost on a purchase order when an
adjustment type has basis code (BSCD) 2 and the adjustment includes exchange
rates. The system creates a variance of .0001. Price history shows a foreign
unit cost of .0001 additional over what the unit cost should be.
STEPS TO REPRODUCE
Note: this issue is data dependent and only happens when certain numbers are
used. Use the exact data outlined below to duplicate issue.
1. Set up an USD to GBP exchange rate with 1.55 as the Multiplier Rate
2. Set up 2 adjustments, one being an override price factor value 44.030,
basis code 5, currency code GBP and the second adjustment using basis code 2,
factor value 1, currency code USD
3. Attach the 2 adjustments to an adjustment schedule
4. Set up a foreign supplier for GBP currency code and attach the adjustment
schedule to the supplier.
5. Enter a one line purchase order
6. Go to Price History and notice The second adjustment is incorrectly
calculated at .4404. It should be .4403 because .01 x 44.030 = .4403. This
incorrect calculation results in a .0001 variance and an incorrect unit cost
on the order.
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