I was asked a question recently, whether developers could get Security Groups and Security Group Members via AL. In this post, I’d like to talk briefly about this.
Tag Archives: Group
How to Modify the behavior in the Price List when using the Customer’s Price Group
A short time ago, I had a support case where the customer showed that the Price List was not working correctly.
After a couple of hours, we were able to identify that the problem was that the Sales Order had a “Bill-to Customer No.” different from the “Sell-to Customer No.“, and the Price Lists are triggered with the “Bill-To Customer No.” only.
How to group data in AL? Best practicies. Performance review.
Data manipulation is one of the most trivial things for Navision/Business Central Developer. We are constantly working with data in tables, adding, deleting, modifying, and so on. Today we’re going to discuss data grouping. What does it mean to group data? How do you do it in AL? What is the best and fastest way to do it? I hope we can find answers to all these questions.
Grouping records using a List
I don’t know why, but grouping records in in C/AL in the past had always been a difficult topic to understand for new programmers during my development courses.
In C/AL the best method was using temporary tables, as in the example below, in which I group the Sales Orders by Customer and then I make a loop over the customers I found to make something.
How To: Group in the RDLC Report in Microsoft Dynamics Business Central or NAV
This blog explains how to do grouping in the RDLC Report in Microsoft Dynamics Business Central or NAV. There are two steps involved: designing the data set and using the Report Builder to set the grouping.
Handling Different Granularities In Power BI Using Slicer Groups
With the release of CTP 2.3 of SQL Server 2019 today there was big news for Analysis Services Tabular developers: Calculation Groups. You can read all about them in detail in this blog post:
Posting Group setup enhancements in Microsoft Dynamics NAV 2018
In the previous versions of NAV, setting up Posting Groups can be very confusing and cumbersome for users. Setting up posting groups in NAV 2018 has been simplified by incorporating visual improvements, smart algorithm and better control.