40
Hello,
other than Object Designer's date & Time Fields, how can we trace the changes in the NAv Objects. We have MS partner who do the changes at their end but when they import the object to our live environment it carries the same date and time when it was last modified in their DB and sometime they change the time to 12.00.00 Am to comply with standard. but how we know that this changes are imported when to our DB? is there any way to know using NAV or SQL?
*This post is locked for comments
Hello Ali,
An old post, just came accorss it and wanted to inform you that you also can use the tool Source Control from NAVToolbox.com - it can be setup in just 5 minutes and dont require any additional NAV/BC license or objects.
Check www.NAVToolbox.com for more info and free trial.
I'm working at an ISV and we are using a selfmade sql code placed as a trigger on the table dbo.Object.
The trigger will create a record in a special HistoryObject table in NAV, and the record will have a BLOB of the changed object. This way we are always able to compare each and every object change. Menusuites are not logged.
I know this is maybe to much for your need, but just to illustrate the possibilities with a sql trigger :)
Hello All,
I agree that requirement is not common. But Since there is a possiblity that we can directly modify the object on Production and also change the date and time and modify flag on objects, so these seems a bit odd that there is no way in Dynamics NAv that we can track such changes like we for data.
Dear Ali Asghar ,
while agreed with Alexander Ermakov's comment
let me give you some comments
your requirement is not a technical thing its a general business practice(your partner must responsible for this )
Its the genuine way of handle Object Desiner - Development environment modification
your partner should have a ability to maintain these filed( Date/Time / Table lock by / name/version list ) update by your vendor or you to having general business practices
If you now ask for some solution to track changes, it is an alarming sign that the processes your partner is applying are not healthy as such. I agree with Jonathan, as it is more correct to build up a correct update process with your partner, ensuring you have test environment where the changes are tested before going to production, and keep versions of objects before and after the upload of changes. Also, remember to use backups.
as amol and dmitry described, there is no out of the box object change tracking in nav standard.
what you need is a defined update process.
best you contact your nav partner, describe your needs, clarify the problems. seems that these necessary coordination steps were not done. setting the objects time to 12:00 is a standard process defined by microsoft. you are right, that can be irritating. so tell your nav partner you prefer not setting the time to 12:00. also, more important, you need a notification, before your nav partner imports updates. i hope, your nav partner uses a ticket system to have a chronology of the communication and changes. always check, if your nav partner updates the documentation trigger, so you can check, what kind of changes were done. if you do not have a developer license you need the nav objects's change description as mail or within the ticket in the ticket system or as text file. otherwise you do not have any information about the changes.
if your nav partner does not help you in that case, think about changing the nav partner.
You cannot do autologging of modifications inside NAV (at least now) , but you can trigger Object table in SQL.
Also check this tool. It can help. But test it before, because in some databases it failed with error when you try to modify any object.
For tracking the changes in object you need to open the object in design mode and can check the comments added against the code changes
You need to export the new object and old object in txt file and compare it using beyond compare or Araxis.
For this you need to have developer license.
#1
André Arnaud de Cal...
291,642
Super User 2024 Season 2
#2
Martin Dráb
230,371
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
