Introduction: In this article, I will be explaining the procedure to display amount in words in a report of Microsoft Dynamics NAV. Pre-Requisite: Microsoft Dynamics NAV 2016 Procedure: Step 1: Declare the following variables in C/AL Globals: ‘RepCheck’ is a variable of DataType ‘Report’ and Subtype ‘Check’ which is Report 1401. ‘NoText’ is a variable … Continue reading Procedure to display the Amount in Words in a report of Microsoft Dynamics NAV →

Introduction: A Single Sign-on (SSO) user experience is achieved between Microsoft Dynamics NAV and the Office 365 Web Applications where the User is authenticated using Office 356 credentials to access NAV Windows client and Webclient. Error: After configuration of SSO in NAV, the Windows client configures SSO successfully but the Web client throws an error. … Continue reading Error Resolution of Web client reply address for SSO in Dynamics NAV →

Introduction: To track changes that are made to records in a particular table and to store them sequentially in NAV, logs have to be created. Using logs we can record changes that are made to standard or custom fields in a table. In this article, I will be demonstrating the steps required to setup logs … Continue reading Procedure to create custom logs in Dynamics NAV →

Introduction This article describes how to deploy Microsoft Dynamics NAV database to Microosft Azure SQL Database. To deploy a Microsoft Dynamics NAV database to Azure SQL Database, the database must be exported as a data-tier application (DAC) file, which is known as a .bacpac file. This can be performed by using SQL Server Manager. Pre-requisite … Continue reading Deploy a Microsoft Dynamics NAV Database to Azure SQL Database →

Introduction: With Microsoft Dynamics NAV 2017, we can increase or decrease the inventory of an item from the item card itself. Steps: 1. Navigate to Item card. 2. Select assist Edit next to Inventory and enter the New Inventory. 3. If New Inventory is less than current inventory a Negative Adjustment will be passed behind … Continue reading Increase/Decrease Inventory from Item Card in NAV 2017 →

Introduction: This blog focuses on displaying the captions of all action buttons of NAV Pages in Arabic language. The requirement was such that the user wanted to view Microsoft Dynamics NAV in Arabic. To suffice this, we installed Arabic module for Microsoft Dynamics NAV 2017 RTC, Server and web client. After installation, only the standard … Continue reading Arabic Language Captions in Microsoft Dynamics NAV →

Introduction: In reports, we always a requirement to display header rows of the table on every page. In this article, I will be explaining the steps to do the same in Dynamics NAV. Pre-Requisite: 1. Microsoft Dynamics NAV 2. Visual Studio Report design Environment Procedure: 1. Under layout of your report, click on the arrow … Continue reading Procedure to repeat table header rows on every page of a report in Dynamics NAV →

Introduction: We often have a requirement to dynamically hide or show fields on a page according to a certain condition. Setting visibility properties of the fields to ‘True’ or ‘False’ do not help as they do not work dynamically. They are only set when the page is opened initially. In this article, I will be … Continue reading Dynamically hide and show fields according to a specific condition on a page in Dynamics NAV →

Introduction: In this article, we will see how to resolve the below error while creating/quering records from NAV. Error Details: Error in calling Operation Query (Lookup Block): Operation failed. Label: Lookup CFSCar, Name: CFSCarLookup, Message: The following error has occurred in the Dynamics NAV Connector: Error: NotFound status code = 404. Resource not found for … Continue reading NAV Error: “Resource not found” in TIBCO Cloud Integration →

Introduction In this article, the selected record details by the user are exported to excel using Excel Buffer. The requirement was such that Purchase Request is sent to the Vendors to enter the Unit cost of each Purchase Items. These details are sent to the vendors in an excel sheet. After the Unit cost is … Continue reading Exporting record details to excel using Excel Buffer in Microsoft Dynamics NAV 2017 →