News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to insert SQL stat...

Small and medium business | Business Central, N...

Suggested answer

How to insert SQL statements for Change log entries to change to the permissions?

(0) Share

Report

Report

Posted on by joshtechsolutions

4,841

Hi Community,

I would like to insert "Some fields" in change log entries for a particular change log ID, as we have many companies, I don't wish to go one by one to every company.

I know that I can insert this in SQL How can I do this?

Thank you!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 82,945 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to insert SQL statements for Change log entries to change to the permissions?

Hi, Very interesting question, the data is stored in table 404 "Change Log Setup (Field)".

For example,

setup.

Open table 404

So, although I haven't tried it, you should be able to import this data using the Configuration Package.

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 691

#2

YUN ZHU 646 Super User 2025 Season 1

#3

Mansi Soni 495

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans