Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

(0) ShareShare
ReportReport
Posted on by 125

We have been using D365 Business Central for years. When entering Customer No. we use an abbreviation of the Customer Name, e.g. CSTMRNAME. Just last week we started getting a validation error when using this in a Sales Quote or Sales Order. The error is "You cannot enter letters in this field." Any thoughts on how to fix this?

  • RTIBobV Profile Picture
    RTIBobV 125 on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    Thank you! The error was in the phone number. It had an x before the extension.

  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,025 Moderator on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    Check either your Customer or Contact Phone No.

    There shouldn't be any letters on the phone no.

    I believe the Customer or Contact Phone No was entered without validation.

    When you enter the Customer No in the Sales Header, the validation on Sales Header was triggered and errored out.

  • RTIBobV Profile Picture
    RTIBobV 125 on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    Permissions.jpg

    I am the sys admin and a Super user. It appears that all of the add-ins have been removed including Office 365 access, the Excel add-in, etc.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    Are you a super user in the system?

    There should be a list of extensions installed and because you are not seeing anything there you might have a permission issue.

    Maybe you should check with your system administrator that you have been assigned the correct permissions in your system?

  • RTIBobV Profile Picture
    RTIBobV 125 on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    Interesting apparently all of the extensions are no longer installed.

    Extension Installation Status shows "There is nothing to show in this view."

    pastedimage1681144020721v2.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    It sounds like you have some custom code added to your solution.

    Go to extension management and check what apps you have installed there.

    The customer field in standard Business Central is a code field that should accept both numbers and letters.

    If you are in BC Online you can also contact your CSP partner and possible have them open a support case with Microsoft around this issue.

  • RTIBobV Profile Picture
    RTIBobV 125 on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    We have not had any issue until now. The Sales order and Sales quote have been modified in order to print correctly but we have not added any filters to the Customer No. field.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,273 Moderator on at
    RE: Sales Order | Customer No. | Validation Results | "You cannot enter letters in this field"

    Hi,

    Please check first if there is any customization done on this field or Sales Order or Sales Quote. Because this error you are facing not the standard one, this is the custom one.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans