CDR Rerating

From Kolmisoft Wiki
Jump to navigationJump to search

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.

Usage

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

Cdrrerating image1.png

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


Also you are able su 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 timesr with same percentage value, on second time nothing will change. 0 leaves or returns initial user_billsec and/or reseller price.

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)

                +                 -                 +

       (just for Reseller User Calls)

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.

  • 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. Also Provider Billing details will be rerated
  • 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. Provider Billing details will NOT be rerated. If you choose this way for Rerating you will be redirected to second step:



Cdrrerating2.png

Here you see call stats for selected date interval. When you are sure everything is correct – press Rerate:

Cdrrerating3.png

Here you will see the Difference after Rerating.

Rerate all users

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

Testing mode

Select Tariff for User below TESTING MODE header:

Cdrtestrerating.png

...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.

Selected Tariff is used just in Icon test.pngTesting 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.

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.

However, localized destinations are used for the Rerating.
Example: 1) User dialled 001137067012345. Localization rule was applied:

Cut: 0011, Add: , Change Tariff to: Tariff B.

So this call to 001137067012345 was billed according to Tariff B rates. Localized destination number 37067012345 was saved to the database.

Now when you are re-rating, destination number 37067012345 is taken. The rule to cut 0011 and change tariff cannot be applied here.

2) User dials 37067012345. Localization rule was applied:

Cut: 3706, 3706 , Change Tariff to: Tariff B.

This call to 37067012345 was billed according to Tariff B rates. Since the destination number is not changed, Localization rules will be applied to number 37067012345 and Tariff B will be used when re-rating.



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.