Skip to Content
Author's profile photo Maruti Shingade

Condition Exclusion Functionality

Business Scenario:

As per the business strategy most companies offer discount on their products to increase sale and be competitive. Company would offer discounts due to various reasons , few of them are mentioned below.

  • Once the product reaches the growth phase and enters maturity phase, marketing department of the companies have to plan promotional activities so as to push the sales
  • Festival seasons
  • Clearance of stock during year end

Key Challenge:

Most companies offer special predefined discount based various parameters such as customer (bulk or frequent buyer), material, region etc.

So during promotional duration it is important from business end to make sure both the normal discounts and promotional discount are not being applied as that would lead to loss for the company, instead the best out of the two discount should be applied

Functional Solution:

Using the functionality of condition exclusion can be used to meet the above business requirement

Below are the two condition types for discount in our pricing procedure

1.  ZKAD: Predefined discount offered by company based on Customer/material

2. ZPAD: Sales Promotion ie promotional discount

Pricing Procedure:

Key Challenge as discussed above, both discounts should not be applied as indicated in below screenshot

To avoid the same we use condition exclusion

Condition Exclusion:

There might be a scenario’s where system determines records for more than one condition type in the pricing procedure. In order to avoid this we can set up conditions or a group of conditions to be mutually exclusive. This is called condition exclusion.

Steps to Set-up condition exclusion

  • Define Condition Exclusion Groups

IMG–>Sales and Distribution–>Basic Function–>Pricing–>Condition Exclusion–>Condition Exclusion for a Group of Conditions

  • Assign Condition types to exclusion group

IMG–>Sales And Distribution–>Basic Functions–>Pricing–>Condition Exclusion–>Condition Exclusion For A Group of Conditions –>Assign Condition Types To Exclusion Groups

Include the condition type for which you need to maintain exclusion

  • Maintain Condition Exclusion for Pricing Procedure

IMG–>Sales And Distribution–>Basic Functions–>Pricing–>Condition Exclusion–>Condition Exclusion For A Group Of Conditions–>Maintain Condition Exclusion For Pricing Procedures

Select the Pricing Procedure and click on Exclusion


  • Decide Condition Exclusion procedure as per your business requirement

Choose condition that is favorable between the condition types (options A and L)
Within a group, select the most favorable condition type. Choose option A for the best value or option L for the least value.

Choose condition that is favorable within the condition type (options B and E)
Select the most favorable (specify either the best with option B or the least with option E) condition record for a condition type, when more than one record has been determined.

Choose condition that is favorable between two exclusion groups (options C and F)
Compare and select the more favorable value between two condition exclusion groups. (e.g. Add group A and group B, compare the totals, and choose the more favorable.) Choose option C for the best value or option F for the least value.

Exclusive (D) If any one condition type from a group A has been selected, ignore all the condition types from group B.

Our case we shall select A

  • Maintain the Condition Exclusion Groups defined above

Sales Order Created to validate the result

In the above screenshot , condition records for both discount related condition types has been found, but the one which is best between the two is selected and applied and hence the discount is only Rs 20

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Alok Khanna
      Alok Khanna


      very informative and useful blog.

      one question: in your subtotal of "Total discount " how come only one condition i.e. the active one is coming .

      because of issue with exclusion is that although condition becomes inactive but the sigma in further subtotal goes wrong .As it adds both inactive and inactive conditions .

      can you share how your subtotal is not considering inactive conditions .




      Author's profile photo Balamurugan Ramamoorthy
      Balamurugan Ramamoorthy

      Simple and very useful blog. Thanks