How to Set Up a Modifier to Discount Lines Based on the Accumulated Ordered Quantity (Doc ID 1059506.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.

Goal

 


My Requirement is to set up a modifier to discount lines based on the accumulated ordered quantity of an item on the order.

For example, if a customer orders 3 lines of the same item that is eligible for a discount, then each line is priced based on the accumulated value of the previous qualifying line for the same product.

Volume Attribute FromVolume Attribute To Adjustment Amount (
Percent)
1 5 5 %
6 10 10 %
11 15 15 %


When this discount is applied, the accumulated values and adjustment amounts are calculated as follows:

Line No.Quantity AccumulatedValue AdjustmentAmount
1.1 3 0 5%
1.2 6 3 8.33 %
1.3 4 9 13.75 %


The accumulation value and discounts are evaluated as follows:

Solution

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