cancel
Showing results for 
Search instead for 
Did you mean: 

Proration of flat rate

diptarkaroy
Explorer
0 Kudos

Hello,

I'm facing the below situation:

We have a flat price maintained in the system with time category as Month ($12/month). Price operand is maintained in the Rate cat level.

A factor operand is maintained in the Installation level and LUMSUM01 is used in the rate with period control 02. 

Let's say, there is a billing period with dates 01/01/2024 to 31/01/2024. Factor value is 0 from 01/01/2024 to 10/01/2024 and factor value is 1 from 11/01/2024 to 31/01/2024. 

In this scenario, system is completely ignoring the price and customer is not charged for 20 days ($8). However, if the contract is moved in on 11/01/2024 and first bill period is valid from 11/01/2024 to 31/01/2024, then proration is happening and customer is getting charged for $8. 

Could you please suggest what change needs to be done if we want to charge the customer for $8 (proration to happen) for the 1st sceanrio?

View Entire Topic
diptarkaroy
Explorer
0 Kudos

Following

diptarkaroy
Explorer
0 Kudos

Hello @katrin_frenzel ,

I'm not sure what wrong I have done. 

My schema setup:

diptarkaroy_0-1714026728126.png

 

My operand setup (factor is maintained as 1 from 03/16/2024): 

diptarkaroy_1-1714026728191.png

 

Operand access control (All operand values selected):

diptarkaroy_2-1714026728275.png

 

Bill period (03/07 to 04/05) : Charge not appearing at all (wrong - it should have been prorated from 03/16 to 04/05)

diptarkaroy_3-1714026728484.png

 

Bill period (04/06 to 04/05) : Charge is appearing for the full period (correct)

diptarkaroy_4-1714026728201.png

 

Price key setup:

diptarkaroy_5-1714026728209.png

 

I'm not able to understand where I'm going wrong 

diptarkaroy_6-1714026727004.png

 

 

katrin_frenzel
Product and Topic Expert
Product and Topic Expert
0 Kudos
You need to maintain also the time slice with factor 0.
katrin_frenzel
Product and Topic Expert
Product and Topic Expert
0 Kudos
The variant will be only executed when values are available for complete billing period.
diptarkaroy
Explorer
0 Kudos

Hello @katrin_frenzel 

I have added the 0 factor value from 03/01 top 03/15 where the bill period start date is 03/07.

This is working now. Thanks a lot for your help. 

Marking your solution as working. 😃