[Bug 29985] New: Cashup summary shows unexplainable odd amounts
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 Bug ID: 29985 Summary: Cashup summary shows unexplainable odd amounts Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Fines and fees Assignee: koha-bugs@lists.koha-community.org Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org CC: martin.renvoize@ptfs-europe.com I performed some transactions testing bug 27779 in a fresh ktd instance. I used amounts like 4.50 or 10.00 or 1.55, nothing with more decimals, but I still ended up with this: Cash register: This is a register. Period: to 2022-01-31 21:22:40 Type Total Total 0.0499999999999998 Cash -0.0499999999999998 I have no idea how this can happen, since all amounts in my accountlines and account_offsets are only in 5 cent steps. With the patch from 27779 applies it also shows even amounts: Cash register: This is a register. Period: to 2022-01-31 21:22:40 Type Total Refund against Manual fee - 6 Refund against New card fee - 6 Manual fee 4.55 USB Stick 1.5 Total 0.0499999999999998 Cash -0.0499999999999998 As this should only be additions/subtractions, I have no idea how this could happen unless we have a bug somewhere? Also display should be using Price (CurrencyFormat) system preference, but it doesn't, display remains unchanged with FR option. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Possibly easier to read if you copy from here to an editor: MariaDB [koha_kohadev]> select * from accountlines; +-----------------+----------+----------------+------------+---------------------+------------+-------------+------------------+-----------------+---------------+----------+--------------+-------------------+---------------------+------+------------+-------------+-----------+------------+ | accountlines_id | issue_id | borrowernumber | itemnumber | date | amount | description | credit_type_code | debit_type_code | credit_number | status | payment_type | amountoutstanding | timestamp | note | manager_id | register_id | interface | branchcode | +-----------------+----------+----------------+------------+---------------------+------------+-------------+------------------+-----------------+---------------+----------+--------------+-------------------+---------------------+------+------------+-------------+-----------+------------+ | 1 | NULL | 19 | NULL | 2022-01-31 21:18:18 | -20.000000 | | CREDIT | NULL | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:19:21 | | 51 | NULL | intranet | CPL | | 2 | NULL | 19 | NULL | 2022-01-31 21:18:32 | 7.000000 | New card | NULL | NEW_CARD | NULL | REFUNDED | NULL | 0.000000 | 2022-01-31 21:19:58 | | 51 | NULL | intranet | CPL | | 3 | NULL | 19 | NULL | 2022-01-31 21:18:48 | 10.000000 | Umbrella | NULL | UMBR | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:19:21 | | 51 | NULL | intranet | CPL | | 4 | NULL | 19 | NULL | 2022-01-31 21:18:54 | 4.500000 | USB Stick | NULL | USB | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:19:48 | | 51 | NULL | intranet | CPL | | 5 | NULL | 19 | NULL | 2022-01-31 21:19:03 | 5.550000 | Manual fee | NULL | MANUAL | NULL | NULL | NULL | 0.000000 | 2022-01-31 21:20:14 | | 51 | NULL | intranet | CPL | | 6 | NULL | 19 | NULL | 2022-01-31 21:19:36 | -4.550000 | | PAYMENT | NULL | NULL | NULL | CASH | 0.000000 | 2022-01-31 21:19:36 | | 51 | 1 | intranet | CPL | | 7 | NULL | 19 | NULL | 2022-01-31 21:19:48 | -1.500000 | | PAYMENT | NULL | NULL | NULL | CASH | 0.000000 | 2022-01-31 21:19:48 | | 51 | 1 | intranet | CPL | | 8 | NULL | 19 | NULL | 2022-01-31 21:19:58 | -7.000000 | NULL | REFUND | NULL | NULL | ADDED | NULL | 0.000000 | 2022-01-31 21:20:56 | NULL | 51 | NULL | intranet | CPL | | 9 | NULL | 19 | NULL | 2022-01-31 21:20:56 | 6.000000 | | NULL | PAYOUT | NULL | PAID | CASH | 0.000000 | 2022-01-31 21:20:56 | | NULL | 1 | intranet | NULL | +-----------------+----------+----------------+------------+---------------------+------------+-------------+------------------+-----------------+---------------+----------+--------------+-------------------+---------------------+------+------------+-------------+-----------+------------+ 9 rows in set (0.002 sec) MariaDB [koha_kohadev]> select * from account_offsets; +----+-----------+----------+--------+------------+---------------------+ | id | credit_id | debit_id | type | amount | created_on | +----+-----------+----------+--------+------------+---------------------+ | 1 | 1 | NULL | CREATE | 20.000000 | 2022-01-31 21:18:18 | | 2 | NULL | 2 | CREATE | 7.000000 | 2022-01-31 21:18:32 | | 3 | NULL | 3 | CREATE | 10.000000 | 2022-01-31 21:18:48 | | 4 | NULL | 4 | CREATE | 4.500000 | 2022-01-31 21:18:54 | | 5 | NULL | 5 | CREATE | 5.550000 | 2022-01-31 21:19:03 | | 6 | 1 | 2 | APPLY | -7.000000 | 2022-01-31 21:19:21 | | 7 | 1 | 3 | APPLY | -10.000000 | 2022-01-31 21:19:21 | | 8 | 1 | 4 | APPLY | -3.000000 | 2022-01-31 21:19:21 | | 9 | 6 | NULL | CREATE | 4.550000 | 2022-01-31 21:19:36 | | 10 | 6 | 5 | APPLY | -4.550000 | 2022-01-31 21:19:36 | | 11 | 7 | NULL | CREATE | 1.500000 | 2022-01-31 21:19:48 | | 12 | 7 | 4 | APPLY | -1.500000 | 2022-01-31 21:19:48 | | 13 | 8 | NULL | CREATE | -7.000000 | 2022-01-31 21:19:58 | | 14 | 8 | 2 | APPLY | 0.000000 | 2022-01-31 21:19:58 | | 15 | 8 | 5 | APPLY | -1.000000 | 2022-01-31 21:20:14 | | 16 | NULL | 9 | CREATE | 6.000000 | 2022-01-31 21:20:56 | | 17 | 8 | 9 | APPLY | -6.000000 | 2022-01-31 21:20:56 | +----+-----------+----------+--------+------------+---------------------+ -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 --- Comment #2 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- I've tried this and am unable to replicate it at the moment. What currently format are you using.. I wonder if there's a difference in configuration. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |martin.renvoize@ptfs-europe |ity.org |.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- This was in January, so that database no longer exists. Chances are it was FR or US, unlikely to be CH. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 --- Comment #4 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- OK, it may well be the FR currency.. I do see other bugs when I change to FR. WIll come back to this. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |13985 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13985 [Bug 13985] Cash Management - Koha as 'Point of Sale' -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |WORKSFORME Status|NEW |RESOLVED --- Comment #5 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- I've never managed to replicate this.. I'm going to close this one out for now.. we can always re-open if someone can replicate it down the line. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985 --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Agreed. There have also been a lot of code changes since I believe. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org