Pricing item 20 based on material of item 10 - can this work?

[Former Member]

I want to determine a price for line item 20 based on the material# of line item 10.

If item 10 material = 123 and

item 20 material = abc,

item 20 price = $100 and because item 10 material = 123, discount = 10%.

How can I do this? I'm willing to create a field for the communication structure, but I don't know how it would work.

Thanks for any help!

[Former Member · Accepted solution]

Hi - In order to solve this require 2 steps need to be carried out:

1 - We need to create a routine for Alternative Base Value in the pricing procedure assign it to the condition type that you have created.

2 - You need to also use the higher level item feature in your contract/order to specify which item you will be using as the basis for your discount calculation.

**Alt Calculation type may not help you. Alt Basetype for Calculation is the key to solving this

Regards

Siddharth

<< Moderator message - Point begging removed >>

Edited by: Rob Burbank on Nov 26, 2010 3:05 PM

[former_member217082]

Hi

While maintaining the condition record for the Line Item 10 and Line Item 20 then you need to maintain a new sub-routine and in that sub-routine you need to give the inputs that Line Item 20 should calculate price based on Line Item 10 Then you may meet your requirement

Second option is you need to include the logic in the Alternate calc key and maintain for the condition type in your pricing procedure

Thanks and Regards

Srinath

[Former Member]

Hello,

I anticipate your item 10 price should be of 111 $. you can do this by applying calculation rule in the pricing procedure for the basic condition type.

i am not sure you also can use the user exits for this requirement. because if you are using automated pricing i think you have to use user exit for such specific material.

Please update what way you have did.

Gajanan

Edited by: Gajanan Rudrakanthwar on Nov 3, 2010 1:28 PM

[former_member274400]

Hello,

It means your actual price for material ABC is something around $110 but after discount because of material 123, its price is 100. Do you want to show as 100 and 10 or you want to show directly as 100?

I think you can achive this by writing routine for alternate calculation type to calculate value

Try this...

Regards,

Mukul

[Former Member]

Actually, I would like for line item 20 price = $100, discount 10% because of material 123, net = $90.

I'm going to try both solutions as they sound viable. Thank you both for your input! I'll let you know how my testing goes.