With the release of Wave 1 2021 lot of new feature introduced . One of the new feature is that partners now can add keys in base table with customized field which was not possible earlier
Today we will see how we can do that
First Lets see what is happening is earlier version of business central. In earlier version we can only add the keys with the field added on table extension and we are not able to see the field available in base table for adding in keys
Look at the following example as I created one simple extension in V17 and trying to add key
Now when I try to add the keys in this table extension it will populate only those fields which are added in table extension
In New version of Business central i.e. Wave 1 2021 we can Add more keys with base table fields and use to improve the performance while retrieving or updating records
Now look at the following example for new version .Just created a simple table extension
Now when I try to add the keys in this table extension it will populate all the fields available in base table as below
So that means we can create keys with
Fields from base table
Fields from table extension
Can I create combination of fields from base table and fields from table extension ?
And the obvious answer is no and reasons are simple that both base table and table extension are two different tables in Sql server.
Recently Microsoft releases plan for major version of Microsoft Dynamics 365. This blog post actually focused on those features which I am looking forward to and may be every one in community.
Partners can add keys to base tables and table extension
Does anybody remembered this points which I raised in year 2017 on GitHub and finally this is going to add in April 2021 and I am looking forward to it as it is not supported and I have restructure the app.
This feature is everybody awaiting because if we need to change in any base app report then we need to copy that report ,make changes and use report substitution to display the customize report. Looking forward for new report extension object where in one can change layout and dataset.
In Year 2016 I wrote this blog post for updating the dimension and not it is going to be add as feature in Business central. This will help end users for updating the incorrect dimensions.
Above all it from April 2021 onwards Business Central will be available in India
Apart from above lot of new features are added in upcoming version of business central