Quantity Discount for material on scale basis

[prakash_parikh]

Hi Experts,

Our customers are given material discount based on quantity scale. e.g. M001 material 2% discount for 10Pcs and 4% discount for 20Pcs. Now customer place order within one month separately 10, 15, 15 Pcs each time with delivery schedule in one month. As total quantity is 40Pcs we want that each order say for 10Pcs should get 4% instead of 2% which is appearing on sales order. How to configure this in each sales order?

Note that in one order we can not place 40Pcs and give different schedule lines. As customer is not sure how much quantity will be placed each month.

So automatically how 4% discount should be applicable/configured? Rebate is not applicable so this suggetion is ruled out by the client.

I shall appreciate early response for solution.

Thanks

Prakash

[prakash_parikh · Accepted solution]

Hi Reddy,

Thanks for inputs. But it did not work. I had earlier tried but can not work.

My requirement is each line item may be 10PCs 20Pcs or 4Pcs but since Total quantity of aales order is more than 20Pcs so each line item should get 4% discount irrespective of each line item quantity.

If I give scale ot PR00 it works 2% discount for first line item for 10Pcs Second item 20Pcs so will give 4% discount. Client wants 4% to first item for 10Pcs as Total quantity reached >20Pcs. Hope you understand well &check on the system how to configured. Appreciate your answer.

Thanks

[jpfriends079 · Accepted solution]

If your using REBATE functionality for your requirement, then you can achieve this with standard configuration.

Else, use a scale formula routine to calculate and update cumulative base value for discount condition type.

Further you don't have any standard routine for this. So, need to create a new routine.

Regards

JP

[prakash_parikh · Accepted solution]

Hello Jyoti Prakash,

Many thanks for understanding & solution. I checked with ABAPer to write new routine based on scale to have cummulative calculation. K004 is marked with Update and test the data. Its now picking Total quantity if material is same and giving 4% discounts even though line item is less quantity then 20Pcs. It works well. thanks a TON for so speedy solution. I have rewarded points. Just check If not rewarded let me know.

Best regards

Prakash Parikh

[Former Member · Accepted solution]

This message was moderated.

[former_member1229123]

Hi ,

As you can maintain scales for material discount k004 while maintaining condition records itself (VK11) or otherwise If you want to decrease price of material for every purchase instead of using discount you can maintain scales in VK11 (PR00).

As per your requirement when customer raises sales order customer will get 2% discount up to 10 materials only . when he place order for 15 items he will get nothing (0%).When customer place order for 20 items he will get 4% discount.There is no need to give discounts separately, when customer raise a sales order automatically discounts are processed.

If your requirement is to provide discounts for those sales transactions you have to change the scales which you have maintained earlier.

Thank you,

pranay

[prakash_parikh]

Hi Experts,

Further in one scenerio, client placed order for monthly for 60Pcs but having 5 schedule lines in the same order.

Now we have 5 line items in one order which is not equal to 20Pcs.

So each line item is getting only 2% discount. So how to put logic so that each item is getting 4% discouont to each line item considering total quantity in sales order.

Thanks