Jet Essentials 2015 Build 15.0.14280.0, 08.10.2014
Changes since 14.1.14226.0
Table Cache Optimization for NAV 2013 and NAV 2015 data sources using NAV's Web Services
Compatibility with NAV 2015
Support for NAV 2015's Office 365 authentication method (also known as OAuth authentication)
Expansion of the Jet Administration Console (part of the Jet Service Tier) to support Jet Mobile
Jet Essentials 2013 Update 1 Build 14.1.14226.0, 18.08.2014
Changes since 14.1.14177.0
Updated product translations.
Fixed issue in the Dynamics NAV SQL data source where the "Windows Authentication (other user)" did not work as expected in conjunction with the GL function.
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.
Jet Essentials 2013 Update 1 Build 14.1.14177.0, 27.06.2014
Changes since 14.1.14133.0
Improved the NP(Dates) function so that the "Return Period End" argument is more intuitive, only returning period ends in the specified range.
Improved the NP(Dates) function so that only the Start Date argument must be specified in order to return the corresponding Period End.
Fixed issue in the Dynamics NAV SQL data source where the Date table was not being recognized in some scenarios.
Fixed issue in the Dynamics NAV SQL data source where the "Windows Authentication (other user)" did not work as expected.
Fixed issue in the Dynamics NAV SQL data source where FlowFields to virtual tables were available, even though virtual tables are not supported.
Fixed issue in the Dynamics NAV SQL data source where some FlowField queries would throw a SqlException in locales that use a comma (',') as decimal separator.
Fixed issue in the Dynamics NAV SQL data source where some decimal values show too many decimal places.
Fixed issue in Dynamics NAV 2013 data sources where an instance name could not be specified for Web Client drilldown.
Fixed issue in Dynamics NAV 2013 data sources where nested CalcFields could attempt to retrieve values from the wrong table.
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 Jet Administration Console where the Company field was not available for a Dynamics NAV SQL data source.
Seite 1 von 15
Fixed issue in the Scheduler where the UI culture was not being set, causing some things not to be displayed in the current locale.
Fixed issue in the Report Builder where related items were not populated when using a Dynamics NAV SQL data source.
Fixed issue in the Report Wizard where filters were not cleared when navigating "Back" then clicking "Next" and returning to the Filters page.
Fixed issue with the NP(Formula) function where an ArgumentOutOfRangeException could occur.
Fixed issue where attempting to insert a pivot table over the top of another did not give a helpful error message.
Fixed issue where renaming a Cube data source would throw an IOException if an Office Data Connection (*.odc) file with the new name already existed.
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 install Jet Essentials over the same version of Jet Express would result in multiple entries in Add/Remove Programs.
Jet Essentials 2013 Update 1 Build 14.1.14133.0, 14.05.2014
Changes since 14.1.14114.0
Fixed issue where Favorites could be lost when closing Excel and then clicking Cancel.
Fixed issue where a timeout could occur when retrieving the NAV license number for a new Dynamics NAV SQL data source.
Fixed issue where field names with a bracket ([ or ]) or a backslash (\) were not supported in the Dynamics NAV SQL data source.
Fixed issue where FlowFields were not allowed as linking fields in the Dynamics NAV SQL data source.
Fixed issue where wildcard filters on FlowFields in the Dynamics NAV SQL data source may not work correctly.
Fixed issue where filter literals were not being trimmed for whitespace in the Dynamics NAV SQL data source.
Fixed issue where an NF function to a record key containing a blank Date field value would error with an EmptyFilterNotAllowedException in all NAV 2013 data sources.
Fixed issue where Dynamics GP GL(Cell) formulas would return #VALUE! errors with the "Enable batch function execution" setting enabled.
Jet Essentials 2013 Update 1 Build 14.1.14114.0
Changes since 14.0.14042.0
Added data source for direct SQL Server access for NAV 2013 and higher.
This build includes new versions of the Jet Configuration Service and the Jet Administration Console needed to support the new data source type.
Jet Essentials 2013 Build 14.0.14042.0, 11.02.2014
Changes since 14.0.14024.0
Seite 2 von 15
Updated the translation for "NAV 2013 and later" in Dutch and Icelandic to remove erroneous "R2".
Added optional SQL Native Client 2012 prerequisite for use with SQL Server 2012.
Fixed issue with the Jet Administration Console where permissions were not displayed correctly when a user and a group shared the same ID.
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.
Fixed issue in the Data Source Settings where importing Favorites may not work as expected.
Jet Essentials 2013 Build 14.0.14024.0, 27.01.2014
Changes since 14.0.13337.0
NAV 2013 and 2013 R2 installations require the Jet Business Objects version 12.5.8 to be installed.
This version of Jet Essentials includes an update to the installer for the Jet Configuration Service and Administration Console but does *not* require the re-installation of the Service or Console
for this version of Jet Essentials.
Fixed issue with the Jet Administration Console where checking a data source Permission for a user would also check it for a group with the same ID.
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.
Fixed issue with Batch Function Execution could fail when a non-optimized function is nested within an optimized function.
Fixed issue where a Viewer may not be able to drilldown on a formula that contains a cross-sheet cell reference.
Fixed issue where switching to "Local Database File" in the Data Source Settings for a Dynamics NAV data source did not enable the "Database" textbox.
Fixed issue where the Data View Creator was not updating table definitions when new tables are added to the database.
Jet Essentials 2013 Build 14.0.13337.0, 03.12.2013
Changes since 14.0.13276.0
NAV 2013 and 2013 R2 installations require the Jet Business Objects version 12.5.8 to be installed.
This version of Jet Essentials includes an update to the installer for the Jet Configuration Service but does *not* require the re-installation of the Service for this version of Jet Essentials.
Seite 3 von 15
Updated French translation.
Added an option to run the Jet Scheduler as Administrator.
Added a message to the Data Source Settings indicating the response time on Test Connection of NAV data sources.
Improved Jet Configuration Service installer so that specifying the local SQL server instance is clearer.
Improved Batch Function Execution so that functions containing a Boolean argument are eligible for optimization.
Improved memory management during report expansion.
Fixed issue in the Jet Administration Console where a NullReferenceException could occur.
Fixed issue where an SSPI exception could be thrown when accessing the Jet Configuration Service.
Fixed issue where results were not sorted correctly when retrieving multiple levels from the same hierarchy in a Cube data source.
Fixed issue where drilldown into an NL(First), NL(Last), etc. function would display the wrong record in a Cube data source.
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.
Fixed issue where replicated values longer than 255 characters were not being quoted and could potentially crash Excel.
Jet Essentials 2013 Build 14.0.13276.0, 04.10.2013
Changes since 14.0.13249.0
NAV 2013 and 2013 R2 installations require the Jet Business Objects version 12.5.8 to be installed.
Updated French translation.
Updated installer translations for all supported languages.
Changed Jet License Activation Token to be stored in Roaming section of user profile.
Added option to enter Jet License Activation Code during installation.
Improved Jet Administration Console so that it does not require Administrative privileges to run.
Improved Scheduler to notify user if an email will not be sent due to Outlook not running as an administrator.
Fixed issue with NL(Table) where invalid characters in the table name using TableName= could cause existing Pivot Tables to lose the table reference.
Fixed issue with Jet Configuration Service installer where an error regarding invalid date format would occur in non-English locales.
Fixed issue with Jet Configuration Service installer where failure to add the Windows Firewall rule would cause the entire installation to fail.
Seite 4 von 15
Fixed issue where Viewer would receive an error during Drilldown with Batch Function Execution enabled.
Fixed issue where Drilldown or Unhide would cause functions to have incorrect cell references with Batch Function Execution enabled.
Fixed issue where a '-' in front of a function would not be restored correctly during Unhide with Batch Function Execution enabled.
Fixed issue where function results would not be populated correctly with more than two levels of dependencies with Batch Function Execution enabled.
Jet Essentials 2013 Build 14.0.13249.0, 06.09.2013
Changes since 14.0.13231.0
NAV 2013 and 2013 R2 installations require the Jet Business Objects version 12.5.8 to be installed.
Updated translations for all supported languages.
Added diagnostic logging to Jet Configuration Service and Jet Administration Console.
Fixed issue with batch query execution where the Dynamics NAV GL function could erroneously return 0.
Fixed issue with batch query execution when referencing a named range that was in the same format as a cell reference.
Fixed issue with NL("Picture") where a COMException would occur when using Excel 2010 SP2.
Fixed issue where NP(DateFilter) would not construct correct filters when a wildcard (*) was specified as the Start Date or End Date.
Fixed issue with the Jet Administration Console where an invalid host name displayed an "unexpected error" message.
Fixed issue with the Jet Administration Console where an SSPI exception could occur when connecting to the service.
Fixed issue where a Universal data source was not able to connect to a SQL Azure database.
Fixed issue where an invalid activation token could result in a confusing error message that posed multiple questions.
Fixed issue with NL(Table) where Formula Field headers would not be displayed when the Function Cache is disabled.
Jet Essentials 2013 Build 14.0.13231.0, 20.08.2013
Changes since 14.0.13222.0
NAV 2013 and 2013 R2 installations require the Jet Business Objects version 12.5.8 to be installed.
Seite 5 von 15
Fixed issue with the Dynamics NAV GL function where accounts with the account type of "totaling" always returned 0.
Fixed issue with batch query execution where an error occurred when doing a company consolidation with GL or NL(Sum).
Fixed issue with the GL function and NL(Sum) where an error occurred when specifying a company name that contains special characters.
Fixed issue with the Scheduler where canceling the elevation prompt resulted in an exception.
Fixed issue with the Jet Configuration Service installer where an error occurred attempting to insert the Schema Version when running in a non-English locale.
Jet Essentials 2013 Build 14.0.13222.0
Changes since 14.0.13203.0
Updated Spanish translation of 'Tooltip'.
Improved error message when license activation fails due to an invalid activation code.
Fixed issue where scheduled reports would fail to run when logged out because the license activation token could not be found.
Fixed issue with batch query execution where NF functions would not be negated as expected.
Fixed issue with batch query execution where special-character escaped filters would return #VALUE! when referencing a row absolute range.
Fixed issue with batch query execution where functions may return #VALUE! when using a Dynamics NAV 2013 data source.
Fixed issue with Jet Configuration Service where a timeout may occur after a long period of inactivity.
Jet Essentials 2013 Build 14.0.13203.0, 01.08.2013
Changes since 14.0.13169.0
NAV 2013 and 2013 R2 installations require the Jet Business Objects version 12.5.8 to be installed.
Implemented cancellation of queries in Dynamics NAV 2013 data sources.
Improved performance, CPU, and memory consumption of the codeunits that are required for Dynamics NAV 2013 data sources.
Added compatibility for Dynamics GP data sources running on Microsoft SQL Server 2012.
Fixed issue where the Jet Scheduler stopped showing scheduled tasks after a recent Windows update caused the Windows task scheduler to require administrative rights.
Fixed issue where Favorites were not being saved when using local settings.
Seite 6 von 15
Fixed issue where local (non-domain) users could not be added using the Jet Administration Console.
Fixed issue where a COMException occurred when specifying a table name with NL(Table) in Excel 2003.
Fixed issue with UserName authentication in Dynamics NAV 2013 data sources where the domain name would be ignored.
Fixed issue where the NF function did not ignore FlowFilters for non-FlowFields in Dynamics NAV 2013 data sources.
Fixed issue with RTC drilldown in Dynamics NAV 2013 data sources, where an error would occur with pure wildcard (*) filters.
Fixed issue where an NF function containing a merged cell could result in an exception.
Fixed issue where batch optimization did not work correctly when an optimized function referenced an NL(Filter) function.
Fixed issue where NP(DateFilter) did not work when referencing a batch optimized NF function.
Fixed issue where a Jet license activation token was not immediately validated when activating over email.
Fixed issue where batch optimized queries could create an HTTP request that was too large.
Fixed issue with Report Options where the lookup window incorrectly build a range filter when a manual sort was applied.
Fixed issue in Jfx where the last item in the lookup would be cut off.
Jet Essentials 2013 Beta Build 14.0.13169.0
Changes since 14.0.13135.0
Improved performance of web requests in Dynamics NAV 2013 data sources.
Added optimization to batch execute GL, NL(Sum), and NL(Numeric) functions in certain situations.
Updated the license activation window with a direct link to enter an activation token hash.
Added messages regarding license activation with a license that has no more available viewers.
Added a confirmation page after sending the license activation email with further instructions.
Updated Czech translation of the "Connection=" tag so that it is not the same as "Link=".
Fixed issue where users would periodically have to reactivate their Jet license.
Fixed issue in Dynamics NAV 2013 data sources where array filters resulting in multiple queries could cause dates to not parse correctly.
Fixed issue where using the NF function could result in an InvalidFilterException when the primary key included a decimal field.
Fixed issue where adding users to the Jet Configuration Service would use an incorrect domain if the domain name was different than the netbios name.
Fixed issue in Jet Administration Console where administrators could not delete any user where the domain value matched the exact case of their own.
Fixed issue where Dynamics NAV 2013 data sources would not correctly handle queries where no records match. (NOTE: Requires update of "Jet Reports Objects.fob" in Dynamics NAV)
Seite 7 von 15
Jet Essentials 2013 Beta Build 14.0.13135.0
Changes since 14.0.13102.0
Fixed issue with NAV2013 data sources where a query that returns no results could hang or report an error that the server could not be reached. (NOTE: Requires update of "Jet Reports
Objects.fob" in Dynamics NAV)
Fixed issue with NAV2013 data sources where date filters may not work correctly in non-English cultures.
Fixed issue where Jet was unable to be installed on a machine containing 64-bit version of Office 365.
Fixed issue where the connector types were disappearing from the Licensing page of the Jet Application Settings.
Fixed issue with Key= in Dynamics NAV data sources where keys containing the primary key may not be found.
Fixed issue where the Import button in the Data Source Settings was disabled for Cube data sources.
Fixed issue with Advanced Dimensions in Dynamics NAV would prefix the dimension with a negative number when using a drop format that contains the number.
Fixed Swedish translation of "Limit=".
Fixed sizing issues on Permissions page of Jet Administration Console.
Cleaned up windows in Jet Administration Console when adding a new data source.
Jet Essentials 2013 Beta Build 14.0.13102.0
Please note that this version requires an update to the Jet Reports Objects.fob in Dynamics NAV.
Changes since 14.0.13088.0
Updated product translations for all supported languages.
Minor improvements to Jet Administration Console.
Changed GP Update Utility to overwrite Jet roles if they already exist, and removed access to Jet Views from the Jet All Users role.
Merged fixes from Jet 2012 R2 Build 12.5.13099.0.
Fixed issue where creating a copy of a data source, then changing settings on the copy, also changed the settings on the original.
Fixed issue in Jfx where an InvalidOperationException could occur, causing the window to hang.
Fixed issue in NP(Slicer) where the result would not be updated for Timeline slicers, introduced in Excel 2013.
Fixed issue in NAV 2013 data sources where opting not to load a language module threw an exception. (NOTE: Requires update of "Jet Reports Objects.fob" in Dynamics NAV)
Fixed issue in Browser where saving Favorites may report an error that the file is in use by another process.
Seite 8 von 15
Fixed issue with NL(Table) where an IndexOutOfRangeException could occur when using NP(Formula).
Jet Essentials 2013 Beta Build 14.0.13088.0
Changes since 14.0.13073.0
Improved performance for all data sources types when the query contains the primary key.
Improved performance of searching for Jet tags in other languages.
Added optimization when searching for NL(Picture) functions while running a report.
Added database lookup in the Jet Configuration Service installer.
Updated a message regarding upgrading existing Centralized Settings to the Jet 2013 Configuration Service.
Fixed issue where Jet may need to be re-activated after changing which NIC is being used (e.g. going from Ethernet to WiFi).
Fixed issue in the Jet Configuration Service where the Administration Console was unable to connect in certain locales.
Fixed issue in the Jet Configuration Service where an exception would be thrown if not connected to a domain network.
Fixed issue in the Jet Configuration Service where it could not be installed when trying to install it as the 'sysadmin' user.
Fixed issue in the Jet Configuration Service where it could not be installed when trying to run it under a local user account.
Fixed issue in Dynamics NAV 2013 data sources where specifying both "Limit=" and "IncludeDuplicates=TRUE" did not work as expected.
Jet Essentials 2012 R2 12.5.13162.0, 13.06.2013
Changes since 12.5.13099.0
Updated Swedish translation of the "Limit=" tag.
Updated Czech translation of the "Connection=" tag so that it is not the same as "Link=".
Improved performance and memory consumption of server side objects required for NAV 2013 data source. (NOTE: Requires update of "Jet Reports Objects.fob" in Dynamics NAV)
Fixed issue with NAV 2013 data sources where date filters may not work as expected if the query contains an array filter or NL(Filter).
Seite 9 von 15
Jet Essentials 2012 R2 12.5.13099.0, 19.04.2013
Changes since 12.5.13072.0
Fixed issue where function results would remain cached after changing the default data source or company on the Jet ribbon.
Fixed issue where Drilldown did not work for Viewers when Jet functions were not uppercase (NL, NF, NP, or GL).
Fixed issue where a connection to a SQL Server using SSL gave the message, "Keyword not supported: 'use encrypted data'."
Fixed issue in the Jfx where auto-population of Link fields did not respect the Drop Format setting.
Fixed issue in NAV 2013 data sources where opting not to load a language module threw an exception. (NOTE: Requires update of "Jet Reports Objects.fob" in Dynamics NAV)
Fixed issue in Report Options where validation would not work with +Lock or +Values when the validation formula contained a Jet function.
Jet Essentials 2012 R2 12.5.13072.0, 14.03.2013
Changes since 12.5.13039.0
Added support for all four types of Dynamics NAV 2013 authentication methods.
Improved performance of Dynamics NAV 2013 data sources.
Fixed issue in Dynamics NAV data sources where sorting by more than two fields may not sort as expected.
Fixed issue in the Jfx where special FilterFields (e.g. Link=, etc.) would not be available in the lookup for NL("Rows=X") and NL("Columns=") functions..
Jet Essentials 2012 R2 12.5.13039.0, 18.02.2013
Changes since 12.5.12353.0
Updated French translation.
Improved performance of Dynamics NAV GL function in certain situations.
Improved performance of lookups on Dimension members in Cube data sources.
Fixed issue with Cube data sources where drilldown on NL(CubeValue) might display an error about a column that does not allow null values.
Fixed issue with Cube data sources where HTTP connections to the Analysis Services server were not supported.
Seite 10 von 15
Fixed issue with the Browser where Favorites might not be saved for a newly created data source.
Jet Essentials 2012 R2 Build 12.5.12353.0, 21.12.2012
Jet Essentials 2012 Build 12.0.12187.0, 05.07.2012
Changes since 12.0.12150.0
Removed incomplete Korean, Slovenian, and Turkish translations from list of available User Interface languages.
Fixed issue in the Scheduler where failure to load one task would prevent others from loading.
Fixed issue where an XmlException could occur when attempting to load Favorites.
Fixed issue where an OdbcException could occur when the Caption Editor attempted to load a non-SQL Universal data source.
Fixed issue in the Dynamics NAV Data Source Settings where the Language Module Folder setting may not update correctly.
Fixed issue where an InvalidCastException would be thrown when performing a drilldown on an NL(Table) function in 64-bit Excel.
Fixed issue where the NL(Table) function could shift column values into incorrect columns when no fields are specified.
Fixed issue where NL(Table) shifted column headers but not values when a blank field is specified.
Fixed issue where an exception during Drilldown into a Universal data source could crash Excel.
Fixed issue with the NF Optimization feature where absolute row references to the NL function were treated as relative references.
Fixed issue with the NF Optimization feature where the 'SQL=' prefix was case-sensitive.
Fixed issue in the Jet GP Update utility where failure to install one Jet View would prevent others from installing.
Fixed issue where multiple User Data sheets could exist in a report for a single report sheet.
Improved User Data error messages associated with duplicate keys.
Jet Essentials 2012 Build 12.0.12150.0, 31.05.2012
Changes since 12.0.12137.0
Fixed issue where Advanced Dimensions in a Dynamics NAV data source were not able to be loaded across multiple companies.
Fixed issue in the Jfx where field caches were not built using the locale specific column separator.
Seite 11 von 15
Fixed issue in the Jfx where the key was not built using the locale specific column separator when performing a lookup of "Key=".
Fixed issue where CalcFields that returned an Excel Range did not work correctly.
Jet Essentials 2011 Build 11.1.12053.0, 27.02.2012
Changes since 11.1.12041.0
Improved overall performance of Database Caption Editor.
Improved performance when using NF Function Optimization feature in certain situations.
Added SMTP timeout to the Jet Application Settings.
Fixed issue where Serenic Navigator User Access Rules were not applied correctly when they differed by company.
Fixed issue in Autopilot/Scheduler where email addresses with top-level domains of more than 4 characters were not recognized.
Fixed issue where binary fields were being included in Grid Drilldown, which resulted in an exception in Oracle data sources.
Fixed issue where shadow sheets were being created for NF Functions regardless of whether the NF Function Optimization feature was enabled.
Fixed issue with NF Function Optimization feature which causes the NF Field argument to be case-sensitive when used with the SQL= feature.
Fixed issue where Jet functions below and to the right of a pivot table were not restored correctly when entering Design Mode.
Fixed issue where a CalcFilterField with an invalid formula threw an unexpected exception.
Jet Essentials 2011 Build 11.1.12041.0, 10.02.2012
Changes since 11.1.11356.0
Updated Swedish translation.
Jet Essentials 2011 Build 11.1.11356.0, 22.12.2011
Changes since 11.1.11334.0
Added Norwegian translation.
Updated Swedish, Spanish, Dutch, Russian, and Italian translations.
Seite 12 von 15
Fixed an issue where the table column reference string built by the Table Builder was not localized for other languages.
Jet Essentials 2011 Build 11.1.11334.0, 30.11.2011
Changes since 11.0.11265.0
Enhanced the Table Builder by adding the ability to save and load templates.
Updated Danish, Polish, Japanese, German, Portuguese, Dutch, French, and Italian translations.
Fixed issue in the Table Builder where column references in a Formula field were inserted with syntax that is incompatible with Excel 2007.
Fixed issue in the Table Builder where column references with a # or ' where not written correctly, resulting in an error.
Fixed issue where Formula fields were not allowed to be written in local syntax.
Fixed issue where the Table Builder always wrote nested links with Link=Table which could cause the link to link to the wrong table.
Fixed issue where the presence of multiple Dynamics NAV companies with different fiscal calendars resulted in problems when attempting to exclude closing dates in a filter.
Fixed issue in Dynamics NAV where if the Dimension table did not exist and a field was invalid, users received the error "TableData 348 does not exist", and fields did not load in the Table
Builder.
Fixed issue where shared tables in NAV were not displayed when Display Empty Tables was disabled.
Fixed issue where Filters= with more than 2 pairs of filters threw an ArgumentOutOfRangeException in NL(Filter).
Fixed issue where using Preserve Page Breaks setting reset the page scaling to 100%.
Fixed issue where SQL= no longer allowed SELECT followed by an open parenthesis "(".
Fixed issue with Link= where validating link types down nested link chains did not work when multiple links existed.
Fixed issue where setting the short date format of the OS to M/d/yy caused date filters to malfunction for Dynamics NAV data sources.
Fixed issue where opening the progress window would raise an error if another WaitHandle existed with the same ID.
Fixed issue where the Jet Data Warehouse data source incorrectly determined whether tables were postfixed resulting in the inability to load fields or execute queries from certain tables.
Jet Essentials 2011 Build 11.0.11265.0, 27.09.2011
Changes since 11.0.11242.0
Updated Dutch, French, Spanish, and Polish product translations.
Improved the NL(Table) function to automatically add a SUM formula in the total row for all numeric columns.
Seite 13 von 15
Fixed issue in the Table Builder where the OK button would be disabled when it should not be.
Fixed issue in the Table Builder where typing @@ in the Formula box of a Formula field would cause a NullReferenceException.
Fixed issue in the Table Builder where clicking a field in the Report Preview while typing in the Formula box of a Formula field could cause a NullReferenceException.
Fixed issue in French translation that would cause a FormatException when specifying an Analysis View in the Dynamics NAV GL function.
Fixed issue in the Jfx where a value lookup could cause an ArgumentException.
Jet Essentials 2010 R2 Build 10.5.11235.0, 23.08.2011
Changes since 10.5.11194.0
Minor updates to Danish translation.
Fixed issue where the "Enable NF Function Optimization" option could cause NF functions to retrieve incorrect values when using the Native server option for Dynamics NAV.
Fixed issue where the "Enable NF Function Optimization" option could cause an NF function with FlowFilters to evaluate to a different value after Drilldown.
Fixed issue where using Grid Drilldown on a function that specified the non-default company displayed drilldown data for the default company.
Fixed issue where boolean values were written to the worksheet as strings from the Report Options window.
Fixed issue where boolean values always displayed in English in the Report Options window.
Added a "Request Timeout" option when using NP(CodeUnit) with the Web Service option of a Dynamics NAV data source.
Jet Essentials 2010 Build 10.1.11048.0, 18.02.2011
Changes since 10.1.11040.0
Fixed issue where numeric fields in Universal/Great Plains data sources could be rounded when being retrieved as part of a field cache.
Jet Essentials 2009 Build 9.2.10167.0, 18.06.2010
Changes since 9.2.10131.0
Fixed issue where Excel 2010 could crash when running a report in a non-English locale.
Seite 14 von 15
Fixed issue where a Dynamics NAV data source would run out-of-process using JetFrontServer.exe in cases where it was not absolutely necessary, affecting performance.
Fixed issue where Jfx would not display arguments correctly with 'What' of "CatName" or "Name" when using the Dynamics GP GL function.
Fixed issue where the Dynamics GP GL function did not support the category number being placed in the 'Account' argument.
Fixed the Dynamics GP GL function so that a 'What' argument of "Accounts", "Categories", or "SegmentX" with a 'Where' argument of blank or "Cell" returns the first item in the requested list.
Fixed broken links in Dutch help file.
Seite 15 von 15
© Copyright 2024 ExpyDoc
