[Spce-user] Billing Plan fallback on missing fee

Barry Flanagan barry at flanagan.ie
Thu Feb 2 10:24:47 EST 2017


On 2 February 2017 at 14:53, Oleg <spce at irg-x.net> wrote:

> Thanks for Your comment. Indeed, I too have to update 10 or 30 Billing
> Plans every time my upstream providers change rates. It's somewhat
> cumbersome to maintain and repeat same fees across all the billing plans
> all the time.
>
> Your idea with CGRates sounds interesting. Any pointers for integration
> between sipwise and cgrates?
>

We would just intend to replace rate-o-mat with a daemon to feed in the CDR
to cgrates then mark them as rated in SP. Our invoicing system then takes
in its rated CDR from cgrates instead of SP.

We have already decoupled our front-end rate management system from SP.
Instead of writing the rates directly to SP it gets written to a separate
system, which can then populate the rates in either/both SP and cgrates.

So far we have successfully exported the same rate card to both systems and
have sent sample SP CDR to cgrates and confirmed they were correctly rated.
Still a lot of work to do though.

-Barry


> Thanks.
>
> Oleg.
>
>
> On 2017-02-02 14:48, Barry Flanagan wrote:
>
>> On 2 February 2017 at 13:01, Oleg <spce at irg-x.net> wrote:
>>
>> Hello,
>>>
>>> Just wandering if there is a way to tell SPCE to fallback to an
>>> alternative billing_plan if rate-o-mat does not find a Fee in the
>>> current plan (on Customer's billing plan missing Fee, apply
>>> Reseller' billing plan fee for the given destination, if present).
>>>
>>
>> No, not possible at the moment. Pity. It would be great if you could
>> assign a "fallthrough" rate card to a customer. So, you could have
>> your standard rate card as base, and then for customer A you can  have
>> a rate card with just a few (say UK) rates. A call from this customer
>> would first check their rate card and if not found, check the
>> fallthrough one.
>>
>> This would mean that instead of having to maintain full separate rate
>> cards for every customer where there is a slight difference, you just
>> maintain the standard rates and then the smaller individual rate cards
>> per customer.
>>
>> This and the lack of multiple Free Time "buckets" are my biggest
>> gripes with SP (I am on Pro).
>>
>> We are actually investigating cgrates as an alternative rating engine
>> (we don't use the invoicing built in to SP)
>>
>> -Barry Flanagan
>>
>> Example.
>>>
>>> - 'DefaultResellerBillingPlan' contains all the destinations
>>> - 'ClientsOfferPlan' contains one destination Fee only (ex.: 5%
>>> discount calculated for fees to US
>>> '^1,on_peak_init_rate,on_peak_init_interval,...')
>>>
>>> A user with 'ClientsOfferPlan' assigned is billed through
>>> DefaultResekkerBillingPlan for all the destination (therein
>>> present), except for one Fee ('^1'), which is billed through
>>> 'ClientsOfferPlan'.
>>>
>>> In other words, I'd like sipwise to rate (and include in Invoice)
>>> 'accounting.cdr.source_reseller_cost' (if > 0) when
>>> accounting.cdr.source_customer_cost=0.
>>>
>>> Is this possible?
>>>
>>> Thank You
>>>
>>> Oleg
>>> _______________________________________________
>>> Spce-user mailing list
>>> Spce-user at lists.sipwise.com
>>> https://lists.sipwise.com/listinfo/spce-user [1]
>>>
>>
>>
>>
>> Links:
>> ------
>> [1] https://lists.sipwise.com/listinfo/spce-user
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170202/4abe5a87/attachment-0001.html>


More information about the Spce-user mailing list