Error while updating any SAP / Customised AddOn Master Data Form in SAP B1

[Former Member]

Hello Experts,

I am facing a unique Problem in my addon .I have created two Master Tables Forms and entered the data in that two forms and the entry is done alright.

But while updating that Master data system is throwing an error "Conversion Failed when converting the nvarchar value 'A001'

to datatype int (CINF) "

Here i have saved the Data as 'A001' in code field of MAster Data Table.

This error is showing even in SAP Item MAster or any MAster Type Forms.

This problem persist in all Master type Forms not the Document Type Forms.

Please suggest a solution for this error to rectify.

Thanks

Amit

Edited by: AmitSharma_061985 on May 30, 2011 8:51 AM

[former_member201110 · Accepted solution]

Hi Amit,

Do you have any customisations in your Transaction Notification proc on the company database? You'll get this error if you have an old version of this procedure and you are doing any validation with the object_type parameter (which used to be data type int but is now nvarchar).

See SAP Note 1298609

Kind Regards,

Owen

[rasmuswulff_jensen · Accepted solution]

Owen is correct that this is due to incorrect usage of the SBOP_SPTransActionNotification. The following PDF explain the error in detail (Using B1 Usability Package Addon as sample) and also how to fix the issue:

http://service.boyum-it.com/fileadmin/user_upload/documents/support/SBO_SP_TransactionNotification_P...

[Former Member]

Solved

[former_member210167]

Apply a patch, or send a message to SAP. It is an known error.

Hope it helps, Jose