Network Security – things to consider

1.       Is Microsoft Navision Secure enough to work without VPN?

2.      What is best practice? How companies that use Navision practice.

3.

If you don’t have an Azure subscription, create a free account that lets you access any Azure service.

Create a Recovery Services vault

To create a Recovery Services vault

• If you haven’t already done so, sign in

Microsoft Dynamics NAV with SQL DB

Excel Reporting and Jet Report 

Excel reporting on Dynamics NAV

This module explains how to create basic NAV reports using Excel to connect to Dynamics NAV.

Lessons:

1. Plan the dashboard
2. Create the dashboard
   – Create and save a SQL data connection
   – Create a report
   – Create a filter
   – Create a slicer
   – Create a Timeline
3. Configure Excel Add-In
4. Practice
5. Useful links

Lab:

1. Create and save a SQL data connection
2. Create a report
3. Create a filter
4. Create a slicer
5. Create a Timeline
6. Configure Excel Add-in
7. Create report to display outstanding amount by customers

After completing this module, students will be able to:

1. Able to create basic dashboard by using Excel and SQL Data source.
2. Able to create basic dashboard that contains several reports and a filter using external data connections.

PRE-REQUISITE:

1. Excel 2013 (and above) installed on Laptop/Notebook
2. Dynamics NAV with SQL DB
3. Bring your own Laptop/Notebook

JET REPORT

Excel Reporting and Jet Report 

Jet report

Module 1: jet professional introduction and report design

This module explains introduction of Jet Professional and processes related to report design using Jet functions.

Lessons:

1. Introduction of Jet Professional
2. Creating a report listing
3. Creating a report option
4. Creating a report from multiple tables
5. Grouping and Sorting
6. Connecting to multiple databases and companies
7. Jet Browser

Lab:

1. Design a report list in Jet
2. Design a report option
3. Design a report from multiple tables
4. Include grouping and sorting in report
5. Connect to multiple data sources

After completing this module, students will be able to:

1. Understand how to design a report in Jet Professional

Register Here :

Yes or No to Call Scripting

Call scripting is one of the “hot topics”, primarily because there are so many opinions on the subject. There are many in favour of call scripting, while many remain against it.

A script

A Word Custom Report Layout is a design in Microsoft Word, what acts as a template for viewing or printing from Microsoft Dynamics NAV clients. A custom XML part is used to map the data into Word Custom Report

Built with the same flexibility and integration capabilities you’ve come to expect from Microsoft Dynamics NAV, the new NAV 2017 will transform your business processes and take your organization to the next level in terms of simplicity, function and