[ASTPPCOM-276] Error with Debit Calculation for Durations > 4500 Seconds (v3.5) Created: 03/Dec/17  Updated: 01/Apr/21  Resolved: 01/Apr/21

Status: Done
Project: ASTPP Community
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature
Reporter: sessionhub Assignee: Samir Doshi
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 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

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



 Comments   
Comment by Samir Doshi [ 04/Dec/17 ]

We do not have any condition to calculate debit value. It's purly depends
on your origination rates and duration of calls.

Provide your call log astpp.log to check the calculation which is happening
with your calls.

<https://mailtrack.io/> Sent with Mailtrack
<https://chrome.google.com/webstore/detail/mailtrack-for-gmail-inbox/ndnaehgpjlnokgebbaldlmgkapkpjkkb?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality>

<https://mailtrack.io/trace/link/25781ca25997fa2c8c94aa1292f8ea6d636c91b8?url=http%3A%2F%2F%2F&userId=1840855&signature=9ec2fe60691ebd29>Best

Regards

Samir Doshi
iNextrix Technologies Pvt. Ltd.
http://www.inextrix.com
<https://mailtrack.io/trace/link/782ff540a10e8d4b7c5b04db7da8159e31b3e1c4?url=http%3A%2F%2Fwww.inextrix.com&userId=1840855&signature=1044ed86e837198f>

Disclaimer:
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorized to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking action in reliance of the contents of this
information is strictly prohibited and may be unlawful. Please notify the
sender immediately and destroy all copies of this message and any
attachments contained in it.

On Mon, Dec 4, 2017 at 4:05 AM, sessionhub <notifications@github.com> wrote:

> 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 |
> ---------------------------------------------------------
>
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub
> <https://mailtrack.io/trace/link/ab1d5343c196d5b6730e446b7ee27efeeefd88ef?url=https%3A%2F%2Fgithub.com%2FiNextrix%2FASTPP%2Fissues%2F276&userId=1840855&signature=472604d40c1ab040>,
> or mute the thread
> <https://mailtrack.io/trace/link/3035d6b0c8fa7f7315bf1268a5a29e44fa353484?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAA6gcYfJD2tlJnBhjncn610vHNIbgdEsks5s8yIlgaJpZM4Qz7N5&userId=1840855&signature=8c434bfe362c3a68>
> .
>

Generated at Sat Feb 10 07:15:43 CET 2024 using Jira 8.13.3#813003-sha1:22ebedbb75c99b147c66f14e031dd8a2d214753a.