Notifications
Announcements
No record found.
How can you know which user deleted which data in dynamics nav ?
*This post is locked for comments
Muleso,
You can setup Change Log, if you want to track the log of particular records.
It is good to track Master data else for transactional log, performance will get an impact.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
You don't know unless you enable change log. If you need to know that kind of information you need to enable change log. Please check the below link for more information,
www.archerpoint.com/.../setting-change-logs-microsoft-dynamics-nav-2013
There are limited options of deleting the data in NAV itself, and users cannot delete posted data - mainly master data or unposted documents. For those, you can setup standard chang log: msdn.microsoft.com/.../hh169208(v=nav.90).aspx
Change log would not work if someone would delete data directly in the SQL database. To log these, you need to use SQL tools.
Dear muleso ,
As i know Dynamics have give less priority for user controls , so that you don't have any direct access or any program to view these kind of user changes.
there are some several ways to track these kind of issues
1. Change log entry
this program can be recorded every single changes that has been done to system , but enabling and using this will effect (enable change log entry to multiple) data base and system will get stuck when u try to view(u can view but take time)
Note : if you didn't enable this to relevant program yet , so sorry u cannot view previous data
2. User permission set
maintaining permission set you can capture the user group , but you cannot capture exact person who delete it
3. DB level
strongly recommend if you don't have knowledge to database level and Dynamics development , Please get help from your organization experts
you can go for the tables and find exact table code , go to db and check whether about the changes
Please verify the answer, if it helps to resolve your issue.its might be help to others
You can activate change log for recording activities from user
I do think Dynamics NAV have a good security system and a good tracking system as well. It is all about how it is been set up. Any good system will look bad if that has been setup incorrectly.
If the Permission Sets, User Personalization, Change Log, NAV Service, SQL DB, security is setup "properly" then NAV will be a very secure system. Plus client license MUST use.
Coming back to the question : If the client license is used for the DB then system will not allow any user to delete posted transactions, any if a any master has open entries then those masters will not be able to delete.
If the change log is activated, then any change happen in the Dynamics NAV (up to field level) can be track back easily.
However, when activating the change log it is very necessary to consider the performance of the system.
Any step to step guide ?
This was insightful
Please check below links, if those of any help to you.
https://msdn.microsoft.com/en-us/library/hh169208(v=nav.90).aspx
http://www.archerpoint.com/blog/Posts/setting-change-logs-microsoft-dynamics-nav-2013
-Yogesh KulkarniPlease verify, if you find answer helpful.
refer Yogesh Kulkarni both link if you need to check step by step guidance how to use it
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
