Hi Katrin and Magnus After the mentioned changes everything works as expected. Thanks again for your help! (And as suggested by Katrin I have set system preference "CurrencyFormat" to a format with decimal dot). Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch Am 08.01.24 um 10:53 schrieb Michael Kuhn:
Hi Katrin and Magnus
Many thanks for your answers!
It is not possible to change the value to "0.00" via Koha menu "Administration > Defining circulation and fine rules for all libraries" - even wehn savin "0.00" it will still show "0,00".
We have eight rules there - all of them show value "0,00" in column "Overdue fines cap (amount)". But in table "circulation_rules" I found the following:
MariaDB [koha_bibliothek]> SELECT * FROM circulation_rules WHERE rule_name="overduefinescap"; +-----+------------+--------------+----------+-----------------+------------+ | id | branchcode | categorycode | itemtype | rule_name | rule_value +-----+------------+--------------+----------+-----------------+------------+ | 4 | NULL | NULL | NULL | overduefinescap | | | 34 | NULL | NULL | BUCH | overduefinescap | 0.00 | | 67 | NULL | NULL | CD | overduefinescap | 0.00 | | 94 | NULL | NULL | ZSS | overduefinescap | 0.00 | | 136 | NULL | PT | BUCH | overduefinescap | | | 170 | NULL | HB | BUCH | overduefinescap | 0.00 | | 182 | NULL | NULL | KONV | overduefinescap | | | 214 | NULL | NULL | DVD | overduefinescap | | +-----+------------+--------------+----------+-----------------+------------+ 8 rows in set (0,000 sec)
So I changed just the values actually containing "0,00" as follows:
MariaDB [koha_bibliothek]> UPDATE circulation_rules SET rule_value = '0.00' WHERE rule_value = '0,00';
Thus table "circulation_rules" now shows:
MariaDB [koha_bibliothek]> SELECT * FROM circulation_rules WHERE rule_name="overduefinescap"; +-----+------------+--------------+----------+-----------------+------------+ | id | branchcode | categorycode | itemtype | rule_name | rule_value | +-----+------------+--------------+----------+-----------------+------------+ | 4 | NULL | NULL | NULL | overduefinescap | | | 34 | NULL | NULL | BUCH | overduefinescap | 0.00 | | 67 | NULL | NULL | CD | overduefinescap | 0.00 | | 94 | NULL | NULL | ZSS | overduefinescap | 0.00 | | 136 | NULL | PT | BUCH | overduefinescap | | | 170 | NULL | HB | BUCH | overduefinescap | 0.00 | | 182 | NULL | NULL | KONV | overduefinescap | | | 214 | NULL | NULL | DVD | overduefinescap | | +-----+------------+--------------+----------+-----------------+------------+ 8 rows in set (0,000 sec)
However, even after restarting Koha ( memcached apache2 koha-common ) Koha menu "Administration > Defining circulation and fine rules for all libraries" still shows the value "0,00" in column "Overdue fines cap (amount)" for all eight rules as before.
I will now wait and see what happens after the next run of "/etc/cron.daily/koha-common".
Best wishes: Michael