This blog is intended to see how Microsoft Dynamics NAV (here onwards NAV) can be connected to external databases. External databases here mean Microsoft Dynamics CRM (hereafter called CRM).
This blog is intended to see how Microsoft Dynamics NAV (here onwards NAV) can be connected to external databases. External databases here mean Microsoft SQL Server, CRM, Exchange* or Microsoft Graph*. We will focus on Microsoft SQL Server (non-NAV database).
Manish Prasad Kutar | NAV
, Microsoft SQL Server
, Microsoft Dynamics NAV
, NAV 2016
, NAV 2017
, Integration | SQL Server
, Microsoft Dynamics NAV
, MS Dynamics NAV
, Microsoft Dynamics
, Microsoft Dynamics NAV 2016
, Microsoft Dynamics NAV 2017 | 0 Comments |
In this post we will move to next step, and there we will go through two more data item grouping.For example: Here we will list Customer Ledger entries by Customer, then Customers by Salespersons. So we will get all customers for each salesperson and ledger entries for each customer that is done by using Salesperson, Customer, and Customer Ledger Entries data items.In my previous blog I briefly explained how to add a parent and child group and how it has displayed list of customers by sale...
Explains how to build online help pages in bulk for 2013 R2 version of NAV using merge tool. It includes detail of creating content from an excel sheet to building online (HTML) pages in bulk using Merge tool.The following are the steps which will be followed to build online help pages.1. Firstly we need to write contents in an excel sheet with table number and name, field number and content (or description) of the online help. Once the excel file is ready, we need to prepare the contents writte...
What is RDLC Report?The Report Definition Language (RDL) Data is a report component that is used by Microsoft Dynamics NAV to display the report in the Role Tailored client. Microsoft Visual Studio Report Designer is an external designer that is used to design the visual element (the RDL data) of a report. It is accessed from the Report Dataset Designer.With the help of RDLC reports we can easily export the report result into Excel, PDF and Word formats. We can have interactive sorting, add link...
Online help page is a web page which displays information in a web browser when user presses the key F1 for the selected field or page in MS Dynamics NAV 2013 R2.In this blog I will try to document the process of creating online help page for Microsoft Dynamics NAV 2013 R2 version, from creating online help topic to building the complied (html) help page and also how to integrate the help page into your project.Prerequisites: · Microsoft Dynamics NAV 2013 R2 with ...
Query is a new object in Microsoft Dynamics NAV 2013 that a programmer can use to define a set of data from the Microsoft Dynamics NAV database. Users can query the database to retrieve field’s information stored in the database from a single table or multiple tables using table relation. You can specify how to join tables in the query where you can define filter criteria to get the desired results. You can specify totalling methods on fields, such as sums and averages.Query helps us to im...
RapidStart Services is an integrated tool that helps you to speed up the implementation process and facilitates better control of whole processes in NAV implementation. It includes Project Overview, Master Data Import and Export, Configuration Packages, etc. You can set up a new company in Microsoft Dynamics NAV with RapidStart Services for Microsoft Dynamics NAV.RapidStart Services gives you an overview of the implementation process of your new company by providing a worksheet in which you can ...