Skip to content


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

John Ellis asked 2 years ago
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?
Oluwadamilola Ajayi answered 2 years 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.