Mrinal Singha's Dynamics NAV Tip & Tricks Blog

Integrating ChatGPT with Power Apps. Here's an overview of the steps you need to follow: Set up a ChatGPT API: First, you'll need to create an API for ChatGPT. You can use a cloud-based service such as AWS, Google Cloud, or Microsoft Azure to host your API. Alternatively, you can use a pre-built API platform such as RapidAPI, which provides pre-built ChatGPT APIs that you can use. Create a custom connector: In Power Apps, you can create a custom connector to connect to external data sources such as APIs. To create a custom connector for ChatGPT, you'll need to provide the connector with the following information: the API endpoint, authentication method, and any custom headers or query parameters that your API requires. Use the connector in your app: Once you've created your custom connector, you can use it to integrate ChatGPT into your Power App. You can add a chatbot control to your app, configure it to use your custom connector, and specify the actions that you want

D on’t like to wait for Visual Studio Code to boot up when you’re looking for a specific .al file? With this trick, you can preview .al files in Windows 10 without opening. .  .. What is File Explorer Preview Pane? First, let's check out the preview pane in File Explorer.  Open File Explorer.  Click on the View tab and then select Preview pane.  Click on a file you wish to view, such as a Word document, Excel sheet, PowerPoint presentation, PDF, or image. The file appears in the preview pane. Increase or decrease the size or width of the file by dragging the separation bar left or right. Modification required to Preview .al file in File Explorer Open Windows Registry Editor (regedit).  Find  Computer\HKEY_CLASSES_ROOT\.al Add New String Value (Right click), Name :  PerceivedType , Value data : text or Download this .reg file and double click to Merge it.  (link below) Download If prompted, click/tap on  Run ,  Yes  ( UAC ),  Yes , and  OK  to ap

We’re the Dynamics NAV developers. We can develop modules, functionalities, fix bugs all the live long day, but, is our code adhere Coding Guidelines, as per Microsoft up there? That’s the end game. How were you guys planning on beating that? Followings are the catalog of coding violations in 4 major categories or Rules, Readability , Design , Globalization & User eXperience .     // Readability Rules     // Rules which ensure that the code is well-formatted and readable.      Error001 = "Readability: There must be exactly one space character on each side of a binary operator such as := + - AND OR =. The parameter comma operator however, should have no spaces.";      Error002 = "Readability: There must be no space between a unary operator and its argument (except for the NOT keyword).";      Error003 = "Readability: There must be no spaces characters before and after [] dimension brackets symbols or

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

         We all know about this pop message shown when we were closing Dynamics NAV classic client or Development Environment. This blog is all about what is zup file and When + How to use it. Introduction         "Setup parameters for running the Microsoft Dynamics NAV Development Environment are stored in a .zup file. By default, the file is located at  C:\users\<username>\AppData\Roaming\.  The information that is stored in the .zup file includes: Database name. Database server name. The parameters that are available in the Options window. User-specified personalization of development environment windows, such as window size, window position, column order, column visibility, and column width. When a user closes the development environment, any setup changes the user has made are saved to the .zup file." When and how to use it!            Few days back my laptop was broke and I had to reinstall Dynamics NAV again. Be

  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 File