How to Set Up a Modifier to Discount Lines Based on the Accumulated Ordered Quantity
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.
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 (|
When this discount is applied, the accumulated values and adjustment amounts are calculated as follows:
|Line No.||Quantity Accumulated||Value Adjustment||Amount|
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.
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