How Can One Achieve Discounts Based On Quantities In Multiples Of 20? (Doc ID 1906322.1)

Last updated on SEPTEMBER 02, 2019

Applies to:

Goal

Seeking details for how to setup Lot Pricing where quantities in multiples of 20 receive a lower price.

How Can One Achieve Discounts Based On Quantities In Multiples Of 20?

For example:

Item XYZ
Quantity 23
Total Ext Price should be (20 * $50) + (3 * $100) = $1300



Item XYZ
Quantity 49
Total Ext Price should be (40 * $50) + (9 * $100) = $2900



Item XYZ
Quantity 79
Total Ext Price should be (60 * $50) + (19 * $100) = $4900

* These could be 3 separate lines on an order or perhaps one might opt to consider lines on 3 different orders.
 

Solution

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