My Oracle Support Banner

E1: 45: Rounding Rules for Sales (P95701, P4071, P4072, P4210) (Doc ID 625669.1)

Last updated on MARCH 26, 2024

Applies to:

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



Rounding Rules provide the ability to perform rounding based on a user-defined set of rules when using Advanced Pricing to calculate a unit price. Users can choose to always round, to only round in certain situations, or not to round at all.

The Rounding Rules (P95701) application allows flexibility in setting up a rounding rule. For example, users may setup a rounding rule to always round up to a certain number or only round up in certain instances. A rounding rule may also be setup to always round to the nearest multiples of 10 or 100 or 1000.

In addition, the use of the Price Adjustment Details to apply the rounding rule adjustment enables the user to set up a rounding rule adjustment based on criteria such as customer, item, currency code, etc. For example, prior to the introduction of the Euro in 1999, the smallest coin in Italy was a 50 lire coin. So prices always had to be rounded to increments of 50.

The rounding of a unit price occurs as a Pricing Adjustment and is stored in Price History. The Advanced Pricing engine processes the Rounding Rule by rounding the unit price and storing the difference between the original price and the rounded price as an Add-On Amount Adjustment.

In addition to setting up user-defined Rounding Rules, the Unit Price can also be rounded at various points depending on the sequence in which the Rounding Rule Adjustment appears on the Price Adjustment Schedule. For example:

Schedule A: 10 Base Price (Adjustment)
                  20 Promotional Discount
                  30 Rounding Adjustment

In Schedule A, the Rounding Rule Adjustment is the last adjustment on the Schedule. This will cause the rounding to take place after all the adjustments have been applied and will affect the final Unit Price.

Schedule B: 10 Base Price (Adjustment)
                  20 Rounding Adjustment
                  30 Accrual Adjustment

In Schedule B, the Rounding Rule Adjustment is applied before the Accrual Adjustment. This will cause the Accrual Adjustment to be calculated based on the rounded amount


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
 Rounding Rules (P95701)
 Price Adjustment Definition (P4071)
 Price Adjustment Detail (P4072)
 Sales Order Entry (P4210)
 Sample Rounding Rules
 What You Should Know
 Frequently Asked Questions

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