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.
It's the report, not a problem in Koha :) - you want to look at the column amountoutstanding instead.