database error what is wrong?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

database error what is wrong?

Heinrich Steuber
This post has NOT been accepted by the mailing list yet.
Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The supplier invoice transaction could not be added to the database because
Duplicate entry '1003-20' for key 'TypeTransNo'
Database SQL Failure : The following SQL to insert the supplier invoice was used
INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate, duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20 , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11', '1.00000000', '', '2017-08-21')
Database Rollback Due to Error Above : Rolling Back Transaction OK
using webERP v4.11.2
Apache version 2.4
Mysql 5.7.19
Ubuntu 16.04