You’re offline. This is a read only version of the page.
580
Is it possible to enter lowercase letters in the item number field?
*This post is locked for comments
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.
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
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
Is there a way around this restriction? Or at least display lower case letters on the customer sales order and invoices.
Thanks for the quick responses!
No, key fields in GP are restricted to capitals only.
No. Unless someone imported direct to sql table then it might show that way.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (