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-boun...@lists.katipo.co.nz> On Behalf Of Stephen Graham
Sent: 21 March 2022 16:35
To: koha@lists <koha@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.grah...@herts.ac.uk<mailto:s.grah...@herts.ac.uk>
Website: herts.ac.uk
_______________________________________________
Koha mailing list http://koha-community.org Koha@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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
