At change of the sales order for in which one line Item contains, adding a second item in the order there is a replacement of an existing position by the added. Nevertheless, in a database the information registers correctly. If to continue item addition in such order there is a following error message:
Database Error : The order line for 1000 could not be inserted
Duplicate entry '1-54' for key 1
Database SQL Failure : The SQL that failed was
INSERT INTO salesorderdetails (orderlineno, orderno, stkcode, quantity, unitprice, discountpercent, itemdue, poline) VALUES(1, 54, '1000', 1, 3501.0000, 0,' ',' ')
In a demo of the version of the program, on a site, the same problem.
What to do?
