How Can One "Round Down" the Calculated Discount Amount by Capturing the SubTotal at the End of Pricing Bucket10 in a Custom Pricing Attribute That Can Then Be Rounded As Such n a Formula? (Doc ID 2401968.1)

Last updated on DECEMBER 05, 2019

Applies to:

Goal

How we can always round down the calculated discount amount by capturing the sub total at the end of pricing bucket10 in a custom pricing attribute that can be rounded as such in a formula?

Using the current functionality, we are not able to achieve the desired result. As an example consider the following scenario:

List Price: 1625
Discount: Promo PA : 350 : Amount Based Discount. - Pricing Bucket 10

Net Price after Bucket 10: 1625-350: 1275

Discount: Draft : 1% - Pricing Bucket 20

i.e. : 1275 *0.01 = 12.75 ---> This should be rounded DOWN to 12.00

Net Price after Bucket20 is 1275 - 12 : 1263

Discount: Brand Discount: 14% -- Pricing Bucket 30
Discount: Truck Allowance : 3% -- Pricing Bucket 30
i.e : 1263 * 0.14 = 176.82 ---> This should be rounded DOWN to 176.00
i.e : 1263 * 0.03 = 37.89 ---> This should be rounded DOWN to 37.00

Net Price after Bucket30 is 1263 - 176 - 37 = 1050.00

So the final unit selling price is 1050.00
 

Solution

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