Field No. Change Impact

matias_jaure
matias_jaure Member Posts: 157
edited 2007-08-17 in NAV/Navision Classic Client
Hello!
We need to change Field No. for some columns of SAles Invoice Line table.
But, when we change Field No. , Forms start getting errors. Navision automatically changes the code that references the column, Any idea to avoid it? or any idea on how to change field no without such kind of problems??

Comments

  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    Are you changing the field number for custom fields? Or standard and addon fields?

    Nonetheless, you're going to get that problem if you change the field ID. The form references the field ID so you will get an error.

    The best way to resolve it is to remove the field from the form first, then change your field ID. Assuming you're changing custom fields.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • matias_jaure
    matias_jaure Member Posts: 157
    Alex Chow wrote:
    Are you changing the field number for custom fields? Or standard and addon fields?

    Nonetheless, you're going to get that problem if you change the field ID. The form references the field ID so you will get an error.

    The best way to resolve it is to remove the field from the form first, then change your field ID. Assuming you're changing custom fields.

    Yes, there are costum fields, the main problem is not in the form itself, the real problem is in the code behind the forms and in the tables that references this tables
  • Savatage
    Savatage Member Posts: 7,142
    Just curious - what are you changing "No." to "Item No."??
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • matias_jaure
    matias_jaure Member Posts: 157
    Savatage wrote:
    Just curious - what are you changing "No." to "Item No."??

    No!, just custom fields ... > 50000
  • kine
    kine Member Posts: 12,562
    1) All reference are coded through Field No. internally in all objects. It means, if you renumber field, you have big problems.
    2) All reference are coded through Field name if you export the object into text file and import it back
    3) It means, if you export all objects before renumber, after that you can renumber the field and import the text file back (excluding the object you changed or you must change the field no. in the text file too) and compile the objects, the reference will be corrected in all objects if you just change the no. and not name of the field.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Mohamed_Zayed
    Mohamed_Zayed Member Posts: 39
    Hi Kine, Can you please give more details to step no 3. i am facing the same issue bit in a bigger problem.
    See my post:
    http://forum.mibuso.com/discussion/68536/renaming-fields-ids-in-navision-tables-effects-on-other-objects/p1?new=1

    Thanks,
    Zayed

Categories