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

TechKnowledge Content

Issue

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.

Resolution

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

APPLIES TO

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×