SAP B1 – Business Partner address fails to update with error “This entry already exists in the following tables (ODBC -2035)”

Symptom

When you update both the Billing and Shipping addresses for a Business Partner, one of the addresses may fail to update. The following error returned is:

This entry already exists in the following tables (ODBC -2035)

Cause

This is caused by attempting to update the same row twice. You can prevent this error by specifying the LineNum of the row to be updated.

Resolution

Before updating the Shipping Address, first query the CRD1 table for the for the LineNum (passing it the CardCode and AddressName as the criteria).
The value returned from the query is then mapped to LineNum during the update operation.

Repeat the steps above for the Billing Address.

SAP Business One Integration Brochure

SAP Business One Integration Brochure

Learn how integrating SAP Business One with other business applications or web services will save your company time and money.

Download Brochure