olisterr.tech | Blog on Dynamics 365 Business Apps, NAV / Business Central, Power Platform and Azure

UPDATE: Business Central Sandbox Tile in Microsoft 365 will be removed! When I logged into Business Central, it occasionally shows me the warning that the Business Central Tile will be removed from Microsoft 365 Apps Tile as follows.  Before the change, there was separate tile for Business Central Sandbox and Business Central Production. After the change, there will be single tile for Business Central Sandbox and Business Central Production. Please note that this feature will be in effect from April 2022 and will be in General availability in June 2022. For more details, refer the Business Central Documentation link below. https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave1/smb/dynamics365-business-central/single-tile-go-business-central

Introduction: In one of my blog on Setting up OAuth Authentication for Webservices and APIs in Dynamics Business Central, I shared how to setup OAuth Authentication. With Dynamics 365 Business Central releasing version 20, the Webservice Key Authentication has become OBSOLETE and all your integrations are to be moved to OAuth Authentication. There are few more steps in addition to the steps I mentioned in the blog above and those will be seen in the demonstration. Pre- requisites : Microsoft Dynamics 365 Business Central Understanding OAuth Authentication Understanding Azure App Registration Demonstration: 1. Complete all the Azure App Registration : Complete the Azure App Registration process as mentioned in the blog  Setting up OAuth Authentication .  2. Change the Redirect URL in Azure App Registration: Change the Redirect URL in Azure App Registration > Authentication to https://businesscentral.dynamics.com/OAuthLanding.htm 3. Azure Active Directory Application: In Business Cen

Introduction: Dataverse is a single platform where you can store all your data in the cloud and comes API and plugins to connect with the Tables stored. Dataverse also acts as a Database for Dynamics 365  CRM (Sales, Marketing, Field Service  etc..), PowerApps and Power Platform. https://docs.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro In this blog, I will be attempting to share my experience in connecting Business Central to Dataverse using the out of the box connector provided by Microsoft. Pre- requisites : Microsoft Dynamics 365 Business Central Microsoft Dataverse Basic understanding of Dataverse and Business Central Books & References: https://docs.microsoft.com/en-us/dynamics365/business-central/admin-how-to-set-up-a-dynamics-crm-connection Demonstration: 1. Start the Setup Wizard by going to Assisted Setup: You can search for Assisted Setup > Setup Connection to Dataverse This will open the Dataverse connection setup wizard. Go ahead and hit Ne

Introduction: Business Central Updates after updating to version 20.x, there is a common problem which is observed. The Business Central environment starts blinking as per the video below - Pre- requisites : Business Central Online  v20 Demonstration: 1. Restart the Business Central Environment: Go to Business Central Admin Center > Select the Environment >Sessions > Restart Environment. 2. Ensure that your URL contains Tenant ID: When you login into the Business Central Environment, make sure that your links are in the following formats Sandbox : https://businesscentral.dynamics.com/<SandboxEnvironmentName>/?sandbox=true Production : https://businesscentral.dynamics.com/<ProductionEnvironmentName>/ If you URL like https://businesscentral.dynamics.com/SandboxName or any other format without Tenant ID, chances are that you will end up with the issue. Also, you can login through Admin Center URL -  Connect from URL in BC Admin Center 3. Check the status if the insta

Introduction: I'm sure with the dawn of Business Central Online, its been so easy to directly get users from Office 365 and the only part that you are remaining with is setting up User Permissions. After SSL & SSO is setup in Business Central On-Premise, the question comes as how to add Users and connect to Azure AD. To get how to setup SSL and SSO refer the links below SSL Setup -  https://olisterr.blogspot.com/2020/03/how-to-setup-navuserpassword-with-ssl.html SSO Setup -  https://olisterr.blogspot.com/2020/03/how-to-setup-single-sign-onsso-for.html Pre- requisites : Microsoft Dynamics Business Central On-Premise SSL Setup SSO Setup Understanding of  Office 365 Understanding of Azure AD Books & References: https://olisterr.blogspot.com/2020/03/how-to-setup-navuserpassword-with-ssl.html https://olisterr.blogspot.com/2020/03/how-to-setup-single-sign-onsso-for.html Demonstration: For SSO Authentication -  1. Search for Users in Global Search and select the Users (Administrat

Introduction: In Dynamics NAV Users Page, a SUPER User has the ability to add more specific user permissions to another user. However, while adding permission if the User mistakenly adds the company name to a SUPER Permission Set for all companies. This is actually a trap, as the user did not remove any permissions but only added by mistake and after adding this value, the data cannot be again set to BLANK. Pre- requisites : Understanding of NAV Powershell Module Microsoft Dynamics NAV Books & References: https://olisterr.blogspot.com/2021/03/setting-up-administrator-account-in-nav.html Demonstration: In my previous blog LINK , I discussed about a workaround to this issue using SQL and NAV Users pages. In this blog I will be sharing the steps to do the same using PowerShell Commands. Using the Powershell Command New-NAVServerUserPermissionSet -PermissionSetId SUPER -ServerInstance <ServerInstanceName> -WindowsAccount <WindowsUserName> Conclusion: Using the New-NAVUserPe

Introduction: After the Business Central On-Premise is ready with the Customization and Data, it's time to migrate the Business Central On-Premise Environment to Business Central Online(Cloud). The end goal in mind is to migrate to Business Central Online(Cloud) Pre- requisites : - Microsoft Dynamics Business Central(On-Prem & Online) - SSMS - Microsoft Azure Data Factory Runtime - Basic understanding of SQL Server and Azure Data Factory Books & References: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migrate-data Demonstration: 1. Setup SQL Server Authentication: Setup the SQL Server Authentication to SQL Server Authentication as follows. Enable Windows and SQL Server Authentication Mode Right Click on SQL Server Instance > Properties > Security > Server Authentication as SQL Server and Windows Authentication mode SQL Server Authentication Set to Windows and SQL Server Goto Security > Logins > <Username> > R