Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Tracking NAV objects Changes

Posted on by 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?

  • Jesper Kenborg Profile Picture
    Jesper Kenborg 10 on at
    RE: Tracking NAV objects Changes

    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.

  • keoma Profile Picture
    keoma 32,671 on at
    RE: Tracking NAV objects Changes

    hi tom,

    sounds interesting.

    please describe that feature in a blog post on your companys blog.

    is that available as product/module ?

  • RE: Tracking NAV objects Changes

    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 :)

  • Suggested answer
    Ali Asghar Profile Picture
    Ali Asghar 40 on at
    RE: Tracking NAV objects Changes

    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.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Tracking NAV objects Changes

    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

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Tracking NAV objects Changes

    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.

  • Verified answer
    keoma Profile Picture
    keoma 32,671 on at
    RE: Tracking NAV objects Changes

    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.

  • Suggested answer
    dkatson Profile Picture
    dkatson 2,263 on at
    RE: Tracking NAV objects Changes

    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.

    mibuso.com/.../navision-audit-sql-script

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Tracking NAV objects Changes

    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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans