Check Transferfields

NAV uses the TRANSFERFIELDS command to copy data from one table to another. When there are conflicting field types or field length in this tables you will get an error like this.

Transferfields Error
Transferfields Error


To check if you have any of these conflicting field types in your database you can use the Check Transferfields page.

Initialize Transferfields Tables

There are two methods to populate the tables to check. The first one is to use the option Initialize Tables. This option fills in the tables that uses the transferfields command in a default Cronus database. If you have customization's in your database it is better to use the option Get Tables from Where Used. This option search your where used base for the transferfields command.

Initializing Tables
Initializing Tables

Transferfields Conflicts

Whenever there is a conflict between table fields, drilldown to the "No. of Errors" column to see which fields cause this conflict. There are two types of conflicts. Warnings are fields that exist in one of the tables but miss in the other. This can be done for a reason, but sometimes it is simply forgotten to add the field to one of the tables. Conflicts of the type 'error' have to be fixed always.

Analyzing Conflicts
Analyzing Conflicts


In the above example you can see that there is a conflict between table Customer and the Contact table. When you drilldown the No. of Errors column you will see which fields cause this conflict.

Apply Differences on Dest. Table

You can create missing fields in the destination table or update existing fields if they have conflicts. Select the lines of the fields which you want to transfer to the destination table. All conflicts would be solved in your database. The Apply Differences with C/AL Code function also copies the C/AL code from the OnValidate and OnLookup triggers of the source fields to the destination fields.