Adding custom table to retention policy list page

(7) Share

Report

Posted on by WilliamSchroeder

Greetings!

I have a custom table (ID=60100) that the client has asked we add to the retention policy list page (ID=3903). We have added the table via the Reten. Pol. Allowed Tables codeunit via the AddAllowedTable method but the table does not appear in the list page. What are we doing wrong?

The code snippet is below. Custom table 60100 is HSCI01Change Log Entry. We have tried the method call with and without specifying the date field that triggers data retention.

var
        bRetVal: boolean;
        oRetentionPolicy: codeunit "Reten. Pol. Allowed Tables";
        oChangeLogEntry: record "HSCI01Change Log Entry";
    begin
        bRetVal := oRetentionPolicy.AddAllowedTable(Database::"HSCI01Change Log Entry", oChangeLogEntry.FieldNo(SystemCreatedAt));
    end;

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, Please refer to the Microsoft standard document below.

Include your extension in a retention policy (requires help from a developer)

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 12,766 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Call AddAllowedTable inside an Install codeunit (OnInstallAppPerCompany), then reinstall the app.
Your table will then appear in the Table ID lookup when creating a new retention policy, it won’t auto-add a row on the page.

Regards,
Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
WilliamSchroeder 62 on at

Like (0)

Report
Copy link

Link copied!

I think my issue is that the New button is not enabled on the Retention Policies page. I am a delegated admin with SUPER rights...Is that why I cannot add a new table to the retention policy list?

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

Like (1)

Report
Copy link

Link copied!

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

Include your extension in a retention policy (requires help from a developer):
Clean Up Data with Retention Policies - Business Central | Microsoft Learn

Dynamics 365 Business Central: creating retention policies from AL – Stefano Demiliani

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Delegated admins (even with SUPER permissions) cannot create or edit retention policies in Business Central Online. This is restricted to users who belong to the tenant where the environment resides and have the appropriate license.

Delegated admin accounts are for partner administration and do not have full functional rights for features like retention policies.

Thanks

Rishabh

Was this reply helpful? Yes No