Discount with reference to one material

[Former Member]

Hi Friends,

I have to design one scenario where following things should come,

1. If sales order is created for one material, then system should automatically calculate discount ( say 20%) on other material.

2. If customer orders a material belonging to one material group ( say ABC) then, discount ( say 20 %) on any material of material group ( say XYZ)

Please help me designing this scenario.

Thanks in advance

Shailesh

[amit_kumar100]

This message was moderated.

[Former Member]

Hi Shailesh,

No need of creating a routine for the same . Just follow the procedure mentioned below and your problem will be solved.

Use the Material group 1 & 2 available in Sales order and maintained at material master also. Lets say you have three materials A , B& C.

Now maintain the material group 1 as dependent materials

Now create condition table taking fields material no. material group 1 and sales org/DC/Div or plant if u required . but the first two fields are must.

Now maintain the condition records for material and material group 1 combination for your condition type -Discount.

So when you create a sales order and see if the system has material A and B or C or B and C both . Go to item level and enter the material group 1 dependent material for item B and C. Go to pricing condition tab and you can see discount picked up for this material.

Please post your result and feedback

Regards,

Krishna O

[Former Member]

Hi there,

1) Use the material discount K004.

2) Define a material discount for eg ZK04 with material group as a condition table a key combination. For eg Sales org / material grp as a condition table. Maintain discount 20% in the condition records for the sales org / material grp combination. Make sure that you will maintain the material grp in the material master data. So any material with that material grp will have the 20% discount.

If your requirement is that the system has to take only either of the discounts but not both, then use condition exclusion logic. Define a new condition exclusion grp & add both K004 & ZK04. In the condition exclusion procedure select the best condition in the group. So system will select the best discount within K004 & Zk04 & apply that in the pricing procedure.

Regards,

Sivanand

[Former Member]

Hi,

>1. If sales order is created for one material, then system should automatically calculate discount ( say 20%) on other material.

What do you mean by this?

Let's say customer order Mat ABC and in the same sales order, you have materials DEF and GHI. So you want to apply 20% discount to material ABC, DEF and GHI in the same sales order?

In other words, if there is a discount applicable material in the sales order, that discount percentage should apply for other materials in the sales order?

>2. If customer orders a material belonging to one material group ( say ABC) then, discount ( say 20 %) on any material of material group ( say XYZ)

Same manner if customer order material belonging to one material group ( say ABC) (Which has a discount of 20%); you want system to apply same discount for other materials (Material Groups) in the same sales order?

Please clarify.

Best regards,

Anupa

[Former Member]

Hi Anupa,

Thanks for reading the thread.

Let me clarify more on the requirement as

1. Say Customer orders Material A, then in the same order if customer orders B or C, Then the discount ( say 20%) is applicable only to B or C but not to material A. But the condition here willl be as ....only if he orders A then only the discount is applicable to B or C. otherwise not. ( means if he orders B or C then the discount (say 20%) will not be applicable to this order.

2. Similarly, customer orders any material of material group ABC, then in the same order material belonging to material group PQR or XYZ will have discount. Otherwise if the customer orders material belonging to PQR orXYZ then the discount is not applicable.

Thanks in advance

Shailesh

[Former Member]

HI,

This is very tricky, Because we are talking about the Line item level conditions. If you look at the system point, system have wait until you enter all materials to identify whether that discount should apply or not.

B'se "Customer orders Material A, then in the same order if customer orders B or C, Then the discount ( say 20%) is applicable only to B or C but not to material A." So this seems like not possible using only Requirement routines for the discount condition.

But you can do something like this. Code a requirement routine to check all those condition (But you have to find a logic, not If material B, C, etc. If that's the case, then you have to enter all those in to the routine. Try to find some other common filed in the material master to identify that, not by the material number)

And then you have to formulate a user procedure to do "Carry out new pricing" for the whole sales order after user is confirmed that sales order material entry (LI entry) is over. If he has to enter another LI again, he has to do "Carry out new pricing" again.

Why I'm saying this is, whether condition is applicable or not can be determined only after entering all LI's.

Else you can do this as well.

You can configure a status profile to have a initial status as blocked. And the to proceed (May be to create delivery) ask user to release that status. Then code a user exit to identify that status change and do "Carry out new pricing" from the back ground.

But you have to make sure that he's not going to add any more line items after that.

I'm just giving you an idea of how to tackle this. Please think through that path and try to finalize the solution for the exact requirement.

Best regards,

Anupa