[Spce-user] carrier accounting

[Skyler]

Hi,

 Funny, the answer was right in front of me this whole time. The table
decimal places are 2 in cdr, so of course it is always showing 0.00 because
the rated value is less than 1 cent.  I changed this now to 4 decimal and
now I can see the correct rated numbers in the cdr.

 ALTER TABLE accounting.cdr MODIFY carrier_cost decimal(10,4);

 I've tried the same for customer_cost and while this also shows correct
rated values, the www-admin/www-csc cdr view is still showing 0.0000 there.
Will poke around a bit and revert when I figure it out.

Skyler

On Tue, Jun 26, 2012 at 5:52 AM, Skyler <skchopperguy at gmail.com> wrote:

> Hi,
>
>  Yes, charges are in cents. 0.004 / 60 = 0.000066666667 but when the call
> is rated it shows 0.00 in cdr and 0.0000 in www-csc or www-admin.
>
> Skyler
>
>
> On Tue, Jun 26, 2012 at 4:32 AM, Vladimir Grujic <hyperbabac at gmail.com>wrote:
>
>> Hi,
>> I think charges are in cents.
>> and set interval 60 seconds for that type of destination
>>
>> Vladimir
>>
>>
>> On Tue, Jun 26, 2012 at 1:21 PM, Skyler <skchopperguy at gmail.com> wrote:
>>
>>> Hi,
>>>
>>>  Really stuck here in understanding how I can enter the carrier_cost so
>>> that it will be correctly accounted in spce.
>>>
>>> Scenario:
>>>
>>>  Carrier 'A' charges 0.004 per minute. How should I enter this into spce
>>> billing fee so that it is calculated properly? I cannot enter 0.004 / 60 as
>>> the number is not recognized by spce.
>>>
>>> Thanks,
>>> Skyler
>>>
>>> _______________________________________________
>>> Spce-user mailing list
>>> Spce-user at lists.sipwise.com
>>> http://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/20120626/85b756ad/attachment-0001.html>