If you import an EDI order and the order file is not consumed and the order is not raised in the system then you will need to look into the error log to see what the system is running into.
If the error states: Cannot insert duplicate key row in object 'dbo.SalesOrderHeaders'
The duplicate key value is (XXX, , S000XXXX , )
Where the XXX is the Company Code the S000XXXX will be the Order number the system tried to create. The Duplicate key value is most likely caused by that Order number already existing within the syste.
EDI order write the sales order number based on the sequence value stored in SQL. If for whatever reason the Sequence has fallen out of alignment with where it should, you will experience this error.
Fortunately a data change from support can sync the sequencing back up and allow you to process EDI Orders as required.
Please contact us and reference the title of this article.
