[Koha-bugs] [Bug 29985] Cashup summary shows unexplainable odd amounts

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29985

--- Comment #1 from Katrin Fischer <katrin.fischer at 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.