SAP - Conversion failed when converting the nvarchar

SAP - Conversion failed when converting the nvarchar

   1:56 AM       BTG

---

This is probably my first post in this blog. :) So, yesterday one of my friend raised an error when adding a Marketing Documents, Item Master Data and Customer Master Data in SAP Business One.

[Microsoft][SQL Server Native Client 11.0](SQL Server)Conversion failed when converting the nvarchar value 'value' to data type int. (CINF)

The root cause of this error is on the SBO_SP_TransactionNotification this is a stored procedure from SAP Business One database where in you can create your own user define error which they can't proceed on Add/Updating based on your scenario. So, I've told him that to review this stored procedure. The solution is either disable all the query in the SBO_SP_TransactionNotification or debug the stored procedure.

To go to this stored procedure :
Log in to your SQL server

Expand Databases > Expand your Database > Programmability > Stored Procedures > Find SBO_SP_TransactionNotification