Difference between revisions of "CDR Rerating"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(30 intermediate revisions by 8 users not shown)
Line 1: Line 1:
= Description =  
= Description =  


This function is used when you change Tariff for some customer and you want to recalculate Price for his Calls in the past. You need to select User, Period and system recalculates all Prices for all Calls in selected period for selected User. It affects balance of User and statistics will show information with new Prices.
This function is used when you change Tariff/Rate for some customer and you want to recalculate price for his Calls in the past. You need to select User, Period and system recalculates all prices for all Calls in selected period for selected User. It affects balance of User and statistics will show information with new prices.
<br><br>
<br><br>
=Usage=
=Usage=


Go to '''SETTINGS –> Billing –> CDR –> Rerating''':
Go to '''SETTINGS –> Billing –> CDR –> Rerating''':
<br><br>
 
[[Image:cdrrerating1.png]]
[[File:Mor_rerating_filters.png]]
<br><br>
 
Select date interval and User whose Calls you want to rerate. <!---This functionality is available from MOR X5---> Also you are able su set '''Ghost Time''' percent, this value will increase user_billsec and price which depends on changed user_billsec. Ghost Time will be calculated just from initial billsec,  and if you will rerate two times with same percentage value, on second time nothing will change. 0 leaves or returns initial user_billsec.
Select date interval and User (or multiple Users) whose Calls you want to rerate. You can select All Users and include calls of Reseller Users.
* <!---This functionality is available from MOR X5---> Press '''Rerate in Background(FAST)''' if you want to send Rerating task to [[Background Tasks]]. This way rerating of huge amount of Calls goes faster than SLOW method and also you do not need to wait in current page till rerating will be finished.  
 
* Press '''Rerate in GUI(SLOW)'''. The rating mechanism is the same as in MOR application but here rating is done by GUI. '''Be patient – if there are many calls – it can take some time to rerate all of them'''. If you choose this way for Rerating you will be redirected to second step:
Also you are able to set '''Ghost Time''' percent, this value will increase user_billsec and/or reseller_billsec and price which depends on changed user_billsec and/or reseller_billsec. Ghost Time will be calculated just from initial billsec,  and if you will rerate two times with same percentage value, on second time nothing will change. 0 leaves or returns initial user_billsec and/or reseller price. By default Ghost Time is applied '''before''' Tariff rounding. If you need to apply Ghost Time on top of Tariff rounding, add additional setting in /etc/mor/system.conf:
<br><br>
 
[[Image:cdrrerating2.png]]
rerating_apply_ghost_time_after_rounding = 1
<br><br>
 
Here you see call stats for selected date interval. Also you can save old data in PDF or CSV formats. When you are sure everything is correct – press '''Rerate''':
<br>
<br><br>
Table below will show which data of Calls will be affected according each selection scenario.
[[Image:cdrrerating3.png]]
<br>
<br><br>
{| class="wikitable" border="1" style="border-collapse: separate; border-spacing: 0; border-width: 1px; border-style: solid; border-color: #C0C0C0; padding: 0"
Here you will see the Difference after Rerating.
|-
<br><br>
!
! One of Admin Users
! One of Admin Resellers
! &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;All Users&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
! One of particular Reseller Users
! All Users (Reseller Users Included)
|-
| user_billsec,
user_rate,
user_price
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+
&nbsp;&nbsp;&nbsp;(just for Admin Users Calls)
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+
|-
| reseller_billsec,
reseller_rate,
reseller_price
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+
&nbsp;(for Calls of All Reseller Users)
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+
|}
'''NOTE''' If in Call of Reseller User will be used one of [[Common Use Providers]] Tariff to rerate Reseller Price will be taken form ADDONS -> Resellers -> Common use Providers. If in Call of Reseller User will be used one of Provider which belongs just to Reseller, Provider Price will be rerated by that Provider tariff.
<br> <br><!---Nuo x6 lieka tik FAST rerating ir test mode--->
 
== Rerate all users ==  
== Rerate all users ==  
<!---This functionality is available from MOR 11--->
<!---This functionality is available from MOR 11--->


Select 'All Users' from User selection to rerate all Users at once in selected period.
Select 'All Users' from User selection to rerate all Users at once in selected period.
<br><br>
== Testing mode ==
Select '''Tariff for User''' below '''TESTING MODE''' header:
<br><br>
[[Image:cdrtestrerating.png]]
<br><br>
...and press '''Test with selected Tariff (SLOW)''' to check differences of Rates for selected User. This way Rerating will not save changes to Calls/Users.
Testing mode is useful for testing "What if User had this Tariff" scenarios.
<br><br>
'''Selected Tariff is used just in [[Image:icon_test.png]]Testing mode.''' Rerating functionality rerates old Calls by Tariff set in User Settings, if you did not change Tariff for User, after rerating Calls Prices will be same as were before.
<br><br>
<br><br>
== Tariff from Localization ==
== Tariff from Localization ==


If call's prefix is in Localization Rule which has some Tariff, this Tariff is used to count call's price instead of User's Tariff.
If call's prefix is in Localization Rule which has some Tariff, this Tariff is used to count call's price instead of User's Tariff.
<br><br>
<br><br>


=Other notes=
=Other notes=
* Re-rate takes effect on User prices only. Provider price remains the same.


* Re-rate does not take into account Flat Rates and User will be charged for such Calls. Do not do rerating for such User.
* Re-rate does not take into account Flat Rates and User will be charged for such Calls. Do not do rerating for such User.
Line 51: Line 67:
* Re-rate does not work when call's DID, LCR or Owner Device is changed by Localization rules.
* Re-rate does not work when call's DID, LCR or Owner Device is changed by Localization rules.


* Re-rate does not work for Reseller Users Calls and reseller when you try to rerate the Reseller account only. You can rerate one User at a time, for example if the Reseller made Calls through his/hers account which is created by Admin.
* Re-rate will take Active Rate when Rates with [[Rate Effective From | Effective From]] are re-rated.
<br><br>
 
* Min duration, Increment and Connection Fee are also changed during Re-rating. Admin still see original duration. Rounded duration is visible under User account.
 
* Provider Billing details will be rerated.

Latest revision as of 11:34, 8 February 2024

Description

This function is used when you change Tariff/Rate for some customer and you want to recalculate price for his Calls in the past. You need to select User, Period and system recalculates all prices for all Calls in selected period for selected User. It affects balance of User and statistics will show information with new prices.

Usage

Go to SETTINGS –> Billing –> CDR –> Rerating:

Mor rerating filters.png

Select date interval and User (or multiple Users) whose Calls you want to rerate. You can select All Users and include calls of Reseller Users.

Also you are able to set Ghost Time percent, this value will increase user_billsec and/or reseller_billsec and price which depends on changed user_billsec and/or reseller_billsec. Ghost Time will be calculated just from initial billsec, and if you will rerate two times with same percentage value, on second time nothing will change. 0 leaves or returns initial user_billsec and/or reseller price. By default Ghost Time is applied before Tariff rounding. If you need to apply Ghost Time on top of Tariff rounding, add additional setting in /etc/mor/system.conf: 

rerating_apply_ghost_time_after_rounding = 1


Table below will show which data of Calls will be affected according each selection scenario.

One of Admin Users One of Admin Resellers                 All Users                 One of particular Reseller Users All Users (Reseller Users Included)
user_billsec,

user_rate, user_price

                +                 -                 +

   (just for Admin Users Calls)

                +                 +
reseller_billsec,

reseller_rate, reseller_price

                -                 +

 (for Calls of All Reseller Users)

                +                 -                 +

NOTE If in Call of Reseller User will be used one of Common Use Providers Tariff to rerate Reseller Price will be taken form ADDONS -> Resellers -> Common use Providers. If in Call of Reseller User will be used one of Provider which belongs just to Reseller, Provider Price will be rerated by that Provider tariff.

Rerate all users

Select 'All Users' from User selection to rerate all Users at once in selected period.

Tariff from Localization

If call's prefix is in Localization Rule which has some Tariff, this Tariff is used to count call's price instead of User's Tariff.



Other notes

  • Re-rate does not take into account Flat Rates and User will be charged for such Calls. Do not do rerating for such User.
  • Re-rate does not work when call's DID, LCR or Owner Device is changed by Localization rules.
  • Min duration, Increment and Connection Fee are also changed during Re-rating. Admin still see original duration. Rounded duration is visible under User account.
  • Provider Billing details will be rerated.
Retrieved from "https://wiki.kolmisoft.com/index.php?title=CDR_Rerating&oldid=29349"