Jet from insightsoftware

Error: This Account Requires Multi-Factor Authentication...
Error: This Account Requires Multi-Factor Authentication...Overview We recently updated the back-end App Registration which facilitates the Business Central public cloud sign-in process for Jet to remove features Microsoft is deprecating and replace them with newer technologies (Microsoft Graph). With this comes the necessity for users to re-authenticate their Business Central public cloud data...
Error: The data source is not properly configured for Microsoft 365 authentication
Error: The data source is not properly configured for Microsoft 365 authentication Overview When trying to log in to your Business Central Public Cloud data source, you encounter the following message: The complete text of the error message is: The data source is not properly configured for Microsoft 365 authentication: AADSTS1002016: You are using TLS version 1.0, 1.1 and...
Run Button Missing Following Jet Reports Upgrade
Run Button Missing Following Jet Reports Upgrade Issue Description Following an upgrade, the Run button no longer appears on the Jet Ribbon under the Report section. Issue Resolution Reset the Jet Ribbon to its default settings to resolve this issue:Select the Jet tab on the ribbon.Click Settings.Select App Settings. The App Settings dialog box opens.On the Jet Ribbon tab, click Res...
Network Drives Do Not Appear In File Explorer When Using The Jet Excel Add-In Scheduler
Network Drives Do Not Appear In File Explorer When Using The Jet Excel Add-In Scheduler Overview When creating a Jet Excel Add-In Scheduler task and browsing for input/output files you may not see your mapped network drives listed in the File Explorer window that appears. Mapped network drives available in Windows File Explorer: Mapped network drives not available in File Expl...
Error - The remote server returned an error (429) when using a Business Central Public Cloud data source
Error - The remote server returned an error (429) when using a Business Central Public Cloud data source Overview When using Jet Reports with a Business Central Public Cloud data source the user may receive an error of "The remote server returned an error (429)". In early August 2019 Microsoft began throttling API requests to Business Central public cloud data sources. The limit was ...
Launching Jet Reports from VBA
Launching Jet Reports from VBA This article applies specifically to Jet Reports 2019 and higher.  For older versions, see Launching older versions of Jet Reports from VBA Related Articles... Overview If you write macros in Excel or want to launch Jet Reports from another application, you can launch Excel, update report options, refresh the report and print.  Below is some sa...
Error - NL is not available in Jet Basics
Error - NL is not available in Jet Basics Overview Jet Basics is a Microsoft Excel add-in for use with Microsoft Dynamics NAV and Dynamics GP, which gives users a simple way to create financial reports inside Excel. In Jet Basics, you can use the Jet GL function within your reports. If you attempt to run a report that has any other type of Jet function [such as NL("Rows"), NL("Fir...
Error: The FilterField has an empty Filter argument...
Error: The FilterField has an empty Filter argument... Overview Sometimes you want to filter an NL() function based on the contents of another cell (or the output of another NL() function) which could be a blank value.  When you run the report, #VALUE is displayed in the cell and one of two error messages (depending on your version of the Jet Excel Add-In) is displayed: Com...
Error: The Pivot Table 'PivotTableX' Could Not Be Refreshed...'Reference is not valid.'
Error: The Pivot Table 'PivotTableX' Could Not Be Refreshed...'Reference is not valid.' Overview When opening a workbook containing a PivotTable which references either an NL(Table) or NL(Rows) report for its data source the following error can be displayed: The pivot table 'PivotTableX' could not be refreshed. The following error was reported: 'Reference is not va...
Export to Word - the Named Range name appears instead of data
Export to Word - the Named Range name appears instead of data Overview When generating a Word document using the Jet Report Export to Word feature, the name of a named range appears in the document instead of the data: Cause: After the Word template was created (in this example using the named range CustomerNo.), the name of that range was changed within the Excel file itself: ...
Error: Value Cannot Be Null
Error: Value Cannot Be Null Overview When trying to connect to your Business Central data source, you see this message: Accounts could not be loaded.  The following error was reported:Value cannot be null. Parameter name: type Cause: Changes made by Microsoft to Business Central can affect how internal codeunits are named. ...
Columns widths in sample reports are too big
Columns widths in sample reports are too big This issue is usually seen in international installations where the Unit of Measure for reports is in centimeters versus inches.  Importing existing reports can result in very large values in the ad-hoc report column widths and in the margins on the Page Setup tabs. Correct these values to the appropriate value in centimeters and you're goo...
Launching Older Versions of Jet Reports from VBA
Launching Older Versions of Jet Reports from VBA The information in this article applies to Jet Reports version 18.5 and earlier.  For newer versions see the article Launching Jet Reports from VBA . Related Articles... Overview If you write macros in Excel or want to launch older versions of Jet Reports from another application, you can launch Excel, update report opt...
Can I use Excel Macros with the Jet Excel Add-in?
Can I use Excel Macros with the Jet Excel Add-in? Question Can I use Excel macros when I have the Jet Excel add-In active within Excel? Answer While we have found that it is certainly possible to have and use macros within Excel while the Jet Excel add-in Is active, we have no control over what those macros do.  It is common for macros to interfere with the functionality of bot...
NTFS Permission Precedence
NTFS Permission Precedence Expert Overview Because of the fact that users can have many different rights settings, it is possible that conflicting permission settings might apply to a particular user's access. When this occurs, the system must resolve the various permissions to determine which it should use to control the access. Rules for Resolving Permiss...
Error: You have reached the maximum number of arguments allowed for creating the report
Error: You have reached the maximum number of arguments allowed for creating the report Overview When specifying filters using the Report Wizard, you may see a message informing you that you cannot add any more filters. Complete text of error message is: You have reached the maximum number of arguments allowed for creating the report. ...
Prefetching Replicated Data - Shadow Sheets
Prefetching Replicated Data - Shadow Sheets Issue When a user runs a report in Jet Reports, the status box hangs on 'Prefetching Replicated Data' for an extended period of time. Resolution: ** Before following the steps below it is VERY IMPORTANT to create a copy of your workbook as there is a high risk of permanently damaging your report if the steps ...
Dynamics NAV Drilldown when Filtering on Data from Another Table
Dynamics NAV Drilldown when Filtering on Data from Another TableHelp Topics... When performing cross-table filtering [i.e., when using LINK= for NL("Filter") ], there are situations when you will not be able to drill down on the cell. This is due to the fact that Dynamics NAV will not accept a list as a filter, so Jet attempts to create a set of filters that will ...
Error: Input string was not in a correct format
Error: Input string was not in a correct format Overview When accessing Dynamics NAV through NAV Web Services, it is possible for the the error Input string was not in a correct format to occur. Example text of error message: An unexpected error has occurred:Input string was not in a correct format.System.FormatExceptionat System.Number.StringToNumber(String str, NumberStyl...
Accessing the Jet Reports Granule on PartnerSource
Accessing the Jet Reports Granule on PartnerSource Overview If, as an authorized Jet reseller, you are unable to find the Jet Reports granule (1412500... all prior numbers have been consolidated under this one granule) in PartnerSource so as to add the granule to a client's Dynamics NAV license, please contact Jet Reports. Contact Send an email... (including your VOICE acc...
Error: Provider cannot be found. It may not be properly installed
Error: Provider cannot be found. It may not be properly installed Overview When using the Jet Excel add-in with SQL Server 2012 or higher, and testing the connection to either a NAV SQL data source or a SQL data source, an "Provider cannot be found" message may be displayed. Complete text of error message is: Provider cannot be found.  It may not be properly ins...
Using Vendor 1099 Code
Using Vendor 1099 Code This information applies to Dynamics NAV Problem: When attempting to use the field 1099 Code from the Dynamics NAV table Vendor , you receive a #VALUE! or Invalid field '1099 Code' Because Jet Reports allows you to preface table and fields name with the the table or field number, Jet Reports interprets "1099 Code" as: ...
Jet Reports Help Topics
Jet Help Topics This article lists the Online Help topics for Jet. Click here for the Help Topics for Jet Basics Overview The Jet products provide you with a wide range of capabilities.  Here, you will find topics to help you in your tasks - be they Installing, Configuring, Getting Started with using the Jet Excel add-in, or simply refining your own skills. Table of Contents...
Error: The Jet activation token is corrupt
Error: The Jet activation token is corrupt Overview When starting Excel, an error can be displayed: Complete text of error message is: The Jet activation token is corrupt.  Please reactivate your Jet license.et Cause: There is an issue with the file that keeps track of your Jet licensing information.  You will need to de...
How to Generate a Jet Reports Log File
How to Generate a Jet Reports Log File Overview When attempting to troubleshoot an issue you are having with a report - or if you are getting an error message - it can sometimes be helpful to have the Jet Excel add-in create a log file containing the details of everything the Jet Reports add-in is doing. If you contact Jet Reports Technical Support, the support analyst may ask you to...
Error: 'Arithmetic operation resulted in an overflow' with MySQL database
Error: 'Arithmetic operation resulted in an overflow' with MySQL database Issue: When using 64-bit Jet Reports to retrieve data from a MySQL database, it is possible for the database to return the error "Arithmetic operation resulted in an overflow." Except text from error message is: An unexpected error has occurred: Arithmetic operation resulted in an overflow. ...
How to Refresh a Database Schema in the Jet Excel add-in
How to Refresh a Database Schema in the Jet Excel add-in Overview There may be times, especially when doing development work with Jet Analytics, when a new table or field may be added to a database that the user is currently reporting from using the Jet Excel add-in. To be able to include this new data in reports, the the database schema must be refreshed.  The database schema is typ...
Error: A problem was detected with the installation of Excel...
Error: A problem was detected with the installation of Excel... Symptom During installation of Jet Reports, Microsoft Windows can return an error to the setup program and the following message is displayed: Complete text of error message is: A problem was detected with the installation of Excel.  Jet Reports cannot be installed until the error is resolved.  Please see the KB a...
Error: Activation.Token is being used by another process
Error: Activation.Token is being used by another process Symptom When opening an Excel file, an error similar to the following is displayed stating that the Excel process cannot access the activation.token file because it is is being used by another process. An unexpected error has occurred: The process cannot access the file 'C:\Users\AppData\Roaming\Jet Reports\Activation...
Moving a Workbook
Moving a Workbook Overview If you open a workbook on a computer that has the Jet Excel add-in installed in a different directory than on the computer where the workbook was created, a window may open with File Not Found as the title and JetReports.xll in the File name box. This window appears when you first open the workbook. Resolution Click Cancel and ...
First Page
Back
For an optimal Community experience, Please view on Desktop