How to delete entries from various tables to clean up

(0) Share

Report

Posted on by mbr

5,136

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

All responses (9)

Answers (1)

mbr 5,136 on at

Like (0)

Report

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 23,116 on at

Like (0)

Report

RE: How to delete entries from various tables to clean up

Please do verify answers.
mbr 5,136 on at

Like (0)

Report

RE: How to delete entries from various tables to clean up

ok. 'will try this too. Thanks Alexander.
mbr 5,136 on at

Like (0)

Report

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 5,136 on at

Like (0)

Report

RE: How to delete entries from various tables to clean up

Thank you Jatin. 'will try this tool.
mmv 11,469 on at

Like (0)

Report

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 23,116 on at

Like (2)

Report

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 28,094 on at

Like (1)

Report

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 2,641 on at

Like (0)

Report

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