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.
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…
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:
Stay tuned for more updates…
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.
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:
Stay tuned for more updates…
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 following precautions:
Stay tuned for more updates…
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 value in existing enum field.
First create extension for enum as below
To check the value just added one action button as below
To check the output publish the app and check
Select the document type and check the result as follows
Hope this help you…
Stay tuned for more..
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 precautions:
Stay tuned for more updates…
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 central
Hope this will help you to have information
Stay tuned for more.
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 following precautions:
Stay tuned for more updates…
Ammolh Saallvi Blog 