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

Question Status

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

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
Leslie Vail responded on 8 Sep 2017 4:25 PM

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

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

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

Reply