[Koha] Report for Fine collection in date ranges

Hi What is the problem with this Report for getting the fine collection in between date ranges. The result is showing minus amounts. Eg: -6, -5 etc. 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') Please help -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 http://kerala-lis.blogspot.com/.