Starting from Dynamics 365 Business Central 2020 Wave 2 (v17) administrators can define retention policies for tables to specify how frequently they want Business Central to delete outdated data in tables that contain log entries and archived records (they are essentially a way to define when data on certain tables expires in your database).
Category Archives: Tips & tricks
Dynamics 365 Business Central: How to Customize Drop-Down List (Field Groups)
I got an interesting question today, is it possible to add new fields to the Drop-Down list when selecting items on a Sales Order line? In this post, I will share how to how to customize drop-down List.
How to add item images to the Sales quote report
Not often, but it can be, that a client wants product pics in the lines of a report, e.g. the sales quote is a candidate for that. So the client can present his products in a more convincing way
Business Central Virtual Entities and CDS
In this post we mention the Virtual Entities (in preview mode) that will soon change the approach for integrations between Business Central and Common data services, in addition to the use of Web Services and OData.
Import data with the Excel Buffer
In this video, I show an old favorite, the Excel Buffer. A great way to get data into Business Central. I create a few handy extra functions to make the experience nicer.
Migrating Control Add-ins from C/SIDE to AL
Thanks to everyone who watched my live stream today! The audience wasn’t big, but it’s a very narrow topic, not of broad interest. Still, I am glad I got a few interesting questions that actually introduced my future topics quite nicely.
Analyze data using Query Analyzer in Business Central
Inline Query Analyzer is a tool to analyze data in Business Central. This is an open source project intended to help developers for quick retrieval of data for analysis purposes. You can write SQL like queries to retrieve data. Users can view the query results in Grid and JSON views.