[Koha] Report for Fine collection in date ranges

[Prajeesh]

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/.