E1: 45: P95701 Rounding Rules - When a Unit Price Exceeds 100, the System Rounds Up Where 3rd Decimal is Less Than 5, Instead of Rounding Down (Doc ID 1996112.1)

Last updated on NOVEMBER 04, 2016

Applies to:

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

Symptoms

When a unit price exceeds 100, the system rounds up where 3rd decimal is less than 5, instead of rounding down.

P95701 Rounding Rules are set up to achieve the following:

1. When unit price < 100,00:
• Round based on 3rd decimal: >=5, add 1 to 2nd decimal.
• Set 3rd and 4th decimal to zero.

2. When unit price >= 100,00:
• Round based on 1st decimal: >=5, add 1 to 1st digit before dot.
• Set all 4 decimals to zero.


Testing the rounding rule looks OK, however when above 100,00 it ALWAYS adds ‘1’ to 1st digit before dot.
It only should do this when 1st decimal is >=5.
For example 100.4123 should be rounded to 100.00, NOT to 101.00.

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