Business Central Phone No. must not contain letters Error

Published: Mar 07, 2022
Post Author Written by eOne Solutions


When importing a record containing a phone number into Business Central any phone number containing letters will return the error message “Phone No. must not contain letters


The BC field type “Phone Number” does not allow any letters. An example of an invalid phone number is:

Invalid: +45 26260101 Ext 123

Valid: +45 26260101 #123


Use a calculation in SmartConnect to strip invalid characters from the phone number prior to importing to Business Central. Below is a sample calculated column I have used to resolve this error.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.