Re: [Koha] Fines question

2019-02-01 Thread Stephen Graham
essage- From: Koha On Behalf Of Ian Bays Sent: 31 January 2019 10:41 To: koha@lists.katipo.co.nz Subject: Re: [Koha] Fines question 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 f

Re: [Koha] Fines question

2019-01-31 Thread 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 itemnum

[Koha] Fines question

2019-01-31 Thread 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 th