any way to stop giving special discount to customers who are inactive

[Former Member]

dear sd gurus

        is there any way to stop giving special discount to customers who are inactive i mean if some customers not purchasing any thing from last 4 months

i mean if not buying anything from last 4 months automatically system stops giving discount ?

[former_member184555]

The requirement cannot be met with the help of Customer groups as suggested above. If you use customer group as a criteria...everyday, you should check the status of each customer (checking the invoices created on that day) and should keep changing the customer group in the customer master records.

One way of meeting your requirement is by adding a piece of code in the requirement routine assigned to the discount condition type in pricing procedure. The code in the requirement routine pulls from table VBRK, the latest invoice created for this customer and compares the billing date (or the document creation date) with the system date and decides the status of the customer as active or inactive and thereby allowing for determining the valid (discount) condition record, if exists.

If the discount condition type is manual and not automatic...you can use an userexit to check the status of the customer (as mentioned earlier) and remove the manually given discount if the customer is not considered as active.

[Former Member]

Dear Venugopala,

Greetings for the day.

Please create a Customer Group,

SPRO -> SD->Master Data ->Business Partners -> Sales -> Maintain Customer Group ( Tcode - OVS9)

Assign the Customer Group to the Customer master record, Sales Area view under the Sales tab. (T Code - XD01 / XD02)

By doing this, we can differentiate our clients, this would also helpful for the reporting purpose too.

Thanks & Regards,

Mathews Mammen

[Former Member]

Hi Akn AKN

for this setting there is no setting
you have to write a program in user exit in which u have to check if any sales order is found against that customer

for the particular time period then it a active customer otherwise it is non active customer then dont include condn type in sales order

regrads

Saurabh Gupta

[kkafoury1]

Hi,

  Kindly consider adding a requirement that checks for the creation date of the most recent sales order.

Best regards.

[Former Member]

Dear Venu

There is no such standard setting. As Rajesh has told, if you can differentiate such customers then you can create condition records accordingly.

Regards

Harish

[Former Member]

I think you can create a customer group and can club all such customer in this group and another customer group for Active customer . This you can maintain in Customer master.

Accordingly you have to create your condition record for special discounts so that it will be applicable only fro active customers.

Thanks

Rajesh