Freight Conditions and Commission Rate - New Requirement

[Former Member]

Hi All,

There is new requirement about Freight condition and Commission Rate. Please see below for details:

I got the requirement lets say:

They want 3 different types of freight like 1st Freight - based on unit/qty, 2nd freight - Fixed Amount, and 3rd Freight - based on kilometer, out of this 3 any one will applicable in sale order at a time depends how they want to charge. they have existing pricing procedure.

I hope the above freight related part clear to you all.

Now the commision part:

Here they are giving commisions whatever rate decided to the commission agent, here also for commission agent they want 3 different types 1st will be Fixed Amount, 2nd will be based on percentage and 3rd will be normal way.

Please help and advice how to achieve this type of requirement.

[Former Member]

Hi,

You can use condition exclusion group for your requirment.

where you can define if one condition is

Path

SPRO>pricing procedure>Condition exsclusion.

there you find condition exclusion group

first define condition exclusion group

assigne all three conditions to the condition exclusion group

maintain condition exclusion group for the pricing procedur.

Select your pricing procedur > control data> add the condition exclusion group in exgr1 select Cpr column as B for the best condition within the condition types.

there are options like condition record from A to E.

from a to c is fevarable to customer

and from d to f are less fevarable logically only

Gajanan rudrakanthwar.

[Former Member]

Hi,

Thanks for your prompt reply ..

Can you elaborate in detail with example to understand better.

How to meet this requirement with help of condition exclusion group.

So it will help me to understand in a better way ..

[Former Member]

hi

Condition Exclusion

The system can exclude conditions so that they are not taken into account during pricing in sales documents.

Material 4711 costs 150 USD. Some customers receive a discount of 10 USD per 100 pieces.

However, a specific customer can buy the material for 100 USD. Since this is a particularly good price, the customer should not also have a discount of 10 USD per 100 pieces. Therefore, this discount is to be excluded from pricing.

To do this, you must follow two steps:

You must set a condition exclusion indicator for the price. You can do this in two ways: If you want to set the condition exclusion indicator a follows then you specify it:

- for all condition records of a condition type (e.g. with condition type PR00) when defining a condition type in SD Customizing

- for an individual condition record (e.g. only for material 4711) in the detail screen of a condition record (in the Condition exclusion field)

You must set a condition for the discount in the pricing procedure in Customizing for sales. If this condition is set, the discount is not valid if the condition exclusion indicator is set. Condition 2 is available in the standard R/3 System.

The condition exclusion indicator is not valid for condition supplements.

This means that if a condition record contains condition supplements they will be taken into account during pricing.

Condition Exclusion Group u2013

In any normal situation there could be more than one condition type in a pricing procedure offering a discount to a customer. Should the discounts be automatically determined, there is the risk that the customer will receive all the relevant discounts and thus purchase the product for a lower price than he should.

By using u2018condition exclusion groupsu2019 you can ensure that the customer does not receive all the discounts, but instead only receives the best of the available discount condition types.

Menu path u2013 IMG - Sales & Distribution - Basic functions u2013 pricing u2013 condition exclusion u2013 condition exclusion for groups of conditions (OV31).

A condition exclusion group is merely a grouping of condition types that are compared to each other during pricing and result in the exclusion of particular condition types within a group or entire groups. It is important to note that the condition types you want the system to compare must exist in the pricing procedure and must have valid condition records created for them.

If for example, a sales order is created using the pricing procedure that the exclusion group is assigned to, you can see that the condition offering the most favorable discount to the customer is represented in the pricing procedure.

For instance, condition type K007 has offered a discount of 10% off the sale price or a real value of $30, while another condition type K005 has offered a real value discount of $10. The system then takes the best discount for the customer between the two, which is K007 and makes the other discount K005 inactive. This can be seen by double clicking on the condition type K005, where you can find a entry saying u2018Inactive A condition exclusion itemu2019.

There are four possible methods of using condition exclusion groups u2013

A u2013 best condition between the condition types

B u2013 best condition within the condition types

C u2013 best condition between the two exclusion groups

D u2013 exclusive

E u2013 least favorable within the condition type

F u2013 least favorable within the two exclusion groups

Configuring u2018Condition Exclusion Groupsu2019

First step is to define a u2018condition exclusion groupu2019 by using a four character alpha numeric key.

Next step is to assign the relevant condition types to the exclusion groups such as discount condition types, freight condition types.

After completing the assignment of the condition types to the exclusion group, proceed with assigning the condition exclusion group to the relevant pricing procedure.

After selecting the pricing procedure for which you want the condition exclusion to be active, select the folder u2018Exclusionu2019 where you can assign the relevant condition exclusion procedure to the relevant condition exclusion group.

When using the condition exclusion group to find the best condition record in a condition type u2013 only use one condition type per exclusion group. The most important thing to remember here is to u201Cdeactivateu201D the Exclusive Indicator on the access sequence assigned to that condition type. Otherwise, the system will merely find the first condition record and stop searching for other records.

[Former Member]

Dear Nitin,

Question 1

They want 3 different types of freight like 1st Freight - based on unit/qty, 2nd freight - Fixed Amount, and 3rd Freight - based on kilometer, out of this 3 any one will applicable in sale order at a time depends how they want to charge. they have existing pricing procedure.

ANSWER

I feel you can achieve by standard slotion like,

FREIGHT

you add all three condition in pricing procedure like ZKF1, ZKF2 ZKF3 , you can create any nomenclature no issue

and define each conditio type as per need e.g. QTY, FIXED AMOUNT, in T.code [V/06] and create propotionate condition record

and put all condition manual , so that as per need user will user respective condition in sales order

QUESTION 2

Here they are giving commisions whatever rate decided to the commission agent, here also for commission agent they want 3 different types 1st will be Fixed Amount, 2nd will be based on percentage and 3rd will be normal way.

ANSWER

the logic is again same as mention above here also you have to define three different condition type but if you are giving commision after some time but charging to customer now so consider the effect Plus/minus positive a or negative as per your business scenario

and above all 3+3 =6 condition put into pricing procedure but manually basis so it user can use as per condition and it will work fine for sure previously i work with same kind of requirement

Thanks & Regards

Hanumant