Error when adding entry to User Defined Object.

[Former Member]

Hi all

I am using SBO2007B SP:00 PL:08.

I tried creating an User Defined Object with master data and master rows object.

I have created UDF's for the two tables..

When i tried adding values to the Default forms, the following error pops up.

(Microsoft) (SQL Native Client) (SQL Server) Conversion failed when converting the nvarchar value

'{UDO Name}' to data type int (CINF)

Help me in sorting out this issue...

Thanks

Marikannan

[vijay_kumar1 · Accepted solution]

Hi Marikannan,

Check if you have any additional code added to the SBO_SP_TransactionNotification stored procedure, if so, comment the additional code and try again.

Regards,

Vijay Kumar

SAP Business One Forums Team

[Former Member · Accepted solution]

Hi Vijay,

Does that mean that i can not have any validations in SBO_SP_TransactionNotification stored procedure if need to use UDO.?

Marikannan

[Former Member · Accepted solution]

It works when i comment all my additional codes in SBO_SP_TransactionNotification stored procedure.

Marikannan

[vijay_kumar1 · Accepted solution]

Hi Marikannan

It might be a syntax error in the code, it should be defined like this

If @object_type = '1'

Regards,

Vijay Kumar

SAP Business One Forums Team

[Former Member · Accepted solution]

Hi Vijay,

It works now...

Thanks.. it was the same one which you have mentioned

Marikannan