Rate Table - Override

Challenge

You are a VoIP Retailer and your VoIP Wholesaler (Provider) provides you with 3 different services which you resell to your customers. They are SMS, MMS and VOICE services. Your VoIP Provider provides you with CDR files on a timely basis which you in turn use for billing your customers, however each CDR file contains CDR records for all 3 services as follows:

_{click to enlarge}

You charge your customers 3 different rates for SMS, MMS and VOICE, as follows:

You however can only assign one Rate Table to a Customer record, so you need a solution that will allow you to define 3 separate Rate Tables, one each for SMS, MMS and VOICE and allow the CDR2 Cloud system to use the applicable table depending on the type of service consumed by your customer.

Solution

You define 3 separate Rate Tables each having the same name but different Override expression as follows

When creating multiple Rate Tables for a Group you can use the Rate Table Copy feature to quickly duplicate the Rate Table but remember to change the Rates.

Lastly you will assign the Customer Rates Rate Table to you customer(s) as shown below