[Koha] Forgiving all overdue fines

[Raymund Delahunty]

Hello Stephen-
We did exactly the same thing. We decided to wipe all fines (not cocts of replacements) accrued since 14th December 2019. We had PTFS Europe (our support company) do this. They ran this little SQL:
SELECT accountlines_id, date, accounttype, payment_type, amountoutstanding FROM accountlines
WHERE date > '2019-12-14'
AND accounttype IN ('F','FU')
AND amountoutstanding > 0

The support analyst said: "This finds 5129 bills. If you are happy for these to be deleted, let me know".

I did, and they were gone in an instant.

Ray Delahunty
University of the Arts London

-----Original Message-----
From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of Stephen Graham
Sent: 21 March 2022 16:35
To: koha at lists <koha at lists.katipo.co.nz>
Subject: [Koha] Forgiving all overdue fines

Hi All - we stopped fining users for overdue items years ago, but still have quite a bit unpaid debt in our Koha system. We would like to write off all this debt in bulk. I'm just wondering if there's a "built in" way of doing this in Koha - I can't see anything in the staff client, but maybe there's a cmd line tool that might help?

If not I'm looking to write a script to calling the Pay method from the Koha::Account class. I don't think there's a RESTful API endpoint for this type of activity yet?

Cheers, Stephen

--------------------------------------
Stephen Graham
Library Technology Consultant
Library and Computing Services

University of Hertfordshire
Hatfield, Hertfordshire, AL10 9AB

Email: s.graham4 at herts.ac.uk<mailto:s.graham4 at herts.ac.uk>
Website: herts.ac.uk

_______________________________________________

Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY