Fatal Database write error when paying invoice [SOLVED]
Hi,
when I try to save a supplier invoice payment (Suppliers -> Enter a payment to ...) I get the following blocking error and I cannot proceed:
"
Database Error 1292 : Cannot insert a payment transaction against the supplier because
Incorrect date value: '0000-00-00' for column 'duedate' at row 1
Database SQL Failure : Cannot insert a payment transaction against the supplier using the SQL
INSERT INTO supptrans ( transno, type, supplierno, trandate, inputdate, suppreference, rate, ovamount, transtext ) VALUES ('49', 22,'STEG','2018-09-13','2019-03-23 12-45-08','Bank Transfer','1','-79.90263','HD WD Blue 2TB')
Database Rollback Due to Error Above : Rolling Back Transaction OK
MySQL version 5.7.24
"
webERP version 4.14.1
Ubuntu Linux 16.04.4
MySQL version 5.7.24
Is anybody experiencing the same issue? Any idea about how to fix it?
Thanks
|