Hi,
First task is to create a new table:
1. Rename the already existing the table name e.g. Employee to Employee - Marked for Removal
2. Create a new table with ID 50001 and name it properly e.g. Employee
3. Copy the fields from 50020 and paste them in Designer of new table. Compile new table.
4. New table is ready.
Next task is to copy data from old table to new table. For this you can use Rapid Start Services (RSS) in NAV.
1. Create a Configuration Package.
2. Add both tables to this Package.
3. Export both tables in excel.
4. Copy the data from old table excel file to new table excel file.
5. Import data to Configuration package for the new table from new table excel file.
6. As both tables are identical there will be no errors.
7. Apply
8. Delete old table
