[Koha] SQL for a report of overdue accounts.

[Fischer, Katrin]

Hi Tony, 

it should be possible to get you a report with borrower information and the total of the charges. What I am not sure about how to do it is the description of all charges grouped by the date of the first charge. I am not sure I understand well what you want to do here. 

We haven't done a report like this for our libraries yet, because most of the time overdue notices get sent out by email and there are only very few patrons without email addresses. We are using the overdue notice triggers in Koha.

The overdue_notices job has an csv and I think also an html option, maybe one of those could work for your purpose?

Hope that helps,

Katrin

-----Ursprüngliche Nachricht-----
Von: koha-bounces at lists.katipo.co.nz im Auftrag von Tony Morton
Gesendet: Di 30.10.2012 04:20
An: schnydszch; koha at lists.katipo.co.nz
Betreff: [Koha] SQL for  a report of overdue accounts.
 
Hello Fellow Koha users,

Firstly let me say I have tried the standard reports and building my own report but I can't get it to do what I want.
I need to be able to produce a report that has the Borrowers contact details, a description of all charges, total of all charges but is grouped by the date of the first charge.
With this information I can mail merge to send out letters for overdue accounts.
If you do this in a different fashion I would be interested to know (I'm willing to change).

Thank you

Tony Morton | Senior Librarian 
Waimate District Library
Waimate District Council | 125 Queen Street | PO Box 122 | Waimate 7960 | New Zealand
|: +64 3 689 0000 | DDI: +64 3 689 0071 | ?: +64 3 689 8075 | Mobile: +64 0210740867
0: tony at waimatedc.govt.nz | ?  www.waimatedc.govt.nz



______________________________________________________________________________
This email has been scrubbed for your protection by SMX.
For more information visit http://smxemail.com
______________________________________________________________________________

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha