Renaming fields IDs in Navision tables & effects on other Objects

Mohamed_Zayed

Problem:

Now we found that one of our Programmer have given new Fields IDs in NAv_2016 for all our new fields which are coming from Nav_2009.

What we want to have :

We want to maintain the same fields IDs in our new Nav_2016 with the same Fields ID like Nav_2009.

Our Concerns:

Now the question is if we changed all tables fields numbers what will happen:

I want to prevent wrong field mapping. for example I am afraid that a code field will not be mapped to another code field and Navision will not complain! If this happened this will destroy all our work which we did in the last 6 months.



What is the best way to changes the tables fields ID without destroying our work?

Mohamed_Zayed

Solution:

1. Export all your objects, change field ID in Text file and import.
2. Export all objects (exclude the tables in which you are going to change the field id's) and change field id's in table (dev), import the objects.
take backup of your objects before do these steps.

Kishorm

Mohamed_Zayed wrote: »

Solution:

1. Export all your objects, change field ID in Text file and import.
2. Export all objects (exclude the tables in which you are going to change the field id's) and change field id's in table (dev), import the objects.
take backup of your objects before do these steps.

Only do this if you don't mind losing the data in the fields you are renumbering. If you do need the data then you will need to handle that too (e.g. by creating temporary tables and creating upgrade codeunits)

Mohamed_Zayed

Solution:

1. Export all your objects, change field ID in Text file and import.
2. Export all objects (exclude the tables in which you are going to change the field id's) and change field id's in table (dev), import the objects.
take backup of your objects before do these steps.

Kishorm

Mohamed_Zayed wrote: »

Solution:

1. Export all your objects, change field ID in Text file and import.
2. Export all objects (exclude the tables in which you are going to change the field id's) and change field id's in table (dev), import the objects.
take backup of your objects before do these steps.

Only do this if you don't mind losing the data in the fields you are renumbering. If you do need the data then you will need to handle that too (e.g. by creating temporary tables and creating upgrade codeunits)