[Koha] report help - total amount writeoff

[Wagner, Jane]

Try something like this:



SELECT round(Sum(accountlines.amount),2) AS 'Writeoffs Last 3 Months' FROM
accountlines WHERE accounttype = 'W' and date like
concat(date_format(LAST_DAY(now() - interval 3 month),'%Y-%m-%'))



(haven’t tested this variant, but I run similar reports for 1 month and
payments)



Jane Wagner

Senior Project Manager

LibLime, a division of PTFS

Content Management and Library Solutions

11501 Huff Court

North Bethesda, MD  20895

(301) 654-8088 x 151

jwagner at liblime.com <jwagner at ptfs.com>



*From:* koha-bounces at lists.katipo.co.nz [mailto:
koha-bounces at lists.katipo.co.nz] *On Behalf Of *Peel Lisa
*Sent:* Wednesday, October 19, 2011 3:08 PM
*To:* 'koha at lists.katipo.co.nz'
*Subject:* [Koha] report help - total amount writeoff



Hello



Report help again I am afraid!



Could anyone supply me with the SQL for a report which will show me the
amount of fines being written off at a specific library for a given period
of time (for example the last three months?)



Regards and thanks in advance



Lisa





[image: Description: Description: Description: CR_logo_POS_COULEUR b]**

* *

* *

*LISA PEEL, PGDip, MA.***

Librarian

César Ritz Colleges Switzerland

1897 Le Bouveret - Switzerland

Tel: +41 24 482 82 82 Fax: +41 24 482 82 80

E-mail: *lisa.peel at ritz.edu <hortense.hofer at ritz.edu>*

http://www.ritz.edu - http://www.culinaryarts.ch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4030 bytes
Desc: not available
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111019/25987bec/attachment.jpg>