Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Lowercase letters in Item number field?

Posted on by 580

Is it possible to enter lowercase letters in the item number field?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Lowercase letters in Item number field?

    Much of this is dependent on your SQL collation.

    learn.microsoft.com/.../microsoft-sql-server-configuration

    Do you want case sensitive or non-case sensitive? Either way all index keys require upper case letters.

  • turquoise Profile Picture
    turquoise 10 on at
    RE: Lowercase letters in Item number field?

    Any idea WHY they are restricted to upper case? Uppercase is much harder to read & harder to see differences between codes (&  easier to make mistakes)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Lowercase letters in Item number field?

    Hi Tim,

    This is a slightly different question relating to lower case.

    I did use the table import and imported checkbook id's containing lower cases. Will this cause an issue?

    I've done extensive testing and nothing has come about, but just to be safe did a UPPER and the tables for the id field anyway.

    Krystal

  • Tim W Profile Picture
    Tim W 2,925 on at
    Re: Lowercase letters in Item number field?

    To get around this for a display on the sales documents you could use one of the other fields such as item short name which does allow for lowercase and just pull that onto the report in place of the item number.

    Downside would be having to populate this field for all items but if you are an intermediate level report writer you could write a conditional field to print item number if you other field is blank.

    Best

    Tim

  • Bao Nguyen Profile Picture
    Bao Nguyen 580 on at
    Re: Lowercase letters in Item number field?

    Is there a way around this restriction? Or at least display lower case letters on the customer sales order and invoices.

  • Bao Nguyen Profile Picture
    Bao Nguyen 580 on at
    Re: Lowercase letters in Item number field?

    Thanks for the quick responses!

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    Re: Lowercase letters in Item number field?

    No, key fields in GP are restricted to capitals only.

  • Maria Price Profile Picture
    Maria Price 290 on at
    Re: Lowercase letters in Item number field?

    No.  Unless someone imported direct to sql table then it might show that way.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans