I need to prepare a customer report in which I need date of creation of customer. Dynamics NAV currently doesn't have "creation date" field in NAV, is there a way I can add that field via development environment? Kindly advise
I need to prepare a customer report in which I need date of creation of customer. Dynamics NAV currently doesn't have "creation date" field in NAV, is there a way I can add that field via development environment? Kindly advise
Thanks Amit, I will try this
Hi,
"Creation Date" field--> Date
and then write code on the
OnInsert() & OnModify trigger of Customer table
"Creation Date" := Today;
Regards
Amit Sharma
www.erpconsultors.com
Thank you NorthW and Yun Zhu. I found an old blog and followed the steps but had an error, I guess it could due to the different nav version
Hi, Yes, you can do it through the development environment.
But as Inge said, this also requires adding some code.
PS: You can refer to the standard feature in BC and add the following four fields.
Data audit system fields are added to every table in Dynamics 365 Business Central
SystemLastModifiedOn
SystemLastModifiedBy
SystemCreatedBy
SystemCreatedOn
Hope this helps.
Thanks.
ZHU
You can add the field. But you will also need to add some code to use that field. So if you are not familiar with the process i recommend you reach out to your partner and have them assist you in this case.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156