SAP Business One Connector: Error when updating the ‘Quotation’ object

Symptom

When using the Quotation object to perform an Update operation, an error similar to the following is received:

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

Cause

This is a known issue, specific to the Sales Quotation and Purchase Quotation objects.

Solution

  1. Remove the files oQuotationsRequest.xslt and oQuotationsResponse.xslt from the folder:
    c:\inetpub\wwwroot\CommunicatorWS\Schemas\ServiceTranslation
  2. Edit the oQuotations.xml file in c:\inetpub\wwwroot\CommunicatorWS\Schemas and remove the ServiceName and AllDataOnUpdate attributes from the first tag.
  3. Within TaskCentre, refresh the schemas for the global connection.
  4. Edit the task step and re-select the Quotation object.
  5. Save all changes made within the task.

 

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