Pricing Discounts based on Quantity
Its called Lot Pricing where quantities in multiples of 20 receive a lower price. Please see my scenario below and let me know if this is possible in R12.
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 3 different orders
1