When we talk about reporting and analytics it’s no longer just the world of RDL and Word Report layouts or Power BI. We have Excel Report layouts, Ad-hoc Data Analysis with queries and page Analyze Data feature. This blog post will focus on how to use a query when building out your report dataset.
Read More »
The new October, 2024 release for Visual Studio Code is pretty magnificent for Business Central Developers. ✨ This blog post is going to be dedicated to working with Copilot Edits in VS Code.
Read More »
A query object is used to collect and read data from Business Central. The data will always be retrieved from SQL, meaning that you may not get the dynamic data that is currently in the middle of being processed. What makes a query object more powerful than reading from a table object is the ability to join multiple tables in one “dataset”.
Read More »
When using templates to create AL objects for MicrosoftDynamics 365 Business Central, there are often many properties that are listed by default. If they are part of a template, then they must be important. So one question I had from new developers is what is a UsageCategory, and why should we be setting it.
Read More »
So you want to develop custom code for Microsoft Dynamics 365 Business Central? The code for BC is written in AL, which stands for “Application Language”, and is a specific language only used for Business Central. To start writing AL code, you need to make sure you have Visual Studio Code installed, along with the AL Language extension for Microsoft Dynamics 365 Business Central. If you need more information on setting up your development environment, check out this blog post. At this point, we are ready to create our first AL project!
Read More »
You have an AL project that you want to work on within your new container. How exactly do you connect your code to your container BC instance? It’s pretty easy!
Within your AL Project you should have a .vscode folder, with a file called launch.json This is a configuration file that is used to define settings for launching and debugging applications. The following configurations should be set to work with a Business Central Container:
BC Development Notebook 