Re: [Koha] Forgiving all overdue fines

2022-03-24 Thread Charles Kelley
Hello, Raymund! In our latest exchange, on 25 Mch. 2022 at 08:01 [JST], I read this from you through the Koha Discussion Group: We do not have any write access to the tables and any database updates are > done by our support company. I understand they have a script they run to do > the busine

Re: [Koha] Forgiving all overdue fines

2022-03-24 Thread Raymund Delahunty
Hello Charles- We do not have any write access to the tables and any database updates are done by our support company. I understand they have a script they run to do the business. I think what PTFS were offering was a simple report for us to run to provide that ‘report for posterity’, but I ha

Re: [Koha] Forgiving all overdue fines

2022-03-23 Thread Charles Kelley
Hello, Raymund! In a recent exchange, on 24 Mch. 2022 at 08:00 [JST], I read the following from you through the Koha Discussion Group. 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

Re: [Koha] Forgiving all overdue fines

2022-03-23 Thread 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 acc