SiT! Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000576SiT!billingpublic2009-03-17 19:532009-07-30 09:47
Reporterpaulh 
Assigned Topaulh 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusassignedResolutionopen 
PlatformOSOS Version
Product Version3.45 
Target VersionFixed in Version 
Summary0000576: contract_details page balance seems out
Descriptionthe balance on contract details is out it includes:

1) Expired services
2) Seems to include some additional entires (I have a specific example, just loggging so I dont forget)
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
User avatar (0000933)
paulh (administrator)
2009-04-17 19:52

Think this is fixed - need to double check
User avatar (0001431)
paulh (administrator)
2009-07-26 19:32

CW reported an annomoly the other day thsi page showed 9 units remaining though a balance of £880 at a unit rate of £110 though the summary report correctly reported 8
User avatar (0001472)
paulh (administrator)
2009-07-30 09:47

Reproduced this:

<!-- SELECT SUM(t.amount) FROM `transactions` AS t, `service` AS s WHERE s.serviceid = t.serviceid AND s.contractid = 3094 AND t.transactionstatus = '5' -->
<!-- SELECT SUM(t.amount) FROM `transactions` AS t, `service` AS s WHERE s.serviceid = t.serviceid AND s.contractid = 3094 AND t.transactionstatus = '10' -->

<!-- CBU: SELECT * FROM `service` WHERE contractid = 3094 AND UNIX_TIMESTAMP(startdate) <= 1248943159 AND UNIX_TIMESTAMP(enddate) >= 1248943159 ORDER BY enddate DESC -->
<!-- UNIT: 32 -->
<!-- UNIT: 64 -->
<!-- UNIT: 88 -->
<!-- UNIT: 88 -->
<!-- SELECT SUM(t.amount) FROM `transactions` AS t, `service` AS s WHERE s.serviceid = t.serviceid AND s.contractid = 3094 AND t.transactionstatus = '5' -->
<!-- AP: 88 A: U:120 C:3094 -->
<!-- SELECT SUM(t.amount) FROM `transactions` AS t, `service` AS s WHERE s.serviceid = t.serviceid AND s.contractid = 3094 AND t.transactionstatus = '10' -->
<!-- IR: 66 R:-2640 U:120 C:3094 -->
<!-- UB: 66 -->


Seems to be caused by reserved monies, we ned to deduct the reserved monies per service rather than at the end as these are service specific given the charging rates

- Issue History
Date Modified Username Field Change
2009-03-17 19:53 paulh New Issue
2009-03-17 19:53 paulh Status new => assigned
2009-03-17 19:53 paulh Assigned To => paulh
2009-04-17 19:52 paulh Note Added: 0000933
2009-07-26 19:32 paulh Note Added: 0001431
2009-07-30 09:47 paulh Note Added: 0001472


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker