Field No. Change Impact

matias_jaure

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??

Alex_Chow

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.

matias_jaure

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

Just curious - what are you changing "No." to "Item No."??

matias_jaure

Savatage wrote:

Just curious - what are you changing "No." to "Item No."??

No!, just custom fields ... > 50000

kine

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.

Mohamed_Zayed

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