Former Member

How to calculate net price based on customized formula

Hi all expert,

I have a requirement in a rental process:

The price of a rental is defined as daily rate (e.g. 100/day) and monthly rate (e.g. 2500/month).

when I create a rental contract, I'd like SAP to calculate net price based on contract duration with both rate and use the lower one.

e.g. rental 5 days. use daily rate = 500; monthly rate = 2500; So use 500.

e.g. rental >=26 days. use daily rate >= 2600; monthly rate = 2500; So use monthly rate 2500.

I was think to use price condition scales to set:

1 - 25 days: 100/day

>=26 days: 2500/month

But the problem is there are 30day a month and 31 days a month. When the contract has to calculate partial month, daily rate has to be calculated as monthly rate/actual days in the month.

How to handle it?

10|10000 characters needed characters exceeded

Related questions

Former Member
Posted on Nov 08, 2012 at 02:23 PM

We decided to create ABAP procedure to do the calculation, together to solve some other billing issues.

10|10000 characters needed characters exceeded
• Posted on Oct 19, 2012 at 05:03 PM

There might be more than one method to resolve the requirement.

You can develop a routine in t.code VOFM and add it in the column AltCTy. The logic in the routine can be if the netvalue exceeds 2500, then the net value should be 2500.

The second option is you can try with using standard. In VK12, after maintaining the pricing as 100/day, go to details. Then in upper limit add value as 2500. Then create a test sales order for 25 days and more than 25 days, then check the values. I think this can help with your scenario.

Regards,

10|10000 characters needed characters exceeded
• Former Member

Hi Shiva,