Is there any way to get the last time modified user name and the last modified field in customer table.

(0) Share

Report

Posted on by KaryaNavTech

239

Our requirement is to get the last time modified username and the last modified field, which time, etc? I have created custom fields in customer master, How to meet above requirements?Is there any built-in function ? is so please suggest I am new NAV.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Andrey Baludin 3,943 on at

Like (1)

Report
Copy link

Link copied!

You need to setup change log for this table:

msdn.microsoft.com/.../hh169208(v=nav.90).aspx

Was this reply helpful? Yes No
KaryaNavTech 239 on at

Like (0)

Report
Copy link

Link copied!

thanks for your reply sir..

Was this reply helpful? Yes No
DavidW Azzure IT 50 on at

Like (1)

Report
Copy link

Link copied!

Be very careful when setting up Change Log to only apply it to record changes to the fields/tables you want tracking otherwise it will fill up with transactions very quickly and can impact on performance.

It’s a great tool for recording modifications/insertions/deletions to Customer and Vendor Cards. I like having it enabled on Vendor Bank Account table to see who has modified bank accounts in case anything strange happens as opposed to using a workflow to authorise changes.

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

With simple customization you can achieve this please check the below blog

www.navisionworld.com/.../how-to-find-out-who-createdmodified.html

Was this reply helpful? Yes No
KaryaNavTech 239 on at

Like (0)

Report
Copy link

Link copied!

"Modified By" := USERID;

"Modified On" := CURRENTDATETIME;

Works absolutely fine But how do i get the last modified field "NAME". in my custom field.

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You have to setup change log entry and review the fields, there are validations on fields which will trigger to modify other fields so indirectly it will update other field values when you update a field. Why do you want to get a last modified field name.

Was this reply helpful? Yes No
KaryaNavTech 239 on at

Like (0)

Report
Copy link

Link copied!

As per our bussiness requirement, we need to have a track on customer card, suppose if some user have accidently changed/modified any of the field datas. Thanks again for your answer yes change log entry helped us to meet our requirement.

Was this reply helpful? Yes No