[Koha] Fines question

[Ian Bays]

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: s.graham4 at herts.ac.uk
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> 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: ian.bays at ptfs-europe.com