Discount condition on a price scaled condition

[Former Member]

Dears,

I have the following business case:

1) Material X has a scale value as follows:

From 1 KG --> 10 USD

From 10 KG --> 9 USD

From 20 KG --> 8 USD

2) Customer A has a 10% material discount on material X.

3) Now, in a sales order for customer A and material X, if the customer buys 1 KG, he'll take 10% discount:

PR00 (10 USD) - K007 ( 10%) = 9 USD.

And this is acceptable.

4) But, for a sales order in which the customer buys 10 KG, he'll take also 10% discount.

PR00 (9 USD) - K007 (10%) = 8.1 USD.

Which is not acceptable.

The customer can only make benefit from one promotion, either the price scale or the material discount.

How can i achieve this?

Note: Please suggest a solution without using pricing routines.

Regards,

Mouty

[ajith_kumar10]

hi

Try to write your logic in routine and assign it your discount condition type.

if the quantity is less then 10 condition value should be calculated for discount or else it should populate zero.

regards

Gopi

[Former Member]

Hi Gopi,

I requested a solution without using pricing routines.

Anyways, thanks for your input.

[Former Member]

Hi Mouty

Why don't you just remove the  10% general discount for that particular customer?

BR

Sumanth G

[Former Member]

Can't remove it, cuz its needed in some cases.

[prashant_sharma21]

Hello Mounty,

You can make two different condition for two discount.

for first point (1) Material X has a scale value) you can create condition (just suppose) K071

for second  (2) Customer A has a 10% material discount on material X.you can create another condition K072.

after that you can use condition exclusion functionality which offer best/least condition among the conditions.

Thanks,

Prashant Sharma

[Former Member]

Hi Parashant,

The problem for both points is that the price scale value is stored in condition PR00.

So, if i created K071 and K072, and i created a sales order for material X with quantity 10 KG, PR00 will be 9 USD, and both conditions will deduct 10% from PR00.

[prashant_sharma21]

Hello Mounty,

Did you try to use Condition Exclusion functionality in your process ?? if not, please try and let me know.

Thanks,

Prashant Sharma

[Former Member]

Hi Parashant,

I know condition exclusion very well, and i think i got what solution you are proposing, but by logic, it wont fit my case.

[prashant_sharma21]

Hello Mounty,

As much as I can understand you requirement.. you want to give one of the discount to your customer either Material discount [10% dicount (PR00 10 - 10% of 10) = 9 USD] OR Customer material discount [PR00 (10 USD) - K007 (10%) = 9 USD] BUT both should not work together [PR00 (9 USD) - K007 (10%) = 8.1 USD.]

Instead of giving the scale at PR00 I think you can give discount

PR00 = 1 KG = 10 USD

K004 = 1 KG = 10 % Discount

K005 =  1 KG = 10% Discount

I strong believe using through the condition exclusion you can achieve it ...

Kindly dive the material discount inscale in K004 instead of giving the scale in PR00.

Are you getting any error/ issue while using condition exclusion??

Follow it it will work.

Thanks,

Prashant Sharma

[Former Member]

you want to give one of the discount to your customer either Material discount [10% dicount (PR00 10 - 10% of 10) = 9 USD]

This case is under condition scale, not 10% discount:

It is as follow in PR00:

From 1 KG = 10 USD

From 10  KG = 9 USD

So, If scale is available, and the customer bought 10 KG, the schema will be as follows:

PR00 = 9 USD (PR00 condition scale)

K007 = 10%

Total = 8.1 USD.