How to Delete Obsolete Dynamics NAV Objects?

Recently, I was asked how to remove obsolete Dynamics NAV objects. Client was trying to delete one old object (I have recreated this scenario on my local CRONUS database to show you an example), but getting error message saying You do not have permission to delete the table:
6378818561 799d685476   How to Delete Obsolete Dynamics NAV Objects?

And, fair enough, the object was not in the licensed range of client’s license. Therefore, I suggested to use Delete Action in the Import Worksheet. However, if you will try to do this, you might get another error message saying Delete is only allowed for empty objects.
6378861511 0b090d8c98   How to Delete Obsolete Dynamics NAV Objects?

So, in order to resolve this issue, what question would you ask next:

  1. Can we temporarily change license to developer’s license and delete the object?
  2. Or, can we create an empty object and use “Delete” Action in Import Worksheet?

Well, the next time you will need to remove an obsolete Dynamics NAV object, you will be able to ask the second question (and you will have an answer for it)!

How to create an empty Dynamics NAV object?
Firstly, connect to a database, where this object does not exist (usually, default CRONUS database works really well). Then follow the steps below:
1. In the Object Designer, click on the object type (in our example, we need to delete table, so let’s click on “Table”).
6378959619 c54d0d8c6b   How to Delete Obsolete Dynamics NAV Objects?

2. Click “Last” button (or Ctrl+End) to jump to the last entry in Object Designer.
6378959907 df6a151cac   How to Delete Obsolete Dynamics NAV Objects?

3. Click Arrow Down button on the keyboard.
6378960071 e1fec3c0db   How to Delete Obsolete Dynamics NAV Objects?

4. Click on the “ID” field and click F2. This will make the field editable. Enter object ID which you need to remove. Also, if you want, you can define the “Name” and other fields.
6379003915 0271a8b2d7   How to Delete Obsolete Dynamics NAV Objects?

5. Click Arrow Up button on the keyboard (this will commit the changes to the database and create an empty object).
6379004173 6cd597546d   How to Delete Obsolete Dynamics NAV Objects?

All you need to do now, is to export the object as a FOB file and import it back to the database where you want this object to be deleted. Then, in Import Worksheet, you will be able to select action “Delete“.6379004291 ba3a4851a0   How to Delete Obsolete Dynamics NAV Objects?

Result! Object gets deleted even if license does not have permissions to access that object ID.
6379004355 ce7328de43   How to Delete Obsolete Dynamics NAV Objects?

Related Links

Technorati Tags: , , , , , ,

This entry was posted in Dynamics NAV / Navision, functionality and tagged , , , , , , . Bookmark the permalink.

3 Responses to How to Delete Obsolete Dynamics NAV Objects?

  1. Mark Brummel says:

    This is brilliant. :)

    Never new this could be done, thanks for sharing…

    /Mark

  2. Yeah right. says:

    This is actually pretty crap. You create here 70000 but try to create something like 1000000 and it won’t work. You will get permission error when you push up button. So it basicly works only for objects that you have permission anyway w/ developer’s license. Tested on 5.00 and 2009R2.

Leave a Reply

Your email address will not be published. Required fields are marked *

* Copy This Password *

* Type Or Paste Password Here *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>