Category: AL Code

Cumulative Update Summary October 2019

This image has an empty alt attribute; its file name is updateimage.jpg

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV.

Microsoft Business Central Spring CU 2:- BUSINESS CENTRAL CU 2

Microsoft Dynamics NAV 2018 CU 22 :- NAV2018CU22

Microsoft Dynamics NAV 2017 CU 35 :- NAV 2017 CU34

Microsoft Dynamics NAV 2016 CU 48 :- NAV 2016 CU 47

Microsoft Dynamics NAV 2015 CU 60 :-NAV 2015 CU 60

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Stay tuned for more updates…

Business Central Wave 2-Upload License

With the release of business central wave 2 No Developer environment ,so question comes how to upload customer/developer license in database.

Powershell command comes to rescue in this environment. Following few commands will help you to upload the license.

Step 1 :- Open windows PowerShell ISE as Administrator

Step 2:- Import Module for Business Central Wave 2 .Use following command

Import-Module 'C:\Program Files\Microsoft Dynamics 365 Business Central\150\Service\NavAdminTool.ps1'

Step 3 :- Add following command to import the license

Import-NAVServerLicense -LicenseFile 'C:\Cronus.flf' -ServerInstance BC150

Step 4 :- Restart Service

Restart-NAVServerInstance -ServerInstance BC150

Step 5 :- See the information of License

Export-NAVServerLicenseInformation -ServerInstance BC150

Hope this will help you. Explore more..

*** Change path of license file and Service name according to your configuration

Business Central Wave 2 Released

So most awaited Business Central release ‘Wave 2’ released on 1st October

Download Link https://mbs.microsoft.com/partnersource/global/support/support-news/bconpremdownload_2019_wave2

Licensing Guide

https://mbs.microsoft.com/partnersource/global/pricing-ordering/licensing-policies/Dyn365BusinessCentralPricingLicensing

Business Central Docs

https://docs.microsoft.com/en-us/dynamics365/business-central/product-get-started

New and Planned Features

https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/planned-features

Lets Explore and Stay Tunes for more

CU01 for Business Central Spring Release 2019

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV.

Microsoft Dynamics Business Central Spring Release CU 01 :- BC CU01

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Stay tuned for more updates…

Business Central-Field Length change in Tables

This spring release of business central comes up with changes in field length of tables as below.

You can check those tables and fields in following file

Hope this will help you specially while upgrade.

Please follow Waldo’s blog for more information on above subject.http://www.waldo.be/2019/05/14/microsoft-dynamics-365-business-central-spring-update-changed-some-field-lengths/

Stay tuned for more.

How to search Pages using Additional Search Terms in Business Central

All of you aware of ‘Tell Me‘ features of business central where you can search pages ,reports by key in name .

Today we will see how to search page apart from default page name .

To achieve this we need to add additional parameters in list pages as follows

Compile the object and search the page using additional terms in web client

Now from web client search the page using additional terms defined in list page

Hope this will help you

Stay tuned for more..

How to Create Unique Keys in AL Development/Business Central

Spring Release 2019 of business central comes up with new features for creating unique keys

Today we will see how to create unique keys in table

While creating second keys you can add an additional parameters said ‘Unique’. This will not allow duplicate values in the field where unique parameter is mentioned.

Now we will see this validation works on business central. Here we are trying put same description which is throwing error because of unique key.

You can define multiple unique keys in one table.

Points to Remember

  • Field can have empty value that means empty value is also value.
  • Not supported in table extensions.

Hope this will help you ..

How to Create Views in AL Development/Business Central

Now you all are aware the importance of creating views in windows client as it save the time of applying filters on the list of records. You can save the view with required filters and use it for future as it show the required data based on saved filters which improves productivity of users

Today we will see how we can create views in AL language.

Following examples illustrates how to create view from item list where inventory is greater than 10000.

In this example create new profile and added views in item list as below

Even you can apply more filters and order by also. As well as you can modify the page layout for the views as per your requirement

Publish the extension and open the business central web client .From setting change the profile and go to item List.

In the above picture you can see views has been added into the item list. Once you click on that view you can see the details as per define in views.

Following points need to remember.

  1. Can not use variables and methods .Can use only table fields
  2. Can not create new page controls from view.
  3. You can modify views from extension or customizations.

Hope you like this way of creating views in business central .Anyhow in upcoming versions there will option available on web client to create views as like windows client.

Cheers….

Cumulative Update Summary April 2019

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV.

Microsoft Dynamics NAV 2018 CU 16 :- NAV 2018 CU16

Microsoft Dynamics NAV 2017 CU 29 :- NAV 2017 CU 29

Microsoft Dynamics NAV 2016 CU 42 :- NAV 2016 CU 42

Microsoft Dynamics NAV 2015 CU 54 :-NAV 2015 CU 54

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Stay tuned for more updates…

Page Inspection in Business Central

Till NAV 2018 we have features called as ‘About this page’ which is very useful to analyze the business data or deep insight the table for those fields which are not visible on main page or sub page.

In business central this features replaced with Page Inspection with more features.

How do I enable Page inspection

Choosing inspect from top menu or by pressing Ctrl+Alt+F1

You can see box on right size which shows details for current record.

Top Features

  1. Page name with id
  2. Table Name with id
  3. All table fields
  4. Extension name which extend this page
  5. Applied Filters.

Stay tuned for more