Skip to content
+1-888-319-3663

COMMUNITY FORUM

A Chart of Accounts Segment is a String Rather Than a Number

John Ellis asked 11 months ago
Hi:
I have imported charts of account numerous times over the years, but I have never had occasion to do so where one of the segments is a string rather than a number.
So, of course, SmartConnect is giving me the error “Failed to convert parameter from a String to Int16”.
How do I get past this?
Thanks!
John
Answers
Oluwadamilola Ajayi Staff answered 6 months ago

 

Hi John,
To get past this, you need to know what the value is, create a calculated field to remove characters that are not integers, and then map the calculated field to the appropriate field in the destination column.
 

If you would like to submit an answer or comment, please sign in to the eOne portal.