Skip to main content

MSDYN365BC - AL Development 10 - Summary of AL Development Series.

Hi Readers,

I hope you all are following this series and learned something new with this series.

If you haven't read any article in this series then Please Refer Table of Index.

To Start with,

May You have a year that is filled with love, laughter, brightness, and hope.

Wishing you a Happy New Year 2019!.

I would thank you for all your suggestions, comments and Questions. Your engagement with this series kept me motivated to keep writing about this. I am always open for your suggestion about articles that you would like to see in this blog. Use Contact Us Page and let me know your suggestions for future Post.

I have few questions yet to be answered that some of the readers asked. I will publish some articles on those questions to get clarity.

Just to clarify, If you think what we discussed is all about AL that's not TRUE. Consider this series as first step toward moving to AL.

To Summarize -
  • We cannot modify base objects in VS Code Extension / AL Programming.
  • We should never modify the ID of Extension in App.Json. Its a unique GUID for the extension.
  • New Object Type Added are - Table Extension & Page Extension.
  • With this being said we can extend (modify) with a limited scope to Tables and Pages.
  • Other Objects are not yet available to modify.
  • MenuSuite is obsolete with Business Central. 
  • Use UsageCategory and ApplicationArea in all User Visible Objects - Pages and Reports. These properties will set under which menu and which Application areas will be visible.
  • Extending objects are only available for Tables, Pages and Codeunit using Database Trigger Events, Integration Events, and Business Event.
  • Snippets are a great tool that will help developers. All Snippets starts with T. If you want to see all available snippet from Microsoft then refer MSDN.
  • Using Extension Model of Programming will greatly help in two areas - Upgrade and Code Reusability.
  • The only challenge is for the Upgrade Team, we will have to detangle all customization in a customer database to develop logical Extensions. We should not upgrade all customization in a single big extension as they will be hard to manage in future.
  • In Business Central on the cloud, customize No. Series (50000-99999) is free and can be used without purchasing any objects from Microsoft.

If you want to download the whole extension that we developed in this series then clone or download using the Github link, as shown below.

If you have any other thoughts about the next series before I think of it please share that via Contact Us Form. I will try my best to have a series for your suggestion.

Stay Tuned for more and please add comments if any questions/suggestions.

Saurav Dhyani


  1. Hi Saurav,

    Followed your series on AL Development, This one helped me a lot.


    1. Thanks Madan Reddy for your comment.
      It felt great that my articles were helped you. Your Comments act as motivation to keep on writing more articles in future.
      Thank you.

  2. Hi Saurav,

    thanks for the article, nice.

    btw, once we created and published new table/page/codeunit in Visual Studio Code, is it will be not created in NAV Development Object Designer? because i cant find it.

    when i saw in the SQL Server, the new table is created there.


    1. Thats correct
      We will not be able to see any of those objects (Created in AL) inside object designer but as far as tables & Table Extensions are related they will be available in SQL. All tables and table extension created in AL will also have Appid part of table name in SQL.
      All objects details are stored inside a table in NAV / BC.

  3. Thanks for this series. Followed it throughout. Great Job.

  4. Thanks for the series, it was a great intro for those of us programming in AL for the first time!

    I have one small question about the Page "Source of Sales" you created. Where should it be added in the Client and how do you control this?

    For me, when I published it, it went under "Departments" on the menu under a new link called "ALTestProject" which was the name of my project folder in Visual Studio Code!

    How should I be controlling where (and if!) this new page should appear in the client. What if I do not want it to appear at all? What if I wanted it to appear in "Sales" after the option "Sales Journals" and before "Posted Sales Invoices" for example?

    1. Sorry for Delay, i kind of missed during email chains.

      The Only thing that we can control where page/report will appear in Menu is based on property UsageCategory.
      ** There is no menusuite in Web Client.

  5. Hi Saurav,
    I am a late beginner with AL und VSCode (in BC21). Thank you for series about AL Development.
    This series is a very good and usefull start for a beginner. Thank you for that.


Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing -