AL Development 02 - How to Develop New Page in Database?

Hello Reader,

As we know to develop any solution in Business Central we must start working on AL Code Extension so from this blog you will get to know the detailed step how to create a page through AL Code in business Central.

Requirement: Need to create a new page to Insert, Modify, Delete the data from table.

Let’s Start the process:
Right Click on the left panel and select New File
My file name is My_PageList.al

Code Snippet for adding a new page, use snippet tpage as shown below:

As we select the tpage it will automatically generate a basic page design layout as below:

Now we must assign a page id and page name as per our naming convention which we are using along with this we need set some other properties as per below:
• Set ApplicationArea to All.
• Set UsageCategory to Lists (If it is a list type page)
• Set Source Table to "TestTable”.

1. ApplicationArea - Based on Application area the user can see those in the application. It Sets the application area for a searched page or report in the web client. Standard values are All, Basic, Suite, and Advanced.

Below are things that will require this property

1. Page
2. Page Field
3. Page Action
4. Report
5. Report Request Page Fields

2. UsageCategory -
Option: None, Lists, Tasks, ReportsAndAnalysis, Documents, History, Administration.
This property Sets the department column for a searched page or report in the web client. As there are no menusuite in web client UsageCategory used to set where these custom objects in Web Client Menu.
List page is mainly divided into two parts:
1. Layout Section: It has 2 sub parts
1.1. Repeater Group List of fields
1.2. Factbox Area which contains factboxes

2. Action Section: It contains all the actions that you want to add on the page actions.

You can add other fields in the page using snippet tfield. Also, to show how to add factbox I have added MyNotes Factbox. Below is the screenshot with all changes that are done in page.

Hope you enjoyed and learned from here.

Stay Tuned for more updates

Share your views in the comment section.

Comments

AL Development 03 - How to Develop New Report in AL?

Hi Readers, Now its time to develop the most important part of Navision which client desire the most yes you are correct i am talking about Reports. As we know to develop any solution in Business Central we must start working on AL Code Extension so from this blog you will get to know the detailed step how to create a Report through AL Code in business Central. Note: As of now there is no provision to customise the base report. Let’s try to create a simple report. Add new file with .al extension in your project folder through visual studio code My File Name is My_report.al Code Snippet for adding a new Report, use snippet treport as shown below: Next Step to set these Report Properties - • Assign ID and Provide a name of the Report that you are adding. • Set UsageCategory to ReportsAndAnalysis. • Set ApplicationArea to All. As you select the treport snippet then a default structure of the report is created as below: Basically, there are 3...

Custom sheet name in RDLC Reports

Hi Readers, In this article we are going to discuss how to change the excel sheet name while using base Navision SAVEASEXCEL functionality. Applicable for RDLC reports of Navision and SSRS reports. Let’s say we have the following report that shows total sales by product category by territory: When we export this report to Excel, we’d like each territory to appear in its own worksheet and each worksheet named after its territory: How do we make this work? Easy! 1) Put every group on its own page. 2) name each page using the same field the group uses. Step 1: Put each group on its own page To put each group on its own page, open the group’s property window. Then, in the Page Breaks category, put a check mark in the Between each instance of a group check box. Click OK to complete this step. Step 2: Name the pages of the group With the group selected in the Row Group s panel, press F4 to open the Properties window. Next, expand the Group ...

AL Development 01 - How to Develop New Table in Database?

Hello readers, As we know to develop any solution in Business Central we must start working on AL Code Extension so from this blog you will get to know the detailed step how to create a table through AL Code in business Central. Requirement : Need to create a new table with below fields: Now let’s Start: Try to keep a naming standard for your projects; As I am using the combination of Table description +Table-ID, you can use your own naming convention. So, my table file name is: My_Table50129.al AL provides a list of the snippets to make it easy for developers to add objects in extension. Snippet for getting a table layout use snippet ttable (here we have to t as prefix for every type of object we want to create in AL) as shown below: Now Assign the ID and name of the table as below: As you select the ttable from the list a default table design structure is created as shown below: You can divide the whole table into 4 Sections - · F...

Microsoft Dynamics 365 Business Central

Search This Blog