How to kill session in Business Central
Nov27

How to kill session in Business Central

Recently faced a problem of table locking which goes in not responding stage and finally user close the tab ,but when user opens the session again it actually messed up the critical data (It seems unimaginable force was roaming that time when this happens). Eventually after trying couple of days for data correction I need to contact Microsoft to restore the database. When this happening… Continue Reading Ammolh Saallvi’s...

Read More
How to check financial journals in background in business central
Nov14

How to check financial journals in background in business central

With the release of Business Central Wave 1 2020  new feature added to check validation in background for financial journals As of now this feature is need to enabled from Feature management This features will helpful to financial users to check the issue before posting. Before this feature we have Test Report and Preview Posting to check the issues before posting. Advantage… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to add XML comments in AL Code :- Business Central
Oct30

How to add XML comments in AL Code :- Business Central

With the release of Business Central Wave 1 2020 XML comments is available in AL code. If you would like to add documentation to your code then you can use XML documentation .The documentation comment must immediately before the object such as codeunit,table,functions etc. The syntax for adding XML comments in your code is triple slashes /// followed by one of the supported XML… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to Delete extension data in business central
Oct25

How to Delete extension data in business central

With the release of Business Central Wave 1 2020 new feature added to delete the extension data from production or sandbox. Prior to that we can uninstall the extension but data still there for the extension. This feature will be useful when 1) Application is not in use. 2) Customer have desire to reinstall the extension data from scratch. Let see how to uninstall and delete… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to Copy Journal Line to Posted General Journal in Business Central
Oct21

How to Copy Journal Line to Posted General Journal in Business Central

With the release of Business Central Wave 1 2020 new feature added to copy the general journal to posted general journal. As you aware that whenever you post the journal entry the entries get deleted after posted the transaction. Now whenever accountant need to reverse the entries then they need to enter the same entries again with opposite sign. With this new version of business… Continue Reading Ammolh...

Read More
How to Use SetLoadFields in Business Central for performance
Oct18

How to Use SetLoadFields in Business Central for performance

With the release of Business Central Wave 1 2020 the partial records capability is available. The partial records capability is allows for loading a subset of normal table fields when accessing the data source based on SQL. To access the data source we use GET ,FIND NEXT. When we use these methods then runtime it load all fields and will hamper the performance while fetching the… Continue Reading Ammolh Saallvi’s Article...

Read More
Business Central Launch Event October 21 2020
Oct07

Business Central Launch Event October 21 2020

With the release of new version of business central One more virtual session is coming up for Business Central with fully loaded content for released version Following are session to be present virtually and of course on demand Register your self here Events No Description Stay tuned for more updates and Don’t Miss it Continue Reading Ammolh Saallvi’s Article on their blog Business Central Launch Event October 21 2020 With...

Read More
Use of implicit ‘with’ will be removed in the future :-Business Central
Oct05

Use of implicit ‘with’ will be removed in the future :-Business Central

Though above warning was informed by MS long time back but it has introduced in latest version of AL. With the update of new version of AL extension this warning is populated in AL code. Once you update above AL language version then you will find below warning Now this warning will become error in near future that means we need to correct it anyhow . If your app… Continue Reading Ammolh Saallvi’s Article on their blog Use...

Read More
The ID Range ‘[50000..99999] is not valid : Business Central
Oct02

The ID Range ‘[50000..99999] is not valid : Business Central

Today morning I update AL extension with the latest version as below After update I found following issue for Per Tenant app and was not able to find any clue for this issue To resolve the issue decided to roll back to latest update and it works fine but it is not giving the latest updates for AL Then I decided to ask our beloved community MVP

Read More
Business Central Wave 2 2020 Released
Oct02

Business Central Wave 2 2020 Released

With the new dawn of 1st October Microsoft released Business Central Wave 2 2020. This version is available for following W1 Version21 Localized versionIndia localization in Preview The product DVD will be downloaded from following URL Business Central Wave 2 2020 Few features of Business Central you can visit this link Business Central Wave 2 2020… Continue Reading Ammolh Saallvi’s Article on their blog Business Central...

Read More
Cumulative Update for Business Central September 2020
Sep09

Cumulative Update for Business Central September 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central MS Dynamics Business Central 2020 Wave 1 (BC16) :- CU 16.5 MS Dynamics 365 Business Central 2019 Release Wave 2(15.10) :- CU 15.10 Business Central Spring Release (BC16) :- CU16 Warning Before you install a cumulative… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Cumulative Update Summary September 2020
Sep07

Cumulative Update Summary September 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 33 :- NAV2018CU33 Microsoft Dynamics NAV 2017 CU46 :- NAV2017CU46 Warning Before you install a cumulative update in a production environment, take the following precautions: Test the cumulative update… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to build Multiline Instruction in Business Central
Sep06

How to build Multiline Instruction in Business Central

Few days back one of my customer ask me can you display text in bulleted format on page. Today I will show how I achieved this with very simple way. Created one page as follows with one field to display instruction in multiline format On the field set the multiline property to true. To display to instruction on bullet format created instruction variable as follows… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Cumulative Update for Business Central August 2020
Aug15

Cumulative Update for Business Central August 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central MS Dynamics Business Central 2020 Wave 1 (BC16) :- CU 16.4 MS Dynamics 365 Business Central 2019 Release Wave 2(15.9) :- CU 15.9 Business Central Spring Release (BC14) :- CU15 Warning Before you install a cumulative… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Cumulative Update Summary August 2020
Aug10

Cumulative Update Summary August 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 32 :- NAV2018CU32 Microsoft Dynamics NAV 2016 CU 58 :- NAV2016CU58 Warning Before you install a cumulative update in a production environment, take the following precautions: Test the cumulative update… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to Create Custom Event in Business Central
Jul28

How to Create Custom Event in Business Central

Looking at the subject there are lot of blogs available but I am writing this based on one of the request from my colleague. Everybody aware of that whenever you developed an app it need to be extensible and if anybody would like to add or modify any field or additional routing we need to have events which can extend the base functionality. Step 1 :- Simple Quick action to add event in… Continue Reading Ammolh Saallvi’s...

Read More
How to create Custom Notification in Business Central
Jul27

How to create Custom Notification in Business Central

This blog post I am writing based on request of one of the follower. Even though notification is not new business central world but today we will see how we will write custom notification and get notified for certain validations. To create notifications I added following simple scenario that when my page get opened it should show some notification. Lets see how we can do… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to Setup SMTP Mail Using Gmail in Business Central
Jul22

How to Setup SMTP Mail Using Gmail in Business Central

Recently I encounter this issue as one of the customer would like to set up Gmail as service provided for SMTP mail in business central. So I started the regular way how we started setting up SMTP and encounter the following issue. Initial Setup :- Did the initial setup with required details and while key in I key in the regular password which used while signing in Gmail.

Read More
How to convert long code into Procedure in AL/Business Central.
Jul16

How to convert long code into Procedure in AL/Business Central.

With the different code actions it is very easy to convert your long code into procedures. Just a small tip to convert to your long code into smaller procedures. To enable to code actions Hope this will help you. Stay tuned for more. Continue Reading Ammolh Saallvi’s Article on their blog How to convert long code into Procedure in AL/Business Central. With the different code actions it is very easy to convert your long code into...

Read More
Cumulative Update for Business Central July 2020
Jul10

Cumulative Update for Business Central July 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central MS Dynamics Business Central 2020 Wave 1 (BC16) :- CU 16.3 MS Dynamics 365 Business Central 2019 Release Wave 2(15.8) :- CU 15.8 Business Central Spring Release (BC14) :- CU14 Warning Before you install a cumulative update… Continue Reading Ammolh Saallvi’s Article on...

Read More
Business Central Wave 2 2020 Upcoming Features
Jul09

Business Central Wave 2 2020 Upcoming Features

By writing this I feel that clock is running faster and till the time we are utilizing the features of Wave 1 2020 more new features are planned and about to release in upcoming version Wave 2 2020. There are plenty of features are planned for Wave 2 2020 but will list here what are the features I am looking for. Database access intent changed to read-only for frequently used reports… Continue Reading Ammolh Saallvi’s...

Read More
Cumulative Update Summary July 2020
Jul07

Cumulative Update Summary July 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 31 :- NAV2018CU31 Microsoft Dynamics NAV 2017 CU 44 :- NAV2017CU44 Microsoft Dynamics NAV 2016 CU 57 :- NAV2016CU57 Warning Before you install a cumulative update in a production environment, take the… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to find Table Relation in Business Central.
Jul06

How to find Table Relation in Business Central.

With the release of business central new property is introduced to find the table relation of given field. This property is called as’ Relation’ which returns integer value Lets see how we can find that . To make it created one page extension and added one action button to display the value of table of given field. If you see the highlighted area where in I have used relation… Continue Reading Ammolh Saallvi’s...

Read More
How to Implement Interface in Business Central
Jul05

How to Implement Interface in Business Central

With the release of Business Central Wave 1 2020 new feature was introduced called ‘Interface’. It is basically syntactical contract that can be implemented by a non-abstract method. This allows for writing code that reduces the dependency on implementation details, makes it easier to reuse code. Today we will see how to write an interface and implement in Business central. For… Continue Reading Ammolh...

Read More
Cumulative Update for Business Central June 2020
Jun09

Cumulative Update for Business Central June 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central Business Central Wave 2 2019 (BC15) :- CU 15.7 Business Central Spring Release (BC14) :- CU13 Warning Before you install a cumulative update in a production environment, take the following precautions: Test the… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Events vs Interface :- Business Central
Jun08

Events vs Interface :- Business Central

While working on new baby ‘Interface’ identified few difference between Events and interface. EVENTSINTERFACESelect Events to Subscribe. Subscription optional.All Methods are mandatory defined in interface code unit and need to implement allUsed to react Used to Invoke.Extensibility for few methods or functionsExtensibility for many methods.All Subscribers are invokedOnly single code… Continue Reading Ammolh...

Read More
Cumulative Update Summary June 2020
Jun07

Cumulative Update Summary June 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 30 :- NAV2018CU30 Microsoft Dynamics NAV 2017 CU 43 :- NAV2017CU43 Microsoft Dynamics NAV 2016 CU 56 :- NAV2016CU56 Warning Before you install a cumulative update in a production environment, take the… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to bookmark Page/ Report in Business Central
Jun04

How to bookmark Page/ Report in Business Central

Today just one simple feature for business central. If you remember correctly in classic version we had ability to add shortcut for your favorite screens or report Now in business central also we can do that by bookmarking them for easy navigation. How to do that Hope this will help Stay tuned for more.. Continue Reading Ammolh Saallvi’s Article on their blog How to bookmark Page/ Report in Business Central Today just one simple...

Read More
Embed Video in Business Central
Jun01

Embed Video in Business Central

Last week my marketing manager asked me is it possible to embed product video in business central ? and my quick answer was YES. Here how we can add the video in business central. for this I created simple extension 1) Added on field to hold an video URL 2) Create one page extension with action button to play the video URL. Publish the extension and below was the… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
How to view database locks in business central
May25

How to view database locks in business central

Do you remember this screen from classic client where in we can find who has locked whom. Once we get blocking id then we try to kill those sessions using sql command . How to view such detail in business central. This view detail information like which object id and which function is causing the database locks. Hope this will help you. Stay tuned for more updates. Continue Reading Ammolh Saallvi’s Article on their blog How to...

Read More
How to View Table data in Business Central
May19

How to View Table data in Business Central

While working in C/AL we have leverage to see the table data from object designer itself but how we can view it from business central. There are different ways like we can mention the table in launch.json or we can construct the string in web browser to display the details. Following small video will help you to view from web client itself. Hope this will help you… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Microsoft Dynamics 365 Business Central Virtual Event
May15

Microsoft Dynamics 365 Business Central Virtual Event

During this global situation of pandemic Microsoft comes up with first ever virtual event for Business central and it will be quite exciting. Top Sessions Overview: Business Central and Common Data Service integrationBusiness Central: Coding for performanceManaging customer environments in Business Central onlineInterfaces and extensibility:  Writing extensible and change-resilient… Continue Reading Ammolh Saallvi’s...

Read More
Cumulative Update for Business Central Wave 1 2020
May13

Cumulative Update for Business Central Wave 1 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central Business Central Wave 1 2020 :- BC 16.1 Warning Before you install a cumulative update in a production environment, take the following precautions: Test the cumulative update in a non-production environment.Make a backup of… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to extend TableRelation Property-Business Central
May12

How to extend TableRelation Property-Business Central

Last week somebody asked me on can we extend table relation property and my answer was yes we can achieve this by table extension. Today we will see how we can do that Firstly create enum extension and extend as follows . For this demo I used Type field from Sales line table. enumextension 50145 PlaySaleDocType extends “Sales Line Type” { value(8; Retail) { Caption… Continue Reading Ammolh Saallvi’s Article on...

Read More
How to Create enum in Business Central
May10

How to Create enum in Business Central

With the release of Business Central 2020 Wave 1 lot of new features has been added to make product more prominent. Today we will see how to create enum in business central and use in table. Step 1 :- Create enum as follow Extensible :- If it is set to true then enum can be extended. Step 2 :- How to use in table As far as business central lot of enum has been added for… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Cumulative Update Summary May 2020-Business Central
May07

Cumulative Update Summary May 2020-Business Central

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central Business Central 2019 Spring Update CU 12 :- BC 14 Business Central 2019 Fall Release Wave 2 :- BC2019Wave2 Warning Before you install a cumulative update in a production environment, take the following precautions: Test the… Continue Reading Ammolh Saallvi’s...

Read More
Business Central : enum vs Options
May06

Business Central : enum vs Options

With the release of Business Central 2020 Wave 1 lot of new features has been added to make product more prominent. Though this concept of ENUM was introduced earlier but from new version onwards most of the option fields are available as extensible enum such as follows that means option fields goes away from table. Based on few queries received thought lets write down few difference… Continue Reading Ammolh Saallvi’s...

Read More
Cumulative Update Summary May 2020
May04

Cumulative Update Summary May 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 29 :- NAV2018CU29 Microsoft Dynamics NAV 2017 CU 42 :- NAV2017CU42 Microsoft Dynamics NAV 2016 CU 55 :- NAV2016CU55 Warning Before you install a cumulative update in a production environment, take the… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to extend enum in Business Central
Apr30

How to extend enum in Business Central

With the release of Business Central 2020 Wave 1 lot of new features has been added to make product more prominent. Though this concept of ENUM was introduced earlier but from new version onwards most of the option fields are available as extensible enum such as follows If define enum is extensible then we can add more option values in that field. How to add the new option… Continue Reading Ammolh Saallvi’s Article on...

Read More
Cumulative Update Summary April 2020-Business Central
Apr15

Cumulative Update Summary April 2020-Business Central

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central Business Central 2019 Spring Update CU 11 :- BC 14 Business Central 2019 Fall Release Wave 2 :- BC2019Wave2 Warning Before you install a cumulative update in a production environment, take the following… Continue Reading Ammolh Saallvi’s Article on their blog Cumulative...

Read More
How to get Table Information in Business Central 2020 Wave 1
Apr12

How to get Table Information in Business Central 2020 Wave 1

With the release of Business Central 2020 Wave 1 lot of new features has been added to make product more prominent. One of the future added is to get all table information such as no of records, size in KB etc. If you remember correctly in old version we have same screen which shows all the relevant information regarding tables as below How to get same screen in business… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Cumulative Update Summary April 2020
Apr09

Cumulative Update Summary April 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 28 :- NAV2018CU28 Microsoft Dynamics NAV 2017 CU 41 :- NAV2017CU41 Microsoft Dynamics NAV 2016 CU 54 :- NAV2016CU54 Warning Before you install a cumulative update in a production environment, take the… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Business Central:- How to find Events in AL
Apr07

Business Central:- How to find Events in AL

With the release of Business Central 2020 Wave 1 and AL extension lot of new features has been added to make AL development more productive. A core part of extension-based development is the use of events and event subscribers. Use the new Shift+Alt+E shortcut in the AL code editor to invoke a list of all events. Hope this will help you Stay tuned for more. Continue Reading Ammolh Saallvi’s Article on their blog Business...

Read More
Business Central 2020 Wave 1: New CodeCops
Apr03

Business Central 2020 Wave 1: New CodeCops

With the release of Business Central 2020 Wave 1 and AL extension new codecops added for more information and making your app more prominent AA0215 – Checking file naming This checks file name as per new guidelines and shows warning as below Following are the new guidelines for this warning Object NameFile NameCodeunit 50000 “Post Bank… Continue Reading Ammolh Saallvi’s Article on their blog Business Central 2020...

Read More
Business Central Wave 1 2020 Released
Apr02

Business Central Wave 1 2020 Released

MS released the major version of business central Wave 1 2020 on 1st April 2020 You can download the on-premise from following URL Few Links to follow Download BC 2020 Wave 1 What’s New and Planned for business Central Features Not Implemented On-Premise AL Language extension update Stay Tuned for more updates. Continue Reading Ammolh Saallvi’s Article on their blog Business Central Wave 1 2020 Released MS released the...

Read More
Cumulative Update for Business Central 2019 Wave 2
Mar17

Cumulative Update for Business Central 2019 Wave 2

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central 2019 Wave 2 Update 15.4 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 :- Business Central CU 15.4 Warning Before you install a cumulative update in a production environment, take the following… Continue Reading Ammolh Saallvi’s Article on their blog...

Read More
Cumulative Update Summary March 2020
Mar11

Cumulative Update Summary March 2020

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV. Microsoft Dynamics NAV 2018 CU 27 :- NAV2018CU27 Microsoft Dynamics NAV 2017 CU 40 :- NAV 2017 CU40 Microsoft Dynamics NAV 2016 CU 53 :- NAV 2017 CU53 Warning Before you install a cumulative update in a production environment, take… Continue Reading Ammolh Saallvi’s Article on their...

Read More
Cumulative Update for Business Central Wave 2
Feb27

Cumulative Update for Business Central Wave 2

Cumulative Update includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics Business Central Wave 2 2019 Release Download update from below Update 15.3 for Microsoft Dynamics 365 Business Central 2019 Release Wave 2 Warning Before you install a cumulative update in a production environment, take the following… Continue Reading Ammolh Saallvi’s Article on their...

Read More
How to Setup ALOps (CI/CD)
Feb21

How to Setup ALOps (CI/CD)

Below Videos will explain you how to setup ALOps for VSCode Hope this will help you guys.. Stay tuned for more.. Continue Reading Ammolh Saallvi’s Article on their blog https://amolsalvi.blog/2020/02/21/how-to-setup-alops-ci-cd/ Blog Syndicated with Ammolh Saallvi’s Permission

Read More
How to Substitute Report in Business Central
Feb12

How to Substitute Report in Business Central

Today we will see how we can substitute our own document report with Standard report in business central. To override report we need to use ReportManaagement Codeunit and from that we need to use OnAfterSubstituteReport event Suppose we have created own customize report called ‘Detail Inventory Transaction’ and now we have to replace standard report for Inventory Transaction Detail … Continue Reading Ammolh...

Read More

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.