New Order Adds Line Item Automatically

A cleared lock or similar situation can sometimes cause a record to be added to the SOP10200 table. The added record will have no SOP Number, so any new orders created in SalesPad will display it as a new line item.

To check this, run the following query:

Select * from dbo.SOP10200 Where SOPNUMBE = ‘’

Remove the records from the table to stop the line item from being added to the document.