Sage 100

v5.1 premium - several instances of duplicate line items in SO_SalesOrderHistoryDetail (about 10 in the last month). These are not deleted lines. SO setup save deleted lines is no. The sequence numbers are different. Is there a reported bug in 2014? Has anyone else experienced this issue? SO_SalesOrderDetail is OK.

Are there lines being added manually at the invoicing stage?

@KevinMoyes It is possible, but doubtful that the lines would be the same item number.

Users may remove / re-add a line with the same item code, not knowing about line keys and mistakenly thinking it will update the existing order line with the same item code. If my theory is correct, you should see evidence of the new duplicate line being added by a row in SO_ARInvoiceHistoryLink, which links AR invoice history lines to SO history lines.

I will check it out. That seems very bizarre. Example. SO has an item ABC qty 1 at $1.00, and order total is $1.00. In SO History the SO has 3 lines of item ABC all at qty 1 at $1, and the order total is $3. I didn't think a user could delete an item during invoice data entry. I thought the line had to be deleted in SO entry.

I checked and you're right, the user cannot delete lines from the SO during invoicing, but they can add new ones, which go into SO history, as you describe.