SAP B1 – Business Partner address fails to update with error “This entry already exists in the following tables (ODBC -2035)”
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)
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.
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.