You might be aware of this idea: https://experience.dynamics.com/ideas/idea/?ideaid=c7f30764-d247-e911-867a-0003ff68f3db And if you haven’t yet, please vote š Now recently I came across a post from Bert De Temmerman on Yammer: https://www.yammer.com/dynamicsnavdev/threads/736254082498560Ā and that got my inspiration flowing… He suggests that when you add this action to the “Report Layout Selection” page, you can export any dataset by … Read More →
Recently Microsoft added the Table Information page to Business Central. See here. And underlying are these objects: Table Information (8700, List) Table Information (2000000028) So I was thinking, hey let’s use this in Power BI. Then my first thought was to create a query object using the Table Information table as a data item, but … Read More →
Recently I stumbled upon Manage Sessions in the Business Central Admin Center: In the Admin Center, open an environment: Then select: Manage sessions: Now you can see and cancel sessions: More information is available here: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/tenant-admin-center-environments#managing-sessions TheĀ Manage SessionsĀ page displays information about active sessions on an environment and lets you cancel selected sessions. To open … Read More →
I recently discovered this cool feature in Business Central: https://docs.microsoft.com/en-US/dynamics365/business-central/admin-feature-management When Microsoft releases features or feature design improvements as part of minor updates, some features aren’t immediately enabled. Administrators can learn about these features and independently enable each feature from theĀ Feature ManagementĀ page. Once a feature is enabled, it becomes available for all users on that … Read More →
I recently discovered this cool feature in Business Central: https://docs.microsoft.com/en-us/dynamics365/business-central/admin-view-table-information The pageĀ 8700 Table InformationĀ provides information about all system and business tables in a Business Central solution. In particular, the page displays information about the amount of data the tables contain. This information is useful for troubleshooting performance problems, because let’s you see the distribution of … Read More →
I recently discovered this cool feature in Business Central: https://docs.microsoft.com/en-us/dynamics365/business-central/admin-view-database-locks https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/monitor-database-locks TheĀ Database LocksĀ page gives snapshot of all current database locks. To view database locks, open pageĀ 9511 Database LocksĀ in the client. TheĀ Database LocksĀ page gives a snapshot of all current database locks in SQL Server. It provides information like the table and database resource affected by the … Read More →
Recently Renato Fajdiga and I were asked to do a webinar about Power BI and Business Central. In Microsoft Dynamics 365 Business Central, we have a more intuitive and faster way to create new Power BI reports that you can share with other users in Business Central. In this webinar, you will learn how to … Read More →
Since C/Side has gone forever, when installing Business Central on Premises you might wonder how to import or upload a license (flf) file into the service tier. Well the solution is very simple. First open the Business Central Administration Shell: Then use the command: Import-NAVServerLicense: More information is available here: https://docs.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.management/import-navserverlicense?view=businesscentral-ps-16 After importing a new … Read More →
Microsoft released Dynamics Business Central on Premises 2020 Wave 1 and you can download the On Prem installation DVD here: https://mbs.microsoft.com/partnersource/northamerica/support/support-news/msdbcentralonprem20wave1 But when you do an installation, you might get the following error: This happens if you don’t meet the system requirements: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/deployment/system-requirement-business-central-v16 To confirm, you don’t need the SQL enterprise edition, SQL Express is … Read More →
Currently there’s a lot of talk about Business Central performance. Microsoft has released and is releasing guidelines, tools about mechanisms to program for performance, analyse and monitorĀ performance. At the same moment there’s also discussions going on on public and private fora about database size and limitations. And last but not least Artificial Intelligence is … Read More →
Here are some interesting aka.ms links I have found: aka.ms/bcideas Dynamics 365 Application Ideas for Dynamics 365 Business Central aka.ms/bccountries Country/Regional availability and Supported Translations aka.ms/collaborate Microsoft Collaborate aka.ms/readytogo The āReady to Goā Program aka.ms/bclearn Microsoft Learn for Business Central aka.ms/bcproductivity Working with Business Central aka.ms/bckeys Keyboard Shortcuts aka.ms/bcupdates Major Updates of Business Central Online … Read More →
Try out the new Business Central 2020 release wave 1 functionality today! Learn how to prepare for major updates with preview environments: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/preview-environments Are you interested to test out all the new bells and whistles of BC version 16, then create your preview sandbox as follows. Go to your Business Central Admin Center: Then spin … Read More →
Imagine you have created an amazing Power BI report that summarizes information using different visuals. Power BI Desktop lets you build advanced queries, models, and reports that visualize data and the idea is that the individual records that come from your data source are aggregated and summarized in your report, giving you the possibility to … Read More →
Performance wise it can be very interesting to use query objects as a data-source in a report (or any other object). Imagine you want to create a report that shows the top X records from a table, let’s say for example Customers, then creating a report dataset with a top-x filtering can be very cumbersome. … Read More →