[Koha] SQL for overdues / fines by borrower ?

[Jonathan Druart]

Hello Scott,

You should find what you are searching for on the wiki:
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Accounting_Reports_.28Fines.2FCredits.2FEtc.29

Regards,
Jonathan

On Tue, 20 Dec 2016 at 17:57 Scott Owen <sowen at edzone.net> wrote:

> Hi all,
> One of my Liberians is asking for a fine report "by borrower" that can be
> easily printed.
>
> ie:
>
> Borrower ID (xxxxx) Last Name, First Name:
>               overdue_Item     ---- Fine
>               overdue_Item2   ---- Fine
>
> BorrowerID (xxxxx) Last Name, First Name:
>               overdue_Item3   ---- Fine
>               overdue_Item4   ---- Fine
>
>
>
> this way we don't have to use 1 sheet of paper per fine, and sometimes wind
> up giving the same patron 3 sheets of paper....
>
> Wondering if someone already has this report made (and would be willing to
> share)
>
> Thanks,
>
> -S
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>