Tracking function execution

malintus

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

AlexDen

Hi,

You can use "Change Log Entry" table.
https://docs.microsoft.com/en-us/dynamics-nav-app/across-log-changes

malintus

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.

AlexDen

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.

malintus

Thank you @AlexDen. I will check all of yours suggestions and let know.