Uploaded image for project: 'ASTPP Community'
  1. ASTPP Community
  2. ASTPPCOM-276

Error with Debit Calculation for Durations > 4500 Seconds (v3.5)

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      Hi
      Please there is a serious billing issue with v3.5
      When Call Duration is greater than ~4500, the debit is ALWAYS == 1

      'SELECT accountid, disposition, billseconds, debit, cost FROM astpp.cdrs WHERE accountid != 0 ORDER BY billseconds DESC LIMIT 12;'
      ---------------------------------------------------------

      accountid disposition billseconds debit cost

      ---------------------------------------------------------

      8 NORMAL_CLEARING 7200 1.000000 768.000000
      8 NORMAL_CLEARING 6361 1.000000 678.510000
      8 NORMAL_CLEARING 5624 1.000000 599.890000
      8 NORMAL_CLEARING 5282 1.000000 563.410000
      8 NORMAL_CLEARING 5269 1.000000 562.030000
      8 NORMAL_CLEARING 4901 1.000000 522.770000
      8 NORMAL_CLEARING 4781 1.000000 509.970000
      10 NORMAL_CLEARING 4332 902.500000 462.080000
      8 NORMAL_CLEARING 4112 890.930000 438.610000
      10 NORMAL_CLEARING 4105 855.210000 437.870000
      8 NORMAL_CLEARING 4100 888.330000 437.330000
      8 NORMAL_CLEARING 4079 883.780000 435.090000

      ---------------------------------------------------------

        Attachments

          Activity

            People

            Assignee:
            samir.doshi Samir Doshi
            Reporter:
            sessionhub sessionhub
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: