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 my customer asked me if something like this happen then can we kill or cancel the session of user and then I came across this feature of Business Central admin center.

How to access admin center

This can be by adding tenant id with your business central URL as below

https://businesscentral.dynamics.com/%5BTenant Id]

This will open admin center as below.

In this portal you can see all the environment including sandbox.I can see this is your control center for managing business central on cloud.

Now next step is click on required environment which will navigate to other screen.

To see all the session click on session

This will show you call the required session for the selected environment.

Now to cancel the session select the required session and click on Cancel session .This will kill the required session.

Another advantage of this screen is that it show other information like which operation is going on ,which object is involved in current operation and duration of current operation.

Hope this will help you to cancel the unwanted session

Stay tuned for more..

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 the extension data.

1) Launch the business central and search for extension management.

2) Select the required extension for uninstall. In this you can see new option added for delete extension data .

3) After selecting the option then you will get following warning message.

4) After click ‘YES’ then you can see ‘Delete Extension Data’ will get enable as follows

5) After that you can click on Uninstall then system will again warn before starting deleting data from extension.

6) If you are sure then click ‘YES’ and it will start processing to delete the data. This can not be undone.

Hope this will help and stay tuned for more.

If you like my blog then please connect me on

Blog :-https://ammolhsaallvi.blog/

Twitter :-https://twitter.com/ammolhsaallvi

LinkedIn :-https://in.linkedin.com/in/amolsalvi

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.

  1. Database access intent changed to read-only for frequently used reports As business required faster access to the information so to speed up default database access change to Read-only.
  2. Notify users of high-risk changes in selected setup fields :- This features means we can make list of fields from master table and get notified when someone changes.
  3. Business Central in Microsoft Teams :-Integrate Microsoft team with Business Central.
  4. Page Inspector supports temporary tables :- With this update, the inspection pane now displays valuable record information also for pages that are implemented to use temporary tables. Information about the current record is displayed in a consistent way and is not different from inspecting pages that use physical source tables.
  5. Data audit system fields are added to every table :- Four New Field will be added in every tables to track the transactions log.
    1. SystemLastModifiedOn
    2. SystemLastModifiedBy
    3. SystemCreatedBy
    4. SystemCreatedOn
  6. Attach to user session when debugging in sandbox :-Currently, when you debug with the Visual Studio Code AL debugger, you cannot attach to a user session, making it much harder to troubleshoot issues that are dependent on users and user permissions. This feature enables attaching to an active user session on the sandbox.
  7. Debug extension installation and upgrade code :- It is currently not possible to debug extension install or upgrade code by just adding breakpoints and deploying a new application. Instead, some workaround is required to manually trigger the install and upgrade code, possibly commenting out upgrade tags and so on, making it tedious to properly test install and upgrade during development, as well as to troubleshoot issues.

For More information on Planned features please check this link

What New and Planned for Dynamics 365 Business Central

Hope this will help you

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

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…

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:

  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…

Events vs Interface :- Business Central

While working on new baby ‘Interface’ identified few difference between Events and interface.

EVENTSINTERFACE
Select Events to Subscribe. Subscription optional.All Methods are mandatory defined in interface code unit and need to implement all
Used to react Used to Invoke.
Extensibility for few methods or functionsExtensibility for many methods.
All Subscribers are invokedOnly single code unit is invoked.
Can Invoke Interface.Can bind events.

Hope this will help you..

Stay tuned 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 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 = 'Retail';
    }
}

Secondly create a table extension and modify required table relation property.

tableextension 50146 PlaySalesTabRelExt extends "Sales Line"
{
    fields
    {
        modify("No.")
        {
            TableRelation = if (type = const(Retail)) Retail;
        }
    }

}

Hope this will help you.

Stay tuned for more update.

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

How to extend enum in business central

Difference between enum and options

Hope this will help you..