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

Delete Change Log Entry without using Retention Policies

(7) Share

Report

Posted on by Peter Nguyen

102

Hello,

Could I use Code Unit to delete some record in Change Log Entry Table (405) directly without Retention Policies function ?

If it is possible, are there any notes when deleting directly record in Change Log Entry table ?

Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Pallavi Phade 3,565 on at

Like (3)

Report

Delete Change Log Entry without using Retention Policies

Namaste @Peter Nguyen

You can delete change log entries , but if records are huge then it will be get into deadlock . Would suggest deletion in batches .

Warm Regards

Pallavi Phade

Was this reply helpful? Yes No
Peter Nguyen 102 on at

Like (4)

Report

Delete Change Log Entry without using Retention Policies

Thank you Pallavi Phade

I will set filter when delete the records.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,103 Super User 2025 Season 2 on at

Like (4)

Report

Delete Change Log Entry without using Retention Policies

As mentioned there's no problem deleting them using a codeunit.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,520 Super User 2025 Season 2 on at

Like (3)

Report

Delete Change Log Entry without using Retention Policies

Any specific reason to ignore Retention Policies?

You can delete there's no any linking for change log so no complain from system side.

On NAV 2013 version's I have used SQL to delete change log on a strict filter basis.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 24,814 Most Valuable Professional on at

Like (4)

Report

Delete Change Log Entry without using Retention Policies

Hi, good day
I hope this can help you, and give you some hints.

Business Central 2025 wave 2 (BC27): Truncating table data with new AL method (procedure Truncate) | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 4,242 on at

Like (3)

Report

Delete Change Log Entry without using Retention Policies

Hello,

Yes, you can delete Change Log Entries (table 405) with your own codeunit.

BC doesn’t block it.

But:

It bypasses Retention Policies and audit logging.

Only delete from table 405, never from the Change Log Setup tables (402–404).

Do it in batches for performance if the table is large.

So: technically allowed, but use carefully.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,075 Super User 2025 Season 2 on at

Like (3)

Report

Delete Change Log Entry without using Retention Policies

Hi, No problem, even posted data can be deleted through Codeunit.

And hope the following can give you some hints.

Business Central 2021 wave 2 (BC19): Data archive extension (Data Archive List page)

https://yzhums.com/19180/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,608 Super User 2025 Season 2 on at

Like (2)

Report

Delete Change Log Entry without using Retention Policies

Hello,

Yes, you can delete records from the Change Log Entry table (405) directly using AL code in a Codeunit.

Direct deletion can impact compliance and auditing, cause performance issues if done in bulk, and should only be performed with proper permissions and after taking a backup. It’s best to apply filters (e.g., date range, Table ID) and delete in batches to avoid locking

1 people found this reply helpful.

Was this reply helpful? Yes No