Cumulative Updates for Microsoft Dynamics NAV 2015/2016/2017/2018 & BC Released in Nov 2019

Cumulative Update 61 for Microsoft Dynamics NAV 2015 (Build 51641)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features that were released in previous cumulative updates.
Note You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than cumulative update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

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 2015, see released cumulative updates for Microsoft Dynamics NAV 2015. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2015.

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 61 for Microsoft Dynamics NAV 2015

How to install a Microsoft Dynamics NAV 2015 cumulative update

See How to install a Microsoft Dynamics NAV 2015 Cumulative Update.

Prerequisites

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

Cumulative Update 49 for Microsoft Dynamics NAV 2016 (Build 51640)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016, 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 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 49 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 36 for Microsoft Dynamics NAV 2017 (Build 30074)

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 36 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 23 for Microsoft Dynamics NAV 2018 (Build 37606)

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 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 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 23 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 13 for Microsoft Dynamics 365 Business Central on-premises (Application Build 37622, Platform Build 37612)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics 365 Business Central, 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 365 Business Central, see released cumulative updates for Microsoft Dynamics 365 Business Central. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics Released Cumulative Updates for Microsoft Dynamics 365 Business Central.

How to obtain the Microsoft Dynamics 365 Business Central update files

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

Cumulative update CU 13 for Microsoft Dynamics 365 Business Central on-premises

How to install a Microsoft Dynamics 365 Business Central cumulative update

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

Prerequisites

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

Cumulative Update 06 for Microsoft Dynamics 365 Business Central Spring 2019 Update on-premises (Application Build 14.7.37609, Platform Build 14.7.37587)

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 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 06 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.1 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 (Application Build 15.1.38071, Platform Build 15.1.37898)

This update replaces previously released updates. You should always install the latest 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 update (this only applies to customer licenses).

For a list of updates 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.1 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.

Dynamics 365 Business Central 2019 wave 2 – Released

The 2019 release wave 2 for Business Central delivers plenty of new features and capabilities.

Dynamics NAV customers upgrading to Business Central on premises will enjoy the unique flexibility to continue running on premises, move to the cloud, or adopt a hybrid approach.

You can download the product ​​​from Microsoft Product Download Page. Select your desired country link to download product specific to your country. You will require partner source or customer source login to access.

Direct link to W1 Product is here.

With the 2019 release wave 2, users access Business Central in the browser, Windows 10 desktop app, mobile apps on Android and iOS, or in Outlook.

The 2019 release wave 2 is the first version that does not include the classic development environment (also known as C/SIDE) or the Dynamics NAV Client connected to Business Central (also known as the Windows client).

The modern developer experience based on Visual Studio Code now supports developing large apps such as the base application from Microsoft, and so C/SIDE is discontinued for Business Central going forward.

Business Central 2019 release wave 2 moves to the Modern Support Lifecycle Policy effective October 1, 2019. This policy requires that the customer maintain the Enhancement Plan and deploy updates as noted in the servicing policy.

The Modern Lifecycle Policy requirements are defined below:

  1. Customers must stay current as per the servicing and licensing requirements published for the product or service.
  2. Customers must have the rights to use the product or service.
  3. Microsoft must currently offer support for the product or service.

BC Product Life Cycle

DYNAMICS 365 BUSINESS CENTRAL LICENSING PROGRAMS

License for Dynamics 365 Business Central will be sold through the following programs:

– Cloud Solution Provider Program (CSP) – Dynamics 365 Business Central

– D​​ynamics Price List (DPL) – Dynamics 365 Business Central on-premises ​

This section lists features that are planned to release from October 2019 through March 2020. Because this topic lists features that may not have released yet, delivery timelines may change and projected functionality may not be released

This colour (This feature is released. ) dates shows which features have been released for public preview or early access and for general availability. Below list is updated as per information available at the time of writing this post.

Application enhancements

Feature Enabled for Public preview General availability
Allow non-sequential numbering End users, automatically Oct 1, 2019
Cancel reminders and finance charge memos End users, automatically Aug 1, 2019 Oct 1, 2019
Carry line descriptions to G/L entries when posting End users, automatically Aug 1, 2019 Oct 1, 2019
Create records and convert prospects with better templates End users, automatically Aug 1, 2019 Oct 1, 2019
Use the Copy Document function on blocked lines End users, automatically Aug 1, 2019 Oct 1, 2019
Aged Accounts Payable includes External Document Number field End users, automatically Sep 1, 2019 Oct 1, 2019
Batch-post sales and purchases as scheduled End users, automatically Sep 1, 2019 Oct 1, 2019
Reconcile payables with the External Document Number field End users, automatically Sep 1, 2019 Oct 1, 2019

Application lifecycle management

Feature Enabled for Public preview General availability
Detailed notifications for update events Admins, makers, or analysts, automatically Oct 1, 2019
Multiple production environments Admins, makers, or analysts, automatically Oct 1, 2019
Report production outage in the Business Central Administration Center Admins, makers, or analysts, automatically Oct 2019
Support for performant data upgrade from C/AL tables to AL tables Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Ability to download a database export file Admins, makers, or analysts, automatically Nov 2019

Empower ISV acceleration

Feature Enabled for Public preview General availability
Design for extensibility Admins, makers, or analysts, automatically Aug 1, 2019 Oct 2019

Migrations to Business Central online

Feature Enabled for Public preview General availability
Enhancements for customer migration tools Admins, makers, or analysts, automatically Oct 2019

Modern clients

Feature Enabled for Public preview General availability
Add links to your navigation menu End users, automatically Aug 1, 2019 Oct 1, 2019
Add notes and links to data End users, automatically Aug 1, 2019 Oct 1, 2019
Enhancements to Excel integration End users, automatically Aug 1, 2019 Oct 1, 2019
Filter reports more efficiently End users, automatically Aug 1, 2019 Oct 1, 2019
Full keyboard shortcut support End users, automatically Aug 1, 2019 Oct 1, 2019
General user experience adjustments End users, automatically Aug 1, 2019 Oct 1, 2019
Get an overview of all business features End users, automatically Aug 1, 2019 Oct 1, 2019
Identify the company by a badge End users, automatically Aug 1, 2019 Oct 1, 2019
Longer timeout period for the server connection End users, automatically Aug 1, 2019 Oct 1, 2019
Modern clients only for Business Central Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Personalize actions on your Role Center End users, automatically Aug 1, 2019 Oct 1, 2019
Resize columns with fewer clicks End users, automatically Aug 1, 2019 Oct 1, 2019
Save and personalize list views End users, automatically Aug 1, 2019 Oct 1, 2019
Switch between companies in your business inbox in Outlook End users, automatically Aug 1, 2019 Oct 1, 2019
Multitask across multiple pages End users, automatically Aug 15, 2019 Oct 1, 2019
Customize user profiles without writing code End users, automatically Sep 1, 2019 Oct 1, 2019
Enter data with speed and agility End users, automatically Sep 1, 2019 Oct 1, 2019
Filter option fields by multiple values End users, automatically Sep 1, 2019 Oct 1, 2019

Modern developer tools

Feature Enabled for Public preview General availability
Translating other extensions Admins, makers, or analysts, automatically Oct 1, 2019
Access modifiers Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Attach and debug next Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Base application delivered as AL applications Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Convert tables from C/AL definitions to AL table definitions Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Database insights made available in AL Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Filtering XmlPort Objects End users by admins, makers, or analysts Aug 1, 2019 Oct 1, 2019
Implementing hierarchical menus End users by admins, makers, or analysts Aug 1, 2019 Oct 1, 2019
Improved app dependency handling on build and deploy Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
More power to developers using Designer Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019

Service fundamentals

Feature Enabled for Public preview General availability
New Support Request option in the Business Central Administration Center Admins, makers, or analysts, automatically Oct 2019
Partners can enter support contact details in the Business Central Administration Center Admins, makers, or analysts, automatically Oct 2019
Lock-free number series End users, automatically Aug 1, 2019 Oct 1, 2019
Page background tasks Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019
Surrogate keys Admins, makers, or analysts, automatically Aug 1, 2019 Oct 1, 2019

What’s New in Business Central April 2019 Release

April ’19 brings an update to Business Central that aims to enhance current customer satisfaction with the product.

Powerful new features for business users

Keyboard-centric features like speed of data entry and analysis, such as quick entry, list sorting, and data values. Improvements to features related to the customer context, such as work date and the company indicator, options enabling advanced users to be even more productive, such as focus mode, totals for lists, improved search, and the new page inspector. Enhancement related to filters in Excel export, common auto-save experience, and modern interface elements, such as the date picker, refreshed action bar, and all-product navigation.

Performance, reliability, and scalability enhancements

Along with innovative new features, Microsoft invested heavily in boosting performance, reliability, and scalability of Business Central, across the platform and business application.

The experience in the browser will be more responsive using technique of on-demand loading of page elements, server resources are optimized for fast user interaction, and the database has been tuned to handle more data and load it faster.

Users requiring assistance now have a single screen through which to find self-help material, share ideas with the community, and request support that has also been streamlined to reduce response time.

Business Central continues to meet ISO27001, ISO27017, ISO27018, SOC 1 & 2 Type 2, HIPPA BAA, and FERPA industry security and privacy compliance standards. For more details and a list of all certificates, see here.

Accessibility

Business Central is ready to support the diversity of your workforce where both the desktop and mobile interfaces are now highly accessible.

Base application as an app

Microsoft is making big investments in the platform to make it easier for ISVs to get into the cloud. This is achieved by splitting the big application that we have today into a system app and an app on top of that as an extension, compiled in AL using Visual Studio Code.

nfbc-1

Data and AI

The last major investment for the April release is Data and AI future. Strengthen and prepare integration with Dynamics 365 for Sales through CDS and ensure Business Central data contributes to intelligent insights (notes synching, late payment prediction) in Dynamics 365 AI for Sales apps and Business Central users get intelligent insights generated by Dynamics 365 AI for Sales (predictive opportunity scoring).

Borne from Overview of Dynamics 365 Business Central April ’19 release article.

New and planned for Dynamics 365 Business Central

Features that are planned to release between April and September 2019. Previews for some features will start in February 2019.

Below table lists functionality that may not have been released yet. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).

Productivity enhancements for business users

Feature Release type Online vs on-premises Date
Application enhancements General Availability Both April 2019
List views General Availability Both April 2019
Rich notes and links General Availability Online April 2019
Document focus mode General Availability Both April 2019
Work date indicator General Availability Both April 2019
Context or system indicator General Availability Both After April 2019
Quick Entry General Availability Both April 2019
New keyboard shortcuts General Availability Both April 2019
Autosave indicator General Availability Both April 2019
Improvements to scrolling in lists General Availability Both April 2019
Improved contextual search experience General Availability Both April 2019
Improved all-product navigation General Availability Both After April 2019
Personalization enhancements General Availability Both April 2019

Self-help and support

Feature Release type Online vs on-premises Date
Simplified Help and Support experience General Availability Both April 2019
Page inspection General Availability Both April 2019

Productivity enhancements for administrators

Feature Release type Online vs on-premises Date
Hardening the integration between Business Central and Dynamics 365 for Sales General Availability Both April 2019
Enhancements for application lifecycle management General Availability Both April 2019
Enhancements to the intelligent cloud for Dynamics SMB and Dynamics 365 Business Central General Availability Both April 2019

Powerful features for developers

Feature Release type Online vs on-premises Date
Designer enhancements for developers General Availability Both April 2019
Visual Studio Code and AL General Availability Both April 2019
Application as an app General Availability Both April 2019
Standard Web API General Availability Both April 2019

It is always suggested to see Microsoft Links for more details and any updates in future.

 

 

API – Business Central Part-2

In our previous post we saw basics of API in Navision. Let’s explore further.

If you missed the earlier post you can find here API – Business Central Part-1

Continuing from where we left in previous post.

Someone asked me why we require API when we have web service in place and can achieve same OData either query or filter in same fashion.

So what I am going to explain below will answer to that query.

The API will generate a REST service which returns OData.  The API is not the same as the OData web services that we discussed in our earlier post.

There we created an OData web service based on a card page.  If there were fields that need to be displayed on a card in the client application but you do not want those fields to expose in the OData web service, you will have to create a second card page to solve this problem.  In this case, we create a separate page for our API and only for the API.  This page cannot be requested in the client application.  It’s also much better concept to separate them from the regular pages.

Also we can apply templates for default value of field, which we will discuss later in below post.

Let’s start with creating our own API.

Each resource is uniquely identified through an ID. As discussed in our earlier post. So let’s start with this, I will start with my earlier created Table LoadoutPoint and add one field ID.

api009

Any new entry in my table will have a unique ID for Loadout Point, so I have added code in OnInsert trigger of the table.

api010

To create an API, you should create a page of type API, instead of a card page or list page.

Use tpage, Page for type API snippet for page structure. You get all the bare minimum properties to be added for API Page.

api011

Then you have to define which fields you would like to include.

api012

Some important rules to be followed for API Pages:

  • Fields should be named in the APIs supported format, Any Captions cannot have spaces and special characters. Only AlphaNumeric values permitted.
  • When you insert an entity through API endpoint, Business Central don’t run OnInsert trigger on the table.
  • And we have assigned the ID for the new record there. So Add Insert(true) for OnInsert Trigger.
  • Add business logic to Modify trigger. As external user can change values through API, even the value of the primary key field.
  • Add Delete(true) for On Delete trigger. The reason same as above.

So let’s add these 3 trigger in our page too.

api013

Ok so now we have modified Table and Created new API page, now it’s time to publish our app/extension.

Use command palette to publish your app.

Now it’s time to test, let’s access our API page from client and do setup for same.

Search for API Setup Page in the client.

api014

You can define and assign your Template from Template Code field, check with available same Templates how to do it.

api015

Also the conditions when this Template should apply as discussed in earlier post also.

Now let’s access the API from outside the Navision/ Business Central.

I will use Postman to test this.

To get the list of 44 standard APIs.

https://KSD-DESKTOP:7748/BC130/api/beta/

api016

To get the list of custom APIs.

https://ksd-desktop:7748/BC130/api/ksdconsultancy/app1/v1.0/

Hope you remember when we created API page we assigned few Properties like

APIPublisher = ksdconsultancy, APIGroup = app1, APIVersion = v1.0.

Now we will use those values to access my custom APIs.

See the url those are included after /api/

api017

All information is available in JSON format and further can be confirmed that there are 1000 records. Thus, the number of records integrated here depends on the Max Page Size parameter setup in Navision Server.

What else you can do with APIs:

  • Get to fetch or List
  • Post to insert records
  • Patch to modify records
  • Delete to Delete records
  • And so on.
  • You can extend existing API Pages too, I have yet not tried.

That we may discuss in some other post. Not to complicate this topic more for now I conclude this post here.

Will come up with more details in my upcoming posts, till then keep exploring, learning and take good care of yourself.

 

AL Basics – Part 6 [Publishing & Testing Extension]

Today we will see in our post how we can Publish & Test our Extension.

To be able to follow this steps discussed below you should have gone through my earlier post and your project is ready to continue from where we left in our previous post. If yet not please follow below links and continue their after to this post.

Bare Minimum Steps to Start with fresh Extension Project for Business Central

AL Basics – Part 2 [Table]

AL Basics – Part 3 [Table Continued]

AL Basics – Part 4 [Page]

AL Basics – Part 5 [Extending Table & Page]

Since we are going to continue same project, reason why I am asking to have it as we will be referencing to the objects we created in above posts.

Let’s begin with our today’s task.

Ext-7

Now we have all required basic stuffs to Publish our Extension.

To Publish your Extension first need to Build and Package your Extension.

Although you can Package & Publish in single command, follow as you feel comfortable.

Press <Ctrl> +<Shift> + <P> to access your Command Pallet.

Ext-8

Chose AL:Package to create Package.

Ext-9

At this stage your package is ready for deployment/Publish.

Next we will Chose AL:Publish from Command Pallet.

Ext-10

This will create Package and Publish to your server as given in launch.json file.

Just previous step is optional to create Package, but it is helpful in case you want to just create a package but not publish to your server, may be you have tested and creating final package for delivery to your customer.

Whatsoever, we are now ready to test our Package/Extension.

You may get below error:

The request for path /BC130/dev/metadata failed with code InternalServerError. Reason: NetFx40_LegacySecurityPolicy is enabled and must be turned off in the Microsoft.Dynamics.Nav.Server.exe.config file.

Locate the file from installation folder in my case: C:\Program Files\Microsoft Dynamics 365 Business Central\130\Service

Ext-11

Set value to false save and replace the config file.

Restart your Service, and try publishing again.

You may get error:

Error: Could not open the specified startup page. Please check that the server configuration key PublicWebBaseUrl has been properly set.

That’s not a problem you can ignore it, actually it is trying to open WebClient and launch the Object you specified in launch.json file.

Open your Client and browse Extension Management.

Ext-12

Your Extension is published, & you can check the information that you provided in app.json file is visible.

Now Let’s Test our Extension.

If you remember we have integration point on Sales order line, so to see our extension in action we need to check our Sales Order Line.

Ext-13

You can see the fields that we added in our Page Extension is visible on Sales Order Line.

You can add your data and start using the extension.

If you remember we also added Appointment Calendar Setup Page to the action on Loadout Point Page.

Ext-14

If you check the Objects in your database you will not find these objects in Object designer, so where is my all data stored & saved.

To find them you need to check in your SQL database.

Your Tables are name defined with postfix your application ID.

Sales Line Extended Table data.

Ext-15

Loadout Point Table data.

Ext-16

Working Calendar Time Slot.

Ext-17

Appointment Calendar Setup.

Ext-18

Hope you enjoyed Publishing and playing around with your First Extension.

I will come up with more advanced features and tips on Extensions in upcoming posts.

Keep Learning, remain safe and stay tuned for more in upcoming posts.

AL Basics – Part 4 [Page]

Today we will see how to create pages in AL.

Before we dive into it lets have some basic concept for Pages.

If you navigate in Navision you may be familiar with page types we have in Navision.

Types of Page

  • Card Page
  • List Page
  • CardPart Page
  • ListPart Page
  • Worksheet Page
  • Document Page
  • RoleCenter Page
  • Confirmation Dialog Page
  • ListPlus Page
  • StandardDialog Page
  • Navigate Page

All above pages are just how we design and use them for specific purpose, I will not go in details what type of page is used for what purpose you can find them in any document or already familiar with.

When we design pages we should have idea of Page Controls

Different Page Controls you have on pages are:

  • Actions
  • Content Area
  • Factbox Area
  • RoleCenter Area

All controls are placed in pages using below arrangement

Type SubType
   
Container Content Area
  FactBox Area
  RoleCenter Area
   
Group Group (Fast Tabs – on Card Pages)
  Repeater (List Pages)
  CueGroup (Rolecenter Pages)
  FixedLayout
  Grid layout
   
Field Data from Table
   
Part Display another Page, Chart, System defined features

Lets understand from below Customer List Page

Pag-1

Let’s create our First Page.

To Create a Page First we will create a File .al.

In Editor we fill type snippet tpage

You will get the options available, select Page of type list, we are going to create List Page.

Pag-2

Basic structure of the Page is given to you as below

Pag-3

Lets create our LoadoutPointList Page on Table Loadout Point table created in previous post.

Pag-4

Similarly we will create a Appointment Calendar Setup List Page, final code as below:

Pag-5

Similarly you can design Card Page Also:

I am not creating Page from scratch but will show you few properties, triggers from standard Page e.g.:- Cost Type Card

Pag-6

PageType you need to define as Card.

For FastTab you need to define group.

Pag-7

Above is the example of few properties for field control on Page.

Pag-8

To add factboxes to the page you define area(factboxes).

Here systempart for Links & Notes is added.

Pag-9

Above is actions to the page. Few properties how to define.

Pag-10

Above is the Page triggers.

Complete code for each objects is not possible to include in post.

But I will give to some tips using which you can explore equivalent AL Code and tryout them.

Suppose you want to see any feature how implemented in Customer Card.

Export that object as text, and convert using txt2al for equivalent al code.

You can refer back to my previous post Quick Start with Extensions for Business Central

Similar method I have explained in this post.

Pag-11

We will explore few more possibilities and Extending to existing Table & Pages in our upcoming post.

 

Bare Minimum Steps to Start with fresh Extension Project for Business Central

Step-1 Create Project Folder

To create a Project Folder press <Ctrl> + <Shift> + <P> to open command Palette or alternatively you can choose from Menu View -> Command Palette.

Now Select Al: Go!

BMS-1

Enter your Forder & Project Folder Name and press <Enter>

BMS-2

Wait for few seconds and choose “Your Own Server” option.

BMS-3

Step -2 Complete your Extension settings & Cleanup

You will land to your project Folder, where few files are created for you by default.

BMS-4

Now we will set our Server connection related changes and remove HelloWorld.al File.

BMS-5

Next we will check our Extension related settings.

BMS-6

Next our Task is to Download Symbols. If Symbol files are missing you will not be able to compile your project. Also any objects referenced for extension will say invalid object.

To Download Symbols again Go to you command pallet out of any 2 methods explained above you are comfortable with.

Step – 3 Download Symbols

BMS-7

Wait for few seconds, if settings of server in launch.json file is correct it should download your symbols.

BMS-8

You will see notification in right bottom corner, else can check the errors in Output Tab of Debugger Window.

You will notice new folder [.alpackages] with 2 files are created. These file contains the definition of your Navision objects.

Next I will prepare my Project Folder for getting started for my Extension development.

Step -4 Prepare your Project Folders to arrange you’re working Files.

BMS-9

Now my Project Folder is ready to start working with Extensions.

We will start creating Files/Objects in our next post.

 

 

AL Basics – Part-1

Programming in AL is very easy, just we need to make up our mind to accept the changes. Till we resist to changes it seems to be hard once we accept it, that becomes easy.

In VS Code, for AL it provides Snippets which help you with creating your base structure following which you can easy build up your complex coding structures.

Few Snippets ready to use are as below:

To Create Structure of Snippet to use
Table ttable
Page tpage
Codeunit tcodeunit
Page Extension tpageext
Table Extension ttableext
Table Field tfield
Page Field tfieldpage
Trigger ttriger
Functions/Procedure tprocedure
Assert error tassert
With Do twithdo
If tif
If Else tifelse
Case of tcaseof
Case else tcaseelse
For tfor
While twhile
Repeat Until trepeat

Today I will explain on conditional and loop statements for others I will do in next post.

These statements are similar as we are familiar with using in our C/AL.

Below are few examples to explain them, since no changes so need not commentary for same.

conditional StatementsLoop Statements

For other Snippets will come in next post.

Quick Start with Extensions for Business Central

Today I am going to give you a tip for getting started with Extension Building for Business Central.

As AL have newly introduced so it is going to take time to learn and be comfortable with programming using AL codes.

Best way of learning anything is learning by examples. What if we first learn what will be equivalent to actions we perform in Navision designer.

So to demonstrate this I will start with creating a small customization directly in Navision then convert it to Extension.

Are you ready? Let’s start with this exciting journey of 1-2-3 step.

Step 1.

Saving my Base Line Object (Prior to performing any Modification).

In this example I am going to Modify Table – Item & Page Item Card.

Let’s export this two object as FOB, Later we will require this to revert our customization.

Also export this two objects as txt. This we will require in our Extension building process. But need to follow instructions explained in below step, else this file will be rejected by the tool when we try to convert to AL. Follow the process of exporting text file explained after completing the Customizations in Step 3.

Step 2.

I will create one Table 50000 – Product Range as below:

1

Next I will create one List Page on above Table, Page 50000 – Product Range as below:

2

Also will Add Table Property as below to enable Lookup & DrillDown

3

Save your objects.

Now I will add one field to Table Item & Page Item Card as below:

4

5

Now I am done with my all customization and saved my modified & New Objects.

Step 3.

Now we will export these objects All New & Modified into Text File.

But we will not do it from Object designer rather will do it from command prompt.

Preparing for AL Conversion.

Run Command Prompt as Administrator.

Change to RTC folder.

6

Check your folder where you have installed, default location is as one I am using.

You can export all objects in one single file or one file per object. I am exporting one object per file, you can explore command parameter to use accordingly.

I will be using below commands.

First we will create 4 Folders namely Original, Modified, Delta & Result

Note: Make sure ExportToNewSyntax with command parameter is used else txt2al (which we will use below) will reject your files, it is mandatory.

Below command is to export Original objects before modification: (Save in Original Folder)

1. finsql.exe Command=ExportToNewSyntax, File=G:\RND\Txt2ALTest\exportedBaselineObjectsT27.txt, Database=”Demo Database NAV (13-0)”, ServerName=”KSD-DESKTOP” ,Filter=Type=table;ID=27

2. finsql.exe Command=ExportToNewSyntax, File=G:\RND\Txt2ALTest\exportedBaselineObjectsP30.txt, Database=”Demo Database NAV (13-0)”, ServerName=”KSD-DESKTOP” ,Filter=Type=page;ID=30

Below command is for New Objects: (Save in Modified Folder)

3. finsql.exe Command=ExportToNewSyntax, File=G:\RND\Txt2ALTest\exportedNewObjectsT50000.txt, Database=”Demo Database NAV (13-0)”, ServerName=”KSD-DESKTOP” ,Filter=Type=table;ID=50000

4. finsql.exe Command=ExportToNewSyntax, File=G:\RND\Txt2ALTest\exportedNewObjectsP50000.txt, Database=”Demo Database NAV (13-0)”, ServerName=”KSD-DESKTOP” ,Filter=Type=page;ID=50000

Below command is for Modified Objects: (Save in Modified Folder)

5. finsql.exe Command=ExportToNewSyntax, File=G:\RND\Txt2ALTest\exportedModifiedObjectsT27.txt, Database=”Demo Database NAV (13-0)”, ServerName=”KSD-DESKTOP” ,Filter=Type=table;ID=27

6. finsql.exe Command=ExportToNewSyntax, File=G:\RND\Txt2ALTest\exportedModifiedObjectsP30.txt, Database=”Demo Database NAV (13-0)”, ServerName=”KSD-DESKTOP” ,Filter=Type=page;ID=30

Our Next step will be to create DELTA files.

Open Business Central Administration Shell

Import your Microsoft.Dynamics.Nav.Model.Tools Module using below syntax

import-module “C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\130\RoleTailored Client\Microsoft.Dynamics.Nav.Model.Tools.psd1” -force –verb

Execute below Shell Command:

Compare-NAVApplicationObject -OriginalPath G:\RND\Txt2ALTest\Original\*.txt -ModifiedPath G:\RND\Txt2ALTest\Modified\*.txt -DeltaPath G:\RND\Txt2ALTest\DELTA\ -ExportToNewSyntax

7

After this process we will get our Delta files in Delta Folder, this will be input to our next command/tool.

Next we will convert Delta File to AL files.

On Command prompt used above run below command: (This is not Shell Window please make sure)

txt2al –source G:\RND\Txt2ALTest\DELTA\ –target G:\RND\Txt2ALTest\RESULT\

8

Here we will get our *.al files. Which will be used for creating extensions.

Step 4.

Perform clean up to the database.

  1. Import the FOB exported in Step one to restore your original Table 27 & Page 30.
  2. Delete New Created Objects.

Now our database in in original state as before performing customization.

Fresh and Clean Business Central Database without any customizations.

Step 5.

In this step we will create extension in VS Code using above obtained *.al file.

Open VS Code and Press <Ctrl>+<Shift>+<P> and select AL:Go! to create a project Folder

9

Enter your Project Folder and press enter

10

Update your app.json file as below:

Add Name & Publisher, also check available idRange all objects in this project must be in this Range.

11

Update your launch.json file with your server & authentication details accordingly:

12

Remove the HelloWorld.al file created by default by right click and select delete.

Now add your created *.al files

13

You can drag and Drop to your Project Folder.

Now you will get errors, to resolve it we need to download our Symbols from Navision.

To download press <Ctrl>+<Shift>+<P> to open command Pallet and select Al: Download Symbols

14

If your server settings in launch.jason is correct your Symbols will get downloaded.

15

Now let resolve any others errors that may have in your *.al Files.

First I will rename my all Files to meaningful name so that in future it is easy to manage.

To do so, right click the File and select Rename, in my case I have renamed as below:

16

Now we will open each file and perform required action to resolve the errors as below.

After changes don’t forget to save your files.

17

18

19

20

Ensure Object ID you use is within the range of id provided in app.json file. ID is not used in database or any other extensions. Else when you deploy the extension it will give errors, also make sure you give unique object names too.

DataClassification property is not available in Al so we removed it.

Now my all objects are error free, and ready to be packaged.

Step 6.

Now we will Deploy & Test our Extension.

To create a package press <Ctrl>+<Shift>+<P> to open command pallet.

21

You can choose AL:Publish also it will create package and Publish to the server.

Next you choose AL:Publish to deploy your Extension to the Business Central.

You can verify your Extension from Extension Management Page from Navision Client

22

Double click on your extension record to see details:

23

Now let’s see in action our extension.

Open Item Card.

24

Congrats, your First Extension is ready to use.

There is lots of many thing to explain, but in single post everything is not possible. I will come up with basic things and creating Extensions from scratch in some other posts.

It was just a quick idea, as everyone is looking option for upgrade so this information may be handy to plan their next move.

We will learn basics of AL and other fundamental things in our upcoming posts.

Before I close this post will like to share few more details to complete this post.

If you check your Navision you will not find any object or additional fields we added in our extension, then where is my data stored?

Let’s have look in SQL.

25

Item Extension & Product Group table is created with your app id of the extension.

We will discuss in more details about other things in details in our next upcoming posts.

Till then keep learning, and stay safe, take care.

 

Cumulative Update for Microsoft Dynamics NAV 2015/2016/2017/2018 Released in Oct 2018

Cumulative Update 48 for Microsoft Dynamics NAV 2015 (Build 50638)

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

Note You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than cumulative update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

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 2015, see released cumulative updates for Microsoft Dynamics NAV 2015. Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2015.

How to obtain the Microsoft Dynamics NAV update files

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

Download Cumulative update CU 48 for Microsoft Dynamics NAV 2015

How to install a Microsoft Dynamics NAV 2015 cumulative update

See How to install a Microsoft Dynamics NAV 2015 Cumulative Update.

Prerequisites

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

Cumulative Update 36 for Microsoft Dynamics NAV 2016 (Build 50637)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016, 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 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.

Download Cumulative update CU 36 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 23 for Microsoft Dynamics NAV 2017 (Build 24745)

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.

Download Cumulative update CU 23 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 10 for Microsoft Dynamics NAV 2018 (Build 24742)

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 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 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.

Download Cumulative update CU 10 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.

Previous Older Entries

Important

Most of the contents you find in this blog will be either inherited from MSDN or Navision Developer IT Pro Help. Some places images are also directly taken from these sites. Purpose is simple to try those stuffs and re-produce adding few things as per my understanding to make easy understanding for others and quick reference.

Here nothing under my own brand or authorship of the content. At any point of time we are just promoting Microsoft stuffs nothing personnel with same.

Hope stuffs used here will not violate any copyright agreement with them. In case by mistake or in-intestinally it happens and the Microsoft feels these should not be used Microsoft have full right to inform me about same and will be glad to take down any such content which may be violating the norms.

Purpose is to promote Navision and share with community.

FB Profile

Like FB Page

%d bloggers like this: