Difference between revisions of "CDR Rerating"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(44 intermediate revisions by 10 users not shown)
Line 1: Line 1:
This function is used when you edited 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. 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.
= Description =


You can reach Rerating in: '''SETTINGS – Billing – CDR – Rerating''':
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>
[[Image:cdrrerating1.png]]
=Usage=


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


Select date interval and user which calls you want to rerate and press '''Proceed''':
[[File:Mor_rerating_filters.png]]


[[Image:cdrrerating2.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:


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''':
rerating_apply_ghost_time_after_rounding = 1


[[Image:cdrrerating3.png]]
<br>
Table below will show which data of Calls will be affected according each selection scenario.
<br>
{| class="wikitable" border="1" style="border-collapse: separate; border-spacing: 0; border-width: 1px; border-style: solid; border-color: #C0C0C0; padding: 0"
|-
!
! 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--->


Here you will see the Difference after Rerating.
== Rerate all users ==
<!---This functionality is available from MOR 11--->


Select 'All Users' from User selection to rerate all Users at once in selected period.
<br><br>
<br><br>
= Rerate all users =  
== Tariff from Localization ==


''This option is available starting from [[MOR_9_documentation | MOR 9]]''
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.
 
Select 'All Users' from User selection to rerate all users at once in selected period.


<br><br>
<br><br>


= Testing mode =  
=Other notes=


You can check [[Image:icon_test.png]] '''Testing mode''' and select any Tariff for 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.


This way Rerating will not save changes to calls/users.
* Re-rate does not work when call's DID, LCR or Owner Device is changed by Localization rules.


Testing mode is useful for testing "What if User had this Tariff" scenarios.
* Re-rate will take Active Rate when Rates with [[Rate Effective From | Effective From]] are re-rated.


* Min duration, Increment and Connection Fee are also changed during Re-rating. Admin still see original duration. Rounded duration is visible under User account.


<br><br>
* Provider Billing details will be rerated.
= 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.

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.