Skip to main content

Posts

Showing posts from 2019

Generic way of Attaching Documents on any Record of the Page in Microsoft Dynamics Business Central - Template Code

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 CentralVS CodeAl Language ExtensionSource 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 related to the attachment

The main u…

Creating Games in Microsoft Dynamics NAV / Business Central using Control AddIn in AL

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 CodeMicrosoft Dynamics NAV / Business Central Understanding of JavascriptUnderstanding of Control AddInSource Code:https://github.com/olisterr/ControlAddIn Books & References:https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-control-addin-objecthttps://www.w3schools.com/js/https://www.github.comhttps://codepen.ioDemonstration: In this demonstration, I will be creating or copying a game from a few sample games available on Github or Codepen.io and then showing how these codes …

Change in function parameter in Microsoft Dynamics 365 Business Central Version 15 Upgrade

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 us take an emailing codeunit as a use-ca…

Few things that can save you a lot of hassle in Per Tenant Extension Code Upgrade in Microsoft Dynamics 365 Business Central Wave 2 (version 15) Upgrade

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 us take an emailing codeunit as a use-ca…

How SQL Profiler can save your day by Identifying Lengthy Processes in Microsoft Dynamics NAV / Business Central

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 Server Instance thr…

How Optimizing Microsoft Dynamics NAV / Business Central Can Save You From Trouble.

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 NAVUnderstanding of SQLUnderstanding of NAV Server Instance  Reference:https://docs.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.management…