I have a problem getting the telephone number to display properly when using Integration Manager to create a Customer. I tried different ways but it always ends up being incorrect. I looked at how it is displayed in RM00101 for exisiting customers and used the same format (just a long row of numbers) but even though it uploads without any errors, it does not display propery, for example 004.16E+090000 instead of 416000000.
*This post is locked for comments
I have the same question (0)What is the field type of this field in IM. It should be char(21). The field will be stored as 21 characters with no dashes or parentheses. It sounds like your integration is treating this as a number as then trying to convert a number to a string.