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.

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

10|10000 characters needed characters exceeded

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

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

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

10|10000 characters needed characters exceeded
• Former Member
Dec 02, 2008 at 03:34 PM

closing

10|10000 characters needed characters exceeded
• Former Member
Dec 02, 2008 at 03:53 PM

Closing this thread. I am working on it,

Barbara

10|10000 characters needed characters exceeded
• 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.