When working with table data, there will be times when we need to retrieve a unique record value from the table (also called SELECT DISTINCT). Unfortunately, D365 Business Central does not provide this logic out of the box. We will need to find a way to do this ourselves.
Category Archives: Tips & tricks
Dynamics 365 Business Central: How to set default Freeze Pane via AL (FreezeColumn Property)
Today I would like to talk about how to set default Freeze Pane via AL in Business Central.
As you might know, we can set/clear Freeze Pane in a list via Personalization.
I’m asking the questions around here in Business Central!
In this video, I go explore how to ask a user a simple yes/no question. Check it out:
Working with SOAP API and XML in AL. Generic API codeunit.
The purpose of this post is to learn the basics of working with XML and SOAP in AL. Besides, we’ll look at my suggestion of the generic API method SendRequest(), which fits most APIs without authorization. The authorization itself is not difficult to add to the general logic, but in the post, they are not considered due to their large number and often unique logic
AL for Beginners – Workbook Version 2.0 (free)
Finally (and it took a while), I can release version 2 of my workbook which I hope will help new developers to start developing in AL.
How To Create Recurring Invoices In Business Central
In this article you will learn how to create recurring invoices in Microsoft Dynamics 365 Business Central. We will learn how to setup recurring sales and purchase lines. Finally, we will see how to use a tool to automatically create Recurring Sales Invoices.
MS365BC JSON Viewer FactBox
In my daily work I often encounter interfaces and web services of any kind. Whether inbound or outbound, they usually use some kind of payload in the form of JSON these days. No matter if it’s the outgoing object or the response of the web service.