Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Setting up a NAV Data Source (for NAV 2009 R2 and earlier)


Setting up a NAV Data Source using:

Jet Professional Jet Express Jet Essentials Jet Reports v9 - v10.5

 

 

Watch the Video!

 

 


Before you can create a NAV Data Source connection,
you will need the following files and information:

 

· For Jet Essentials 2013 and higher: your Jet License Activation Code
· For Jet Essentials 2012 R2 and earlier: your Jet License File (.jlf)
· Your Microsoft Dynamics NAV License File (.flf)

· Database Information
o Server Type (Local, Database Server, or SQL Server)
o Authentication Type (Windows or Database)
o Server Name or Address
o Net Type


You will also need to have downloaded and installed either:

Gathering your Database Information

 

You can find your Dynamics NAV configuration information (such as server type, server name, net type, and authentication type) in the NAV classic client.

To do this, open the NAV client and select Database from the File menu and then select Information

 

If you are using a NAV Server or Local connection, you will find most of the information you need to configure your data source on the Connection tab.

If the Connection is Local, then you want a Local Database File data source.

If the Connection is Server, then you need a Dynamics NAV Database Server data source in Jet Professional. The Server Name and Net Type are also needed to configure your Jet data source.

If you are using a NAV SQL Server, you will find most of the information you need on the Database tab.

 

You will need the Server Name, Database Name, and Net Type.

 

If using either NAV-Server or NAV-SQL Server, you need to know what type of authentication you use to access the database.

If you have to type a username/password in each time you open NAV then you are using Database Authentication. You will have to supply your NAV username/password in your Jet data source setttings in order to access your NAV data.

If you do *not* have to type in a username/password each time you open NAV then you are using Windows Authentication. NAV and Jet can use your Windows login credentials to connect.


 

Once you have gathered the necessary files and information listed above, please follow these steps...

Step Action
1
Place a copy of your NAV license (.flf) in the local client folder (i.e. C:\Program Files\Microsoft Dynamics NAV\Client )
 

IMPORTANT : You must rename the license file “fin.flf”

2

If using Jet Essentials 2012 R2 or earlier, place your Jet license (.jlf) on a network drive or on your local computer.

If using Jet Essentials 2013 or higher, ensure that you have Activated your Jet License.

3

Open Excel, then open the "Application Settings" from the Jet ribbon or Jet menu

4

If using Jet Essentials 2012 R2 or earlier...

In the “Jet License Folder:” section, browse to the network or local folder where you placed your Jet license in Step 2.

 

Select OK on the Application Settings screen.

5

Open the "Data Source Settings" from the Jet ribbon

6  

Click the "Add" button (or, for older versions, select "File" then "New")

7  Give the data source a unique name.
8

Make sure the “Type” is set to "Dynamics NAV 2009 R2 or earlier"
(or, for older versions, "Navision")

and then select OK.

9

For the "Dynamics NAV client folder", browse to your Dynamics NAV client folder (this is the same folder into which you placed your NAV license in Step 1).

10

If you exported a language module and would like to use it for this data source, specify the folder in the “Language module folder:” box.

Then, select the same language from the pull-down list.

11

In the “Authentication” section, select your authentication type.

If you *do not* have to enter in a user name and password each time you start NAV, you probably use Windows Authentication.

Otherwise, you probably use Database Authentication and need to specify your user name and password in the areas provided.

12

In the "Connection" section (named the “Connect to” section in older versions), specify the server type, then fill in the server name, database name or path, and net type if applicable.

13

Select a default company from the “Company” dropdown list.

14  

Select “Test Connection” at the top of the Data Source Settings screen.


 
Desired Result:  Test Connection Succeeded

 

 

 

Troubleshooting


IF...

THEN...


You cannot select a default company from the company dropdown…


You are unable to connect to the database. Go back through the prior steps and make sure everything is correct.

The message at the bottom of the Data Source Settings says “You are not licensed for this data source” after you’ve completed the setup…

Check the License section of the Jet Application Settings to ensure that your Microsoft NAV license number is included on your Jet license.
 
(if using an older version of Jet Essentials, ensure that the Jet License Folder setting is correct)

When you test the connection, you receive the message “The required Navision Client executable (fin.exe) could not be found…”

Make sure that the Navision Client folder is correct.

When you test the connection, you receive the message: “A Navision license file could not be found in…”

Make sure that you have placed your NAV license in the client folder AND that its name has been changed to “fin.flf”

The message at the bottom of the Data Source Settings says “You are licensed as a Viewer” and you should be licensed as a Designer.

Check with your system administrator.

If your Jet license is set to use your Excel user name, check to make sure that your Excel user name EXACTLY matches your designer name on the Jet License.

If your Jet license is configured to use your Windows login information, ensure that you are listed on your organization's license as a Designer.

 

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments