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,941 on at

Like (1)

Report

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

thanks for your reply sir..

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

Like (1)

Report

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,243 Super User 2025 Season 2 on at

Like (1)

Report

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

"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,243 Super User 2025 Season 2 on at

Like (1)

Report

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

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