Optimizing Data Management in Business Central using Retention Policies

-

Introduction

Data retention policies dictate which data should be stored or archived, where it should be stored, and for how long.
When the retention period for a data set expires, the data can either be deleted or moved to secondary or tertiary storage as historical data.
This approach helps maintain cleaner primary storage and ensures the organization remains compliant with data management regulations.

In this blog, we'll be covering - 
  1. Retention Policies.
  2. Retention Period.
  3. Record Level Filters for Retention Policies.
  4. Using Custom Tables in Retention Policies.

Pre-requisites

Business Central environment

References

Data Retention Policy

Clean up Data with Retention Policy - Microsoft Learn

Details


In Business Central, we can define Retention Policies based on two main parameters -
The table which is to be monitored and the retention policy.

Retention Policy




Retention periods specify how long data is kept in tables under a retention policy. 
These periods determine how often data is deleted.
Retention periods can be as long or as short as needed.

Applying a retention policy - 
Retention policies can be applied automatically or manually.
For automatic application, enable the policy, which creates a job queue entry to apply it according to the defined retention period.
By default, the job queue entry applies policies daily at 0200, but this timing can be adjusted (refer below screenshot), preferably to non-business hours.


All retention policies use the same job queue entry.

For manual application, use the "Apply Manually" action on the Retention Policies page and turn on the "Manual" toggle to prevent the job queue entry from applying the policy automatically.


We can also exclude or include certain records based on filters.

Deselect the "Apply to all records" this will show a new tab where we can define the record filters.
Every such group can have it's own retention period.


By default, only a few selected tables are shown in the table selection on the Retention Policy page.


If we want to include our custom table in this list, we'll have to do a small customization.

**You cannot add tables that belong to seperate modules, for example "Purchase Header" cannot be added in this list by you. Unless you work at Microsoft in which case you already knew this. **

So here I've created a small sample table.


And I've created an Codeunit with Install subtype where I'm adding my custom table to the allowed tables list.


After deploying I can now see my custom table in the list.


Developers also have the option to set Mandatory or Default filters on the custom tables.
Mandatory filters cannot be removed and Default filters can be removed.
To create a mandatory/default filter - 


Setting the "Mandatory" parameter to true, makes it Mandatory otherwise it's a default filter.

When I add the table ID on the "Retention Policy" I get the following entry created automatically.


If I try to remove the filters, I get the error - 


Conclusion

Thus we saw how we can leverage Retention Policies in Business Central to reduce capacity wastage without heavy customizations.

Happy Coding!


Comments

Post a Comment

Popular posts from this blog

Using Notifications in Business Central via AL

-
Image
Introduction Notifications in Business Central are alerts that appears in the Notification bar based on User actions. Notifications stack up from top to bottom, lasting until the user dismisses them, including those from sub-pages.  Validation errors are prioritized and shown before other notifications. We can use this to alert the user regarding something without taking all the user's notification towards it, in the way messages or errors do. They also have the option to allow Users to make a corrective action by embedding the action button directly into the notification. Let's see how it works. Source Code Pre-requisites Business Central OnPrem/Cloud. References Notification - Business Central Docs Configuration Here, for an example, I've created one simple page which takes two inputs. 1. The message that is to be shown in the notification. 2. The message to be shown after the User clicks on the action embedded in the notification.     And I have two actions which I'l
Read more

Actionable Error Messages in Business Central

-
Image
Introduction Error handling is an important concept in every technical field.  It helps programs deal with unexpected problems and mistakes smoothly.  It makes sure software works reliably and doesn't crash unexpectedly.  Error handling also helps developers find and fix issues quickly, making the software better for users. Plus, it gives users clear messages when something goes wrong, making their experience smoother. It shows that the team has considered the scenario and has measures in place for it indicating a well designed solution. Microsoft has an amazing document which lists the things to keep in mind for writing resilient code. In Business Central, we have try functions to handle errors and error function to show those errors to the Users.  In this blog, we'll learn how we can enhance the error messages so that the Users can resolve the errors themselves or at the very least we can point them towards where the error is. Pre-requisites Business Central OnPrem/Cloud Refe
Read more

Configure Gmail SMTP service in Business Central without "Allow Less Secure" setting

-
Image
 Introduction Business Central has great email features like sending email, editing it with Rich Text, adding attachments, etc, but to send emails, you'll need to connect it with services like Outlook or Gmail. There is no outlook side configuration that is to be done if you are using Microsoft Outlook however if you are using Google's Gmail then there's a litte change that has happened on the configuration end. Starting May, 2022, Google has removed the "Allow Less Secure Apps" settings from the Google Accounts, which was essential is using Gmail to send emails from Business Central. However, to replace that we have "App Passwords" which we can use instead. Also, just something to keep in mind, Google is going to remove this from the "Google Workspace" accounts as well by Sept, 2024 so it would be wise for you to migrate your configurations to use app passwords. Reference 1.  How to Setup Email in Business Central 2.  Google Support - Less sec
Read more