My Oracle Support Banner

E1: 45: Detached Adjustment Totals Calculating Incorrectly Due to Rounding (Doc ID 2815887.1)

Last updated on JUNE 10, 2022

Applies to:

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


Detached price adjustments are not rounding up to the nearest 0.01 in some orders where item primary Unit of Measure is EA, but Pricing Unit of Measure is 6P (6 pieces) and the adjustment is expresses as a percentage. For example an adjustment calculated as 1% of 14.50 is calculated as 0.14 instead of being rounded up to 0.15. The result is a 0.01 rounding difference between the customer's purchase order and the E1 sales order on approximately 100 production orders per day. Accounting workarounds are needed to correct the discrepancy.

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

  1. Item Primary UOM is EA
  2. Secondary and Pricing UOM is 6P
  3. Conversion: 1 "6P" = 6 "EA"
  4. Detached Price Adjustment Definition (P4071) has Quantity Level Break selected.
  5. Base Price (P4106) is in UOM "6P" and is $2.90 per "6P" (same as 4.833333333333 per EA)
  6. Price Adjustment Detail (P4072) is Basis Code 1, Factor Value = -1% for UOM "6P"
  7. Sales Order is created as follows:
      a. Order Quantity is 5 "6P" units (60 EA)
      b. Unit Price on Sales Order is $2.90 per "6P"
      c. Extended Price on Sales Order is $14.50
      d. Detached Adjustment calculates as -1% of Extended Amount as -0.14 instead of -0.15.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.