[Spce-user] No charges in calls history
Andrew Pogrebennyk
apogrebennyk at sipwise.com
Tue Jan 31 13:07:15 EST 2012
At first glance it looks wrong that you have two entries in the
contract_balances for overlapping intervals. I'll check it later on..
On 01/31/2012 06:39 PM, Mario Contreras wrote:
>>
>> Initially I thought from your description that the CDR does not appear
>> on the web. So it does appear but always with zero cost, right?
>
> No, it's not always zero. It's only zero when the customer has cash.
> Now, a customer has consumed the cash, and I'm trying to add 1€, but it
> doesn't seems to do anything. Look at this:
>
> mysql> select * from contract_balances;
> +--------+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
>
> | id | contract_id | cash_balance | cash_balance_interval |
> free_time_balance | free_time_balance_interval | start | end| invoice_id |
> +--------+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
>
> | 1 | 2 | 0| 0 | 0| 0| 2012-01-01 00:00:00 | 2012-01-31
> 23:59:59 |NULL |
> | 2 | 3 | 0 | 0| 0 | 0| 2012-01-01 00:00:00 | 2012-01-31
> 23:59:59 | NULL|
> | 3 | 4 | 0 | 200| 0 | 0 | 2012-01-01 00:00:00 |
> 2012-01-31 23:59:59 | NULL |
> | 4 | 4 | 100 | 100 | 0 | 0 | 2011-12-31 18:00:00 |
> 2012-01-31 17:59:59 | NULL |
> +--------+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
>
>
> The contract_id reffers to my customer account, right? I have made this
> select after I've tried to add 1€. Is this ok? (Be care with the time.
> In my country, it's 18:38 now, and I have tried to add cash after 18:00)
>> Have you
>> added the billing fees for the destination you are calling in billing
>> profile (click the shopping card icon next to profile name)? In what
>> format are the dialed number and added fees?
>
> I have only added a destination to probe the result. It's '.*' (whithout
> the commas). What do you mean whith the format of the dialed number and
> fees?
More information about the Spce-user
mailing list