[Koha] fines list is not generated

Nicole Engard nicole.engard at liblime.com
Wed Apr 1 00:04:03 NZDT 2009


I'm not sure how to help with that - maybe someone else on the list has an idea.

---

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 Sat, Mar 28, 2009 at 2:58 AM, jksamyal <jksamyal at gmail.com> wrote:
> Thanks very much nicole, its working now..
>
> One more problem is there.
> While working in Koha, it automatically comes out of login and i have
> to log on again.
>
> please guide me further...
>
> Jatinder kumar
>
>
>
> On Fri, Mar 27, 2009 at 3:57 PM, Nicole Engard
> <nicole.engard at liblime.com> wrote:
>> 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
>>>
>>
>


More information about the Koha mailing list