July 2020 Cumulative Updates for Microsoft Dynamics 365 Business Central

Hi Readers,

Below are the Cumulative updates Download links for Microsoft Dynamics Business Central #MSDYN365BC

Business Central Cumulative Updates

Released cumulative updates for Microsoft Dynamics 365 Business Central Spring 2019.

DownloadCumulative Update 14 for Microsoft Dynamics 365 Business Central April’19 on-premises
Release dateJuly, 2020
Build no.Application Build 14.15.43800 , Platform Build 14.15.43793
Local versions includedAT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK

Released updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 1.

DownloadUpdate 16.3 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1
Release dateJuly, 2020
Build no.Application Build 16.3.14238,Platform Build 16.3.14195
Local versions includedAT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK

Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2

DownloadUpdate 15.8 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2
Release dateJuly, 2020
Build no.Application Build 15.8.43801,Platform Build 15.8.43794
Local versions includedAT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK

Divyesh Chitte

Connect  – Twitter | Facebook | Linkedin 
Follow    – Blog | Facebook Page  | DynamicsCommunity

Get ready for Microsoft Dynamics 365: 2020 release wave 2 plan is here

#2020Releasewave2

Microsoft is providing regular updates for Business Central and the product is rapidly improvising to cater all the business requirement for the Customers as well as Technical team

Below is the list of features we can expect

Administration

Application

Migrations to Business Central Online

Modern Clients

Seemless Service

General

For Details on Planned features please check this link

What New and Planned for Dynamics 365 Business Central

Happy reading

Divyesh Chitte

Connect  – Twitter | Facebook | Linkedin 
Follow    – Blog | Facebook Page  | DynamicsCommunity

Create Snippet for AL in Visual Studio Code for MSDYN365BC

Understand that snippets are context-aware, meaning if you are working in an AL file, AL snippets show up. If you’re working in HTML, HTML snippets will show up. In this article, we are going to focus on creating snippets in Visual Studio Code for Business Central. We are going to take a look of how to create Snippet for AL in Visual Studio for MSDYN365BC

Create Snippet in AL

We will Open Vs Code

Press COMMAND + SHIFT + P to open the command palette.

Find “Preferences: Configure User Snippets”.

Click “New Global snippets file”.

Snippet can be defined in Scope Prefix body and Description.

This will open up a file with a .code-snippets extension in ~/Library/Application Support/Code/User/snippets/filename.code-snippets.

I have created a demo snippet for repeat until Loop in AL which we use frequently. We can use the snippet by typing Repeat and it will show us the Global Snippet in suggestion.

Use AL Snippet.

To Use the Snippet Start writing Repeat and you will find suggestion as TDRepeat which we created.

Select the Snippet and use, this will reduce down our efforts of remembering the syntax and focus on Logics.

To get new updates and learn about Microsoft Dynamics 365 Business Central Microsoft Learn and Self Learning

Download Link for different version of NAV and Business Central.

Happy Reading.

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

Divyesh Chitte

Connect  – Twitter | Facebook | Linkedin 
Follow    – Blog | Facebook Page  | DynamicsCommunity

Blog Series Part 10: Automize process for Sales Transaction in MSDYN365BC

Hi Readers,

I am sure you would have created the functionality mentioned in my previous blogs. If you still have not, refer to link given below

To show the complete functionality and it working , you can see the video .

This process can be fully automise as well using Task Manager or job Queue in Microsoft Dynamics Business Central.

To get new updates and learn about Microsoft Dynamics 365 Business Central Microsoft Learn and Self Learning

Download Link for different version of NAV and Business Central.

Happy Reading.

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

Thanks & Regards

Divyesh Chitte

Connect  – Twitter | Facebook | Linkedin 
Follow    – Blog | Facebook Page  | DynamicsCommunity

Blog Series Part 9: Developing Matrix Report in AL for MSDYN365BC.

Hi Readers,

I am sure you might be able to create all the Objects mentioned in below mentioned blog.If you have not seen my previous blogs I have mentioned the links

So let us focus on the Developing report in Microsoft Dynamics Business Central MSDYN365BC. The format is mentioned in the Blog 01 – Customer Requirement for AL Development 2.5 Interface Report.

Report format in Msdyn365BC

Lets start build the report.

Add new file Report50000.al and you can use the Snippent to add the report.

I have added UsageCategory so that we can view the report on modern client. You can see What happened to Menusuite in the Webclient for MSDYN365BC? for more details on this property.

RDLCLayout is the default layout that is used.

report 50000 "Insurance Interface Report"
{
    UsageCategory = ReportsAndAnalysis;
    RDLCLayout = './Report/Insurance Interface Report.rdl';
    dataset
    {
        dataitem("Insurance Interface Entry"; "Insurance Interface Entry")
        {
            RequestFilterFields = "Transaction No.", "Transaction Date";
            column(CompanyNameText; COMPANYNAME)
            {
            }
            column(PageCaption; PageCaption)
            {
            }
            column(ReportName; ReportName)
            {
            }
            column(Userid; UserIDText)
            {
            }
            column(TransactionNo_InsuranceInterfaceEntry; "Insurance Interface Entry"."Transaction No.")
            {
            }
            column(TransactionDate_InsuranceInterfaceEntry; "Insurance Interface Entry"."Transaction Date")
            {
            }
            column(TransactionType_InsuranceInterfaceEntry; "Insurance Interface Entry"."Transaction Type")
            {
            }
            column(EntryType_InsuranceInterfaceEntry; "Insurance Interface Entry"."Entry Type")
            {
            }
            column(DebitCredit_InsuranceInterfaceEntry; "Insurance Interface Entry"."Debit/Credit")
            {
            }
            column(Amount_InsuranceInterfaceEntry; "Insurance Interface Entry".Amount)
            {
            }
            column(Description_InsuranceInterfaceEntry; "Insurance Interface Entry".Description)
            {
            }
            column(Department_InsuranceInterfaceEntry; "Insurance Interface Entry".Department)
            {
            }
            column(PolicyType_InsuranceInterfaceEntry; "Insurance Interface Entry"."Policy Type")
            {
            }
            column(PolicyNumber_InsuranceInterfaceEntry; "Insurance Interface Entry"."Policy Number")
            {
            }
            column(ClientCode_InsuranceInterfaceEntry; "Insurance Interface Entry"."Client Code")
            {
            }
            column(Name_InsuranceInterfaceEntry; "Insurance Interface Entry".Name)
            {
            }
            column(Address_InsuranceInterfaceEntry; "Insurance Interface Entry".Address)
            {
            }
            column(Address2_InsuranceInterfaceEntry; "Insurance Interface Entry"."Address 2")
            {
            }
            column(City_InsuranceInterfaceEntry; "Insurance Interface Entry".City)
            {
            }
            column(PostCode_InsuranceInterfaceEntry; "Insurance Interface Entry"."Post Code")
            {
            }
            column(TelNo_InsuranceInterfaceEntry; "Insurance Interface Entry"."Tel. No")
            {
            }
            column(EmailAddress_InsuranceInterfaceEntry; "Insurance Interface Entry"."Email Address")
            {
            }
            column(NominalCode_InsuranceInterfaceEntry; "Insurance Interface Entry"."Nominal Code")
            {
            }
            column(ImportedByUserID_InsuranceInterfaceEntry; "Insurance Interface Entry"."Imported By UserID")
            {
            }
            column(ImportedDateTime_InsuranceInterfaceEntry; "Insurance Interface Entry"."Imported DateTime")
            {
            }
            column(ProcessedByUserID_InsuranceInterfaceEntry; "Insurance Interface Entry"."Processed By UserID")
            {
            }
            column(DateTimeProcessed_InsuranceInterfaceEntry; "Insurance Interface Entry"."DateTime Processed")
            {
            }
            column(PostedByUserID_InsuranceInterfaceEntry; "Insurance Interface Entry"."Posted By UserID")
            {
            }
            column(DateTimePosted_InsuranceInterfaceEntry; "Insurance Interface Entry"."DateTime Posted")
            {
            }
        }
    }
    labels
    {
    }
    var
        CompNameText: Text;
        PageCaption: Label '"Page "';
        ReportName: Label 'Insurance Interface Report';
        UserIDText: Label '"User ID "';
}

Once you save and compile this file you will see an .rdl file which you can open and Reveal File in Explorer and open the file. For more details Creating an RDL Layout Report in Microsoft Dynamics 365 Business Central (MSDYN365BC).

Note: You need to install the report builder.msi if you are developing the report for first time.

Open the Insurance Interface Report.rdl with report builder.

Add a matrix in the body of the report as shown in below screen shot.

RdlLayout

Once you have added the Matrix report , add RowGroup on Transaction No. and ColumnGroup EntryType.

Add the body Section and Sum in the Footer of the Matrix report similar to the Table. Once you run the report you will get the output as mentioned on top.

To get new updates and learn about Microsoft Dynamics 365 Business Central Microsoft Learn and Self Learning

Download Link for different version of NAV and Business Central.

Happy Reading.

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

Thanks & Regards

Divyesh Chitte

Connect  – Twitter | Facebook | Linkedin 
Follow    – Blog | Facebook Page  | DynamicsCommunity