Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

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

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
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 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 32,748 Super User 2024 Season 1 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 32,748 Super User 2024 Season 1 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,091 Super User 2024 Season 1 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans