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

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

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

Introduction: After upgrading Business Central to version 17 (Wave2 2020), I found that there was an error telling me that WebService Key is going to be deprecated soon. Web Service Access Key is deprecated. Hence, I decided to explore and probably make it easier through this blog. Pre- requisites : Admin Access to Office 365 Admin Access to Azure Demonstration: 1. App Registration on Azure Portal: To enable OAuth authentication for any apps in Azure Active Directory, you will need to perform App Registration and set up the permissions and security details. i.) Register the App: Search for 'App Registration' on the Azure Portal. Click on New Registration Type in the App Names, Account Types and Redirect URI. Registering Application ii.) Setup API Permissions: Go to API Permissions > Add Permissions > Business Central App > Select Delegated Permissions > Select Other Permissions and Financials > Add Permissions Button. Setup API Permissions iii.) Setup Client Secr...

Introduction: In my previous blog on setting up the App Password for Outlook after enabling Multi-Factor Authentication, refer to How to bypass Multi-Factor Authentication This blog is an update on the changes made to the process creation of App Password and is relatively easier to follow. I faced an issue where the ' View Privacy Link ' button was missing in Settings & Privacy > Privacy View Privacy Link Missing - Office 365 / Microsoft 365   Pre- requisites : Microsoft 365 (a.k.a Office 365) Demonstration: In portal.office.com, go to the Users icon on the top right and select ' View Account' View Account Head over to the ' Security Info ' navigation on the left side and click on ' Add Method Adding Method in Security Info You need to select the Method as ' App Password ', provide the ' App Name ' and copy the password generated for further use Adding a Method Adding AppName Copying App Password I tested the copied password in SMTP Ma...

Introduction: While going through the Setup of Business Central with Jet Reports as per the article from Jet Global, I noticed that for some reason I wasn't finding the same options as mentioned in the article. Hence, I decided to try somethings on my own, and here are my findings. In this blog, I would like to cover the JetReport Setup with Business Central Sandbox or Production. Pre- requisites : Microsoft Excel Microsoft Dynamics 365 Business Central Jet Report Extension Setup in Business Central Jet Report Add-In installed References: https://support.jetglobal.com/hc/en-us/articles/360010307533-Create-A-Business-Central-Public-Cloud-Web-Services-Data-Source Demonstration: As you know that the setup wasn't exactly as mentioned in the article. 1. Data Source Type: Goto App Settings > Data Source Type > Select WebServices DataSourceType as Web Services 2. Authentication   For Authentication, select the NavUserPassword. Use the Username and Web Service Key from Users. Use...

  Introduction: Today, as I was working with Real-Time Integration with TCI Scribe, I noticed that the integrations which were working prior stopped working. Although the URL when triggered through the POSTMAN app it works fine. The error that was received is ' {​​​​​"The underlying connection was closed: An unexpected error occurred on a send."}​​​​​ ' Pre- requisites : Microsoft Dynamics NAV / Business Central Understanding of .NET Interoperability Postman App Test Endpoint for API Procedure: I have used NAVWebRequest or HTTPWebRequest as .NET interoperability in NAV referring to https://dynamics.is/?p=2739   1. Debugging the issue: In order to make sure that the coding is correctly triggering the URL with POST call and JSON Data Payload, I created an endpoint on Request Bin and the solution seems to be working. Request Bin Also, when triggering the URL through Postman, the response is correctly generated. Postman Trigger 2. Finding the issue and possible solution u...