Business Central: obsoleting WITH statement

Today, I have been checking some of my extensions for business central 17 compatibility. Majorly, I found that it is giving a warning for with statements. After that, I checked some blogs on the google and found that it is going to be obsolete soon in the newer version of business central.

With clause can help us to write a more readable source code for our customization. In fact, Microsoft is already using this with clause many times the we have seen in the Navision as well as in the business central.

We have to change our code for solving this problem as soon as possible. Many people are asking that it is just a warning why we need to take care today but my answer is always to change your code as earliest as possible for not creating mess at the deadline.

I hope you will understand the seriousness of handling With clause. After changing code when you compile source you will not get a warning for code AL0606.

Comments

How to add editable field in Ledger Entries in Business Central?

How to add editable field in Ledger Entries in Business Central? Many times we need to make an editable field in the business central on Customer Ledger entries or General Ledger Entries or Item Ledger Entries. On the Ledger Entries, we can not add directly editable fields on the page because these Ledger Entry pages are designed to not allow modify fields because of below code. So, I want to add field called comment on the General Ledger Entries. Now, what we can do if we want to add editable field on the General Ledger Entries? Firstly, we will extend table and add comment field and then will extend general ledger entries and add our field at the last. tableextension 50261 tableextension50261 extends "G/L Entry" { fields { // Add changes to table fields here field( 50261 ; Comments; Text [ 250 ] ) { DataClassification = CustomerContent; Caption = 'Comments' ; } } } pageextension

Custom API in Business Central

Today, I will demonstrate how to work with custom API in Business Central. Custom API is very useful when we are working with integration apps. So, lets start exploring custom API in business central. We will take one table called student and will create one API page in order to access this table as API. Moreover, we can check this API in Postman as well. Here, we will mainly perform three operations GET, Post, and Delete. First of all, we will create student Table with four fields ID, First Name, Last Name and Email. For the primary key we will take ID. Once table is added, we will create one list page to view our data. So, we can easily check our custom API is working properly or not. Now, we will add another page which is used as API. This is a new page type introduced in business central. You can check how to create API page in business central.( Click Here ) Now, we can interact with student data with the help of this API page in the business central. We will write a logic i

Import Excel File in Business Central

Import Excel in Business Central Many times we need to import data through excel file in the business central / navision. We used to perform this kind of activity in the navision but we need to explore the thing in business central. So, i am trying to import data from excel file in the business central. I am using business central wave 1 2020 for the development. We will create a table called student and add some fields to test imported data from Excel in Business Central. Now, We will add a new list page to view imported data from excel. Now, We will create a new report to import data from the excel in business central. If you worked with the navision then you might be noticed that some of the functions are not working in the business central due to scope issue. So, we will replace those functions which we used in NAV and try some new available functions to import excel. Now, we will add an action to the list page for import data

Tech Harshil

Search This Blog