Mandatory Affixes as per AppSourceCop Rule AS0011 in Microsoft Dynamics Business Central

 Hi All, 

I hope you'll are doing well. 

Business Central 17 has come up with a lot of improvements and functionalities, and one of them is Mandatory Affixes which is very important for developers w.r.t Code Standardization and managing their objects.

AppSourceCop Rule AS0011: An affix is required

Now, what does that mean! Let's look into it in detail. 

Enum.FromInteger Method in Microsoft Dynamics 365 Business Central

Hi All, 

Long time no see... I hope you'll are doing well. 

We have already discussed Enums in one of the blogs. If you haven't checked it already,  refer: https://jyotsnanav.blogspot.com/2020/06/enum-and-how-to-use-and-extend-them-in.html 

Today, we'll talk about how Enums can be used and returns an enum with the integer value. The method used is Enum.FromInteger

This method takes the Integer (Enum Ordinal) and returns the value of the Enum.

Syntax:

Using Azure Functions in Mirosoft Dynamics Business Central

Hi Readers, 

I hope you are doing well!

I know this blog took a while, sorry about that! But here it is!

There's a lot of talking going on w.r.t Azure functions which we can use in Business Central. ut what exactly are they? How will they benefit? How to use them? I'll answer these questions in this blog. 

Microsoft Azure is a cloud computing service that is used for building, testing, deploying, and managing applications.

Substitute a Standard Report with your Custom Report in Microsoft Dynamics 365 Business Central

 Hi Readers, 

I hope you are having a great day!

Today, we'll talk about another interesting topic of Business Central and that is, how you can use the same action and its properties that has a Standard Report and replace it with your own Custom Report and this can be done just by using simple Events. How cool is that! 

Let's get started!

As you might know, standard reports cannot be changed in Business Central. So if there are any changes required we have to create a new al file and a report layout.

Know what an Upgrade Codeunit does and how to execute it in Microsoft Dynamics 365 Business Central

 Hi Readers, 

Business Central gives you a facility to perform certain operations while you upgrade the extension i.e, changes were made to your extension and you would want to publish it. This can be done with the help of an Upgrade codeunit. There are operations that can be performed while you modify an extension and want to check something at that time. 

Some of the examples can be updating version of an app,  modifying records in a table, inserting value to a field if a new field was created in the extension. 

How to create it? 

Know what an Install Codeunit does and how to execute it in Microsoft Dynamics 365 Business Central

 Hi Readers, 

Business Central gives you a facility to perform certain operations while you install the extension. This can be done with the help of an Install codeunit. You can also use these codeunits if you want to test something during the extension installation. 

Some of the examples can be populating empty records with data, service callbacks and telemetry, version checks, and messages to users. 

How to create it? 

Consider these Key Points before you upgrade to Business Central online

Hi Readers,

I hope you are doing well and had a great weekend!

Since a lot of changes have been happening since the release of Business Central and everyone is looking for an upgrade and want to move to SaaS, i.e, Microsoft NAV (from any version) to Dynamics 365 Business Central. I would like to talk about some checkpoints. 

Before you jump into the data, application and PowerShell commands, there are a few important points that you should consider. You can also call them as Prerequisites or precheck. Following are the points:

1. Codeunit 1 (ApplicationManagement) has been deprecated and replaced and new ‘system’ codeunits has been introduced. No functionality has been removed by this change. All system method triggers, event publishers, and their code have been moved to other codeunits.

Dynamics 365 Business Central August 2020 release wave 1 overview

 Hi Readers, 

Microsoft dynamics 365 Business Central had come up with its new release Plan at the end of June 2020. See this blog post to know more: Microsoft Dynamics 365 Business Central release wave 2 Plan June 2020

Some of the capabilities have been added by Microsoft in August 2020. 

Source: Youtube (Microsoft Dynamics 365)

Get an overview of the latest capabilities and functionalities here, 

Creating APIs in Microsoft Dynamics 365 Business Central and using Postman to send GET, POST, PATCH and DELETE requests

Hi Readers,

I hope you are doing well. Here is another interesting blog for you all!

APIs give more feasibility over Web Services and have fewer restrictions than them. The data can also be in any format, and also provides the segregation over Page Cards which we had to create for Web services. Business Central gives a lot of facilities for APIs. You can also connect to external APIs without any hassle and access JSON parameters. But that is again for another blog.

Today, we’ll see how to create APIs pages and use GET, POST, PATCH and DELETE methods for CRUD operations, through Postman.

Let’s get started!

Prerequisites:

Extending an Extension in AL for Microsoft Dynamics 365 Business Central

Hi Readers, 

I hope you are liking the blogs and following them. Today, I am here with an interesting and important concept related to AL Extensions. 

For us to access Business Central Objects, we have to Download Symbols. This Download of Symbols depends on something called as dependencies in app.json. Due to this, you have the accessibility to Base Application and System Application which is basically the Out-of-the-box Application.

Creating a new report and modifying an existing report in Microsoft Dynamics 365 Business Central

Reports, one of the most important aspects of an ERP and of course are widely used through the application. The layout of reports works the same in Business Central as that of NAV. You can use RDLC or Work Layout, the difference is, of course, the AL file like any other object. Apart from this, a major change or drawback is that reports cannot be extended. Yes, you heard it right! Microsoft hasn’t come with report extensions yet but we surely have some workarounds that will help us overcome this drawback.

In this blog, we’ll look into the following:

1.      Create a new report

2.      Modifying this custom report

3.    Modifying layout of an existing report wherein modification is required only in the layout.

4.  Modifying an existing report wherein modification is required in AL like adding a new field to its dataset (Workaround since reports are not extendable)

Microsoft Dynamics 365 Business Central release wave 2 Plan June 2020

Microsoft is full fledged working on updating Business Central and yet again we have another release plan updated as per 26^th June 2020. Few features are available for preview since May 2020, others are for August & September 2020 whereas few ones do not have a day yet. General availability is in October 2020 as per the plan. Similar to every release, this also has Administration, Applications, Power Platform, etc features. Although, I am still locking forward to report Extensions, to be honest. Regardless, the features mentioned are big enhancements, I must say.

[Resolution] Unable to Download Symbols in Visual Studio Code for AL Extension

Hi Readers,

While getting started with AL and creating your first Workspace you might have come across with this error at least once, as you can see in the image below.

  

There are 3 points mentioned which can help you resolve this error:

1.       The correct server name and instance are specified in the launch.json file.

READ and WRITE file(s), BLOB and ZIP by using INSREAM and OUTSTREAM in Microsoft Dynamics 365 Business Central

Hi Readers, 

Hope you are doing well.

Today we'll talk about File Management in Business Central. 

INSTREAM and OUTSTREAM are used to access binary data (such as File or BLOB) that are stored in Objects. In this blog, we’ll see how to use InStream and OutStream in AL for Business Central.

InStream:

This is used to read bytes from a stream object in binary format, and you can use the Read and ReadText functions to read that format.

What is Microsoft Dynamics 365 and its benefits?

Microsoft has stepped up its game in SaaS and got all the things under one roof! Now, what do II mean by this… we’ll see as I speak about it. I know it’s been few years that they achieved such a thing known as Dynamics 365, and many of you must be aware too, but the way Dynamics 365 is enhancing and progressing, II cannot stop myself from writing a blog about it! So please stay with me on this blog, you might discover something new or at least have an overview. 

365 is an amazing and sensible term that they have used. Image it as a circle. In a circle, any point can connect with any point and doesn’t have any start point. Consider Dynamics 365 the same. How awesome is that!

In Dynamics 365, there are so many Microsoft Products which you can Connect, Integrate and combine them. The ones that were on – Premise have been deployed as SaaS. For example, NAV as Business Central and Power BI in Dynamics 365. 

Automation API in Dynamics 365 Business Central 2020 Wave 1 April 2020 release

Hi Readers, 

Business Central 2020 wave 1 came up with a lot of features and is enhancing more and more, day by day. Check out the updates here: Business Central 2020 wave 1

One of the features of Business Central 16 is the advancements in APIs. These automated APIs give you the facility such as calling this Automated API and change company setup after the tenant is created. It is placed in microsoft/automation. These APIs work like any other APIs with POST, GET, PATCH requests.

Location of API: https://api.businesscentral.dynamics.com

Some of the examples are as follows:

Automate Company:

----------------------------------------------------------------------------------------------------------------------

POST https://api.businesscentral.dynamics.com/v2.0/{environment name}/api/microsoft/automation/{apiVersion}/companies({companyId})/automationCompanies

Enum and how to use and extend them in Microsoft Dynamics 365 Business Central

Hi Readers, 

As you might be aware that Business Central 16 has come with a lot of features from which one of them is advancements in enums. They have been existing from quite some time, but now they are used extensively and most of the fields are extensible. You can also use them for local and global variables as well as parameters. 

But what are exactly enums? They are quite popular in other programming language and doesn't mean anything different. Enums are set of constants which with an assigned ID. It is like a menu through which you can make a choice and this is called enumeration. One example can be an optionstring to which you can add another option value. 

Declare an enum:

AL Interfaces in Microsoft Dynamics 365 Business Central

Hi Readers,

Microsoft Dynamics 365 Business Central is enhancing and in April 2020, came with new features and advancements. 

To know what all accessible features do we have in Microsoft Dynamics 365 Business Central 2020 Wave 1 release, refer Business Central 2020 Updates

There is one interesting feature about which I wanted to write from forever, and that is AL Interfaces. 

Now, what are Interfaces, how to use them and what are its benefits? I'll try to explain it as simply as possible. 

Top 10 Microsoft Dynamics 365 Business Central Interview Questions and Answers

Hi Reader,

I hope you have checked Part 1, 2 & 3 of 4 blog series. If not, do check it here: Part 1, Part 2 & Part 3

This 4 blogs series, which I feel will help you to get through the Interviews in this difficult time of COVID. Refer these blogs rather searching through the internet, use your time efficiently. All the best!

Part 4: Top 10 Microsoft Dynamics 365 Business Central Interview Questions and Answers

Top 10 Microsoft Dynamics NAV Interview Questions and Answers

Hi Reader,

I hope you have checked Part 1 & 2 of 4 blog series. If not, do check it here: Part 1 & Part 2

This 4 blogs series which I feel will help you to get through the Interviews in this difficult time of COVID. Refer these blogs rather searching through the internet, use your time efficiently. All the best!

Part 3: Top 10 Microsoft Dynamics NAV Interview Questions and Answers 

Best Microsoft Dynamics Business Central Technical Interview Questions and Answers references

Hi Reader,

I hope you have checked Part 1 of 4 blog series. If not, do check it here: Part 1  (NAV Technical links can be referred for Business Central as well, so make sure you check Part 1 too)

This 4 blogs series which I feel will help you to get through the Interviews in this difficult time of COVID. Business Central questions are bombarding, therefore refer this blog rather searching through the internet, use your time efficiently. All the best!


Part 2: Best Microsoft Dynamics Business Central Technical Interview Questions and Answers references:

Best Microsoft Dynamics Navision Technical Interview Questions and Answers references

Hi Reader,

I hope everyone is doing well. The situations of COVID is difficult and job hunting is a mental drain.
I want you to stay strong and keep hunting. We can do it. We are not going to give up.
At times like these, getting an Interview is difficult and we do not want to miss a single one if we get any. This is a 4 blogs series which I feel will help all of us to get through the Interviews. Refer the blog series rather searching through the internet, use your time efficiently. All the best!


Part 1: Best Microsoft Dynamics Navision Technical Interview Questions and Answers references:

Publishing Events, Raising the Events and Subscribing to Events for modifying base application of Microsoft Dynamics 365 Business Central

Hi Readers,
As you might know, Online Business Central does not allow you to change the standard code just as NAV. in the sense that, whenever you wanted to add code to a trigger in NAV all we had to do was find the right place, insert your code and document the version. It doesn't work the same way in Business Central.

Now, what to do if we want to add some code on onValidate() of Customer Table or modify any other Object? How do we change the standard code? Is it even possible?
Well, all the questions will be answered in this blog.

Creating RDLC Report in Microsoft Dynamics 365 Business Central using Microsoft SQL Report Builder

Hi Readers,

Welcome back!

In this blog, we'll see how to create an RDLC Report in Business Central using AL and SQL Report Builder. 

When we talk about NAV, we already have an Object Designer wherein we create a new report, add datasets and create a Design in SQL Builder.

But Visual Studio does not have an Object Designer as shown below:

Integrating Dynamics 365 Field Service with Microsoft Dynamics NAV 2018 using WCF Part 2

Hi Readers,
This is the continuation of previous blog! Don't forget to check that out before moving forward! Previous Blog

In this blog,  we'll Create Function in Microsoft Dynamics to receive data from Microsoft Dynamics CRM  through a WCF Service. 

Know more about Integration in my other blog Dynamics NAV and Dynamics 365 Integration to get more insides.

Now, lets get started!

Integrating Dynamics 365 Field Service with Microsoft Dynamics NAV 2018 using WCF Part 1

Hi Readers,

In this blog, we will look into the Integration of NAV and CRM, wherein we'll Create Function in Microsoft Dynamics to pass data to Microsoft Dynamics CRM through a WCF Service. 

Know more about Integration in my other blog Dynamics NAV and Dynamics 365 Integration to get more insides.

First, we'll require a WCF Service which will have functions to accept data from NAV and pass it to CRM. Then, we'll have to add this WCF Services as a dll in NAV. Add dll to NAV

Prerequisites: 

Accept DotNet JSON as Text in Microsoft Dynamics Navision

Hi Readers,

NAV doesn't accept .net Data source i.e., JSON as a parameter. But what if we want to pass a .net Data source in a NAV function to access its properties. 

Here is a short blog for that! 

We can pass .net Data in a form of Text as parameter in NAV and this is how that can be done. 

Consider,

Microsoft Dynamics 365 Business Central 2020 release wave 1 Updates

Hi readers,

Dynamics Business Central is having enhancements day-by-day. Recently a new version of Business Central was released in 2020. The changes were planned in Jan,2020 and enhancements happened in Jan,2020 and Feb,2020. The updates are available now! (April,2020). It came with many functional as well as development features.

Following are list (links) of features/updates that I think are useful and interesting:

AL in Visual Studio Code for Dynamics 365 Business Central 2020 wave 1 version 5.0

Hi Readers,

Motive of this blogs is to Setup AL Workspace in Visual Studio without going through a lot of unnecessary steps. All you need to do is follow the below mentioned steps precisely.

Here the Setup is according to online Dynamics 365 Business Central 2020 release wave 1 (latest)

1. Sign up with your work email for Business Central Sandbox so that you know the  Server Instance. Sign up
If you already have the environment, be ready with the Server Instance and Development port.

Using dlls or Assembly List in Microsoft Dynamics Navision

Hi Readers,
Today we will talk about how to use dlls efficiently and its importance.
If you are from a .net background you probably know that dlls are nothing but .cs classes. If we talk in NAV terms, dlls are files that has specific code which can be used for a feature.

NAV has predefined function such as SETRANGE, MESSAGE, DATETIME, etc. But what if NAV doesn't have a function you need and the feature will require a lot of custom code to do so, this is when dlls comes in picture. NAV has many

AL Object Designer in Visual Studio Code for Business Central

Hi Readers,

When it comes to a Business Central Environment in VS Code, moving towards a new language is one thing but figuring out which Object to use and sometimes we do not remember the Object IDs or names, it becomes difficult for a Developer to attempt to the new environment. The On-Premise version of Business Central is not in use anymore and we have to depend on the Workspace.

What do we do if I want to use an object but I cannot remember the Object ID or names? Well... I guess I'll have to try a few!

Luckily, No! Hence I thought of writing a small Blog of about it. It is handy and convenient!

Upgrade NAV 2018 to Business Central

Hi Readers, 

Since we are quickly moving to Dynamics 365 Business Central, there are many projects that are still working on Microsoft NAV 2018 and we need to migrate it to Business Central. 
When it comes to NAV - NAV migration, we do the export and merge operations but since Business Central doe snot support C/AL and has a new language AL, we need to perform certain steps to perform the upgrade. 

Today, we will discuss how that can be achieved. 

Prerequisites: 
1. VS Code
2. Business Central Workspace

Different ways of implementing Dynamics NAV and Dynamics 365 CRM Integration

Hi Reader,

Due to the boom of 345, a lot of clients have been looking forward to use NAV as well as CRM. Therefore, there is a need to create a link between the two. There are various ways in which this can be achieved depending on the client requirements, costing and convenience.

Here, I'll provide you with a gist of six ways in which an Integration of NAV to CRM can be achieved.