Notifications
Announcements
No record found.
Is it possible to enter lowercase letters in the item number field?
*This post is locked for comments
No. Unless someone imported direct to sql table then it might show that way.
No, key fields in GP are restricted to capitals only.
Thanks for the quick responses!
Is there a way around this restriction? Or at least display lower case letters on the customer sales order and invoices.
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
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
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)
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
