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.

When I click to Test Email setup and encounter the following error.

Now question is how get over this issue as it is something like you have entered some wrong password and you are getting this issue. After investing some hours I found the crucks for this issue as we need to generate App Password

This issue is encounter because of the Gmail security which required to authenticate the app which is going to use Gmail id.

To do this we need to do following

  1. Sign in your Gmail account which you are using in business central.
  2. Click on Manage your google account
  3. Go to Security.

4. Click on App Passwords to generate the app password (Need to enable 2-Step Verification first).

5. Select the required App and Device as below

6. Click on Generate to generate the App Password and you will get as follows

Now go back to business central SMTP Setup and key in this App password instead of regular passwords.

Now again test the email setup and you will happy to see this message and email.

Email in you inbox

Hope this will help you…

Stay tuned for more…

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

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 property to find table id of CITY field of customer table.

Output of this simple code as follows

Hope this will help you

Stay tuned for more..

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 defining interface we no need to have object id.

If you can see in above interface we just define method but not programmed any business logic.

Now Lets see how to implement interface.

Added new code unit which implements the defined interface.

For checking the result of interface created following page with one function.

Above function to initialize the interface.

Lets check the result of interface.

Hope this will help you to understand interface and implementation.

To understand more on differentiate between events and interface read Interface Vs Events..

Stay tuned for more…

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 (16.2) :- 16.2

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…

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

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

To Play video inside application you need to add embed URL as below

https://www.youtube.com/embed/5aGgktag6L8

If the URL is without embed then video will play outside the application

Hope this will help you all.

Stay tune for more.

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.

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

Stay tuned for more…

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 integration
  • Business Central: Coding for performance
  • Managing customer environments in Business Central online
  • Interfaces and extensibility:  Writing extensible and change-resilient code.

Here is registration link

https://vshow.on24.com/vshow/BCVE/registration/17187

Lets drive more deep in Business central with this event and don’t forget to get you system check specially for internet.

Cheers!!!