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 →

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 →

Microsoft has announced the release of Power BI Desktop: February 2020 and you can read all about it here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/ I am very happy about incremental refresh, which is now generally available and is now supported for Power BI Pro licensing, meaning it is no longer a Premium only feature! Read all about that here: Read More →

I recently came across a question in the Business Central forum: How do I get information about Posted Sales Shipments in Power BI? And this is not a standalone question, I get these questions a lot in my training’s that I deliver all over the world. Many times I see answers suggesting to use existing Read More →

Released Cumulative Updates for Microsoft Dynamics 365 Business Central on-premises: https://support.microsoft.com/en-us/help/4470116/released-cumulative-updates-for-microsoft-dynamics-365-business Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2: https://support.microsoft.com/nl-be/help/4528706/released-updates-for-microsoft-dynamics-365-business-central-2019 Dynamics 365 Business Central On-Premises Spring 2019 Updates: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/deployment/update-versions-14