Open Forum

Expand all | Collapse all

Changing max number of characters in Nonstock Item table

  • 1.  Changing max number of characters in Nonstock Item table

    SILVER CONTRIBUTOR
    Posted 7 days ago
    ​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
    ------------------------------


  • 2.  RE: Changing max number of characters in Nonstock Item table

    TOP CONTRIBUTOR
    Posted 7 days ago
    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
    ------------------------------