Header Ads Widget

Top Picks

6/recent/ticker-posts

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.

Post a Comment

11 Comments

  1. Wow. Nice information. Expecting more exciting contents from you :)

    ReplyDelete
  2. Good explanation of the content 🙂

    ReplyDelete
  3. Good and useful information

    ReplyDelete
  4. How to pass guid for lookup col for many to one relationship
    LogicalCollection(guid) is not working in d365 sales connect odata

    ReplyDelete
  5. Fantastic article.. Really enjoyed this article post. Cool.
    who is chenzhi

    ReplyDelete
  6. Fantastic article.. Really enjoyed this article post. Cool.
    who is chenzhi

    ReplyDelete

Youtube Channel Image
goms tech talks Subscribe To watch more Tech Tutorials
Subscribe