Discussions – Dynamics Business Central (NAV) – Dynamics Communities

Changing max number of characters in Nonstock Item table

Dynamics Business Central (NAV)

Changing max number of characters in Nonstock Item table

Posted by Devora on March 15, 2019 at 9:54 am
- Devora Locke
  
  Member
  
  March 15, 2019 at 9:54 AM
  
  ?I have a user request to change the number of allowed characters in ‘5718 Nonstock Item’, ‘No.’ from 20 characters to 30. I know I would have to also change it in table 27, Item table, but wondering where else? ILE? Sales Line? Sales Invoice Line? Looks like it could become a long list. Will also need to check my pages to ensure text will fit, but that’s minor.
  
  Thanks!
  -Devora.
  
  ——————————
  Devora Locke
  Shin-Etsu MicroSi, Inc
  Phoenix AZ
  ——————————
- Matt Traxinger
  
  Member
  
  March 15, 2019 at 10:01 AM
  
  It is never recommended to change any part of the primary key for a base table. Or the length of any base field really. It is a guaranteed upgrade issue. It’s also not just other tables you would have to worry about changing. The value could be copied to other variables in the code that only allow up to 20 characters.
  
  If your users are need the additional character length I would recommend adding a new field of length 30 and using that to search / filter on.
  
  ——————————
  Matt Traxinger
  NAV Developer
  ArcherPoint Inc.
  San Antonio TX
  ——————————
  ——————————————-
Devora replied 7 years ago 1 Member · 0 Replies
0 Replies

Sorry, there were no replies found.

The discussion ‘Changing max number of characters in Nonstock Item table’ is closed to new replies.