[Koha] fines list is not generated

[Nicole Engard]

Sounds like you need a custom report - I have one that gives me all
the patrons with fines and the amount of the fine:

SELECT  borrowers.cardnumber,borrowers.surname,borrowers.firstname,FORMAT(SUM(accountlines.amountoutstanding),2)
as due FROM borrowers LEFT JOIN accountlines on
(borrowers.borrowernumber=accountlines.borrowernumber)  WHERE
accountlines.amountoutstanding > 0 GROUP BY borrowers.cardnumber ORDER
BY borrowers.surname asc


---

Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at liblime.com
AIM/Y!/Skype: nengard

http://liblime.com
http://blogs.liblime.com/open-sesame/



On Thu, Mar 26, 2009 at 11:51 PM, jksamyal <jksamyal at gmail.com> wrote:
> We are using Koha 3.0 version. Now we are closing the semester and
>   exam are on. we want to generate a list of fines of defaulted
>   students.
>   Please guide me for this.
>   jatinder kumar
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>