group condition

[Former Member]

Dear all,

Plz help me. I want to know the use of group condition with example.

Thanks in advance.

[jpfriends079]

You can use this is feature of Group condition of a condition type to apply price or discount for a material based on common property.

For instance, you maintained a discount based condition record based on material group ( = 01 for example). You maintained scales also.

Qty Discount

1 - 10 Rs. 100.00

11 - 50 Rs. 105.00

51 - 150 Rs. 110.00 etc.

Then, you are creating a sales order for a customer with five different items with different quantities as below

ITEM 1 - 25 No's

ITEM 2 - 3 No's

ITEM 3 - 12 No's

ITEM 4 - 27 No's

ITEM 5 - 62 No's

All the material is having the material group = 01.

While calculating the discount, because of this group condition, system add the quantities of items which have material group = 01.

In the above example total quantity is = 109.

System apply a discount of Rs. 110.00 to each item irrespective of the individual quantities.

Please note if you have not activated the group condition feature, system determines the discount value based on individual item quantity which is as below.

Discount

ITEM 1 - 25 No's Rs. 105.00

ITEM 2 - 3 No's Rs. 100.00

ITEM 3 - 12 No's Rs. 105.00

ITEM 4 - 27 No's Rs. 105.00

ITEM 5 - 62 No's Rs. 115.00

To test the same on your sandbox.

1. Create 3 materials. Maintain Material Group of each item is same.

2. Activate the condition type as a group condition.

3. Create a condition record for this condition type with scales.

4. Process a sales order for a customer with these three material with different quantities.

5. Check the result.

I hope this suffice your requirement.

Thanks & Regards

JP