Hey,<br><br>It did the trick..<br>I will try to call and see  what hapeen in CDR,  Thanks!!<br clear="all"><div><br></div><div>Best Regards,<br><b>Jayesh Labade</b><br></div>
<div>e-mail: <a href="mailto:jayesh.labade@gmail.com" target="_blank">jayesh.labade@gmail.com</a></div><br>
<br><br><div class="gmail_quote">On Mon, Jan 9, 2012 at 10:07 PM, Andrew Pogrebennyk <span dir="ltr"><<a href="mailto:apogrebennyk@sipwise.com">apogrebennyk@sipwise.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
That is the problem - for some reason you have two contract_balances<br>
records with period from=2012-01-01 to=2012-01-31. It should not be<br>
possible to create such duplicates with spce, if you find a way to do<br>
that please let me know. For now just remove one record from the DB and<br>
keep the correct one.<br>
<br>
I guess the correct one has cash_balance: 5000, in that case execute<br>
mysql biling -e "delete from contract_balances where id=9;"<br>
The admin panel should display correct data after that. And you can<br>
check if the billing works as expected.<br>
<div><div class="h5"><br>
On 01/09/2012 05:31 PM, Jayesh Labade wrote:<br>
> Hello Andrew,<br>
><br>
> This is output..<br>
><br>
> *************************** 1. row ***************************<br>
>                         id: 2<br>
>                contract_id: 3<br>
>               cash_balance: 0<br>
>      cash_balance_interval: 0<br>
>          free_time_balance: 0<br>
> free_time_balance_interval: 0<br>
>                      start: 2011-12-01 00:00:00<br>
>                        end: 2011-12-31 23:59:59<br>
>                 invoice_id: NULL<br>
> *************************** 2. row ***************************<br>
>                         id: 7<br>
>                contract_id: 3<br>
>               cash_balance: 0<br>
>      cash_balance_interval: 0<br>
>          free_time_balance: 0<br>
> free_time_balance_interval: 0<br>
>                      start: 2012-01-01 00:00:00<br>
>                        end: 2012-01-31 00:00:00<br>
>                 invoice_id: NULL<br>
> *************************** 3. row ***************************<br>
>                         id: 9<br>
>                contract_id: 3<br>
>               cash_balance: 5000<br>
>      cash_balance_interval: 0<br>
>          free_time_balance: 112<br>
> free_time_balance_interval: 0<br>
>                      start: 2012-01-01 00:00:00<br>
>                        end: 2012-01-31 23:59:59<br>
>                 invoice_id: NULL<br>
><br>
><br>
> Best Regards,<br>
</div></div>> *Jayesh Labade*<br>
> e-mail: <a href="mailto:jayesh.labade@gmail.com">jayesh.labade@gmail.com</a> <mailto:<a href="mailto:jayesh.labade@gmail.com">jayesh.labade@gmail.com</a>><br>
><br>
</blockquote></div><br>