Bug 10946 - pay fine amout showing negative value
Summary: pay fine amout showing negative value
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: 3.12
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-25 13:50 UTC by Prajeesh Bhaskaran
Modified: 2015-12-03 22:00 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
pay fine negative amount (197.43 KB, image/jpeg)
2013-09-25 13:50 UTC, Prajeesh Bhaskaran
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Prajeesh Bhaskaran 2013-09-25 13:50:26 UTC
Created attachment 21443 [details]
pay fine negative amount

When paying a fine the amount tab showing (under Finetab)negative amount. when we run the report based on the follwing SQL query the result showing negative amounts.

SELECT  borrowers.cardnumber,borrowers.surname,accountlines.date,accountlines.amount FROM borrowers LEFT JOIN accountlines on (borrowers.borrowernumber=accountlines.borrowernumber)  
WHERE DATE(timestamp) BETWEEN <<Added BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> AND (accounttype='PAY')

is it the problem of Koha or in SQL query. Please help me.
Comment 1 Katrin Fischer 2015-01-06 21:21:35 UTC
It's the report, not a problem in Koha :) - you want to look at the column amountoutstanding instead.