Author: Ammolh Saallvi

I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development. Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs. Certifications:- Microsoft Certified Technology Specialist -Dynamics Microsoft Sure Step Certified Professional Moderator at DUG Forum Specialties: • ERP Implementation • Client/Server Programming • Coding, Testing, troubleshooting and documentation. • Database Tuning and SQL • Database Performance • Debugging large programs • Project Management and Resource Management.

CU Summary for NAV -August 2018

updateimage

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

NAV 2018 :- Cumulative Update 08 for Microsoft Dynamics NAV 2018

NAV 2017 :- Cumulative Update 21 for Microsoft Dynamics NAV 2017

NAV 2016:- Cumulative Update 34 for Microsoft Dynamics NAV 2016

NAV 2015:-Cumulative Update 46 for Microsoft Dynamics NAV 2015

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.
  3. This Cumulative Update can require a database upgrade.

Stay tuned for more..

How to modify standard page layout using extension

15

In this blog we will see how we can modify  standard page by adding few fields and modify property of existing fields.

Adding customize fields in page layout 

For this I assume table extension is already created and now would like to add fields in page layout by creating page extension

In page layout for adding fields you can mention whether you want add fields before/after specified fields or addfirst/addlast in page.

In following example I am adding fields after field VAT Prod. Posting group

pay1

Once you press Shift+F5 then you can see result in page as follows.

pay2

Modifying existing  fields properties  in page layout 

One can modify properties of existing field using modify option in page extension

In this example changing visible property of one of the field in page as per below example

Original page display the field as below

pay3Now we would like to hide this field using visible property so in page extension you can write as below

pay4

Even you can add trigger and write you routine to execute.

Add Action in Page Layout

For adding action once can write following 

pay5

Here is the result in client.

pay6

Hope this help and stay tuned for more.

How to Protect IP Code in Business Central

15Now I know you already started developing app using VS Code and now questions is that how to protect app for viewing the code while debugging or downloading.

However extension development package provide setting for IP protection for viewing or downloading the code of extensions but you can also control by just adding one line code  in app.json file.

app.json file containing setting called showMyCode which controls whether it is possible to debug the code ,By default it is set to false which means debugging in extension code not allowed.

If you want to allow to show extension code then add the line as below in app.json file as by default this setting is not added in app.json file when it is created.

appjson

By adding this setting, you enable debugging into an extension to view the source code when that extension is set as a dependency.

Stay tuned for more.

 

 

 

How to Retain data after publishing App

15

Hope you all started app development and may be wondering how to retain data after publishing app or debugging several times or after adding more sample data.

How do I retain the sample data so every time no need to add the same data.  ?????

In Business central you can synchronize the sample data while publishing several times. This can be done by simple settings in launch .json file.

lanuchjson

Once you mention this settings then the  data synchronize is controlled by this settings.

This settings consist of two options i.e. Synchronize and Recreate .

The default value is synchronize which means data will be retain every time when the app get published.

When schemaupdate set to Recreate mode then all the tables and table extensions are recreated every time and data will get lost.

When schemaupdate set to Synchronize then:

Do’s

  1. Add more field in table
  2. Increase length of field.

Don’t

  1. Don’t delete the field which contains sample data as if the field is removed from table then data can not be synchronize
  2. Don’t decrease the length of field for code and text datatype.

For above points you need to write upgrade code units or set schemaupdate to recreate.

In next blog will see how to write upgrade code units.

Stay tuned for more…

 

 

 

 

 

 

 

 

Dynamics 365 Business Central October ’18 release

With the October ’18 release, Dynamics 365 Business Central is available in the cloud, on-premises, and in hybrid deployments.

Business Central on-premises availability

Business Central gets an on-premises deployment option that serves as a successor to Dynamics NAV. In other words, rather than a new version number for Dynamics NAV, customers can get Business Central on-premises.

Check following links

Overview of Dynamics 365 Business Central October ’18 release

Summary of what’s new in Dynamics 365 Business Central

 

CU Update with NAV 2018

updateimage

New cumulative update release for NAV 2018 CU 7

You can check on this link for more update Check for Details

Download from NAV 2018 CU7

Visit here for more details

https://blogs.msdn.microsoft.com/nav/2018/07/09/cumulative-update-07-for-microsoft-dynamics-nav-2018-has-been-released/

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.
  3. This Cumulative Update can require a database upgrade.

 

 

 

User and Workspace Settings in Visual Studio Code

I hope you already started working with Visual studio code.

In this section we will see how to do setting for User and workspace in Visual Studio code environment.

It is easy to configure visual studio code as per your likings using various settings. You can change VS code editor ,user interface and functioning by using this settings

There are three ways you can open user and workspace settings

  1. To access you can go to  Click on File–>Preferences–>Settings

User1user2

2) Using Command Palette(Ctrl+Shift+P)  by typing

Preferences: Open User Settings  or Preferences : Open Workspace Settings

user3

3) Use keyboard shortcut (Ctrl+,)

This provides two different settings

  • User Settings – Settings that apply globally to any instance of VS Code you open.
  • Workspace Settings – Settings stored inside your workspace and only apply when the workspace is opened.

Workspace settings override user settings.

How to create user settings 

Once you open settings then you can modify settings as below

Example. If I want to change font size in editor then I can do it from here

 

Change the font size and see the effect on editor.

user6

It shows the effect immediately after saving the file.

Same kind of settings you can do it for AL language extension management

user7These changes get saved in %APPDATA%\Code\User\settings.json

Hope this will help you while extension development

Stay tuned for more…

Cheers…

 

 

 

 

Setup Visual Studio Code for local NAV server Installation

In this section we will see how do we setup Visual studio code locally on NAV 2018 server.

Hereby I assume that NAV 2018 is already installed on local machine .

You can download Visual studio code from Visual Studio Code

After Installing NAV 2018 and Visual Studio Code follow following steps to enable Visual studio code for writing extension and AL code.

  1. Enable Developer Service endpoint from NAV server instance

Developer End Point

2) Setup Web Client Base URL

Mention the web client url address .for example :- http://localhost:8080/dynamicsnav110/

WebClientURL

Once all changes done in service then restart the service.

3) Open Visual studio code and Install VSIX file from media 

InstallVSIX

You will find .vsix file in NAV 2018 Media file in folder ..\NAV.11.0.22292.W1.DVD\ModernDev\program files\Microsoft Dynamics NAV\110\Modern Development Environment\ALLanguage.Vsix

This will install AL language in visual studio code

4) Press CTRL+SHIFT+P and select command AL:GO in order to select a location and create a folder with default file of an extension

5) Setup Launch .JSON file

JSOn

Change server instance to DynamicsNAV110 and authentication to Windows

6) Press CTRL+SHIFT+P  and use command to download symbols AL:Download Symbols

7) Pres CTRL+F5 to publish the Helloworld.AL extension which extends customer list page and same id is mention in startupobjectid parameters of launch .json file

AL1

Once publish you will get following in web client

2

Get ready for extension development with this….

Cheers…

 

 

 

 

Designer Feature in NAV 2018 CU3

Today I was exploring NAV 2018 CU3 web client and found that designer feature already available just like in Dynamics 365 Business central.

This also  create extension once design is complete …  Tooo Cool

That’s Nice.

 

Dynamics 365 Business Central : How to Search for Pages/report

How to enable the navigational  support for the page or report from search option on Business central

AL provides property called as UsageCategory which can be used to enable the search for page or report through search in Business central. If the UsageCategory property not defined then it will not available in search

Following are the property values which one can define in AL

  • None
  • Lists
  • Tasks
  • ReportsAndAnalysis
  • Documents
  • History
  • Administration

usage