[Koha] Fines question

[Stephen Graham]

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