SBX - Search With Button

SBX - Forum Post Title

DOC 1 ERROR: Cannot convert field 'Purchases ' Value ' $2997.980000' to numeric value.

Microsoft Dynamics GP Forum

Carolina Hernandez asked a question on 7 Sep 2017 6:02 PM
My Badges

Question Status

Unanswered

I have this error when I run the Integration Manager.

DOC 1 ERROR: Cannot convert field 'Purchases ' Value ' $2997.980000' to numeric value.

I changed the value with this  test values :  2997.98,  $2997.98, 2297.900000, $2297.900000 and I have the same error.

Please your advice.

Carolina H.

Reply

Carolina,

When you look at the data source, what type of field does the source indicate?

Leslie

Reply
Carolina Hernandez responded on 11 Sep 2017 12:33 PM
My Badges

The type of field is numeric with numeric scale 6 and size 14.

When I removed the symbol of  "$"  then Integration Manager closed with error and I can not to continue.

Reply
Leslie Vail responded on 11 Sep 2017 10:19 PM

I'm going to try and replicate the error. It looks like you are importing payables transactions. If you are doing POs please let  me know. I'll let you know how I come out.

Leslie

PS what are you using for your source? Excel, csv, sql, tab, etc.

LV

Reply
Carolina Hernandez responded on 12 Sep 2017 5:57 PM
My Badges

thanks Leslie Vail , I fit the Integration manager and I loaded the information.

Reply

SBX - Two Col Forum

SBX - Migrated JS