http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10946 Bug ID: 10946 Summary: pay fine amout showing negative value Change sponsored?: --- Product: Koha Version: 3.12 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: prajeeshb77@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Created attachment 21443 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21443&action=edit 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. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.