422
Hi, I have test DB where I test new requirements. So, I use to post sales, purchases, ledgers..etc.
Now, i am thinking to clear all the posted entries(ILE,Value entries, GL Etnries .etc).
is there any simple way to do this in NAV 2013R2
Abdul
*This post is locked for comments
Try out this good tool: www.olofsimren.com/record-deletion-tool-for-dynamics-nav-2015 and similar tools.
thank you Amol. fine,, i was wondering if i have to concentrate other parts nav as well when i delete these tables. now, i'll go straight and delete using codes, or the objects as Mahesh advised.
thanks again.
May be you can write code as following in CU or report.
laTableID[1] := 32;
FOR lvLoop := 1 TO 1 DO
BEGIN
ltRecordRef.OPEN(laTableID[lvLoop]);
ltRecordRef.DELETEALL();
ltRecordRef.CLOSE;
COMMIT;
END;
Define variables
Name DataType
ltRecordRef RecordRef
laTableID Integer
lvLoop Integer
Hi Amol, is it okay if i delete those from SQL queries?
or I write simple codes to delete all for those tables in C/AL?
no need to check any linked entries, validations etc.?
Thank you Mahesh & Amol,
And, Mahesh, I hv imported those objects from the link, but i get permission error while
i run that page.
i put permission manually for those as well, still same
this s strange why NAV asks 'execute permission' for table? not for page.
You need to write a code to delete the record from ledger tables.
I don't think there's an easy way out. You need to have a customized solution, perhaps a report.
Below may give you some idea:-
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 (