Does anybody know if there is a tool that would put all the ledger entries and registers back to blank so we can copy an existing company in a new one without the transactions?
*This post is locked for comments
Hi,
I ran into problems when I tried to delete tabledata in 2013R2. As it turned out, there is a bug in the "table information" object that prevented my report from finishing... whoopsie. Thankfully I got some help from Microsoft with this and we found a workaround. I have attached the object, you can take ist as a template. All warnings from Aleksandar apply to this one, too. :)
with best regards
Jens
https://community.dynamics.com/cfs-file.ashx/__key/communityserver-discussions-components-files/34/4606.report_5F00_0005274900.txt
The better solution is to prepare configuration packages and then migrate these data to the new database or company.
But, if you must to delete data from ledger and other tables, you can do it using 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;
You need to be carefully with this and important thing is that you must use partner license for this process.
Not exactly a tool to delete transactions, but what I have started doing for NAV 2013 is to use the configuration packages to do what I think you want to do.
It takes a day or two to set them up, but once you have them you can reuse them.
If you create one for the Setup tables and one for the Master data tables, then instead of deleting transactions, you can extract everything except the transactions and import it back into a new company.
Just a thought. I think it works ok, if you have large amount of master data records then it could be a bit slow.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (