Skip to Content
0
Former Member
Oct 19, 2012 at 04:30 PM

How to calculate net price based on customized formula

308 Views

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?

Thank you in advance!