Summary: | Cashup summary shows unexplainable odd amounts | ||
---|---|---|---|
Product: | Koha | Reporter: | Katrin Fischer <katrin.fischer> |
Component: | Fines and fees | Assignee: | Martin Renvoize (ashimema) <martin.renvoize> |
Status: | NEW --- | QA Contact: | Testopia <testopia> |
Severity: | major | ||
Priority: | P5 - low | CC: | martin.renvoize |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: | ||
Bug Depends on: | |||
Bug Blocks: | 13985 |
Description
Katrin Fischer
2022-01-31 21:34:11 UTC
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 | +----+-----------+----------+--------+------------+---------------------+ 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. This was in January, so that database no longer exists. Chances are it was FR or US, unlikely to be CH. OK, it may well be the FR currency.. I do see other bugs when I change to FR. WIll come back to this. |