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?
eg:
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' => [
'1930'
]
};
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 :-)
Ian
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: [email protected]
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
---
This email has been checked for viruses by AVG.
https://www.avg.com
--
Ian Bays
Director, PTFS Europe Limited
Content Management and Library Solutions
+44 (0) 7774 995297 (mobile)
skype: ian.bays
email: [email protected]
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
