This is what happens in the video
Business Central includes a change log that lets you track changes to specific tables in your system. You activate and configure it in the Change Log Setup page. You decide which tables to track, whether to log insertions, modifications, and deletions, and which fields to include in the log.
To track changes on the Customer table, open the Change Log Setup, select the table, and choose to log on insert, on modify, or on delete. You can track all fields or only selected fields, such as the customer number, name, address, and city. After configuring the tables and fields, you must activate the change log for it to start recording entries.
What the change log in Business Central does
The change log is a way to track any changes made to specific tables in your system. It records what happened, so you can see when records were created, edited, or removed and what the values were.
You set it up by searching for “change log” in Business Central and opening the Change Log Setup. From there you choose which tables you want to monitor.
Choosing which tables and actions to log
For each table you can decide which actions to track:
- Insert – logs when a new record is created, for example a new customer.
- Modify – logs when an existing record is changed.
- Delete – logs when someone in your company removes a record.
As an example, on the Customer table you can set up logging on insert, on modify, and on delete. That way, if a customer is created, edited, or deleted, you will see it as a log entry.
Selecting which fields to track
You can log changes on all fields on a table or only on selected fields. To pick specific fields, open the assist edit and choose the fields you want to track.
For instance, on the Customer table you might choose to track the number, the name, the address, and the city. When a new customer is then inserted, the log will show the number, name, address, and city.
Activating the change log
Configuring the tables and fields is not enough on its own. Once you have set everything up, close the setup page and activate the change log. Until you do that, no entries are recorded.
Q&A
What is the change log in Business Central used for?
The change log lets you track changes on specific tables in your system. It records insertions, modifications, and deletions so you can see when and how records were changed.
How do you set up the change log in Business Central?
Search for “change log” and open the Change Log Setup. Select the tables you want to track, choose whether to log on insert, modify, or delete, and pick which fields to include. Then close the page and activate the change log.
Can you track only some fields on a table?
Yes. You can log changes on all fields or only on selected fields. Open the assist edit on the table and choose the specific fields you want to track, such as number, name, address, and city on the Customer table.
What actions can the change log record?
It can record insert, modify, and delete actions. Insert logs new records, modify logs changes to existing records, and delete logs when a record is removed.
Why does the change log not record any entries after setup?
The change log only records entries once it is activated. After configuring the tables and fields, you must activate the change log for it to start logging.