Discount need to be given based on material for the fixed quantity for each customer

[Former Member]

Dear Experts,

i Have Requirement, Discount to be given based on material for the fixed quantity for each customer.

Example: Let us Consider Customer A buys - Material X  -100 Quantity  then 20% Discount will be given.He may give 100 quantity order for 1 time  or 100 times. Discount will be given up to 100 quantity.After exceeding 100 quantity if order created for the same material then system should not propose discount. I tried in vk11 when maintain condition record for the Discount condition and maintained scales. Discount will be created when created order for 100 quantity. but when created order for 1 quantity system was not giving. Can we do this in Standard or any other way is there.

Thanks in Advance

Rakesh Rahul

[Former Member]

I don't think so that your requirement will be fulfilled using only condition record.

You can do is, Don't make this condition type as Mandatory in pricing procedure, secondly with the help of ABAPer write routine / requirement and assign this new requirement to condition type in pricing.

In your requirement you should add all quantity sold to the customer and if that is less than or equal to 100 then only populate this condition type else not.

if you search (maximum quantity in SD pricing), many people had same kind of requirement and that is fulfilled by using routine / requirement only. Check post # 3394720

[srinu_s1]

As per my understanding of your requirement you can achieve this through condition update.

If you need more details please follow the below link.

thanks,

Srinu.

[Former Member]

Dear Srinu,

Thanks for the reply. Condition update will work for the first 3 orders. After that it will not work.

Regards,

Rakesh Rahul

[Former Member]

In condition update use condition base value set 100 and maximum number of order blank

It will work for your case.

Regards,

Karthikeyan R

[Former Member]

Dear Karthikeyan,

i tried in system. It is not working. i required based on Quantity not value.

Regards,

T. Naresh Babu

[Former Member]

Hi Rakesh,

In the discount condition type, use calculation type "A"-Percentage, scale basis "C"-Quantity scale and scale type "B"-to scale. Maintain condition record with the to-scale quantity as 100 units.With these settings, irrespective of whether the condition update in the condition type is checked or unchecked, the system gives a discount of 20% upto 100 units of the material. For 101 units onwards, the discount value remains blank (discount does not apply automatically based on the condition record). The discount percentage can be manually entered in the sales order, if required.

I have tried these settings out and it works.

Regards,

Sumita Mittra

[Former Member]

Hi Sumitra,

Thanks for the Reply, I have tried with your input.i maintained condition record as guided.

1.when i create order for the material 1 Quantity, system was giving Discount and saved the order.

2.when i create 2nd order for the 99 quantity system gave Discount.

3.When i create 3rd order for 100 quantity system gave Discount.

4.When i create 4th order for 101 Quantity system not proposed Discount.

But My requirement is discount to be given up to 100 quantity(regardless of the number of orders).

in the above example point No.3-whwn i create 3rd order system should should not give discount(Because it exceeded the 100 quantity in 1storder=1 quantity and 2nd order=99quantity)

Regards,

Rakesh Rahul

[Former Member]

Hi Rahul,

In addition to the settings that I already told you about, please try using the condition exclusion indicator in the discount condition record (go to VK12-scales-go to details of scales-there is an exclusion field KONP-KZNEP).

Follow the below procedure:

1) Define condition exclusion, say Z with description as Quantity>100. This setting can be done in IMG-Sales&Distribution-basic functions-pricing-Condition exclusion-Condition exclusion for condition types and records)

2) Assign the condition exclusion indicator(Z in my example) in the condition record-in the details of scales screen

3) Create a routine with this condition exclusion and assign the routine in your pricing procedure. (Make the routine customer specific. I.e. if the total quantity of the material, for the particular customer, from all sales orders is greater than 100 then exclude the condition record.).

The system should now ignore the condition record if the total quantity from all orders, for the customer is greater than 100.

I haven't tried the solution out. Please do let me know if it works.

Regards,

Sumita Mittra

[krishna_mantravadi]

Rakesh,

Here's what I understood: you have a requirement where you give a discount of 20% for up to 100 units of an item. Once the customer buys a 100 units (regardless of the number of orders he places to get to the 100 units) the system should stop issuing a discount. Is this correct?

You can carry this out with cumulative values. Within a condition record, you have a field for max. condition base value. In this field, you can specify the max number of pieces or cases/ units are allowed before the condition is made inactive. Check out this link.

Note: condition update has to be active for the condition type in question for this to work.

Krishna

[hasan_ahmed1]

Hi Rahul,

Per ur query it's understood that u wana give discount based on customer and material on scale basis.

I didn't get ur last point that is created order for 1.??

Please get back with more details So that you can get help.

Thanks

Hidayath