Siebel Pricing: Aggregate Volume Discount article was much appreciated by readers. A reader has problem in enabling Tiered Volume Discount for an order having multiple order line items of same product . Lets look in to complete query and its resolution suggested by us.

————————————————————————————————————————————–
Query:

I was wondering is there any way to achieve a Tiered Volume discount across multiple line items.
eg:
there is a rule which says: if the customer buys 1 qty of product P1, no discount should be applied.
if he buys 2 or more, he will get 50% off on the 2nd product onwards.

This can be set up as a Tiered volume discount.
Now consider the scenario where we have 3 order lines in the same order; each order line item with product P1 and quantity 1. how can I give 50% off on the 2nd and 3rd order line using tiered volume discount?

————————————————————————————————————————————–Resolution:

The calculations may be tiered but in the Quote, you will see an average discount.
If you have the same product on 2 lines, you cannot have the first line at 100% of the price and the second line at 50% of the price. This is marketing chat, not how siebel will apply the discount.
siebel will calculate an average price for both product after the discount is applied to the 2nd product. and put that average price on lines products.
now I don’t see any technical reason that would prevent to have discount on the second line but I have many reasons not to do it.

if you want to apply a volume discount on multiple lines, you need to change the pricing workflows.

in the Dynamic Pricing Procedure workflow you first aggregate the Quantity of all identical product Id in the Quote/Order.
for this you use business service “Row Set Transformation Toolkit”, method is “Aggregate Transform”
the input arguments are mainly:
“Aggregate Type”, “Group By”, “Aggregate Field”
you put Sum, Product Id, Extended Quantity Requested respetively
plus the usual suspects (Row Set, Context…)

once you have determined the total qty of a product, you add the number to each product in the Row Set (I suggest you create a new property to store the new qty)

the row set would now look like this
 

 then you just have to modify the Pricing Procedure – Calculate Net Price worflow, specifically the step that calculate the discount:
step: Tiered Volume Discount
you update argument “In Memory Search Specification”
the value of the argument show something like [Minimum Quantity] <= {Row.Extended Quantity Requested}
change “Extended Quantity Requested” with “Aggregated Qty” and you’re done.
you may want to to price waterfall to display all applied discounts. If you do, you can push it further and create a specific message for the waterfall to indicate that a aggregate discount has applied. Since the discount now apply to multiple rows in the Row Set, you are obliged to use the Reprice All function to reprice all line items
if you use reprice, the rowset will only be created with the selected record in the line item.
so adding a new product, changing the qty does not reprice the whole Order. You must use a reprice all
My experience with this is that you can automate a reprice all when you add a new product or when you change the qty or a product but you can trigger the reprice all when you delete a product. This is a scripting limitation, nothing to do with epricer (since the record is deleted, the context of the record is lost and the row set cannot be created and siebel throw an error).

I was going to try something else, trigger the reprice all on a pre-delete event, take the row id of the deleted Order item, remove this row id from the Row set and continue with price calculation but we finally decided that we could just do a reprice all manually plus a reprice all when the order is submitted

If you are good with epricer all the above should make sense and is pretty easy to implement, although it does take some time.depending on your requirement, you may also want to consider other approaches such as aggregate discount or product promotion.

Related posts:

• Siebel Pricing: Aggregate Volume Discount
• Siebel Pricing: Volume Discount
• How To Configure Aggregate Discount In Siebel Application
• Siebel pricing – An Overview
• Siebel Pricing – Component Based Pricing || Combination of Fixed and Roll-Up Pricing
• Siebel Pricing – Component Based Pricing || Roll-Up Pricing