Skip to main content


Showing posts from March, 2021

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

Announcement! Business Central Launch Event

Register now for Dynamics 365 Business Central Launch Event Tuesday, April 13, 2021 | 8:00 - 9:30am Pacific Time (UTC -7)   Join us for the Dynamics 365 Business Central Launch Event, a digital event. We are bringing the latest innovations for Business Central to you via a new all access digital experience. Expect game-changing speakers, dynamic content, and opportunities to learn how to take Business Central to the next level. All 100% free. You'll hear from product leaders as they share with you the latest innovations and capabilities to help you confidently move to the cloud and unlock the insights needed to adapt faster, work smarter, and perform better. And that's just the start. Connect with product experts and access 10+ hours of live and on-demand content to uncover the latest product updates and learn how they help you to: Deliver seamless service and performance Improve compliance and security Build ISV solutions and support globalization Delight customers by exceedin

Dynamic Filtering and Filter Creation during for multiple record selections in Page Lookup in NAVISION

  Introduction: I have been working in NAV/BC for a couple of years to master the craft and to some extent all of us are successful. But a single scenario/ user error/misunderstanding can create a big question mark. This blog is mainly divided into two parts 1. Why does NAV/BC support few small things which are not supported when analyzing the data? 2. Workaround and its implications. So the use case is the NAV/BC Administrator creates an Item with the number in the 'ABC-1039-(A)'. He and other users do all the manufacturing, trading activities. When he tries to run reports having Item No. Lookup using Table Relation, he is given the following error. Pre- requisites : Microsoft Dynamics NAV / BC References: Demonstration: 1. Checking if this scenario is supported by spinning up some test code. Turns out when I hard-code Item No in SETFILTER, the report is working precisely as expected.