Today, Microsoft released Microsoft Dynamics 365 Business Central Spring 2019 Update.
You can download from below links.
Downaload Center : https://www.microsoft.com/en-US/download/details.aspx?id=58106
PartnerSource : https://mbs.microsoft.com/partnersource/global/support/bconpremdownload
What’s new and planned for Dynamics 365 Business Central Spring 2019 release
Start exploring the new features and stay tuned for more posts here…
Please find more information about Cumulative Update for Microsoft Dynamics 365 Business Central released in November 2018 below.
Here you can find the download link.
Cumulative Update 1 for Microsoft Dynamics 365 Business Central has been released (Build 25767)
On October 1st, Microsoft releases Microsoft Dynamics Business Central on premises.
With this latest release, Microsoft Dynamics NAV is renamed Microsoft Dynamics 365 Business Central on premises to be united under the Dynamics 365 Business Central brand. Dynamics NAV customers upgrading to Business Central on premises will enjoy the unique flexibility to continue running on premises, move to the cloud, or adopt a hybrid approach.
Download link : https://mbs.microsoft.com/partnersource/northamerica/support/support-news/bconpremdownload
Currently it is available for 23 countries including World-wide version. See below list.
Stay tuned for What’s new and more information…
In older NAV versions, developers and users(with required permissions) can view the table data by running tables directly from the Object Designer of NAV Development Environment. See below screen.
But now with Business Central we have new Modern Development Environment for AL programming. For more information, https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-reference-overview
Let’s see how we can View Table Data in Microsoft Dynamics 365 Business Central Web Client.
For developers, administrators, and support personnel, it can be useful to inspect table data in the tenant database, particularly when debugging or troubleshooting. To support this need, you can view table objects in the Web client.
- In a production environment, administrators and support can view a table directly from the Web client.
- In a development environment, in addition to viewing a table directly from the Web client, developers can view a table automatically when they publish/debug an AL project from Visual Studio Code.
NOTE : The table appears as read-only in the client, so modifications, insertions and deletions cannot be made.
IMPORTANT : Data in the tables can be sensitive. Be sure to follow your organization’s guidelines for handling such data.
Whether viewing the table directly from the client or from Visual Studio Code, your Dynamics 365 user account must have the following permissions:
- Read permission on the table that you want to view.
- Execution permission (direct) on the System object 1350 Run table.
Any end-user that is assigned these permissions will be able to view that table in the browser.
View a table object directly from the client
To view a table, you add the table=<TableID> parameter to the client’s address (URL), replacing <TableID> with the ID of the table that you want to view.
For example, if your URL starts with https://businesscentral.dynamics.com , then to view table 18 Customer in your current company, you could use the following URL:
Or for a specific company, such as “CRONUS Inc.”:
Note the use of & when table=<TableID> is not located directly after the domain name.
See below example, how we can run table object directly from the client running on docker container.
- To view data in current company
- To view data in specific company
View a table object from an AL project in Visual Studio Code
You can configure an AL project to view a table when you publish or debug the project (pressing F5 or Ctrl+F5).
In the launch.json file for the project, set the “startupObjectType” parameter to “table” and the “startupObjectId” parameter to the ID of the table. For example:
Output will be
You cannot view virtual tables or the following system tables:
||Configuration Package File
||Configuration Package File
||Nav App Capabilities
||Nav App Data Archive
||Nav App Dependencies
||Nav App Object Metadata
||Nav App Object Prerequisites
||Nav App Resource
||Nav App TenantApp
||Profile Page Metadata
||Send To Program
||Upgrade Blob Storage
Source of Information : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-view-table-data