Configure NAV or Business Central Web Services for Jet Reports

Related Articles...

Overview

Installing and Publishing the Jet Business Objects on the Microsoft Dynamics Server

1. Installing the Jet Business Objects

   The Jet Business Objects must be imported into the Dynamics NAV Server to enable communication with the Jet Excel add-in.  These objects should only be used with NAV 2013 and higher.

   • There are three sets of Business Objects available for version 18.1 or higher of the Jet Excel add-in:
     • A zip file containing the objects ( Jet Reports Objects.fob ) for NAV 2013-2015 is available for download here.
     • A zip file containing the objects for NAV 2016 is available for download here.
     • A zip file containing the objects for NAV 2017 is available for download here.
     • A zip file containing the objects for NAV 2018 and higher is available for download here.
     • A zip file containing the objects for Business Central is available for download here.
     You will need to extract the .FOB file from the compressed zip file.
     Need Business Objects for an older version of the Jet Excel add-in?

   To install the .fob file, open the Microsoft Dynamics NAV Development Environment and then connect to the database

   1. Open the Object Designer (choose Object Designer from the Tools menu)
   2. Import the .fob file (from the File menu, choose Import )
   3. Locate the import file and then choose Open 
   4. The .fob file includes modified objects. When prompted choose Yes to import all objects
   5. Verify that no objects are to be skipped. Objects are skipped if the version of the object in the database is later than the one in the .fob file
   6. Choose the OK button to import the .fob file

   The .fob file installs a set of business objects in codeunits 14125500 - 14125504 and Table 14125600.

   Note:  Users of the Jet Excel add-in must have Read, Insert, Modify, Delete (RIMD-) permissions to Table 14125600 "Jet Cancellation".

2. Publishing the Jet Data Source Code Unit to the Web Service

   Publishing the Jet Data Source Code Unit to the Web Service Microsoft Dynamics NAV 2013 and later includes a "Jet Data Source" codeunit which must be published to enable Jet Reports to operate.

   
   This can be published using the Microsoft Dynamics NAV Role Tailored Client (RTC).
   
   Inside the RTC go to Departments > Administration > IT Administration > General and select Web Services.

   Publish the Jet Data Source code unit by selecting New from the Web services ribbon

   Object Type	Object ID	Service Name	Published
   Codeunit	14125500	Jet Data Source	[x]

3. Enable SOAP Services and identify connection parameters

   Jet Reports calls Web Services (SOAP) when running reports or accessing information from Microsoft Dynamics NAV 2013 and higher.

   Using the Microsoft Dynamics NAV Server Administration Tool select the instance that you want to use and check the box next to Enable SOAP Services

   If the Jet Excel add-in will be used outside a secure network then SSL should be enabled for the SOAP Services to help provide security and data integrity for data communications

    

   Please refer to Microsoft instructions regarding how to configure this. These topics may be helpful...
   NAV 2013:  http://msdn.microsoft.com/en-us/library/ee414240(v=nav.70).aspx

   NAV 2016:  https://msdn.microsoft.com/en-us/library/ee414240(v=nav.90).aspx

   From the Microsoft Dynamics NAV Server Administration Tool, record the:

   • Credential Type
   • Server Name
   • Instance
   • SOAP Services Port
   • Whether SSL is enabled for SOAP Services

   This information is required for configuring your data source connection in the Jet Excel add-in on client machines.