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

Problem Statement: In Microsoft Business Central, there is a way to attach attachments only on Documents or Master Table records. But, what if this requirement is for other tables such as Opportunities, custom tables, etc. Introduction: I have seen many developers afraid to touch the attachment-related customization as it seems complicated. Well, I have found a solution and here it goes. In this blog, I'm attempting to create a generic template for code that needs to have an attachment feature on any table that you like using AL Code. This means that you simply cannot copy-paste the same code for all the tables but a simple change in variable sub-type will ease your work significantly Pre-requisites: Microsoft Dynamics Business Central VS Code Al Language Extension Source Code: https://github.com/olisterr/Generic-Attachment-Template Demonstration: 1. How it works: Document Attachment is a table which stores a few things that help in tracking information rel...

Introduction: In this blog, I'm attempting to demonstrate a proof of concept as How To Create Third-Party Apps, Games and Integrate it in Business Central using Control AddIns, Javascript and CSS. Also, this blog illustrates how to port any javascript apps and games to Microsoft Dynamics NAV / Business Central. In this case, I have created a simple JavaScript Game and will be showing how to make it compatible with Business Central using Control AddIn. Pre-requisites: VS Code Microsoft Dynamics NAV / Business Central  Understanding of Javascript Understanding of Control AddIn Source Code: https://github.com/olisterr/ControlAddIn Books & References: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-control-addin-object https://www.w3schools.com/js/ https://www.github.com https://codepen.io Demonstration: In this demonstration, I will be creating or copying a game from a few sample games available on Github o...

Problem Statement: With a change in Business Central Version from Version 14 to Version 15, I had noticed a few things got deprecated. Instead, these functions where deprecated and overloaded which why function definition remains the same but the parameters change. Introduction: In this blog, let us discuss the changes in Business Central BaseApp coding that can possibly break your extension and prevent you from upgrading.  Also, I will be discussing the list data type introduced since the 2019 Wave 2 release. Pre-requisites: Microsoft Dynamics Business Central Version 14 Microsoft Dynamics Business Central Version 15 Books & References: List DataType https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/list/list-data-type https://www.kauffmann.nl/2019/10/11/net-types-in-al-are-reference-types/ https://demiliani.com/2019/09/17/dynamics-365-bc-wave-2-release-what-happens-now/ Demonstration: In this blog, let...

Problem Statement: With a change in Business Central Version from Version 14 to Version 15, I had noticed a few things got deprecated. Instead, these functions where deprecated and overloaded which why function definition remains the same but the parameters change. Introduction: In this blog, let us discuss the changes in Business Central BaseApp coding that can possibly break your extension and prevent you from upgrading.  Also, I will be discussing the list data type introduced since the 2019 Wave 2 release. Pre-requisites: Microsoft Dynamics Business Central Version 14 Microsoft Dynamics Business Central Version 15 Books & References: List DataType https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/list/list-data-type https://www.kauffmann.nl/2019/10/11/net-types-in-al-are-reference-types/ https://demiliani.com/2019/09/17/dynamics-365-bc-wave-2-release-what-happens-now/ Demonstration: In this blog, let u...

Problem Statement: While building customization for Microsoft Dynamics NAV / Business Central ERP, at times the customization is so heavy that we as developers do not realize how much load we put on the SQL Database which the backbone of the system. One example of this situation is, I had built a system that can create a Cash Receipt during accepting Payment in terms of Cash from the Customer by temporary passing an entry through the Cash Receipt Journal. There was also a Payment Application code that applied(reconciled) the Payments and the Invoices of the Customer that ran posting of any financial entry concerning that specific Customer. During this attempt of creating Cash Receipt, the posting would block the Customer, Customer Ledger Entries and G/L Entries Tables which was as per design. And it wouldn't allow anyone to make an entry during this period and it would take approximately 20-30 seconds. To get out of the Deadlock, I was forced to restart the NAV Serv...

Problem Statement: After my client's implementation in NAV, the system was working smooth and flawlessly. An important  issue was that the client couldn't close their books due to the change in Business Processes and even the customization was evolving as per the changing Business Process. This lead to serious slowing down of the system, filtering and finding records was a pain. When all the options ran out, we default to calling the Microsoft Support for help! They suggested upgrading the NAV CU versions which was way painful as all the data needed to migrate and again the system would face a downtime which my client couldn't afford!! Out of nowhere we were suggested reindexing the tables in NAV which were impacted the most as a periodic activity. Pre-requisites: Microsoft SQL Server Management Studio (SSMS) Microsoft Dynamics NAV Understanding of SQL Understanding of NAV Server Instance  Reference: https://docs.microsoft.com/en-us/powershell/module/m...