Simple Project in Dynamics 365 Business Central - AL Programming

Introduction

In this blog, I will show you to create a simple project using AL programming in Dynamics 365 business central. This project consists of one table, two pages and one RDLC report. The pre-requisites are 

  1. Visual studio code (installed and configured with BC in your system)
  2. Business Central login credentials (for on-prem)
  3. Report Builder installed in your system for RDLC report.   

Table
Dynamics 365 Business Central stores data in tables. Data will be recorded in a table regardless of how it is registered in the product - whether it is via a web service or a finger swipe on a phone app.

Table Snippet

Table Snippet
Table Student: Code

Table Student: Code

Page
The main method of displaying and organizing visual data in Dynamics 365 Business Central is through pages. The user interacts with them primarily and they behave differently depending on the type. This allows a single page to be repurposed across phones, tablets, and web clients regardless of the device they are rendered on. There are many types of pages. In this project, I have created two pages, a card and a list.

Page Code: Card
Page Code: Card
Page Code: List

Page Code: List
Report
A report displays or prints information from a database. A report is useful for structuring and summarizing information, as well as printing documents.

Page Code: List


Code Execution

In the launch.json, give the object ID and type of the object. Press Alt+F5 to execute the code. The student. rdl will be automatically created in the file explorer (Visual Studio code).
Open the RDL report and format the report based on your requirements. Save the report format and close it.

Go to Business Central, click the search icon, type Student select the report and analysis and click Preview and close. 

You can view the report as per the format you have created.




If you really like it, like, share and comment the blog.







Happy coding.

Comments

Post a Comment

Popular posts from this blog

Learning Path: Business Central Technical Consultant | Dynamics 365 Business Central

Top Business Central Interview Questions for Technical Consultants: Tips and Strategies for Nailing Your Interview

Table in Business Central