stevegray
4Penny.net
Points: 55509

5/13/2016 12:07:29 PM

eConnect - Error converting datatype nvarchar to numeric

This is in GP 2010... it does not occur in GP2015

The error was caused by trying to eConnect a SOP document with an item number that contained a forward slant (/)

We tried troubleshooting with my usual method:

Wrap the data in a CDATA, so it would look like this: <![CDATA[MYITEM/ISBAD]]>

That didn't work

Then we tried using the PRE procedure to encode it and decode it when we got to SQL. (Our PRE and POST primer is here)

I did not solve this, except to tell the customer that they'll need to use the Item Number Changer in the Professional Tools Services Library.

But... there is some discussion of what I tried below.


 
4Penny.net
Version: All
Section: eConnect
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3