For my previous contribution on business central please visit this link
This blog contains keyboard shortcut for business central and VS code while will make our life easier while navigating and developing business central extension aka app.
Spring Release 2019 of business central comes up with new features for creating unique keys
Today we will see how to create unique keys in table
While creating second keys you can add an additional parameters said ‘Unique’. This will not allow duplicate values in the field where unique parameter is mentioned.
Now we will see this validation works on business central. Here we are trying put same description which is throwing error because of unique key.
You can define multiple unique keys in one table.
Points to Remember
Field can have empty value that means empty value is also value.
Now you all are aware the importance of creating views in windows client as it save the time of applying filters on the list of records. You can save the view with required filters and use it for future as it show the required data based on saved filters which improves productivity of users
Today we will see how we can create views in AL language.
Following examples illustrates how to create view from item list where inventory is greater than 10000.
In this example create new profile and added views in item list as below
Even you can apply more filters and order by also. As well as you can modify the page layout for the views as per your requirement
Publish the extension and open the business central web client .From setting change the profile and go to item List.
In the above picture you can see views has been added into the item list. Once you click on that view you can see the details as per define in views.
Following points need to remember.
Can not use variables and methods .Can use only table fields
Can not create new page controls from view.
You can modify views from extension or customizations.
Hope you like this way of creating views in business central .Anyhow in upcoming versions there will option available on web client to create views as like windows client.
As you all are aware the importance of having prefix and suffix in your app. In every extension you design need must have prefix or suffix on objects which include Table Extension, Page extension as well as control parts on pages. Benefits of this is that it will avoid collision of fields between two app which customer would like to install.
As a partner you need to register the prefix or suffix by sending email on d365val@microsoft.com. This will helpful when conflict arise so whosever registered will win.
Now when you convert the app from C/AL to AL then you need to huge task to us Prefix or Suffix in entire project.
To find all missing Prefix/Suffix you can enable AppSourceCoup which will help every time.
A code analyzer is a library that builds on the compiler’s functionality to offer enhanced analysis of the syntax and semantics of your code at build time
CodeCop is an analyzer that enforces the official AL Coding Guidelines
PerTenantExtensionCop is an analyzer that enforces rules that must be respected by extensions meant to be installed for individual tenants
AppSourceCop is an analyzer that enforces rules that must be respected by extensions meant to be published to Microsoft AppSource
UserInterfaceCop is an analyzer that enforces rules that must be respected by extensions meant to be installed for individual tenants
To enable following rules we can use Code Analysis tools
Following are few rules for every code analysis tool .You can download from following file
NAV TechDays is the name of a conference, organized by mibuso.com. This conference meant technical only and highly relevant – sessions, related NAV and Business Central.
NAV TechDays is the place where some of the best developers and MVP’s exchange ideas and provides more insight of NAV world (oops Business Central)
Few of the session which I think more useful for everybody which listed here on my blog and you can visit them
Practical approaches for upgrading your NAV database and moving to extensions
The future for developers and consultants
Performance: Business Central reloaded for the Cloud
What’s new in Developing for Business Central
Evolution of a titan: a look at the development of NAV from an MVP angle
Business Central: The new face of the client
Crazy mix of integrations: Dynamics 365 Business Central and Azure services