Skip to Content
avatar image
Former Member

Condition formula for condition type

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    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)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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

    Add comment
    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 02, 2013 at 04:55 AM

    go to V/06 and choose your condition type, Group Cond field and select GrpCond routine as '1' for overall document.

    hope this works out for you.

    Add comment
    10|10000 characters needed characters exceeded