Formula for price condition type

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Morning Sanjeev,

The final price is based on consumption from 1 month.

This facturation is like Eletricity Bill.

Thanks,

Nilza

[Former Member]

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.

[Former Member]

Closing this thread. I am working on it,

Barbara

[Former Member]

closing

[Former Member]

Closing this thread.