The Delete Document features may be used to correct the issue cannot insert duplicate key row in object. The details of how and why this error may occur are in Knowledgebase Article 312 here. Select the Document Type (Sales Order for SOPOrder errors, Purchase Order for POPOrder errors) and then click Delete. You will be prompted ‘Are you sure?’, click Yes and the Document and associated records will be removed from the Sage database.

Note: While not recommended, this utility may be used to delete any Sales Order or Purchase Order Document from the Sage database. By double-clicking the ‘Delete Document’ label, this will enable the Field dropdown and Value textbox. Values may be set in these controls to delete any Document.