Hello, moving back to Dynamics after 3 years of using ConnectWise. I am trying to import my contact and opportunity data. I am unable to download a template, keeps telling me that a duplicate column heading exists, but I cannot find a duplicate in any field. I also keep getting a “number of fields differs from number of column headings” error which I cannot find. Any help?
It is possible you have a hidden column or it is trying to import an empty one. You might try to delete 10 empty columns to the right of your last column and check for hidden columns
This may be due to currency columns. For example, Balance Due and Balance Due (Base) have the same display name, but Balance Due combines currency conversion.
Thank you, I am going to check both of these ideas.