Error 2221 "When Adding or Updating Lines to an Existing Document, UpdateIfExists Must = 1" in eConnect

TechKnowledge Content


Error 2221 - "Stored Procedure taSopLineIvcInsert Error Description = When adding or updating lines to an existing document, UpdateIfExists must = 1" occurs in eConnect.

Potential Cause

The SOP Invoice already exists in the system.


If the intent was to update the Invoice line:

UpdateIfExists must = 1

Needs to be added to the taSopLineIvcInsert node. Otherwise delete the Invoice number or Batch and re-import the XML file.

This article was TechKnowledge Document ID: 30818


eConnect, when used with:
  Microsoft Dynamics GP 9.0
  Microsoft Business Solutions–Great Plains 8.0
  Microsoft Business Solutions–Great Plains 7.5
  Microsoft Great Plains Dynamics 7.0
  Microsoft Great Plains eEnterprise 7.0
  Great Plains Dynamics 6.0
  Great Plains eEnterprise 6.0