Mrinal Singha's Dynamics NAV Tip & Tricks Blog

As a Dynamics NAV Developer, we always wished our Dynamics NAV Development Environment could deliver more feature like other IDE. A simple feature like code navigation is so tedious you simply lost track or press ESC key accidentally. We wish this developer environment with folding lines to indicate indentation with collapse and expand feature not just only for Function or Procedure level. Could bookmark a code line and track back later. And last but not the least we (at least I) wished keywords are more glorious or eye catching. I am working on this project for last 3 months and more to create and Dynamics NAV IDE Source code viewer to enhance NAV source code file readability. My fellow Dynamics NAV developer presenting FinCAL – A powerful Dynamics NAV Source Code Viewer. This is still in its infant stage and I am continuous working on more advance features like integrating Code Metrics to calculate our code efficiency. More on upcoming updates. .  .. ...

  Dynamics NAV has System or Virtual tables, which is not visible in Object Explorer. Object ID range starting from 2000000001.. 2000000200 and Object Type as Table. What is Virtual Tables?   "A virtual table contains system information. You cannot change the data in virtual tables. You can only read the information. Virtual tables are not stored in the database but are computed by Microsoft Dynamics NAV at run time. Because virtual tables are not stored in the database, you cannot view them directly. To view a virtual table, you must create a list page based on the virtual table." List of Virtual Tables in Dynamics NAV 2016 Object Type Object ID Name Table 2000000001 Object Table 2000000004 Permission Set Table 2000000005 Permission Table 2000000006 Company Table 2000000007 Date Table 2000000009 Session Table 2000000020 Drive Table 2000000022 ...

   Araxis Merge is well known and one of the commonly used file comparing and merging tool across the globe. Which offers Two-way & Three-way (only for Professional Edition) compare and merge changes in text files. If you want to know more about this tool visit, https://www.araxis.com/merge/features.en Now to the point, Araxis Merge doesn’t support C/AL code and treats NAV text object as plain text so NO Syntax Highlighting. but with this simple tweak Araxis can great C/AL code editor and better at code r eadability.    This how Araxis will like look after this following tweak.  I am sharing my  Araxis Merge options configuration file (.mop7) , where I added all the C/AL keywords.  Google drive link below. https://drive.google.com/file/d/1XImUUhZ44l7IoX9h1qgZSfrSRt8DAW99/view?usp=sharing After downloading the file import this into your Araxis merge, steps below. 1. Open Options 2. Click Open Saved Options... 3. ...

:: Customizing Code Coverage ::    Before beginning this session, if you are new to code coverage, let's have a quick overview. What is Code Coverage?    Code coverage is the means of being able to track which part of the application code has been exercised during an activity. In Microsoft Dynamics NAV, code coverage is recorded by C/AL code line and specifies if a code line was exercised by the activity and the number of times the line of code was executed . How to open Code Coverage?    path: /Departments/Administration/Application Tools    click here open  Code Coverage  directly. How to Start Code Coverage Monitoring?     Before beginning your process open Code Coverage window and click Start. " This starts the code coverage engine, and code coverage is captured. However, you will not be able to see any updated information until you choose Refresh or Stop . The information contains coverage of o...

:: Optimizing  Code Coverage Page  ::    As a Dynamics NAV developer, we all are fa miliar with this veteran tool for code tracking, The Code Coverage. This tool is very different from debugging as we don’t halt the transaction or process with breakpoints. It simply track all the codes executed during its capturing process from start to stop. It tracks all the code lines and count the line hit during the execution.    In Dynamics NAV previous versions like 2009 SP1 & 2009 R2 it was a great tool for developers to fix calculation issues which doesn't cause runtime error, Third party tool integrations or Tracking codes for developing new functionality in a module.    It feels gloomy to realize how this tool has lost its usability in recent versions. Recently I encountered G/L CONSISTENCY error in a transaction which is nothing but a calculation traggic in one of G/L entry. I tried debugger but unfortunately it didn’t work for me. Then...

C/AL Code support in Notepad++ Normally NAV object (.txt file) open as plain text in Notepad++ without no keyword highlighting as below. Which completely different from our native Developer Environment thus this editor is not friendly for code readability. But with importing a user defined C/AL language or UDL file in Notepad++, C/AL codes can be supported as other build-in support languages like Java or C#. Same file opened in Notepad++ after importing the UDL file. Now keywords are highlighted in multiple colours which is customizable.