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.
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 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.
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.
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 precautions:
Stay tuned for more updates…
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 precautions:
Stay tuned for more updates…
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
[EventSubscriber(ObjectType::Codeunit, 44, 'OnAfterSubstituteReport', '', true, true)]
procedure SubstituteInventoryTransactionReport(ReportId: Integer; var NewReportId: Integer)
begin
If ReportId = Report::"Inventory - Transaction Detail" then
NewReportId := Report::"Detail Inventory Transaction";
end;Publish your extension and check the report .You will find new report is substituted with standard report.
Hope this will help you.
Stay tuned for more..
One of nice feature of business central for opening balance.
This will help one to have readymade template of opening balance with ledger account where in one can key in amount and post or even export in excel and after key in values import back to Business Central and post
Hope this small link will help to prepare opening balance as this gives template with ledger account.
Stay tuned for more..
Ammolh Saallvi Blog 