[Koha] report help - total amount writeoff

[Peel Lisa]

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


[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.p...@ritz.edu
http://www.ritz.edu - 
http://www.culinaryarts.ch

<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [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

jwag...@liblime.com 



*From:* koha-boun...@lists.katipo.co.nz [mailto:
koha-boun...@lists.katipo.co.nz] *On Behalf Of *Peel Lisa
*Sent:* Wednesday, October 19, 2011 3:08 PM
*To:* 'koha@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.p...@ritz.edu *

http://www.ritz.edu - http://www.culinaryarts.ch
<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha