Former Member

### Hi

I need help to create a Condition formula for alternative calculation type in my sales order, I want to link to my condition price a formula:

The aim of the formula is to give a price accordind the global quantity  of the sales order, for instance :

I have several times the sames material :

Line 10      MATERIAL X               QTY 50000

Line 20      MATERIAL X               QTY 10000

The price must be calculated according the quantity global  and the scale of the condition time :

Material X  0 to 60 0000 the price is 1000£

So the price of my sales order must be 1000£

Any body could help me to do this formula?

Thanks a lot

Regards

Kari

10|10000 characters needed characters exceeded

Former Member
Jul 01, 2013 at 05:26 PM

Hi Just adding screenshot on what santosh has said above,

go to V/06 and choose your condition type, also you need to tick Group Cond field.

1.JPG (16.2 kB)
10|10000 characters needed characters exceeded
• Former Member
Jul 01, 2013 at 02:25 PM

Hi,

One doubt about global quantity, what does it mean?

Well let me give you a hint which may help you in solving this. Write a routine which would sum up all the quantities in an order with the same material number before deciding the price or scale. This logic would help to solve your problem.

Regards,

Jaydeep

10|10000 characters needed characters exceeded
• Former Member Former Member

Hi Elmka,

I guess you need to just replace MATNR in place of KONDM in my previous reply. So system will check each and every line item with MATNR which is a material number, and if it find the same number it will accumulate before calculating final price or scale. So please follow my previous reply, write a routine, assign it to condition type, since you are assigning to your condition type i dont think you need to assign in to pricing procedure, you can give a try.

Let me know if it works for you.

Thanks,

Jay

• Jul 01, 2013 at 02:01 PM

Hi,

for your condition type, check the group condition in the V/06 condition types configuration and try

maintain the scales accordingly

with group condition, your  quantity will be cummulated for your condition type

check and revert

regards,

santosh