Product: Dynamics 365 Business Central

Error: Error: Internal_EntityWithSameKeyExists The record in table Sales Line already exists

Article Link: http://help.truecommerce.com/en/articles/11180325-dynamics-365-business-central-error-the-record-in-table-sales-line-already-exists

Issue: When exporting out a Purchase Order (850) from Transaction Manager you receive the following error: 'Error: Internal_EntityWithSameKeyExists The record in table Sales Line already exists.'

Reason: During creation or updating of the Sales Order within Dynamics 365 Business Central, the Line # passed in was found to already of been used.

If you're passing multiple Items or adding a Line Item that doesn't exist on the incoming Transaction either through Mapping Manager or through a script on Sales Order creation you need to ensure that the Line Numbers are not repeated.

Update the lineNumber within Transaction Manager to either properly push the Line # sent by your Trading Partner, or use the [I:Item Loop Index] token (found under Tools → AccountInfo to auto-sequence the Line Number

Navigate: Partner Maps → Purchase Order

Select: Edit

Select: SalesOrderLines → Details (from Row/Column Selection)

Map: lineNumber

If a script customization has been added by your Value Added Reseller (VAR) or Consultant - you will need to have them update the solution to use a different Line Number value, such as 1000, 2000, or 3000 to avoid conflicts of Line Numbers that your Trading Partner may be sending instead.

rev 5/1/2025