BC14, BC15, BC16, BC17, Business Central, Cumulative Updates, How To, Information, Instalation & Configuration, Install, NAV 2016, NAV 2017, NAV 2018, on-premises, Updates, Wave 1, Wave 2, What's New

Cumulative Updates for Microsoft Dynamics NAV 2016/2017/2018 And BC Released in Mar 2021

Update 17.5 for Microsoft Dynamics 365 Business Central 2020 Release Wave 2 (Application Build 17.5.22499.22546, Platform Build 17.0.22463.22540)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)

For a list of updates that were released for Microsoft Dynamics 365 Business Central 2020 Release Wave 2, see released updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 2. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 2.

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 17.5 for Microsoft Dynamics 365 Business Central  2020 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 2 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 2 installed to apply this hotfix.

Update 16.11 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.11.22526, Platform Build 16.0.22511)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)

For a list of updates that were released for Microsoft Dynamics 365 Business Central 2020 Release Wave 1, see released updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 1. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 1.

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 1 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 16.11 for Microsoft Dynamics 365 Business Central  2020 Release Wave 1

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 1 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 1 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 1 installed to apply this hotfix.

Update 15.16 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 (Application Build 15.16.46612, Platform Build 15.0.46600)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)

For a list of updates that were released for Microsoft Dynamics 365 Business Central 2019 Release Wave 2, see released updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2.

How to obtain the Microsoft Dynamics 365 Business Central 2019 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 15.16 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2019 Release Wave 2 installed to apply this hotfix.

Cumulative Update 22 for Microsoft Dynamics 365 Business Central April’19 on-premises (Application Build 14.23.46611, Platform Build 14.0.46607)

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics 365 Business Central Spring 2019, see released cumulative updates for Microsoft Dynamics 365 Business Central Spring 2019. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics Released Cumulative Updates for Microsoft Dynamics 365 Business Central Spring 2019.

How to obtain the Microsoft Dynamics 365 Business Central Spring 2019 files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 22 for Microsoft Dynamics 365 Business Central Spring 2019 Update on-premises

How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update

See How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central Spring 2019 installed to apply this hotfix.

Cumulative Update 39 for Microsoft Dynamics NAV 2018 (Build 46609)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2018, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics NAV 2018, see released cumulative updates for Microsoft Dynamics NAV 2018. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2018.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 39 for Microsoft Dynamics NAV 2018

How to install a Microsoft Dynamics NAV 2018 cumulative update

See How to install a Microsoft Dynamics NAV 2018 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2018 installed to apply this hotfix.

Cumulative Update 52 for Microsoft Dynamics NAV 2017 (Build 30477)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2017, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2017, see released cumulative updates for Microsoft Dynamics NAV 2017. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2017.

How to install a Microsoft Dynamics NAV 2017 cumulative update

See How to install a Microsoft Dynamics NAV 2017 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2017 installed to apply this hotfix.

Cumulative Update 65 for Microsoft Dynamics NAV 2016 (Build 52121)

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics NAV 2016, see released cumulative updates for Microsoft Dynamics NAV 2016. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2016.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 65 for Microsoft Dynamics NAV 2016

How to install a Microsoft Dynamics NAV 2016 cumulative update

See How to install a Microsoft Dynamics NAV 2016 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2016 installed to apply this hotfix.

BC14, BC15, BC16, BC17, Business Central, Cumulative Updates, How To, Information, Instalation & Configuration, NAV 2016, NAV 2017, NAV 2018, Wave 1, Wave 2

Cumulative Updates for Microsoft Dynamics NAV 2016/2017/2018 And BC Released in Feb 2021

Update 17.4 for Microsoft Dynamics 365 Business Central 2020 Release Wave 2 (Application Build 17.4.21531, Platform Build 17.0.21516)

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 17.4 for Microsoft Dynamics 365 Business Central  2020 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 2 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 2 installed to apply this hotfix.

Update 16.10 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.10.21502, Platform Build 16.0.21469)

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 1 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 16.10 for Microsoft Dynamics 365 Business Central  2020 Release Wave 1

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 1 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 1 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 1 installed to apply this hotfix.

Update 15.15 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 (Application Build 15.15.46359, Platform Build 15.0.46345)

How to obtain the Microsoft Dynamics 365 Business Central 2019 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 15.15 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2019 Release Wave 2 installed to apply this hotfix.

Cumulative Update 21 for Microsoft Dynamics 365 Business Central April’19 on-premises (Application Build 14.22.46358, Platform Build 14.0.46351)

How to obtain the Microsoft Dynamics 365 Business Central Spring 2019 files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 21 for Microsoft Dynamics 365 Business Central Spring 2019 Update on-premises

How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update

See How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central Spring 2019 installed to apply this hotfix.

Cumulative Update 38 for Microsoft Dynamics NAV 2018 (Build 46360)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 38 for Microsoft Dynamics NAV 2018

How to install a Microsoft Dynamics NAV 2018 cumulative update

See How to install a Microsoft Dynamics NAV 2018 cumulative update.

Prerequisites

Cumulative Update 51 for Microsoft Dynamics NAV 2017 (Build 30443)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 51 for Microsoft Dynamics NAV 2017

How to install a Microsoft Dynamics NAV 2017 cumulative update

See How to install a Microsoft Dynamics NAV 2017 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2017 installed to apply this hotfix.

Cumulative Update 64 for Microsoft Dynamics NAV 2016 (Build 52091)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 64 for Microsoft Dynamics NAV 2016

How to install a Microsoft Dynamics NAV 2016 cumulative update

See How to install a Microsoft Dynamics NAV 2016 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2016 installed to apply this hotfix.

BC14, BC15, BC16, BC17, Business Central, Cumulative Updates, Dynamics 365, How To, Information, Instalation & Configuration, NAV 2016, NAV 2017, NAV 2018, on-premises, Updates, Wave 1, Wave 2

Cumulative Updates for Microsoft Dynamics NAV 2016/2017/2018 And BC Released in Jan 2021

Update 17.3 for Microsoft Dynamics 365 Business Central 2020 Release Wave 2 (Application Build 17.3.20605, Platform Build 17.0.20517)

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)

For a list of updates that were released for Microsoft Dynamics 365 Business Central 2020 Release Wave 2, see released updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 2. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 2.

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 17.3 for Microsoft Dynamics 365 Business Central  2020 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 2 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 2 installed to apply this hotfix.

Update 16.9 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.9.20537, Platform Build 16.0.20513)

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 1 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 16.9 for Microsoft Dynamics 365 Business Central  2020 Release Wave 1

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 1 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 1 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 1 installed to apply this hotfix.

Update 15.14 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 (Application Build 15.14.46107, Platform Build 15.0.46099)

How to obtain the Microsoft Dynamics 365 Business Central 2019 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 15.14 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2019 Release Wave 2 installed to apply this hotfix.

Cumulative Update 20 for Microsoft Dynamics 365 Business Central April’19 on-premises (Application Build 14.21.46103, Platform Build 14.0.46080)

How to obtain the Microsoft Dynamics 365 Business Central Spring 2019 files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 20 for Microsoft Dynamics 365 Business Central Spring 2019 Update on-premises

How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update

See How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central Spring 2019 installed to apply this hotfix.

Cumulative Update 37 for Microsoft Dynamics NAV 2018 (Build 46142)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 37 for Microsoft Dynamics NAV 2018

How to install a Microsoft Dynamics NAV 2018 cumulative update

See How to install a Microsoft Dynamics NAV 2018 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2018 installed to apply this hotfix.

Cumulative Update 50 for Microsoft Dynamics NAV 2017 (Build 30428)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 50 for Microsoft Dynamics NAV 2017

How to install a Microsoft Dynamics NAV 2017 cumulative update

See How to install a Microsoft Dynamics NAV 2017 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2017 installed to apply this hotfix.

Cumulative Update 63 for Microsoft Dynamics NAV 2016 (Build 52055)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 63 for Microsoft Dynamics NAV 2016

How to install a Microsoft Dynamics NAV 2016 cumulative update

See How to install a Microsoft Dynamics NAV 2016 cumulative update.

Prerequisites

You must have Microsoft Dynamics NAV 2016 installed to apply this hotfix.

AL, API, Application, AppVersion, BC14, BC17, Business Central, Code, Codeunit, DataVersion, Dependencies, Development Tips, Dynamics 365, Extension, GetCurrentModuleInfo, GetModuleInfo, How To, Information, Instalation & Configuration, Install, Name, on-premises, OnInstallAppPerCompany, Publisher, Tip & Tricks, Version.Create, Visual Studio Code, Wave 1, Wave 2

Extension Install Code

Extension install code is executed when:

  • An extension is installed for the first time.
  • An uninstalled version is installed again.

This gives you control to write different logics for first time installation of extension and reinstallations of uninstalled extensions.

This is achieved by defining Install Codeunit in your Extension.

First thing first:

  1. Subtype property of codeunit need to be set to Install
  2. OnInstallAppPerCompany trigger is triggered when the Extension is Installed first time or subsequent install of same version on Extension.
  3. DataVersion property one of the important properties which tells you what version of data that you’re dealing with.
  4. AppVersionDataVersionDependenciesIDName, and Publisher. These properties are encapsulated in a ModuleInfo data type. You can access these properties by using the NavApp.GetCurrentModuleInfo and NavApp.GetModuleInfo methods.
  5. If the DataVersion property equals Version.Create(0,0,0,0), then it’s the first time that the extension is installed because no data exists in the archive.

Sample codeunit can be similar to below:

codeunit <ID> “Name of Codeunit

{

    // Install Logic

    Subtype = Install;

    trigger OnInstallAppPerCompany();

    var

        myAppInfo: ModuleInfo;

    begin

        NavApp.GetCurrentModuleInfo(myAppInfo);

// Get info about the currently executing module

        if myAppInfo.DataVersion = Version.Create(0, 0, 0, 0) then

// A ‘DataVersion’ of 0.0.0.0 indicates a ‘fresh/new’ install

            HandleFreshInstall

        else

            HandleReinstall;

// If not a fresh install, then we are Reinstalling the same version of the extension

    end;

    local procedure HandleFreshInstall();

    begin

        // Logic to execute on first time this extension is ever installed for this tenant.

        // Some possible usages: – Initial data setup for use

    end;

    local procedure HandleReinstall();

    begin

        // Logic to execute on reinstalling the same version of this extension back on this tenant.

        // Some possible usages: – Data ‘patchup’ work, for example, detecting if new ‘base’

// records have been changed while you have been working ‘offline’.

    end;

}

Happy Learning.

Container, Docker, Docker Info, How To, Image, Information, Instalation & Configuration, Kill, List, Networks, Prune, Remove, Start, Stop, Tip & Tricks, Volumes, Wipe Docker

Docker Maintenance

Continuing from where we left in previous post, if not seen you can visit here.

During development, your resource utilization can grow unorganized with old, outdated, and unused components. Where you may require maintenance to manage, free resources and reclaim for other uses.

Let’s learn few commands which will be useful to work and maintain docker containers, images and other resources.

Today we will learn how to organize a Docker environment by removing Docker images, containers, volumes, and networks. 

Using these commands makes Docker container management fast and easy.

A container creates a specific environment in which a process can be executed. As we all are aware of many containers are created over time, tested, and uninhibited during the development lifecycle.

Therefore, it’s important to know how to find unnecessary containers and remove them.

First, you will need to list all Docker containers using the command:

docker container ls -a

This will list all running containers, their IDs, names, images, status and other parameters.

Most of the time you are only interested to have list of all the containers only by their numeric ID’s, that you can obtain running the command:

docker container ls –aq

To stop a specific container, enter the following:

docker container stop [container_id]

Replace [container_id] with the numeric ID of the container from your list.

You can enter multiple container IDs into the same command.

To stop all containers, enter:

docker container stop $(docker container ls –aq)

This forces Docker to use the list of all container IDs as the target of the stop command.

To launch or start a single or multiple stopped Docker containers

docker start [options] container_id

List all Docker Resources

Enter the following commands to display resources:

docker info

docker container ls

docker image ls

docker volume ls

docker network ls

The above-mentioned lists number of containers, images, and information about the Docker installation. These commands can help you locate and identify resources that you want to keep, or that you want to delete.

Remove a Stopped Container

To remove a stopped container, use the command:

docker container rm [container_id]

Remove All Stopped Containers

To remove all stopped containers:

docker container rm $(docker container ls –aq)

Remove All Docker Containers

To wipe Docker clean and start from scratch, enter the command:

docker container stop $(docker container ls –aq) && docker system prune –af ––volumes

Let’s decode above command line as:

docker container ls –aq

will list all containers with their numeric ID

docker container stop

will stop all containers obtained from above list

&& docker system prune –af ––volumes

Will remove all stopped containers and volumes

Here (a) indicates this should apply to all containers &(f) without a required confirmation.

How to Remove Docker Images

Docker images are files, which include multiple layers used to run code within a container.

Images may go through many iterations during development. Old and outdated images can clutter your system, taking up storage space and making searches more difficult.

To remove a Docker image, start by listing all the images on your system:

docker image ls

The output displays the locally available Docker images, as seen below.

Make a note of the IMAGE ID – this is the identifier used to remove the image.

Then, remove the unwanted image(s):

docker image rm [image_id1]

Replace [image_id1] with the image ID you pulled from the first command. You can enter a single Image ID, or multiple IDs for removal.

The system may respond to your request with an error message, that there is a conflict and it is unable to remove the repository reference.

This indicates that a container is using the image. You need to remove the container first before you can remove the image.

How to Remove Docker Volumes

A volume is used to store Docker data.

It helps store and organize data outside containers in a way that it’s accessible to multiple containers.

Use the following command to generate a list of all the available Docker volumes:

docker volume ls

Take note of the VOLUME NAME you want to remove.

Then enter:

docker volume rm VolumeName

Make sure to replace VolumeName with the actual name you generated with the previous command.

If the volume is in use by an existing container, the system responds with an error. This means need to remove the container first.

How to Remove Docker Networks

Docker networks allow different containers to communicate with each other freely while also preventing traffic from outside the network. This is typically done with a Docker bridge network.

The prune command removes all unused networks.

Removing a Single Network

Display a list of all existing Docker networks with the command:

docker network ls

Take note of the NETWORK ID – this is the identifier used to remove a specific network. Then, enter:

docker network rm [networkID]

Replace [networkID] with the ID you captured from the first command.

You may receive an error message that says the network has active endpoints. That means that the network is currently in use by containers. You need to remove the containers that are using the network before you can remove the network.

Remove All Unused Docker Objects

The prune command automatically removes all resources that aren’t associated with a container. This is a streamlined way to clean up unused images, containers, volumes, and networks.

In a terminal window, enter the following:

docker system prune

Additional flags can be included:

a To include stopped containers and unused images

–f  Bypasses confirmation dialog

––volumes Removes all unused volumes

Also, you can specify a single type of object to be removed, instead of the entire environment:

docker container prune

docker image prune

docker volume prune

docker network prune

Running docker system prune -a removes both unused and dangling images. Images used in a container, either currently running or exited, will NOT be affected.

Finally, my docker is clean:

May come with more commands and maintenance tips in future post. While writing this post I was using limited resources, so was unable to attach screen shot for each command. In future may add more scenarios.

Till then keep experimenting & learning.

AL, Array, BC14, BC17, Business Central, Collection, Development Tips, Dictionary, Dynamics 365, How To, Information, List, Modern Development Tool, on-premises, Tip & Tricks, Visual Studio Code, Wave 1, Wave 2, Web Client

Working with Collections

Today we will learn three types of collections supported by AL.

A collection is a complex type that contains multiple values in one variable.

You can’t have values with different types in the same collection. For example, you can’t add date values in a collection that only allows integer values.

The three types of collections that AL supports are:

  • Array
  • List
  • Dictionary

We will discuss about each type of collections in this post with examples.

Let’s start with most familiar collection we have used with old versions of Navision too, yes you are right, I am talking about Arrays.

Arrays

Arrays are complex variables that contain a group of values with the same data type.

An array holds multiple values, and these values are stored in the elements of the array. You can access these values by using the index, which can also be a value that is stored in another variable. With this design, you can create a loop where you increment a certain variable to loop through every element in an array.

By using the Dimension property, you can define how many dimensions that the array will hold.

When creating a variable of an array data type, you first need to define how many elements that you’ll have in the array. The most commonly used array is the one-dimensional array, which is a list of elements with the same data type.

You can represent an array as a row of values.

To create an array, use the following code:

SalesAmount: array[10] of Integer;

To access an element in an array, use the array element syntax:

SalesAmount[5] := 0;

Unlike other programming languages array index don’t starts with 0 rather with 1. In above example first element will be 1 and last 10.

Having only one element between the square brackets indicates that you are using a one-dimensional array. If you want to have a multi-dimensional array, use a comma-separated list between the brackets, as follows:

SalesAmount: array[6,9] of Integer;

To access an element in an array, use the array element syntax:

SalesAmount[5,3] := 0;

Lists

The List data type can be compared with an array. The List type can only be used with fundamental types and represents a strongly typed list of values that can be accessed by index.

Therefore, you can have a List type of [Integer], but you cannot have a List type of [Blob].

List data type doesn’t require you to define how many elements you want to store up front (while an Array data type does).

The List data type has some methods that are used frequently. The methods that are available for a List data type will discuss in a later post.

To create a list, use the following code:

CustomerNames: List of [Text];

To access an element in a list, use the following methods:

To store/add values to list

CustomerNames.Add(‘KSD Consultancy’);

CustomerNames.Add(‘Microsoft India’);

CustomerNames.Add(‘Ashwini Tripathi’);

To retrive values from list

CustomerNames.Get(1);

Dictionary

The Dictionary data type represents a collection of keys and values.

Every key that you create in this dictionary must be unique. The main benefit is that you can immediately get the value for a specific key.

The value can be a type, but it can also be a List or another Dictionary data type.

Blow code sequence will give you idea how to use dictionary data type:

//Declaring List

CustomerNamesIN: List of [Text];

CustomerNamesUS: List of [Text];

CustomerNamesCA: List of [Text];

//Declaring Dictionary

CountryWiseCustomer: Dictionary of [Code[20], List of [Text]];

//Assigning values to List

CustomerNamesIN.Add(‘KSD Consultancy’);

CustomerNamesIN.Add(‘Microsoft India’);

CustomerNamesIn.Add(‘Ashwini Tripathi’);

CustomerNamesUS.Add(‘Paul’);

CustomerNamesUS.Add(‘Linda’);

CustomerNamesCA.Add(‘Eddy’);

CustomerNamesCA.Add(‘Mark’);

//Assigning values to Dictionary

CountryWiseCustomer.Add(‘IN’,CustomerNamesIN);

CountryWiseCustomer.Add(‘US’,CustomerNamesUS);

CountryWiseCustomer.Add(‘CA’,CustomerNamesCA);

//Retrieving value from Dictionary

CountryWiseCustomer.Get(‘IN’).Get(1);

Here is the complete code:

Created new codeunit and declared variables & procedures to manipulate values in Collections.

Added Code to call procedures defined in codeunit, to assign and retrieve values from collections.

Now its time to check output of above code.

Hope you get idea how to work with Collections, you may find more posts in coming days where we may discuss about methods available for collection.

BC14, Business Central, Cumulative Updates, Dynamics 365, How To, Information, Instalation & Configuration, NAV 2016, NAV 2017, NAV 2018, Updates, Wave 1, Wave 2

Cumulative Updates for Microsoft Dynamics NAV 2016/2017/2018 And BC Released in Dec 2020

Update 17.2 for Microsoft Dynamics 365 Business Central 2020 Release Wave 2 (Application Build 17.2.19367.19735, Platform Build 17.0.19353.19730)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)

For a list of updates that were released for Microsoft Dynamics 365 Business Central 2020 Release Wave 2, see released updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 2. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 2.

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 17.2 for Microsoft Dynamics 365 Business Central  2020 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 2 update.

Prerequisites

You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 2 installed to apply this hotfix.

Update 16.8 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.8.19389, Platform Build 16.0.19389)

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 1 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 16.8 for Microsoft Dynamics 365 Business Central  2020 Release Wave 1

Update 15.13 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 (Application Build 15.13.45740, Platform Build 15.0.45731)

How to obtain the Microsoft Dynamics 365 Business Central 2019 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.

Update 15.13 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2

Cumulative Update 19 for Microsoft Dynamics 365 Business Central April’19 on-premises (Application Build 14.20.45823, Platform Build 14.0.45810)

How to obtain the Microsoft Dynamics 365 Business Central Spring 2019 files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 19 for Microsoft Dynamics 365 Business Central Spring 2019 Update on-premises

Cumulative Update 36 for Microsoft Dynamics NAV 2018 (Build 45821)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 36 for Microsoft Dynamics NAV 2018

Cumulative Update 49 for Microsoft Dynamics NAV 2017 (Build 30392)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 49 for Microsoft Dynamics NAV 2017

Cumulative Update 62 for Microsoft Dynamics NAV 2016 (Build 52006)

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 62 for Microsoft Dynamics NAV 2016

Announcement, BC14, Business Central, Cumulative Updates, How To, India Localization, Information, Instalation & Configuration, NAV 2016, NAV 2017, NAV 2018, Tip & Tricks, Updates, Wave 1, Wave 2

2020 wave 2 & Cumulative Updates for Microsoft Dynamics NAV 2016/2017/2018 And BC Released in Oct 2020

Microsoft Dynamics Business Central on Premises 2020 Wave 2 Release

Product Downloads

Download the appropriate files below:

Microsoft Dynamics 365 Business Central on premises
Download AU-Australia
Download AT-Austria 
Download BE-Belgium 
Download CA-CanadaDownload CZ-Czech Republic  
Download DK-Denmark 
Download FI-Finland 
Download FR-France 
Download DE-Germany 
Download IN-India (preview)
Download IS-Iceland 
Download IT-Italy 
Download MX-Mexico 
Download NL-Netherlands 
Download NZ-New Zealand 
Download NO-Norway 
Download ES-Spain 
Download SE-Sweden 
Download CH-Switzerland 
Download UK-United Kingdom Download US-United States of America
Download RU-Russia 
Download W1 

Cumulative Update 60 for Microsoft Dynamics NAV 2016 (Build 51947)

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics NAV 2016, see released cumulative updates for Microsoft Dynamics NAV 2016. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2016.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 60 for Microsoft Dynamics NAV 2016

How to install a Microsoft Dynamics NAV 2016 cumulative update

See How to install a Microsoft Dynamics NAV 2016 cumulative update.

Prerequisites You must have Microsoft Dynamics NAV 2016 installed to apply this hotfix.

Cumulative Update 47 for Microsoft Dynamics NAV 2017 (Build 30351)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2017, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2017, see released cumulative updates for Microsoft Dynamics NAV 2017. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2017.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 47 for Microsoft Dynamics NAV 2017

How to install a Microsoft Dynamics NAV 2017 cumulative update

See How to install a Microsoft Dynamics NAV 2017 cumulative update.

Prerequisites You must have Microsoft Dynamics NAV 2017 installed to apply this hotfix.

Cumulative Update 34 for Microsoft Dynamics NAV 2018 (Build 44952)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2018, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics NAV 2018, see released cumulative updates for Microsoft Dynamics NAV 2018. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2018.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 34 for Microsoft Dynamics NAV 2018

How to install a Microsoft Dynamics NAV 2018 cumulative update

See How to install a Microsoft Dynamics NAV 2018 cumulative update.

Prerequisites You must have Microsoft Dynamics NAV 2018 installed to apply this hotfix.

Cumulative Update 17 for Microsoft Dynamics 365 Business Central April’19 on-premises (Application Build 14.18.45015, Platform Build 14.0.45012)

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics 365 Business Central Spring 2019, see released cumulative updates for Microsoft Dynamics 365 Business Central Spring 2019. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics Released Cumulative Updates for Microsoft Dynamics 365 Business Central Spring 2019.

Note

When you upgrade to Business Central 2019 release wave 2 (version 15), refer to Dynamics 365 Business Central Upgrade Compatibility Matrix to see which Business Central 15 versions are compatible with this cumulative update.

How to obtain the Microsoft Dynamics 365 Business Central Spring 2019 files

This update is available for manual download and installation from the Microsoft Download Center.Cumulative update CU 17 for Microsoft Dynamics 365 Business Central Spring 2019 Update on-premises

How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update

See How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update.

Prerequisites You must have Microsoft Dynamics 365 Business Central Spring 2019 installed to apply this hotfix.

Update 15.11 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 (Application Build 15.11.44966, Platform Build 15.0.44957)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)

For a list of updates that were released for Microsoft Dynamics 365 Business Central 2019 Release Wave 2, see released updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2.

How to obtain the Microsoft Dynamics 365 Business Central 2019 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.Update 15.11 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update.

Prerequisites You must have Microsoft Dynamics 365 Business Central 2019 Release Wave 2 installed to apply this hotfix.

Update 16.6 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.6.17046, Platform Build 16.0.17024)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)
For a list of updates that were released for Microsoft Dynamics 365 Business Central 2020 Release Wave 1, see released updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 1. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 1.

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 1 files

This update is available for manual download and installation from the Microsoft Download Center.Update 16.6 for Microsoft Dynamics 365 Business Central  2020 Release Wave 1

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 1 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 1 update.

Prerequisites You must have Microsoft Dynamics 365 Business Central 2020 Release Wave 1 installed to apply this hotfix.

BC14, Business Central, Error, Event Log, Failed to reach status, How To, Information, On this Server, Running, Symbol Reference

Update Symbol Reference & Error: Failed to reach status ‘Running’ on this server – Additional information may be in the event log of the server

Some time while working we notice below error; Server Instance fails to start.

One of my reader requested solution from me.

So, to generate error I have intentionally created the error to explain the process.

You should pay attention to the message, as it says Additional information may be in the event log of the server.

All errors represented in Error log, sometimes is too technical and don’t give right clue.

There could be other reason, I am representing one general error.

When this happens, series of error messages are generated. All of them may not be helpful to find exact error.

But if you seriously scan each error, something always you can find which can help you in identifying the error or cause of same.

Just like below message, here we can identify that error is in Page 41, due to which Metadata is not updated correctly, leading to failure to starting the Server Instance.

Once you fix the error, you may get error for another object and similarly you can fix that too.

Alternatively, you can compile all objects and find errors in objects modified by you and get done in one shot.

Once all error is resolved, you will be able to start the Server Instance.

If you don’t get modifications to objects available in your AL you can run below command, make sure you Run as Administrator.

Switch to Installation folder by default: –

C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\140\RoleTailored Client

And execute below command:

Finsql.exec Command=generatesymbolrefrence, Database=<Your BC Database>, ServerName=<Your SQL Server Name>

After this you should be ok to start your Server Instance and see modification in AL Project.

Business Central, Cumulative Updates, How To, Information, Instalation & Configuration, NAV 2017, NAV 2018, on-premises, Updates, Wave 1, Wave 2

Cumulative Updates for Microsoft Dynamics NAV 2017/2018 And BC Released in Sep 2020

Cumulative Update 46 for Microsoft Dynamics NAV 2017 (Build 30340)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2017, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2017, see released cumulative updates for Microsoft Dynamics NAV 2017. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2017.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 46 for Microsoft Dynamics NAV 2017

How to install a Microsoft Dynamics NAV 2017 cumulative update

See How to install a Microsoft Dynamics NAV 2017 cumulative update.

PrerequisitesYou must have Microsoft Dynamics NAV 2017 installed to apply this hotfix.

Cumulative Update 33 for Microsoft Dynamics NAV 2018 (Build 44657)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2018, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics NAV 2018, see released cumulative updates for Microsoft Dynamics NAV 2018. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2018.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

Cumulative update CU 33 for Microsoft Dynamics NAV 2018

How to install a Microsoft Dynamics NAV 2018 cumulative update

See How to install a Microsoft Dynamics NAV 2018 cumulative update.

PrerequisitesYou must have Microsoft Dynamics NAV 2018 installed to apply this hotfix.

Cumulative Update 16 for Microsoft Dynamics 365 Business Central April’19 on-premises (Application Build 14.17.44663, Platform Build 14.17.44656

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous cumulative update. (This applies only to customer licenses.)

For a list of cumulative updates that were released for Microsoft Dynamics 365 Business Central Spring 2019, see released cumulative updates for Microsoft Dynamics 365 Business Central Spring 2019. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics Released Cumulative Updates for Microsoft Dynamics 365 Business Central Spring 2019.

How to obtain the Microsoft Dynamics 365 Business Central Spring 2019 files

This update is available for manual download and installation from the Microsoft Download Center.Cumulative update CU 16 for Microsoft Dynamics 365 Business Central Spring 2019 Update on-premises

How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update

See How to install a Microsoft Dynamics 365 Business Central Spring 2019 cumulative update.

PrerequisitesYou must have Microsoft Dynamics 365 Business Central Spring 2019 installed to apply this hotfix.

Update 15.10 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 (Application Build 15.10.44664, Platform Build 15.10.44655)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)

For a list of updates that were released for Microsoft Dynamics 365 Business Central 2019 Release Wave 2, see released updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2.

How to obtain the Microsoft Dynamics 365 Business Central 2019 Release Wave 2 files

This update is available for manual download and installation from the Microsoft Download Center.Update 15.10 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2

How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update

See How to install a Microsoft Dynamics 365 Business Central 2019 Release Wave 2 update.

PrerequisitesYou must have Microsoft Dynamics 365 Business Central 2019 Release Wave 2 installed to apply this hotfix.

Update 16.5 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.5.15953, Platform Build 16.5.15941)

This update replaces previously released updates. You should always install the latest update.

It may be necessary to update your license after you install this hotfix to gain access to new objects that are included in this or a previous update. (This only applies to customer licenses.)
For a list of updates that were released for Microsoft Dynamics 365 Business Central 2019 Release Wave 2, see released updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 1. Updates are intended for new and existing customers who are running Microsoft Dynamics Released Updates for Microsoft Dynamics 365 Business Central 2020 Release Wave 1.

How to obtain the Microsoft Dynamics 365 Business Central 2020 Release Wave 1 files

This update is available for manual download and installation from the Microsoft Download Center.Update 16.5 for Microsoft Dynamics 365 Business Central  2020 Release Wave 1

How to install a Microsoft Dynamics 365 Business Central on-premises 2020 Release Wave 1 update

See How to install a Microsoft Dynamics 365 Business Central 2020 Release Wave 1 update.

PrerequisitesYou must have Microsoft Dynamics 365 Business Central 2020 Release Wave 1 installed to apply this hotfix.