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?
Last updated on MAY 22, 2018
Applies to:Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
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
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