Failed to convert parameter value or Input String was not in a correct format.
John Ellis asked 6 years ago
Hello:
A client was trying to load a new chart of accounts map, into a new database. He only had 431 rows, yet, SmartConnect was trying to load 832 rows and was erroring out on each row with the error message, “Failed to convert parameter value or Input String was not in a correct format.”
I tried to mimic my own SmartConnect chart of account map that I have on my laptop, at that point, by putting in a translation for Posting Type and Typical Balance. We were not able to try this result, though, as the client had to go off to a meeting.
Can you think of anything else to eliminate this issue?
Thanks!
John
A client was trying to load a new chart of accounts map, into a new database. He only had 431 rows, yet, SmartConnect was trying to load 832 rows and was erroring out on each row with the error message, “Failed to convert parameter value or Input String was not in a correct format.”
I tried to mimic my own SmartConnect chart of account map that I have on my laptop, at that point, by putting in a translation for Posting Type and Typical Balance. We were not able to try this result, though, as the client had to go off to a meeting.
Can you think of anything else to eliminate this issue?
Thanks!
John
Answers
Best Answer
Lorren Zemke Staff answered 6 years ago
Lorren Zemke Staff answered 6 years ago
John,
1. If the rows are doubling then it would seem you have marked two Dynamics GP companies to send the data.
2. The best method for troubleshooting the message where you are not sending the right data type is to change the destination to Dynamics GP – File and look to see the value being sent in the XML and compare it to the requirements for eConnect for that field. If the source has a string and it requires an integer you will get something similar to that error.
Lorren
1. If the rows are doubling then it would seem you have marked two Dynamics GP companies to send the data.
2. The best method for troubleshooting the message where you are not sending the right data type is to change the destination to Dynamics GP – File and look to see the value being sent in the XML and compare it to the requirements for eConnect for that field. If the source has a string and it requires an integer you will get something similar to that error.
Lorren