Skip to main content

Posts

Delete Users from NAV / Business Central

Introduction:  Have you received demo databases from someone? But you do not have the credentials? Read below to find the details. Pre-requisites:  NAV / Business Central OnPermise Demonstration:  NOTE: This step is not recommended for Production Server unless you explicitly need to do so. If you do not have Users in NAV/ Business Central, by default will allow you to add yourself as Administrator. This is needed if you migrate your database from one server to another outside of your AD. 1. Take SQL Backup: You can take SQL Backup by visiting SSMS > Right Click on DB > Tasks > Back Up > Select the File. Once you complete the wizard, your SQL backup file will be created. 2. Clear User Data using SQL Script: You can clear the Users, clear User Personalization, clear Metadata, and other tables USE [YOUR DB NAME] GO delete from [dbo].[User] delete from [dbo].[Access Control] delete from [dbo].[User Property] delete from [dbo].[Page Data Personalization] delete from [dbo].[User
Recent posts

Customer Digital Experience(CDX) to setup Business Central

Introduction:  In this blog, I will be sharing my experience in Customer Data Experience (CDX) and how to set up Business Central, CDX is a platform that is used to create Demos for Customers. This implies that you no longer have to pay or signup for trials in order to demonstrate Dynamics 365 Apps for Customers. To get more details Pre-requisites:  Basic understanding of CDX Access to CDX environments Books & References:  https://cdx.transform.microsoft.com/ https://learn.microsoft.com/en-us/partner-center/mpn-demos Demonstration:  1. Visit  https://cdx.transform.microsoft.com/ : Once you are on the CDX portal, you can log in with your Work Account. You can select your segment and your role. 2. Accept the CDX - Terms of use: Once you have accepted the CDX- Terms of Use, you will be taken to Customer Digital Experience Dashboard. 3. CDX - Environments:  Click on Environments to get the list of tenants. You can also create new tenants from this screen. Below you can create your own

How to update your Business Central to Latest CU

Introduction:  There are times when Microsoft releases the latest major version upgrade for Business Central Upgrade and you face many issues with it. As soon as the bugs are reported to Microsoft, they start to fix them and ask you to upgrade to a certain Cumulative Update. In this blog, I will be sharing my experience with Business Central v21 CU0 upgrade to Business Central v21 CU2. Pre-requisites:  Business Central DVD for Latest CU Basic Understanding of Business Central CU Updates Books & References:  List of Update Packages How to Update CU version Demonstration:  1. Check the current state of BC: As part of knowing the current state of your Business Central environment, I'm assuming that your Business Central Environment will have some data in the standard Base App also there will be customization with extended tables and newly created tables. Customization - TableExtension on Customer Table  Customization - Custom Table created Make a note of the data that is present i

Changes in Permission Sets in Business Central

Introduction:  In this blog I will be discussing about Permission Sets as Objects and how they are different from Permission Sets in earlier versions of NAV/BC. Also, I will share some insights on my experience with Permission Sets. Pre-requisites:  Understanding of Permission Set Objects Understanding of how Permission Sets work. Books & References:  Permission Set Object Upgrade Permission Sets Demonstration:  1. Permission Set as Data: In earlier version of NAV / Business Central, the Permission Sets were stored as data. Meanwhile, you would get the Permission Sets configured as Data in your Database. Generally when you upgrade from NAV, you will get this data upgraded automatically. You  can import/export permission sets as XML files. 2. Permission Set as XML: For every PTE it is mandatory to have your own Permission Sets. We create these permission sets as XML files for Business Central PTEs. For rest of the Base Application, Microsoft had in database and can be exported as XM