Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to delete entries ...
Microsoft Dynamics NAV (Archived)

How to delete entries from various tables to clean up

(0) ShareShare
ReportReport
Posted on by mbr 5,130

Hello.  We created a new Company within the same Nav DB.  Because this company is very similar to our existing company and we don't want to lose any setup info, we copied from Existing Company into the new company.  Now, we want to clean up this new company so informations such as Items, Purchase Orders, Sales Orders, Posted Tables, etc.  Do you know of an easy way to delete these records?  I could write transact sql scripts but these will not run the triggers in the target tables as they are bound to the Nav objects, not SQL server tables.  Any ideas would be welcomed! :)

*This post is locked for comments

  • mbr Profile Picture
    mbr 5,130 on at
    RE: How to delete entries from various tables to clean up

    Hi Tharanga.  Absolutely.  I  plan to test all the tools and update you guys with what worked.  Thank you in advance.

  • Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: How to delete entries from various tables to clean up

    Please do verify answers.

  • mbr Profile Picture
    mbr 5,130 on at
    RE: How to delete entries from various tables to clean up

    ok.  'will try this too.  Thanks Alexander.

  • mbr Profile Picture
    mbr 5,130 on at
    RE: How to delete entries from various tables to clean up

    Hi Mahesh.  This was my original approach.  But then there were more setup files that we may not know of yet and would require more research.  So plan B was to just copy from the source and then clean up the user data.  if the suggestions from other partners do not work, I will revert back to just importing the setup files and we would just need to go through the growing pains of figuring out what other tables we need to import.

  • mbr Profile Picture
    mbr 5,130 on at
    RE: How to delete entries from various tables to clean up

    Thank you Jatin.  'will try this tool.

  • mmv Profile Picture
    mmv 11,467 on at
    RE: How to delete entries from various tables to clean up

    Hi,

    Importing the setup data is the right approach instead of deletion.

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: How to delete entries from various tables to clean up

    Hello,

    Without copying the entire company, why don't you just create a new company and then only import the setup data to your new company. In that way you will be in a safe zone. Deleting data from Dynamics NAV is not recommended since how data been stored in Dynamics NAV is bit complex and what you see from surface is not the exact picture behind.

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: How to delete entries from various tables to clean up

    You can theoretically delete the data manually from posting tables, if you understand the structure of the system. But, note, that what Navigate will show you would not be enough - there are more tables that contain posted data. To learn what tables are filled, you can start with checking the database info to see the quantity of records in the tables.

    However, it is recommended to use small cleaning tools that are available. Check e.g. this thread:

    forum.mibuso.com/.../how-to-clean-up-navision-database

  • Suggested answer
    Jatin Patel Profile Picture
    Jatin Patel 2,641 on at
    RE: How to delete entries from various tables to clean up

    Hi,

    Please refer below link. There is a very good Data Deletion Tool by Olof Simren.

    https://community.dynamics.com/nav/b/olofsimrendynamicsnavblog/archive/2014/11/17/record-deletion-tool-for-dynamics-nav-2015

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans