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

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: Today, I received a call from one of the NAV Administrators stating the issue as if I try to access the User Card page for some users I receive the following error. Upon investigating it was clear that the Administrator by mistake deleted his own access to the company for all the users who have access to a different company. Even using the Administrators account I cannot get access to a different company. The condition here was that I cannot simply clear all User Access as per the blog below. https://www.sauravdhyani.com/2012/12/you-are-not-authorized-to-sign-in.html Pre- requisites :  Microsoft Dynamics NAV / Business Central On-Premise Demonstration: 1. Modifying User using SQL Database: If observed it evident that whenever the Administrator account is added there should always be a Windows User associated with it. To remove this constraint, modify the Username in User Table and Windows Security ID using SSMS in SQL Tables. Changed the User Name to ADMINISTRATOR-1 and o

Problem Statement: Few months ago I wrote a blog on  Generic way of attaching documents . As a feedback to this, questions started coming if there is any chance for bulk uploading attachments like  Import multiple Item Pictures . Lets start. Pre- requisites : Understanding of AL. Microsoft Dynamics Business Central Tenant. Understanding of how compression works in BC. Demonstration: 1. Understanding the Base App Code: In the picture below I have illustrated the important parts needed to understand the Base App Code. In short Upload Zip as Stream > Decompress to Lists > Attach the element of the List. LoadZIP - Item Picture - Code Understanding 2. Writing the Code for the Functionality: To be specific, I have written a code whihc will bulk upload Attachments for Variants of Items. I will be seperating delimiting and recognizing Items and Variants using the format as follows ' VariantNo.[Count per variant]%ItemNo.%[*].[ext] ' Load ZIP - Cu