Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Audit Trial for Accoun...
Small and medium business | Business Central, N...
Suggested answer

Audit Trial for Account Creation

(1) ShareShare
ReportReport
Posted on by Community member 2
Hey,
 
I was wondering if there was a way to track who created a new customer card/account?
 
Almost everything else, like Invoices and credit memos have USER-ID to it which makes it easy to check who created them.
 
Using Nav 2018.
 
Thanks.
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,941 Super User 2024 Season 2 on at
    Audit Trial for Account Creation
    You would need to activate Change Log. 
    Open Change Log Setup , then go to tables and choose all the tables and fields You would like to monitor. For example customer card - table 18, would need a monitoring on Insert part only Customer No., and Modify/Delete - all the other fields that are important. 
    Then in the "Change Log Entries" page You can filter out by the Table No. and afterwards by Primary Key values to see who and when inserted or modified records.
    This will work only for future modifications and history You cannot get.
     
    additional note is that this table can grow pretty quickly, so keep a track on the size of it and decide on Retention policy (which You can also set up in Business Central), or in NAV version You have a process Delete change Log Entries-  where You can provide filter on date and/or Table No. to delete those records which are not needed anymore (like 1year old entries, or processed document logs etc).


    Some more info with pictures found here (or google):
    ​​​​​​​Dynamics NAV Consultant | Understanding the Dynamics NAV Change Log (redthree.com)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on at
    Audit Trial for Account Creation
    Unfortunately, there is no such function in NAV2018, unless you use the change log, it cannot be tracked.
     
    PS: In Business Central 2020 release wave 2 and later, Microsoft added Data audit fields to all tables.
     
    Hope this helps.
    Thanks.
    ZHU

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans