Tracking function execution
malintus
Member Posts: 32
Hi,
I have an issue with deleted header of production orders. Probobly it's made by some custmization but it's hard to find which one. My question is how to set up some tracking/logging in for example OnDelete trigger in table when this trigger is executed. Is it even possible to set up tracking this way in NAV?
Regards,
Malintus
I have an issue with deleted header of production orders. Probobly it's made by some custmization but it's hard to find which one. My question is how to set up some tracking/logging in for example OnDelete trigger in table when this trigger is executed. Is it even possible to set up tracking this way in NAV?
Regards,
Malintus
0
Answers
-
Hi,
You can use "Change Log Entry" table.
https://docs.microsoft.com/en-us/dynamics-nav-app/across-log-changes0 -
Log Entry just show me which record was changed - I already know that but what I do not know is what process/function did that. BTW delete only header of production orders cannot be done by user. It can be done only from development (user do not have license to do that), some function, or from sql (user do not have access to sql). I am not able to find which function made that because deletion happens time to time, twice a month or something like that and I dont know why.0
-
Are you talking about table 5405 Production Order?
There is no license limitation to delete records from this table - users can do this from interface.
Can you see in change log information about deletion of prod. orders?
If yes then it is done by some nav function and you have to analyze code in nav.
You can use the following tools for this:
https://mibuso.com/downloads/gdt-where-used-tool
https://mibuso.com/downloads/statical-prism-ce
https://mibuso.com/downloads/code-coverage-k3
Maybe, you can find something useful from this article:
http://vjeko.com/detecting-current-object-type-and-id-using-some-funky-net-interop/
If there is no information in change log then you can make trigger on sql and log who and when deletes data. But you will not be able to understand what procedure do this.
And keep in mind that when prod. order is being finished, it's being deleted and inserted with new status.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions