Jet Basics - Release Notes

Jet Basics is a Microsoft Excel Add-in, for use with Microsoft Dynamics NAV and GP, which gives users a simple way to create basic reports and business queries inside Excel.

Here is a version-by-version list of changes made to Jet Basics.

Jet Basics 2019 Build 19.3.18339.1

Fixed an issue where NAV SQL data source cannot connect to Nav 2018

Jet Basics 2019 Build 19.2.18311.1

Fixed an issue where Jet Basics is unable to evaluate functions in certain languages.

Jet Basics 2019 Build 19.1.18296.2

General Update

Jet Basics 2019 Build 19.1.18289.1

Excel Add-InFixed an issue where an exception is thrown when a cell formula exceeds what excel allows to be in a formula property.Fixed an issue where running a report with an invalid function will toggle the current workbook to the background.Fixed an issue where unnecessary worksheet searching was causing a slowed performance.Fixed an issue where Office 2010 does not display the report progress window or report run times.

Jet Basics 2019 Build 19.0.18268.1

Initial Release of Jet Basics 2019

Jet Express 2018 R2 Build 18.5.18215.2(August 6, 2018)

General Update

Jet Express 2018 R2 Build 18.4.18186.3(July 16, 2018)

General Update

Jet Express 2018 R2 Build 18.3.18165.4(June 25, 2018)

General Update

Jet Express 2018 R2 Build 18.1.18149.1(June 4, 2018)

General Update

Jet Express 2018 R2 Build 18.1.18137.5(May 21, 2018)

Excel Add-In

Fixed an issue where a confusing error message would be displayed when an empty filter was not allowed in a Jet function.Fixed an issue where the Activate Jet Professional button could be hidden from the ribbon in Jet Express.Fixed an issue where Excel 2010 would produce a cryptic error message when auto-debugging #VALUE! cells.Fixed an issue where Table Builder templates were available to Jet Express users.Fixed several layout issues when using languages with messaging that is longer than English messaging.

Jet Express 2018 R2 Build 18.1.18101.2(April 19, 2018)

Initial Release of version 2018 R2

Jet Express 2018 Build 18.0.18060.4(March 8, 2018)

Excel Add-In

Fixed an issue where some queries would return an error when run in regions where commas are used as decimal points.

Fixed an issue where worksheets containing more than one NL(Table) function would only create the first table defined.

Jet Express 2018 Build 18.0.18039.1(February 15, 2018)

General Update

Jet Express 2018 Build 18.0.18018.1(January 25, 2018)

Excel Add-In

Fixed an issue where Office365 authentication was not functioning properly when configured for a NAV data source that supports it.

Fixed an issue where reports containing a cell with a very large value would sometimes throw an exception.

Fixed an issue where refreshing certain reports would take much longer to run than switching from design mode to report mode.

Fixed an issue where subsequent runs of a report after its initial run would sometimes not update report option values correctly.

Jet Express 2018 Build 18.0.17362.4(January 4, 2018)

Excel add-in

Fixed an issue where lists of tables in the Table Builder would sometimes not be sorted correctly.

Fixed an issue where reports would sometimes fail to run on non-English systems.

Jet Express 2018 Build 18.0.17342.2(December 12, 2017)

Excel add-in

The cells contained within the report options window from the Jfx are now selectable.Fixed an issue where using the Jfx from within the report options window would sometimes send the Excel window to the background when the report options window was closed.Usability of the report options window has been improved:- Tabbing moves you through each option value allowing you to edit the values.- Single-clicking a cell edits the value.- Clicking or tabbing to edit a cell selects the entire value.- ENTER runs the report.- Tooltips appear when hovering either over the title or the value.Fixed an issue where Excel 2010 users would not see updated icons.Fixed an issue where large reports would sometimes cause Excel to run out of memory.

Excel Add-inFixed an issue where Windows OS with certain regional settings were not supported with SQL-based data sources.Fixed an issue with NL(Sheets) where a sheet name with a ’:’ (colon) character would generate a COMException.Fixed an issue in the Data Source Settings where creating a Dynamics NAV 2009 R2 or earlier data source cropped the text in the Data sources -> Advanced Settings window.Fixed an issue in the Dynamics NAV 2009 R2 or earlier data source where Windows OS with certain regional settings caused dates to be retrieved incorrectly.

Fixed an issue in the Dynamics GP data source where a drilldown operation on a cell value of zero crashed Microsoft Excel.Fixed an issue where Windows OS with certain regional settings were not supported with SQL-based data sources.

Jet Express 2017 R2 Build 16.1.17081.0

InstallerFixed issue where a COMException could occur during installation.

Jet Remote Data ServiceFixed issue where Jet Remote Data Service could not be installed on Windows Server 2008 or earlier.

Excel Add-inFixed issue in the Jfx where switching the type of function would not change the available inputs. Fixed issue in the Excel Add-in where links to KB articles were incorrect.Fixed issue in the Excel Add-in where double-clicking on the Pivot Table Icon on the Jet Ribbon would select the wrong item within the Pivot Table window.

Jet Express 2017 R2 Build 16.1.17061.0

Fixed an issue where reports that used NP(Union), NP(Difference), or NP(Intersect) with a Microsoft Dynamics NAV 2013 or later data source could result in an unexpected error.

Fixed an issue where reports with Microsoft Dynamics Nav 2009 and earlier data sources could not be run.

Jet Express 2017 R2 Build 16.1.17033.0

Initial Release of Jet Express 2017 R2

Jet Express 2017 Build 16.0.16354.0

Remote Data Service

Fixed issue in the NAV Remote Data Service where using Windows Authentication on the server caused the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

Excel Add-In

Fixed issue with GP data sources where conditional formatting was not preserved on a replicator row containing GL(Rows), GL(Columns), or GL(Sheets).

Jet Express 2017 Build 16.0.16293.1

Excel Add-In

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

Jet Remote Data Service

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

Fixed issue in SQL-Based data sources where Time fields would throw an ArgumentException, or always return 0.Fixed issue in Dynamics NAV SQL data sources where Code fields backed by a SQL Variant did not work correctly.Fixed issue where the NL(Table) function threw an IndexOutOfRangeException if one of the requested fields was blank.Fixed issue where database name drop-downs were not sorted alphabetically.Fixed issue where downgrading the Excel Add-In could result in an error when opening Excel due to an unrecognized Application Setting type.

Jet Remote Data Service

Added a Launch Condition to the MSI that requires the SQL Native Client to be installed.

Excel Add-In

Fixed issue in SQL-Based data sources where Time fields would throw an ArgumentException, or always return 0.Fixed issue where the NL(Table) function threw an IndexOutOfRangeException if one of the requested fields was blank.Fixed issue where database name drop-downs were not sorted alphabetically.Fixed issue where downgrading the Excel Add-In could result in an error when opening Excel due to an unrecognized Application Setting type.

Jet Remote Data Service

Added a Launch Condition to the MSI that requires the SQL Native Client to be installed.

Jet Express 2017 for Excel Build 16.0.16252.0

Added support for NAV 2017. Note that an updated version of the "Jet Reports Objects.fob" NAV objects must also be imported.Improved overall performance of NAV Remote Data Service data sources.

Fixed issue where the "Auto Debug Report Errors" feature no longer worked as expected.Fixed issue where the Table Builder would allow multi-selection for a filter value but would only select a single value.

Fixed issue where grid drilldown into a Remote Data Service data source would display an empty grid.Fixed issue where the "Auto Debug Report Errors" feature no longer worked as expected.Fixed issue where the Table Builder would allow multi-selection for a filter value but would only select a single value.

Jet Express 2017 for Excel Build 16.0.16221.0

Updated the link to the Privacy Policy in the Activate Jet License window.

Fixed issue in the Dynamics NAV Remote Data Service data source where sorting by a CalcField did not work correctly.Fixed issue in the Dynamics NAV SQL data source where filtering by an NAV Code field with properties Numeric=Yes and SQL Data Type=Variant may not retrieve the correct results.Fixed issue where orphaned workbook connections with associated PivotTables could cause E_INVALIDARG errors.

Updated the link to the Privacy Policy in the Activate Jet License window.

Fixed issue in the Dynamics GP data source where functions containing SQL= may fail when the Batch Function Execution setting was enabled.Fixed issue in the Dynamics GP data source where tables/views were always sorted by their physical name in the Table Builder and Jfx.Fixed issue where orphaned workbook connections with associated PivotTables could cause E_INVALIDARG errors.

Jet Express 2017 for Excel Build 16.0.16196.0

Initial Release of Jet Express 2017 for Excel (NAV)

Initial Release of Jet Express 2017 for Excel (GP)

Jet Express 2015 Update 1 Build 15.1.16119.0

General Update.

General Update

Jet Express 2015 Update 1 Build 15.1.16098.0

Modified the Jet Setup to detect running applications and prompt the user to close them before proceeding.

Fixed issue where a Dynamics NAV GL function that specifies multiple companies may not give the correct value for a totaling account.Fixed issue where clicking the Next button button after choosing "Activate via Email" in the Jet Activation window crashes Excel.

Modified the Jet Setup to detect running applications and prompt the user to close them before proceeding.

Fixed issue where clicking the Next button button after choosing "Activate via Email" in the Jet Activation window crashes Excel.Fixed issue where NL(Table) throws an ArgumentOutOfRangeException when duplicate field identifiers are specified.

Jet Express 2015 Update 1 Build 15.1.16054.0

Removed validation check for ambiguous field references that resulted in the message, "The identifier 'x' is ambiguous between two or more objects."Improved installation experience when an issue is encountered with the Excel installation, formerly resulting in an InvalidExcelApplicationException.

Fixed issue where a lag could occur when switching between Excel workbooks.Fixed issue where an ArgumentException could occur when running a report that contains a pivot table.Fixed issue where the "Update Data Source" button would not work for a pivot table that was created using the Jet ribbon.Fixed issue where Excel would fail to open files from Windows Explorer when both the Jet and Hyperion add-ins were installed.Fixed issue where Excel tables that were not created by Jet would lose their data when refreshing the report.Fixed issue where the Jet installer could give an error when using Swedish regional settings.Fixed issue where Grid drilldown did not work in Dynamics NAV Remote Data Service data sources.Fixed issue where double-clicking one of the Jfx buttons on the ribbon could crash Excel.

Removed validation check for ambiguous field references that resulted in the message, "The identifier 'x' is ambiguous between two or more objects."Improved installation experience when an issue is encountered with the Excel installation, formerly resulting in an InvalidExcelApplicationException.

Fixed issue where a lag could occur when switching between Excel workbooks.Fixed issue where an ArgumentException could occur when running a report that contains a pivot table.Fixed issue where the "Update Data Source" button would not work for a pivot table that was created using the Jet ribbon.Fixed issue where Excel would fail to open files from Windows Explorer when both the Jet and Hyperion add-ins were installed.Fixed issue where Excel tables that were not created by Jet would lose their data when refreshing the report.Fixed issue where the Jet installer could give an error when using Swedish regional settings.Fixed issue where double-clicking one of the Jfx buttons on the ribbon could crash Excel.

Jet Express 2015 Update 1 Build 15.1.16013.0

Fixed issue where duplicate fields could be loaded in a SQL-Server based data source, resulting in an AmbiguousIdentifierException when accessing the field.Fixed issue where an exception could occur when accessing certain tables in the Dynamics NAV 2013 and later Web Services data source.Fixed issue where the custom Jet message box could truncate text.

Fixed issue where Dynamics GP data sources could throw an SEHException when connecting to SQL Server 2012.Fixed issue where duplicate fields could be loaded in a SQL-Server based data source, resulting in an AmbiguousIdentifierException when accessing the field.Fixed issue where the custom Jet message box could truncate text.

Jet Express for Dynamics 2015 Build 15.1.15350.0

Fixed issue where drilldown did not work in a Multitenant NAV Remote Data Service data source.

General Update

Jet Express 2015 Build 15.1.15337.0

Improved the error message when attempting to connect to a NAVRDS with an invalid host name.

Fixed issue where Jet Setup would throw a COMException when Excel was not installed.Fixed issue where NL(Table) threw an ArgumentException when switching companies.Fixed issue where too many decimal places were displayed in the Jet data grid drilldown for NAV SQL data sources.Fixed issue where the DataSource Settings Window and the New User Experience Window were cut off in the Windows 10.Fixed issue where Excel crashed closing the JFx.Fixed issue where the JFx stayed active when opening a workbook saved in Report-Mode.Fixed issue where the NAVRDS data sources did not respect local date formats.Fixed issue where Calc fields containing dimension fields inside an NF() for NavSqlDataSources threw a FieldNotFound exception.Fixed issue where the Progress Window failed to appear and the Report Runtime was 00:00'00 when running a report.Fixed issue where grid drilldown does not work on a formula containing a flowfield in a field cache.Fixed issue where the table record count only returned the count for the first company in a NAV 2013 Web Service Data Source.Fixed issue where NAVSQL data sources threw an Invalid Field error when a dimension value contained special characters.Added a link to a KB article for users who can create and connect to a NAVSQL data source but receive an error stating that the "data provider cannot be found" when designing reports.Fixed issue where Serenic User Access Rules were not being respected for NAV 2013 and later databases.

Changed the GPRDS data source to require Essentials.Changed Jet to throw an error message when a query is made using an ambiguous table or field identifier. Depending on the data source this could be the number, name, or caption.

Fixed issue where Jet Setup would throw a COMException when Excel was not installed.Fixed issue where NL(Table) threw an ArgumentException when switching companies.Fixed issue where the DataSource Settings Window and the New User Experience Window were cut off in the Windows 10.Fixed issue where Excel crashed closing the JFx.Fixed issue where the JFx stayed active when opening a workbook saved in Report-Mode.Fixed issue where the Progress Window failed to appear and the Report Runtime was 00:00'00 when running a report.

Jet Express 2015 Build 15.1.15308.0

Added KB article links for various messages.

Fixed issue where a COMException was thrown when refreshing a report with a Pivot table based on a SQL database was in a report.Fixed issue where a COMException was thrown when a HideSheet tag was on the active worksheet and the report was refreshed.Fixed issue with batch optimization in the NAVRDS where NF functions returned #VALUE when one or more of the record keys was blank.Fixed issue with batch optimization in the NAV Web Service data source where an NF returning the primary key value from a scalar record function returned #VALUE.

Added KB article links for various messages.

Fixed issue where a COMException was thrown when refreshing a report with a Pivot table based on a SQL database was in a report.Fixed issue where a COMException was thrown when a HideSheet tag was on the active worksheet and the report was refreshed.

Jet Express 2015 Build 15.1.15265.0

Changed the Remote Data Service installer to require PowerShell 4.0.

Fixed issue where a Pivot table based on an NL("Table") would leave extra data on a report.Fixed issue where a Pivot table based on Jet data would throw an error when using PowerPivot data.Fixed issue where a Pivot table based on Jet data would throw the error "The workbook connection 'LinkedTable_Table1' could not be updated for the following reason: Exception from HRESULT: 0x800A03EC."Fixed French translation of the Table Builder Supertip.Fixed typo in the Jet log file (data soure type => data source type).Fixed issue where the Jet Ribbon would disappear when the JFx was open and the user interacted with Excel's formula bar.

Changed the Remote Data Service installer to require PowerShell 4.0.

Fixed issue where a Pivot table based on an NL("Table") would leave extra data on a report.Fixed issue where a Pivot table based on Jet data would throw an error when using PowerPivot data.Fixed issue where a Pivot table based on Jet data would throw the error "The workbook connection 'LinkedTable_Table1' could not be updated for the following reason: Exception from HRESULT: 0x800A03EC."Fixed French translation of the Table Builder Supertip.Fixed typo in the Jet log file (data soure type => data source type).Fixed issue where the Jet Ribbon would disappear when the JFx was open and the user interacted with Excel's formula bar.

Fixed issue in the Dynamics NAV SQL data source where a SQL error could occur when using a LinkField against a nested link that uses multiple fields to join the table.

General Update

Jet Express 2013 Update 1 Build 14.1.14177.0

Fixed issue in the installer where attempting to upgrade Jet Express could result in an MSI error.Fixed issue in the Dynamics NAV Web Service data source where filters on Decimal fields were not correct in locales that use a comma (',') as decimal separator.Fixed issue in the Jfx where picking up a function with more than 10 FilterField/Filter pairs would throw an ArgumentOutOfRangeException.Fixed issue in the Table Builder where double-clicking the scrollbar when looking up a table would cause the popup window to close.Fixed issue in the Jfx/Table Builder where double-clicking the resize handle of a popup would cause erratic behavior.

Fixed issue in the installer where attempting to upgrade Jet Express could result in an MSI error.Fixed issue in the Jfx where picking up a function with more than 10 FilterField/Filter pairs would throw an ArgumentOutOfRangeException.Fixed issue in the Table Builder where double-clicking the scrollbar when looking up a table would cause the popup window to close.Fixed issue in the Jfx/Table Builder where double-clicking the resize handle of a popup would cause erratic behavior.

Jet Express 2013 Build 14.1.14133.0

General Update

General Update

Jet Express 2013 Build 14.1.14114.0

General Update

General update

Jet Express 2013 Build 14.0.14042.0

Updated the translation for "NAV 2013 and later" in Dutch and Icelandic to remove erroneous "R2".

Fixed issue where a NullReferenceException could occur after a report is run when a cell containing an Excel (non-Jet) formula was selected.Fixed issue with NP(Codeunit) and Dynamics NAV 2013 data sources where an AppDomainUnloadedException could occur.

Added optional SQL Native Client 2012 prerequisite for use with SQL Server 2012.Fixed issue where a NullReferenceException could occur after a report is run when a cell containing an Excel (non-Jet) formula was selected.

Jet Express 2013 Build 14.0.14024.0

Fixed issue with Dynamics NAV 2013 data sources where an NF function would give an InvalidCastException when the primary key contains a Boolean value.Fixed issue with Dynamics NAV data sources where an IndexOutOfRangeException may occur during drilldown if the company name contained a special character.Fixed issue with Dynamics NAV data sources where an ArgumentNullException could occur if the Dimension table contained a blank Code.

General Update

Jet Express 2013 Build 14.0.13337.0

Updated French translation.Added a message to the Data Source Settings indicating the response time on Test Connection of NAV data sources.

Fixed issue where CalcFields in NAV 2013 data sources were case-sensitive when searching for embedded NF functions.Fixed issue where Option fields were returned as numbers instead of captions in NAV 2013 data sources.Fixed issue where user is prompted for credentials when login fails for a NAV data source, even when using Windows Authentication.

General Update

Jet Express 2013 Build 14.0.13276.0

Updated French translation.Updated installer translations for all supported languages.

Fixed issue with NL(Table) where invalid characters in the table name using TableName= could cause existing Pivot Tables to lose the table reference.

Updated French translation.Updated installer translations for all supported languages.

Fixed issue with NL(Table) where invalid characters in the table name using TableName= could cause existing Pivot Tables to lose the table reference.

Jet Express 2013 Build 14.0.13249.0

Updated product translations for all supported languages.

Updated product translations for all supported languages.

Jet Express 2013 Build 14.0.13231.0

Fixed issue with the Dynamics NAV GL function where accounts with the account type of "totaling" always returned 0.Fixed issue with the GL function and NL(Sum) where an error occurred when specifying a company name that contains special characters.

General Update

Jet Express 2013 Build 14.0.13222.0

Fixed issue with batch query execution where functions may return #VALUE! when using a Dynamics NAV 2013 data source.

General Update

Jet Express 2013 Build 14.0.13203.0

Fixed issue where a COMException occurred when specifying a table name with NL(Table) in Excel 2003.Fixed issue in Jfx where the last item in the lookup would be cut off.