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

Introduction: The story starts with one of our clients who want to have Jet Report installed along with Dynamics 365 Business Central. After procuring the licenses, the client realizes he needs to connect Jet Reports to his home PC as well which may cost an additional license cost since Jet Report uses O365/M365 and Device Details as well to register its client. This means that it is not totally remote like Business Central(SaaS). So we need something that has all the data in the center but can connect to O365 as well as re-activate once the user changes the devices. It would have been easier if the client connected his home PC with office Azure AD, transfer the logins and AD metadata but that's unethical to some IT policies.  So after nearly 2 weeks of back and forth, the jet team suggested using Jet Hub, and the caveat was only 5% of the companies who install Jet Reports choose this option due to its complexity.  Meanwhile, I lost my patience and interfered thinking " How ha

Introduction: After having a successful implementation of Business Central On-Premise for the client's environment, it is necessary to automate administrative tasks such as Database Backups and restoration policies to Ensure Business Continuity and Disaster Recovery. Pre- requisites : Understanding of SQL Backups -Full Backups: https://www.mssqltips.com/sqlservertutorial/7/sql-server-full-backups/ - Differential Backups:https://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/ - Transactional Backups: https://www.mssqltips.com/sqlservertutorial/8/sql-server-transaction-log-backups/ Understanding of PowerShell Demonstration: In this blog, it is necessary that you understand the different backup types. Just to give a hint below is a one-line explanation. i. Full Backups: Takes a full backup of DB ii. Differential Backups: After the full backup takes the change in data is added to the differential backup iii. Transactional Backup: After the last backup, the tra

Introduction: Since Business Central's inception, Subscription-based licensing is in use. While implementing LS Central, I noticed that this cannot be simply based on Subscription-based licensing because there are multiple shared terminals between multiple staff members. The worst part is that not all users are logged in at the given time which means the efficiency is closed to 50%. This issue can be resolved by handling device-based licensing whereby the license is paid only for the number of devices used as long as the registered device logs in. This blog will demonstrate how to enable device-based licenses for Business Central. To understand where Device-based License is used, refer to https://www.solsyst.com/post/business-central-device-license-capabilities-when-to-use Pre- requisites : Microsoft Dynamics 365 Business Central  Demonstration: 1. User setup for Device-based License: 2. Registering your Device MAC Address: To get the MAC Address of the Device, open CMD and run the

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

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

  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: https://community.dynamics.com/nav/b/moxie4nav/posts/convert-setselectionfilter-to-setfilter 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.