Hello Experts,
I am currently working on credit memo
for rental contract; need your help for calculating credit value.
Scenario as below
1.Customer gets bill in
advance
2.Customer returns or
terminates contract in middle of billing plan which is already billed.
We can use following example -
Contracts have different billing
cycles and pricing conditions
- 1.Daily - 135.00
- 2.Weekly – 345.00
- 3.4 week – 850.00
- 4.Monthly – 850.00
As of now contract have 4 week
billing cycle and so 4 week condition type is active in contract
Let’s say Last billing cycle was from
04/07/2017 to 05/04/2017 – Billing completed
Then terminated contract on
04/20/2017
With standard SAP credit memo,
Customer should get pro-rated credit but clients do it differently.
Client’s expectations -
- a.If the contract was terminated on 4/20 than the customer had the
equipment for 14 days. The customer was already invoiced $850 for the month.
- b.The weekly rate on this contract is $345. The customer had the
equipment for 2 weeks. (14 days) $345 x 2 = $690
- c.Since the best rate for the customer would have been $690 versus
$850 – the customer would receive a credit amount of $160.00
Please advice, how we can achieve
this.
