Conversion failed when converting nvarchar

[#1]

Forum,

I have a set of data when when you try and make any amendments to the Business Partner Master screen and stock master data, the following error message appears:

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

Again, it doesn't matter what's altered i.e. remarks, descriptions. The same error occurs.

The system i am testing on is 8.81 PL06

Has anyone come across this before?

Regards,

Juan

[Former Member]

1.Try to stop add-on if you have.

2.If you have any UDF in master then check that data type.

3.If you have any FMS then also check there.

Because you have been tring to fill Nvarchar value in integer field.

Thanks

Manvendra Singh Niranjan

[Former Member]

There is a comment in an SP causing this issue. rem this out and it solves the problem.

SP in question. SP_PostTransactionNotice

[Former Member]

Could you post your SP in the form ?

Thanks

Manvendra Singh Niranjan