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.
BPA Platform for SAP Business One
BPA Platform is a SAP Certified integration solution for SAP Business One. BPA Platform supports the central creation and management of an Integration Platform as a Service (iPaaS).
It is designed specifically for SAP channel partners and customers who wish to connect SAP databases to third-party solutions and accelerate the automation of business processes.
Deploy BPA Platform in a Cloud, Hybrid or On-premises environment and get the integration and process automation tools you need when you need it.
