85
I have prepared a database for production with all setup, but I also use it for test (I posted different documents).
I want to delete all data from posted entries tables. How I can do it on easy way?
I use Dynamics NAV 2009.
*This post is locked for comments
I ever saw a feature like this in NAV 4 SP3, but not in later version.
I have tried it, and prefer to create a Database from the scratch.
You can utilize Data Migration, and always backup your DB after setting up Setup tables, before you use it for testing purposes.
Later, you can restore it, for Production use.
Depends of table you want to delete. More of them require partner license permissions. I guess you want to delete G/L Entry, Item Leder Entry, Customer Entry... If I am in right, these tables surely require partner license permissions.
Why I need a partner license?
You can make a report. In DataItem of this report, you need to fill all tables you want to delete.
For each DataItem, in C/AL editor, in OnPreDataItem(), you need to write DELETEALL;
It is important that you have partner license.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
