[Spce-user] (no subject)

[Daniel Grotti]

Hi Julian,
Please remember always to set a Subject in your email.
Regarding your issue, I'm not sure I really understand your question.
What is not working ?

Anyway, in order to get more info about billing rate, you can check your
CDR entry and there you will find the fees_id matched for that calls.
Inside billing, you can find the billing_fees table, where you can
search for your matching fees, so you can know which zone_id is
associated to that fees.


regards,



--
Daniel Grotti
VoIP Engineer


Sipwise GmbH
Europaring F15 | 2345 Brunn am Gebirge, Austria | www.sipwise.com

On 07/09/2015 04:54 PM, Julian Seifert wrote:
> I guess this might be the reason:
> 
> mysql> select * from  billing_fees 
>     -> ;
> +----+--------------------+-----------------+--------+-------------+-----------+------+------------------+----------------------+--------------------+------------------------+-------------------+-----------------------+---------------------+-------------------------+---------------+
> | id | billing_profile_id | billing_zone_id | source | destination | direction | type | onpeak_init_rate | onpeak_init_interval | onpeak_follow_rate | onpeak_follow_interval | offpeak_init_rate | offpeak_init_interval | offpeak_follow_rate | offpeak_follow_interval | use_free_time |
> +----+--------------------+-----------------+--------+-------------+-----------+------+------------------+----------------------+--------------------+------------------------+-------------------+-----------------------+---------------------+-------------------------+---------------+
> |  1 |                  1 |               1 | .      | .*          | out       | call |                0 |                  600 |                  0 |                    600 |                 0 |                   600 |                   0 |                     600 |             0 |
> |  4 |                 13 |               4 | .      | .           | out       | call |              0.5 |                   60 |                0.5 |                     60 |               0.5 |                    60 |                 0.5 |                      60 |             0 |
> +----+--------------------+-----------------+--------+-------------+-----------+------+------------------+----------------------+--------------------+------------------------+-------------------+-----------------------+---------------------+-------------------------+---------------+
> 
> there is another default rule already in place and maybe it matches "better" to the calls? 
> 
> kind regards,
> 
>   Julian
> ________________________________________
> Von: Spce-user [spce-user-bounces at lists.sipwise.com]" im Auftrag von "Julian Seifert [js at dacor.de]
> Gesendet: Donnerstag, 9. Juli 2015 16:48
> An: spce-user at lists.sipwise.com
> Betreff: [Spce-user] (no subject)
> 
> Hi again,
> 
> sorry to bother you again ;) now that our SIP-Peering is up and running we face another issue.
> Our billing rules are not being applied correctly.
> 
> we have one single rule:
> #    source desti  direction      zone
> 4         .          .         out            Default zone
> 
> (do not get distracted by the id - we had more rules earlier but
> reduced it to this single rule)
> This rule has for example "0.5" as cost for everything (on/offpeak etc.)
> 
> we created a billing-profile for our reseller (to which a test-customer
> that makes the calls belongs to) and are using tis rule in the billing profile.
> 
> When we are doing some calls and are creating the bill for the customer
> the calls and duration are listed correctly but the assignment/classification of the
> calls to the zone(s) is not working apparently?
> 
> any ideas how to fix/change this?
> 
> kind regards,
> 
>   Julian
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>