Excluding a pricing condition for a customer

[Former Member]

Hi Friends

There is a special requirement of my customer.

They are charging a royalty amount for some materials. The condition records for royalty condition are maintained at the level of material.

For a specific customer, they do not want to charge the royalty.

How can this customer be excluded from being charged the royalty?

Thanks in advance

Vikas

[Lakshmipathi · Accepted solution]

One option is to add this logic to your existing routine assigned to that condition type.  The other option can be create a new condition type with Discount as Condition Class and Percentage as Calculation type.  For this, have Customer / Material combination and maintain condition record for the same with 100%.  By doing so, as and when sale orders are created for this customer, the royalty won't be debited to customer.  Of course, this is a configuration change and if there is any open sale orders for this customer, you need to foreclose those open orders and have to create new orders

G. Lakshmipathi

[Former Member · Accepted solution]

Thanks all for your help

[moazzam_ali]

Hi

Maintain a Z table with customer number. There could be more customers in future so it is better to maintain a table for it.

Write code in routine VOFM or simply in MV45AFZZ program to exclude this condition type when customer is matched with that Z table.

Thank$

[jobis]

Hi Vikas,

you have the options provided by other members which will meet your requirement.

Now you can chose which ever one you find better. If i had this requirement , i would go with the option suggested by Mukund, Create a new access with customer/material and place it as the first step in the access sequence and make it Exclusive.

By this we can avoid the ABAP work, and everytime you have a new customer to be added for this benefit, just create the condition record for him as zero value.

Thanks

Jobi

[Former Member]

Hi Vikas,

I can think off a couple of things here.

The first is, create a new table A999 for example with customer/material combination. Assign it to the same access sequence that royalty condition type has. Make the access sequence exclusive. Now, for those customer material combination you can just maintain Zero value condition record. (I believe it will not be that many condition records you have to maintain and it will also give flexibility for future if you need to add more).

The second one that i was thinking may work for you is to create a new condition type with access sequence of customer/material. Create an exclusion group and assign the new condition type and the existing royalty condition type to it. During assigning exclusion procedure, pick 'L' - "Least favorable between conditions types ". Now, for the new condition type, for the combination for customer/material, you can maintain Zero value condition record. When you create a sales order, system should consider this new condition type over the royalty. --- (I am not 100% positive about this solution as i have not tried it, but you may want to give it a shot).

Both the above may save you some development time and may be it will be easier to convince the business. 

Hope this helps.

Regards,

Mukund S

[former_member204407]

Hi Vikas Gupta,

Maintain a royalty condition record with a combination(access sequence) of customer & Material or Customer group(maintain common customer group in for those applicable customers in customer master) & Material combination for those customer you want apply royalty condition amount.

We can automatically exclude those customers if the condition record not maintained with any one of above combination.

Thanks,

Krishna.

[Former Member]

Hi Krishna

There is no point in maintaining condition records for so many customers when you just want to exclude a condition for only one customer. Business will never agree for that approach. Btw, I already mentioned in my post that condition records are already maintained at material level. We want that when order is created for that specific customer, the royalty condition is not applied.

Regards

Vikas

[former_member211462]

Dear Vikas Gupta,

As per the input you have given the condition records are already created even for this customer also.

Now when a new sales order is created for that particular customer the royalty amount is not applicabe for him.

When such a situation arrises why dont you mention in a table or a list with those customers for whom this condition type is not added with an exit or maybe a routine for that condition type.

You can maintian customers  for those whom this royalty charge is not applicable.

Regards

JNM

[Former Member]

HI,

we can achieve this through below options

1) maintain a requirement at condition record  level at pricing procedure or access sequence level to avoid triggering of the condition type for this particular customer - instead of hard coding the customer you can find a unique parameter in the customer and you can use the same in your piece of code

2) maintain a specific customer / material access sequence - as mentioned in the above posts

3) if this requirement is only for one instance then manually delete or change the value to 0$ for the condition type in the sales document ( if the condition type is having that provision in v/06)

Thank you for your time.