Open Forum

Expand all | Collapse all

Increasing Description Field Length in Item Table

  • 1.  Increasing Description Field Length in Item Table

    Posted Feb 05, 2020 05:42 AM
    Hi Every one,
    When I put description in item that have 68 caracters I get an error even Ihave increase field length to 70 in Item Table.
    Any suggestion?
    Increasing Field Length


    ------------------------------
    Abdel DAHMANI

    ------------------------------


  • 2.  RE: Increasing Description Field Length in Item Table

    TOP CONTRIBUTOR
    Posted Feb 05, 2020 08:28 AM
    This is a big change you are trying to do, as the description is used in many many places, you'll get that error in a lot of other places.
    If you start a debugger, you'll see in what other table you need it in your scenario.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



  • 3.  RE: Increasing Description Field Length in Item Table

    TOP CONTRIBUTOR
    Posted Feb 06, 2020 07:23 AM
    Use the field Description 2. Far easier to add that to Pages and Reports where needed rather than expanding Description.

    If you are in a newer build of NAV / BC, you also have Item Attributes.

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------



  • 4.  RE: Increasing Description Field Length in Item Table

    TOP CONTRIBUTOR
    Posted Feb 06, 2020 08:51 AM
    You should also consider using the Extended Text option for Items.  You can have this drop into the lines of your orders, which populates in the main Description field.  This makes the report print easier as you don't have to space both the Description and Description 2 fields.

    ------------------------------
    Ben Baxter
    Consultant
    Accent Software, Inc.
    carmel IN
    ------------------------------



  • 5.  RE: Increasing Description Field Length in Item Table

    Posted Feb 06, 2020 11:48 AM
    I get it
    Thank you for reply
    Now it'ts very clear for me

    ------------------------------
    Abdel DAHMANI
    Dynamics Nav Developer
    Freelancer
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role