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.
Today I was helping a customer with a problem that seemed quite simple on the surface. She had a data table containing historical customer sales orders (each customer has many orders on different dates). The objective was to filter this table in Power Query and just load one record for each customer – the one that was the last order date. To illustrate the problem more clearly, I have adapted the scenario using the Adventure Works database.
In Microsoft Business Central, there is a way to attach attachments only on Documents or Master Table records. But, what if this requirement is for other tables such as Opportunities, custom tables, etc.
In Microsoft Business Central, there is a way to attach attachments only on Documents or Master Table records. But, what if this requirement is for other tables such as Opportunities, custom tables, etc.
Recently someone asked me if it is possible to programmatically access information from notes and add them on a page or report, so I thought, why not blog about it?
The first thing you should know is that notes are saved in the table: “Record Link“:
I know you all started working with AL development and extension. As you are converting your product or customization every time need to deal with base application code as during C/AL days you already added business logic in required codeunits,tables,pages etc.
I think we all like the Zooming in the classic client and the Help/ About This Page in the Role Tailored client. This extension I created can be easily added to any page that displays records from the database and it will show all fields included in the source table. The source code is available on Github.