Hi Graham,

This may not be perfect, but do you get a reasonable match if you see which writeoff accountlines match the amount of the replacement price for the items?


select count(*) from accountlines where accounttype = 'W' and (amount = (select replacementprice from items where itemnumber = accountlines.itemnumber) OR amount = (select replacementprice from deleteditems where itemnumber = accountlines.itemnumber));

If you want a bit more precision I believe the action_logs link the writeoff accountline to the original accountline but that might take some fairly complex SQL and/or scripting.  So for example an entry in action_logs for a writeoff might include in the info field:

$VAR1 = {
          'itemnumber' => '524905',
          'manager_id' => '143623',
          'accounttype' => 'W',
          'accountno' => '17',
          'amount' => '-0.35',
          'action' => 'create_writeoff',
          'borrowernumber' => '206622',
          'accountlines_paid' => [

Which in turn points to the original accountline which indicates it is an accountline type "F".

I hope this helps. If anyone has a snappier solution please step forward :-)


On 31/01/2019 10:04, Stephen Graham wrote:
Hi All - we have two main ways of generating "fines" - overdue items or book 
replacement costs. I can see in the accountlines table that for overdue books the fines 
have an accounttype of either F or FU, and for book replacement costs it's usually L or 
LR. However, if we write off/wipe a fine the accounttype changes to W. Once this has 
happened is it possible to work out if the fine was for a book replacement or a overdue 
item? We've been asked if we can produce a report which has the total amount of all 
overdue fine wiped off in the last six months, but because all these are now set to W I 
cannot see a way of distinguishing the two different fine types. We are on 17.11.

Cheers, Stephen

Stephen Graham
Library Technology Consultant
Content and Collections Team
Library and Computing Services
University of Hertfordshire
Tel: 01707 286111
Ext: 77751
Email: s.grah...@herts.ac.uk

Koha mailing list  http://koha-community.org

This email has been checked for viruses by AVG.

Ian Bays
Director, PTFS Europe Limited
Content Management and Library Solutions
+44 (0) 7774 995297 (mobile)
skype: ian.bays
email: ian.b...@ptfs-europe.com

Koha mailing list  http://koha-community.org

Reply via email to