Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 4:00 pm
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: calledrate dropped from cc_call table
PostPosted: Tue Jan 18, 2011 10:24 pm 
Offline

Joined: Tue Jan 18, 2011 10:17 pm
Posts: 1
We are planning to move from A2Billing 1.3.3 to 1.7.1.
In the UPDATE-a2billing-v1.3.4-to-v1.4.0.sql script, the calledrate is dropped from the cc_call record.
ALTER TABLE cc_call DROP calledrate, DROP buyrate;
It looks like A2Billing now uses the rateinitial from the associated cc_ratecard to get the sell rate for the CDRs.

Currently we update the rateinitial value in the ratecard when our sell rates change. We also delete unused ratecards when they are no longer applicable.

When we move to 1.7.1 the old CDRs would then not show the rateinitial that was in effect at the time of the call if the rateinitial value
was updated or the associated ratecard was deleted.

We'd appreciate any recommendations on what we should be doing to ensure we show the sell rates that were in effect at the time of the call.

When we change sell rates, instead of modifying the existing ratecard should we create a new ratecard with the updated values so the rateinitial history is retained
in the old ratecard? Instead of deleting unused ratecards do we need to keep these ratecards for history?

Thanks for any suggestions!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group