I would like to know if I can upload call history data from a RADIUS server into Compiere. We collect call sessions in seconds and our price model is like this: the price of a call is USD0.03/sec. Minimum order is 30 seconds and in increments of 6 seconds. For example, if the call is for 10 seconds, we bill for 30 seconds worth. If the call is 33 seconds, we bill for 36 seconds. Is it possible for us to model this in Compiere? Thanks in advance.
yes, this is possible to be done. You need to write small callout which calculate proper price and will populate column price when minutes are entered into Sales Order Line. This is very interest functionality.
This "small callout" is in java and not in PL/SQL, right? I was hoping of making this price model conform to policies set out by the management. For example, what if they want to change the minimum usage to 20 seconds instead of 30 seconds, do I need to do this programmatically? I tried using the UoM combinations to no avail - maybe I just don't know how.
I'll try to do some coding first. Thanks.
>This "small callout" is in java and not in PL/SQL, right?
>I was hoping of making this price model conform to policies set out by the management. For example, what if they want to change the minimum usage to 20 seconds instead of 30 seconds, do I need to do this programmatically?
Good think is that you can program your callout to take rules for prica calculation from a table or other source and allow dynamicaly price calculation.
Hello, what you are looking for seems like a rating/billing solution of eTom model
I believe that basic functionality can be constructed not so difficult, but
take account of rating module normally becomes complicated when you require
new functionality like:
- separate night/day rates
- partitioning of calls
- holiday special rates
- special discounts for determined targets (geographically or by number)
... etc ...
There is an interesting project on the matter:
They currently doesn't have billing module but it's announced to support it:
Carlos Ruiz - globalqss
Re Compiere-NMA, is there a comprehensive documentation somewhere?
I think, what Trifon has suggested is a very good solution. You just need to create one table [window, tabs, fields] using AD, based upon what all combination of price calculation you want to do.
Add another SO Type [Call Billing]
Write one Callout and for SO Type "Call Billing" and based upon the rules specified in the table, calculate the price.
It so simple and a real beauty solution.
Log in to post a comment.