Document value

[Former Member]

Hi all,

Can i make a condition to be dependent on the whole document value? for example, the item no 10 to be discounted with 5% if the document value exceeded 10,000$

Thanks

[Former Member · Accepted solution]

Yes, You can do it. Just maintained the proper requirement routine.

Thanks,

Raja

[Former Member · Accepted solution]

Can you advise which routine should be used.

Thanks

[Former Member · Accepted solution]

Hi Mostafa

I have got a solution.It is useful if the materials belong to same material pricing group (specified in the material master> sales org 2 tab).

Just try once, if it is useful.

Condition type settings

- Mark the Condition type K005 as "Group condition" in the condition type deatails screen(V/06).

- Specify "Group condition routine" as value "3".

- Change the calculation type from quantity( C ) to (B) in the "Calculation type " field.

- Change the "Scale basis" to "B"(value scale).

- Activate the "Value" and "Calculation type" check box .

- Specify value "D"(not possible process mannually) in the "Manual entries " field and save the settings.

Now, create the condition record using K005 for the 1st item and specify discount as 5%.

- Go to the scale and specify for 10,000 $ discount is 5%, so system will not give discount below 10,000 $.

- Create condition record using condition type K005 for other materials specify a scale value which is not possible to reach normally, like 99,999,99999 $, then it is discount 5%.

This is setting for group condition with varying key.

Here, total sum value of all the material (must be of same Material pricing group) is eligible for discount but the material will take the discount rate from their individual condition record.

So, once the total value will reach 10,000 $, then the 1st item only will get the discount 5%, but other item will not get any discount.

One problem is that, in the item condition of other items (except 1st item), condition type K005 will appear but with 0% discount.

But, this will serve your purpose, it works nicely.

[Former Member · Accepted solution]

Thank you so much

[Former Member · Accepted solution]

If the user enters the material that attracts the 5% discount more than once, I suspect you might have a problem in that the discount will be repeated for each of such line item.

[Former Member]

Hi,

There are two condition types AMIW and AMIZ related with the document value.

You can use them.

regards

[Former Member]

yes, you can but that will be header condition. Or you want that at each line item?