Condition exclusion

[Former Member]

Hi,

1.How do I use condition exclusion indicator &At what level is the condition exclusion indicator used?

2..What fields in the customer and the material master decide whether they are liable for tax or not?

[Former Member · Accepted solution]

Hi

<b>MLAN Tax data material master

KNVI Customer master tax indicator</b>

Condition Exclusion

Use

I In pricing for sales and billing documents, more than one condition record may apply to a particular item at any one time. You can use the condition exclusion process to compare possible conditions in order to determine such things as the best price for a customer.

The Condition Exclusion Procedure

First of all, you create exclusion groups. An exclusion group is a list of condition types that is identified by a three-digit number. Exclusion groups are defined in Customizing for Sales. You also assign exclusion groups to a pricing procedure and to determine how the condition exclusion is to be carried out.

You then assign the exclusion groups to a pricing procedure, thus defining the condition exclusion.

Depending on how you configure exclusion groups in the pricing procedure, the system can use condition exclusion to select the best price or discount in six different ways:

Selecting the best condition record of a particular condition type from within one exclusion group

Selecting the most unsuitable condition from within one exclusion group

Selecting the best condition record for a condition type

Selecting the most unsuitable condition record for a condition type

Selecting the best conditions from different exclusion groups

Excluding all condition types in the second exclusion group if a particular condition type in the first exclusion group exists in the document

Determining Best Price From Condition Types

During automatic pricing for a sales order item, the system may find a number of valid condition records that apply to the same item. If the competing condition records belong to a variety of condition types, the system selects the record with the best price and excludes the other condition records. Condition records that the system ignores are not deleted from the sales order but are simply deactivated. You can still see the excluded condition records on the pricing screen in the sales order.

In condition exclusion in the standard system, a condition record with a zero value is not taken into consideration. It is treated as though it doesn’t exist.

If you want to take a zero value into consideration, enter the standard calculation formula 038 in the pricing procedure for one of the conditions to be compared.

The following is an example of a situation where a zero value should be taken into consideration:

A company has two condition types in the pricing procedure for surcharges. A condition exclusion group with these two condition types has been defined and shows that the lower of the two should be applied. In some cases the surcharge could be zero. The reason for this may be a condition record found or a manual entry. In order that the system takes zero into consideration as the lowest surcharge for the customer, the formula ‘38’ must be assigned to one of the condition types in the pricing procedure.

Determining Best Price Within One Condition Type

If the access sequence for a particular condition type does not specify exclusive accesses, it is possible for the competing condition records to exist within the same condition type. For example, the system may find two valid condition records for a material discount (K004) - one a material discount, the other a customer-specific material discount. The system determines the record with the most favorable discount for the customer.

If the Exclusive access indicator is set, the system looks no further after it finds the first valid condition record. In this case, the system cannot determine a best price.

Determining Best Price from Different Exclusion Groups

This method allows the system to check between exclusion groups for the most favorable price or discount. In this case, the system totals the condition values for each group, compares them, then selects the most advantageous group for the customer.

Excluding the Conditions in an Exclusion Group

In the fourth alternative when the system selects one particular condition type that exists in the first exclusion group, it excludes all the conditions in the second exclusion group from pricing.

After you have defined the exclusion groups you want to use, you can enter them in the pricing procedure. The following example shows how exclusion groups can be used in the pricing procedure. In this case, the exclusion procedure selected is the best condition type within one exclusion group.

<b>Tax field in mm sales plat tab and billing in cust mast</b>

Message was edited by:

SHESAGIRI.G

Message was edited by:

SHESAGIRI.G

[bcrao]

1.conditions can be linked to req in pric proc, a req can evaluate the ondition exclusion indicator and ignore the condition if indicato is set.

condition exclusion indicator can be set in con record or cond type.

This is called excluding condition. not condition eclusion(which means determining best price etc)

2.tax classification from cu mas and mat ast

tax det; tax classifiation from cu mast, mat mast,country of plant(shiipiing point),country of ship to party

[Former Member]

Hi,

In order to exclude a particular condition type durung pricing, we use condition exclusion. It can be set at two places: In Condition type (V/06) and for a particular condition record of a condition type.

Note: Condition exclusion also exclude condition types which are same "requirement"

2. Go to CMR (Sales Area Button > Billing Tab) and MMR (Sales org 1 tab)

Hope it answrs your query

Reward if so

Regards

SD