interduo
commented
5 years ago Ta płatność:
MariaDB [lmsdb]> SELECT * FROM billtech_payments WHERE id=4634;
+------+-----+------------+--------+-------+-----------------+------------------+------------+--------+--------+
| id | ten | customerid | amount | title | document_number | reference_number | cdate | closed | cashid |
+------+-----+------------+--------+-------+-----------------+------------------+------------+--------+--------+
| 4634 | | 3528 | 58.00 | | saldo-20190719 | 20190719-813207 | 1563560722 | 1 | NULL |
+------+-----+------------+--------+-------+-----------------+------------------+------------+--------+--------+
1 row in set (0.00 sec)
W tym polu jest cashid = NULL i tutaj pewnie jest błąd?
Wpis który powinien zostać usunięty:
MariaDB [lmsdb]> SELECT * FROM cash WHERE id='413480';
+--------+------------+------+--------+-------+-------+------------+-------------------+-------+--------+----------+----------+
| id | time | type | userid | value | taxid | customerid | comment | docid | itemid | importid | sourceid |
+--------+------------+------+--------+-------+-------+------------+-------------------+-------+--------+----------+----------+
| 413480 | 1563560722 | 100 | NULL | 58.00 | NULL | 3528 | BillTech Payments | NULL | 0 | NULL | NULL |
+--------+------------+------+--------+-------+-------+------------+-------------------+-------+--------+----------+----------+
1 row in set (0.00 sec)
michal-kaciuba
Nie działa automatyczne kasowanie wpłat tymczasowych z komentarzem "BillTech Payments" z tabeli cash podczas czynności:
Te wpłaty na liście płatności są zaznaczone jako rozliczone (szare).