How to Set Up a Modifier to Discount Lines Based on the Accumulated Ordered Quantity
(Doc ID 1059506.1)
Last updated on AUGUST 02, 2023
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 From
Volume 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 Accumulated
Value Adjustment
Amount
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:
The first line -- 1.1 -- is given a discount of 5% because an accumulation value of 0 is passed and the order quantity of 3 satisfies the range 1-5.
Line 1.2 is evaluated with starting at the accumulated value of 3. Two of the ordered quantity 6 fall within the range of 1-5 and 4 fall within the range 6-10 resulting in an 8.33% adjustment.
Line 1.3 is evaluated with a starting point of (3+6) = 9 passed by the calling application and an order quantity of 4. One of quantity 4 falls within range 6-10 and 3 fall within the range of 11-15 resulting in a 13.75% adjustment.
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!