E1: 45: Adjustment Rounding Variance With Multi Currency (Doc ID 2077740.1)

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.

Symptoms

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.

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