Skip to Content
avatar image
Former Member

Formula for price condition type

Hello all,

I will create a new condition type for price with tax (Price + Tax). This new condition will have a value that iis valid for period of 2 months.

I would need to create a formula (VOFM) for this new condition price but I do not know how to do that.

Please would anyone help me?

The scenery is:

First price was created (VK11) on March/1th. It will be valid until April/30th. Value of 10,00.

Second price is created (VK11) on May/1th. It will be valid until July/31th. Value of 20,00.

I need to bill my customer from April/15th until May/14th.

My customer consumed 60L of material from April/15th until April/30th (16 days) with value = 10.

And consumed more 40L from May/1th until May/14th (14 days) with value = 20.

Customer consumed

16 days x 10 = 160,00

14 days x 20 = 280,00

How to do this formula?

Does SAP have, as standard, any formula like that?

Or maybe does anyone knows/has a formula to calculate that?

Many Thanks,

Barbara

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2008 at 12:12 AM

    Hi Brabara,

    How are you calculating final price based on numer of days in a period or on the basis of the consumption.

    Thanks, Sanjeev

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Morning Sanjeev,

      The final price is based on consumption from 1 month.

      This facturation is like Eletricity Bill.

      Thanks,

      Nilza

  • avatar image
    Former Member
    Dec 02, 2008 at 03:34 PM

    Closing this thread.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2008 at 03:34 PM

    closing

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2008 at 03:53 PM

    Closing this thread. I am working on it,

    Barbara

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 03, 2008 at 04:45 AM

    Hi Barbara,

    While creating sales order in the condition tab which pricing system is picking up.

    It will be better instead of creating one condition type just create two condition type.

    It will be help full for you and what ever will be scenario will be fulfilled.

    The reason system is not picking up your old condition record is because its validity is over.

    So it will not take into consideration while carrying out pricing.

    Please do that if you want to do that.

    Regards

    Raj.

    Add comment
    10|10000 characters needed characters exceeded