cancel
Showing results for 
Search instead for 
Did you mean: 

error-converting data type nvarchar to numeric while making purchase order for particualr items

former_member209725
Participant
0 Kudos
224

Dear Experts,

I am facing Error of Converting Data Type nvarchar to numeric while making purchase order for some particular items. If I make new items with same details then there is no error.

This is happening for some of the items. Herewith attaching a screen shot for the error.

Kindly suggest what to be done.

Regards,

Ravi Soni

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear ravi.jha,

There is no screenshot.

Could you please check the issue after removing the customized code written under SBO_SP_TransactionNotification?

Do you have Formatted Searches (FMS) also on the form?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

View Entire Topic
former_member209725
Participant
0 Kudos

Dear Ankit Chauhan,

Thanks for prompt reply, also sorry for missing attachment. Herewith attaching the screenshot. item-error.png .This happens for some items and other items with same configuration are fine. Yes FMS is there but error is not in all cases only in few items with same Item Group and same settings.

Regards,

Ravi

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear ravi.jha,

When do you get this error?

When you click on the "Add" button or when you select the Item?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support