Compliance and Efficiency with Business Central and Retention Policy

Many organizations today are incorporating a blend of Dynamics 365 Business Central and Retention Policy into their processes to optimize operations and meet legal requirements. Business Central is a cloud-based platform that enables companies to manage finances, operations, sales, and customer service from one unified system. Meanwhile, a Retention Policy defines the duration for which specific types of data should be stored and when it must be deleted. By merging these two systems into their workflows, businesses can efficiently handle data management while ensuring compliance with industry regulations. Additionally, Business Central and Retention Policy provide greater insight into data, empowering businesses to make informed decisions and improve overall performance.

For assistance in configuring the retention policy in Business Central, we have outlined a step-by-step guide below.

Retention Policy setup process

Setting up a new Retention Policy for the Job Queue Entries
1. Search Retention Policy
2. Click New -> Click three dots …
and select Job Queue Log Entry or enter Table ID 474.

3. Select the Retention period, for example One Month or the retention period you like to retain; this will the enable the process for you once you select the Retention period.

4. If you like to manually run the process you can do so by clicking on Process -> Apply manually.

5. Next Retention Policy requires the following:

6. You need to enable the Table ID 3905 Retention Policy Log Entries. This will clear those logs as well as those that get created from the Retention Policies being run.

7. You can change that from 6 months down to 1 month, though the default is set to 6 months.

8. If you are using the Change Log Entries Table ID 405, you can then set that up as well: this will help you reduce those Change Logs. You may want to keep, at a minimum, a 1-year history on the change log; you can always export them out to Excel to keep the history of any master record changes. If not set up, you don't need to Change Log Entries setup.

How to check if your Change Log Entries are set:

Go to the Change Log Entries page and view if there are any entries as that will then need to be set to clear those entries using point 8.

Beyond following these steps, you can engage our expert consultants to guide you through the process of implementing your retention policy in Business Central. This will entail identifying the data that needs to be retained, creating retention rules, configuring retention schedules, and implementing the policy across your organization. With this policy in place, you can efficiently manage and preserve your business data, ensuring compliance with legal and regulatory requirements. With the help of our team, you can ensure that your policy is correctly configured and effectively implemented, providing your business with the security and peace of mind it needs.

What can you set in the Business Central retention policy?

In Business Central, you can set up a retention policy to manage the lifecycle of different types of data. The policy can be configured to automatically delete various types of data, such as Job Queue Entries, Blob Storages, Change Log Entries, and more, after a specified period. This helps to ensure that your database does not become cluttered with unnecessary data and that your system runs smoothly. By setting up a retention policy, you can also ensure compliance with data retention regulations and avoid any legal or financial risks associated with data retention.

On-demand Webinar

Implementing AI - Organize and secure your data first

Join our team for an insightful webinar as we delve into content management and data security, two pivotal factors for successfully rolling out AI in your organization. Discover how to strengthen your data landscape to seamlessly surface insights using the integrated tools within Microsoft 365.

Register to watch...

Read the full Microsoft Work Trend Index Report

Will AI Fix Work?

The pace of work is outpacing our ability to keep up. AI is poised to create a whole new way of working.

Read more...