6.FINE PAID REPORT

select borrowers.cardnumber as CardNumber, concat(borrowers.firstname," ",borrowers.Surname) as Name, abs(ROUND(accountlines.amount,2)) as AmountPaid, date as ReceivedDate,

accountlines.note as "Receipt No"

from borrowers right join accountlines on borrowers.borrowernumber =accountlines.borrowernumber

where borrowers.categorycode=<<Enter category borrowers|categorycode>>

and  date(date)>=<<Enter From Date|date>> and date(date)<=<<Enter To Date|date>>

and accountlines.amount < 0 group by borrowers.borrowernumber