The Net Unit Price for a Sales Order Line Is Not Rounded Properly when "Summed" Price Rules Are Used
Last updated on JANUARY 02, 2018
Applies to:PeopleSoft Enterprise SCM Order Management - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
When there's a rounding rule to 2 decimals and multiple Price Rules with an Adjustment Method of 'Summed' are applied, the Net Unit Price at the Sales Order line level is not rounding correctly (navigation: Order Management, Quotes and Orders, Create/Update Order).
When a Price Rule of -18% is applied on a Price of 12.35, the Net Price is coming to 12.13
when "Summed " Price Rules -5% and -13% are applied on a Price of 12.35, the line Net Unit Price is coming to 12.12 instead of 12.13. There is an inconsistency in the rounding.
13% discount: 12.35 * .13 = 1.6055
5% discount: 12.35 * .05 = 0.6175
12.35 - (1.6055 + 0.6175) = 10.127 (rounded to 10.13 per 2 decimal rounding rule)
As per PeopleBooks, both Price Rules should be summed and then applied.
Select the method for applying the adjustment for the Discount/Surcharge and Product Add price action types.
Cascading: Applied as they are found. A second discount is applied to the previously discounted price, a third discount is applied to a price that is already discounted twice, and so on. For example, if the system encounters two discounts, such as 10 percent and 20 percent off the list price of 100 USD, then the system applies the discounts in this way: 10 percent off of 100 USD and 20 percent off of 90 USD. Thus, the unit price for the order schedule line is 72 USD.
Summed: When the system finds multiple discounts, it adds them together and applies the discount once. Thus, for the summed example, the system applies discounts in this way: the 10 percent and 20 percent discounts are combined for 30 percent off of 100 USD. The unit price for the order schedule line is 70 USD. The summed adjustments are applied to the net price with cascading adjustments already applied.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms