I needed to renumber objects for Skyrr Payroll addon and found on Mibuso an old renumbering tool.  I downloaded it and installed.  I corrected the bug and created an import function for Excel worksheet.

The Excel worksheet has the object type in column A, object ID in column B, object name in column C, object caption in column D and the object new ID in column E.  The first row is the header row.  I simply copied my object list from Object Designer and worked out my new ids in Excel.

After importing this Excel worksheet I have a list of new and old IDs in NAV.

If any of the new IDs is an old ID, you will need to renumber first from the old ID to temporary ID and then do another renumbering to the new ID.

I create two sheets in my Excel workbook to solve this.

This renumbering tool does not support Pages and I did not need that support in this case.

Renumbering Tool Source Code

8 thoughts on “Renumbering tool for Dynamics NAV Objects

  1. Jens Glathe says:

    Hi Gunnar,

    thank you for posting the source code… I have created a version which includes pages (and is faster :). Do you mind if I post it back on mibuso.com?

    with best regards

    Jens

    1. Sure, please do.
      I would appreciate the link to the new version.

      Regards,
      Gunnar Þór

  2. Anton Modaresi says:

    I’d apprecaite the link to the new version as well =)

    1. anton modaresi says:

      thanks Gunnar 🙂

  3. Anton Modaresi says:

    Hmm variables with nordic chars end up unreadable in 5.01 text export. tough cookie !

  4. Great Tool, but it did’nt correct table-relations..

  5. Thank you Johannes. Have you tried the new version ?

Leave a Reply

%d bloggers like this: