System.Data.SqlClient.SqlException (0x80131904) Error converting data type nvarchar to numeric.

Environment:  

iVend Retail 6.6 7989 With SAP B1 10.0

Problem statement: 

iVend Optical Product Master Created in SAP Business, however those failed stuck in integration failure log from SAP To iVend with below error.

System.Data.SqlClient.SqlException (0x80131904) Error converting data type nvarchar to numeric.

Symptoms: 

It was configuration issue.

Resolution/Work Around: 

Issue resolved after updating the correct value in UDF.

Recommendations /Suggestion: 

Numeric type UDF will only accept numeric value.

• Related Articles

• Integration Err System.Data.SqlClient.SqlException (0x80131904): Error converting nvarchar data type

  Product Version: 6.5 Update 6 Patch2 Problem Statement Incident ID - INC0012326 - Warehouse events stuck on Integration Failure Monitor from SAP to iVend with error message System.Data.SqlClient.SqlException (0x80131904): Error converting nvarchar ...

• Integration failure Error converting data type nvarchar to numeric

  Environment iVend 6.5 Update 4 With SAPB1 9.2 Problem Statement Integration errors from SAPB1 to iVend as Product Update events: System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to numeric. at ...

• SAP to iVend Integration Error "Error converting data type nvarchar to numeric.

  Environment: iVend 6.6 and SAP Business One Problem statement: SAP to iVend integration Error "System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to numeric." for product Symptoms : The product created in SAP but ...

• After upgrade to version 6.6 an error "Error converting data type nvarchar to bigint" on POS

  Environment: iVend 6.6 Problem Statement: After upgrade I find the mentioned error when printing the Sales Transaction. How can this be fixed? <Version>6.6.7989.24759</Version> <Category>ERROR</Category> <Time>09:32:37 am</Time> <Message>Error ...

• Facing error "error converting data type nvarchar to bigint" after 6.6 upgrade

  Problem - Facing the error when try to add customer through point of sale. Below error was reported while saving the record. "error converting data type nvarchar to bigint" Version : iVend 6.6 + Ecuador Localization Scenario : The error is witnessed ...