Extracting data
Dynamics NAV offers several ways of analyzing and reporting data inside the application. If that is not enough, you can also extract data from the application and use external tools to report and analyze your data.
In this section, we will see the different ways you can extract your data from Dynamics NAV. Once it is outside the application, you can use the most convenient tool for you.
Data in Dynamics NAV can be extracted in multiple ways. The various ways include:
Copying and pasting to Excel
Extracting data through SQL Server
Any external data/reporting tools that can connect to SQL Server
Web services
EDI
The list goes on and on…
In this section, we'll focus only on two ways of exporting the data:
Sending data to Microsoft Office applications
Using web services
Sending data to Microsoft Office applications
Dynamics NAV data can be sent to either Microsoft Word or Microsoft Excel by the users.
Whenever that is possible, which is on all the pages in Dynamics NAV, except on the Role...