I retract my last statements about a2billing not having true least cost routing. If rates are not entered correctly no telecom program can automatically determine every factor and always make the best choice in routing calls. There too many variables and what is right for one user might not be right for another. I spent several hours trying to rework the sql statement a2billing uses to make improvement in the least cost routing area and finally come to the conclusion it’s not possible to cover all the possible scenarios.
The bottom line is your rate-data has to be entered correctly regardless of what type least cost routing software one might be using. I spoke too soon without first doing a little research. Trying to cover too many possible scenarios could and most likely would greatly reduce performance such as speed and this is aside from the fact it still wouldn’t be right for everyone or every situation.
Attached is a tool that can help modify your rate-decks rates so they can be organized properly for the least cost routing to work. It consists of sql statements and some code for mysql triggers. It’s not the best written code or easiest to use and might not fit all everyone’s needs but for the most part it can be a real time saver for many common rate-deck issues
I accidently posted it on the wrong part of the forums and not going to repost it again here other than to attach a file. To read more about it go to. viewtopic.php?f=4&t=6892