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

Introduction: When migrating from NAV 2017 to NAV 2018 i.e moving from C/AL to AL the created objects need not be created again from scratch in AL. This blog demonstrates how we can create the AL objects from C/AL using Txt2Al in Command Prompt. Pre-requisite: NAV 2018. Backup of Objects in TEXT or FOB format. Steps: 1. Import objects in NAV 2018 from the created  . TXT or . FOB files. In NAV Development Environment goto, Files > Import > Choose the .FOB or  .TXT file > Replace all the objects 2. Export the objects in New Syntax to . TXT files. Create a directory to store the objects in .TXT format which will be exported as new syntax. Here, ‘source’ is the name of the directory used. Use  ‘mkdir source ‘ Create a directory to store the .AL that will be created by TXT2AL Converter utility. Here ‘target’ is the name of the directory used. Use ‘mkdir target’ To export the objects in .TXT format in NewSyntax use the following command ...

Introduction: In Microsoft Dynamics NAV(NAVISION ERP), there is a feature on Financial Documents called Record Links. Record Links are used to copy multiple URL links, Texts on the documents so that it can be used for reference later. The best part of Record Links is that, these can be added through Document and post it. After posting these the Record Links are copied to G/L, Subledger and Posted Documents as well. Pre- requisites : Microsoft Dynamics NAV Books & References: https://forum.mibuso.com/discussion/41101/how-to-copy-notes-stored-in-record-links-table Demonstration: 1. What is Record Links: Record Links is a feature to add links and texts on Documents. You will need to click on Links Actions on the page. You will get the Link insertion Window, where as below. Records Link Insertion After the Link is inserted, you will get a view where you can open the link. Viewing Record Links 2. How Record Links work: Record Links is stored in Sys...

Introduction: In this series of Fixed Assets aka FA, I will be teaching you through a lifecycle of the Fixed Assets. How to create and acquire these fixed assets, how to appreciate or depreciate the FA, and how to post transactions on Fixed Assets in Microsoft Dynamics Business Central. Pre-requisites: Microsoft Dynamics Business Central(ERP) Understanding of Fixed Assets Demonstration: 1. Creation of Fixed Assets: To create Fixed Assets search Fixed Assets and open the Fixed Asset List. Click on New (+), automatically FA No. is set up from No Series. Enter the FA Name, FA Class Type, FA Subclass Type, FA Location if you have multiple FA Locations. Creation of Fixed Asset Setup the FA Depreciation Book, by default we have COMPANY. Also set up the Depreciation Start Date and End Date or Start Date and No. of Years. Book value is the current value of the Fixed Assets. This value increases or decreases depending on your Appreciation or Depreciation of FA. 2. Ac...

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