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

  Introduction: In my previous blog , I discussed on what is Microsoft Dataverse and how to setup Dataverse Connectivity with Business Central. In this blog, I will be attempting to share my experience on fine-tuning various parameters  involved in Business Central integration to Dataverse provided in connector  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. Dataverse Connection Setup: For any setups related to Dataverse Connectivity the first step is you go to Dataverse Connection Setup You search for Dataverse Connection Setup All the setups related to Dataverse Connection Setup are in the actions of the Dataverse Connection Setup 2.  Connection Actiongroup: The actions in the Connection Actiongroup are mentioned as follows - Assisted...

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 a...

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: Now that NAV 2017 Database is upgraded to Business Central v14 (Refer link ), it's time to connect your AL Development with your Business Central environment. One of the issues with this approach is that NAV Database does not have the symbols generated. Pre- requisites : - Upgraded DB from NAV to BC - VS Code & AL Language Extension - finsql.exe - Business Central On-Premise with Windows Client Books & References: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-running-cside-and-al-side-by-side https://olisterr.blogspot.com/2020/04/resolving-tenant-default-is-not.html Demonstration: 1. Connect VS Code to Business Central Database: - Ensure that in Business Central Administration > Development > Enable Development Service Endpoint and Enable Debugging and Enable loading application symbol references at startup. Enable Development in Business Central Administration  - Ensure that the launch.json file in your project...