Skip to main content


Showing posts with the label NAVISION(ERP)

Update: Add User PermissionSet to NAV

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: 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

Setting Up Administrator Account in NAV when Administrator accidentally deletes his own permission 😂

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

How to Bulk Upload attachements using AL in Business Central

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