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…
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
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!!!
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.
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..
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…
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 between enum and option.
| Enum | Option |
| An enumeration type, also known as an enum in programming, is a keyword used to declare a type that consists of a set of named constants. The list of named constants is called the enumeration list. Enums can be used as table fields, local and global variables, and parameters. | In the OptionString Property of the field or variable, you can enter the option values as a comma-separated list. The Option type is a zero-based enumerator type, which means that the option values are assigned to sequential numbers, starting with 0. You can convert option data types to integers. |
| To declare an enum in AL you must specify an ID and name | To define option need to add value as comma-seprated list |
| Enum with extensible property set to true can be extended | To extend option value need to modify the base table and add the required value |
| How to define enum enum 50110 MyList { Â Â Â Extensible = true; Â Â Â Â Â Â value(0; None) { } Â Â Â value(1; First) { } Â Â Â value(2; Second) { } Â Â Â value(3; Third) Â Â Â { Â Â Â Â Â Â Â Caption = ‘My List’; Â Â Â } } | How to define option field(2; OptionField; option) { Â Â Â OptionMembers = “Option with “, “spaces and “, “other symbols!”; } |
To extend the standard enum from base product visit here
Stay tune 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 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…
Ammolh Saallvi Blog 