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:
How to delete absolete objects - You do not have permission to delete

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.
How to delete obsolete objects - Delete is only allowed for empty 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”).
How to delete obsolete objects - Click on Table

2. Click “Last” button (or Ctrl+End) to jump to the last entry in Object Designer.
How to delete obsolete objects - Click on Last button

3. Click Arrow Down button on the keyboard.
How to delete obsolete objects - Click on Arrow Down button

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.
How to delete obsolete objects - Define ID

5. Click Arrow Up button on the keyboard (this will commit the changes to the database and create an empty object).
How to delete obsolete objects - Click Arrow Up button

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“.How to delete obsolete objects - Import Worksheet Delete Action

Result! Object gets deleted even if license does not have permissions to access that object ID.
How to delete obsolete objects - Deleted

Related Links

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

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


  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.

    • Steve says:

      You could’ve said it nicer but you’re right. I’m having a simular problem: I work for a solution center and we have a new customer who was already using a NAV 2009 R2 version from another solution center. Now, I’m triing to get rid of the obsolete objects somewhere in the 5-Million range. But I can’t create the delete objects because we have no license in that range.

      Your post is only usefull if you want to delete your own objects with a FOB import (instead of manually removing them.)

      • Monika says:

        We’ve got a hint directly from Microsoft how to delete objects outside your own range. You can do this in SQL Server by inserting rows into the Object table. It works really well, we’ve used this a lot of times.

  3. Roger says:

    The answer implies that you can use the import function to delete non-empty TableData outside of your license but that is not true.
    You still get the error stating that it contains data.

  4. Yusuf says:

    this is actually refreshing …as we all learn everyday.
    steve is right…am actually having this problem right now…
    and i still need solution for it.

    whoever has find a solution for this should advise me on what to do.


Leave a Reply

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