30/6 price model

2006-08-31
2013-05-02
  • Lester Hurtado

    Lester Hurtado - 2006-08-31

    Hi,

    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.

    VTY,

    Lester

     
    • Trifon (An ADempiere founder)

      Hi,

      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.

      Kind Regards,
      Trifon

       
      • Lester Hurtado

        Lester Hurtado - 2006-09-01

        Hi Trifon,

          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.

        VTY,
        Lester

         
        • Trifon (An ADempiere founder)

          Hi Lester,

          >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.

          Kind regards,
          Trifon

           
    • Carlos Ruiz

      Carlos Ruiz - 2006-09-01

      Hello, what you are looking for seems like a rating/billing solution of eTom model
      http://www.tmforum.org/browse.aspx?catID=1648

      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:
      https://sourceforge.net/projects/compiere-nma
      They currently doesn't have billing module but it's announced to support it:
      https://sourceforge.net/forum/forum.php?thread_id=1451584&forum_id=479856

      Regards,

      Carlos Ruiz - globalqss
      http://globalqss.com

       
    • Lester Hurtado

      Lester Hurtado - 2006-09-04

      Re Compiere-NMA, is there a comprehensive documentation somewhere?

       
    • jetpharma

      jetpharma - 2006-09-12

      Lester,

      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.

      regards,
      deep

       

Log in to post a comment.