Solution 7 - Release Notes ========================== v 4.8.6913 - 05 December 2018 Fixed: #VALUE when using non UK format in a date parameter. NetSuite Version ---------------- Fixed: #VALUE when using a Fiscal Year or Quarter in a Period parameter. Fixed: Hyperlinks in Transaction Detail DrillDown not working for all Transaction Types. Fixed: Uploading a budget with a 'Non-inventory Item for Sale' Item throws 'Item Record Type Invalid' error. v 4.8.6906 - 28 November 2018 Updated: Ribbon icons of Column / Row Lists. Updated: General bug fixes. NetSuite Version ---------------- Fixed: Account, Class, Department and Location parameters in Transactions - Aged Pivot. v 4.8.6892 - 14 November 2018 Updated: General bug fixes. v 4.8.6878 - 31 October 2018 Fixed: Automation settings not saving. Updated: General bug fixes. v 4.8.6871 - 24 October 2018 Fixed: Formulas not filling down to match adjacent lists during automation. Fixed: Automation not finishing after selecting 'Leave Formulas' in options. v 4.8.6864 - 17 October 2018 Updated: General bug fixes. v 4.8.6850 - 03 October 2018 Fixed: Lists not always updating on cell value change when their refresh mode had been set to automatic. Fixed: Extra blanks inserted at the beginning of lists on update. Updated: General bug fixes. v 4.8.6843 - 26 September 2018 Fixed: Pivot table formula columns being formatted as dates when there are errors in the results. Fixed: Parameter Lookup doesn't always load for functions with lots of parameters. Fixed: Parameter Lookup not pre-selecting multiple values that have been previously selected. Updated: General bug fixes. v 4.8.6822 - 05 September 2018 Fixed: NullReferenceException on cell change when a lists refresh mode has been changed to manual. Dream Version ------------- Fixed: Refresh Workbook incorrectly returns zero when mixing case of parameters. v 4.8.6815 - 29 August 2018 Fixed: HResult error when unlocking workbook. Updated: General bug fixes. v 4.8.6801 - 15 August 2018 Fixed: Filling formulas not working when updating horizontal lists. Updated: General bug fixes. v 4.8.6794 - 08 August 2018 Fixed: Subtotals not being preserved when an item is added or deleted from a list. Updated: General bug fixes. NetSuite Version ---------------- Fixed: Manual budget records may be overwritten if using custom segments on existing records. v 4.8.6787 - 01 August 2018 Updated: General bug fixes. NetSuite Version ---------------- Fixed: Empty Amount column on Transaction Detail drill down when custom Amount column added to Transaction. Fixed: 'USER_ERROR (1290) - Inconsistent values...' when uploading budgets to NetSuite. v 4.8.6775 - 20 July 2018 Fixed: Incorrect list separator when selecting multiple values from a lookup using the Swedish version of Excel. Added: Support for international list seperators. Updated: General bug fixes. NetSuite Version ---------------- Fixed: Error when using lookup button on Class / Department / Location. v 4.8.6766 - 11 July 2018 Fixed: Object reference error on refreshing workbook when zero suppression range outside used range. Fixed: NSGLBAL returns 0 instead of #VALUE! when parameter evaluation fails. Updated: General bug fixes. Dream Version ------------- Fixed: 'Invalid object name' error when Inserting List. v 4.8.6752 - 27 June 2018 Fixed: Add-in manager's force close dialog will close all user's excel processes when ran on a Terminal server. Fixed: Switching window whilst editing PivotTable causes error. Updated: General bug fixes. v 4.8.6745 - 20 June 2018 Fixed: Zero Suppression not applied when triggered from cell changes. Fixed: Default return field and filter field values for lookup functions. Fixed: Validation on activation for files with mixed case file extensions. Updated: General bug fixes. v 4.8.6738 - 13 June 2018 Fixed: Error on List Refresh - 'An item with the same key...'. Fixed: Error on Unlocking - 'Value cannot be null'. Fixed: Error on Locking - 'Out of present range'. NetSuite Version ---------------- Fixed: NSGLABAL incorrect multi-book balances - NetSuite Defect 467777: Consolidated exchange rates. v 4.8.6731 - 06 June 2018 Fixed: Error on Activation - 'An item with the same key...'. NetSuite Version ---------------- Fixed: NSGLTBAL drill-down doesn't match function value when passing multiple values (array of values). v 4.8.6724 - 30 May 2018 Fixed: HRESULT error refreshing PivotTable when using automation. v 4.8.6719 - 25 May 2018 Fixed: Drill Down menu not showing any items in 64-bit version. Updated: General bug fixes. NetSuite Version ---------------- Fixed: NSGLABAL.BETA by Customer returns 0 for '- None -'. v 4.8.6710 - 16 May 2018 Updated: General bug fixes. v 4.8.6708 - 14 May 2018 NetSuite Version ---------------- Fixed: TLS Handshake Failure on Activation. v 4.8.6697 - 03 May 2018 Added: Support for custom formula columns in PivotTables. Added: Improved support for High DPI Scaling. Updated: Performance improvements to Automation Engine. Updated: General bug fixes. NetSuite Version ---------------- Fixed: NSGLxBUD functions not correctly honoring Global budget flag on Budget Category Added: Budget Upload - Support for uploading by Project and Item. Added: Budget Upload - Support for up to 24 periods. Added: BETA - Age of Debt PivotTable. Added: BETA - Non-posting PivotTable (Sales Orders, Purchase Orders). Added: BETA functions included by default. Added: Performance improvements to BAL functions (Balance Sheet). Fixed: Budget Upload - Uploading to wrong period when an adjustment period is defined in the same financial year. v 4.7.6710 - 16 May 2018 Updated: General bug fixes. v 4.7.6708 - 14 May 2018 NetSuite Version ---------------- Fixed: TLS Handshake Failure on Activation. v 4.7.6694 - 30 April 2018 Fixed: Lock/unlock of filtered cells. Updated: General bug fixes. v 4.7.6689 - 25 April 2018 Fixed: Lock/unlock of hidden cells. Updated: General bug fixes. v 4.7.6684 - 20 April 2018 Updated: General bug fixes. v 4.7.6656 - 23 March 2018 Fixed: Double clicking activate causes error. Fixed: Switching worksheets can lock up Excel. Fixed: Lists refreshing (which can be slow) when updating list options. Lists must now be Refreshed separately. Fixed: List doesn't refresh correctly when referencing a range of cells and where the first cell in the range is blank. Fixed: Functions failing when account names contain apostrophes. Fixed: Timeouts when using multiple connections. Updated: General bug fixes. v 4.7.6626 - 21 February 2018 Fixed: Long automation text not showing correctly in Email tab when running Automation Fixed: Lists not refreshing correctly when referencing ranges. Fails to correctly detect dependant cells. Updated: General bug fixes. v 4.7.6613 - 8 February 2018 Fixed: Embedded Solution 7 forumlas in a table very slow / hangs Excel. Fixed: Overflow exception thrown when using two wild cards in a parameter for a list. Updated: General bug fixes. NetSuite Version ---------------- Fixed: Upload budgets where the total is 0. Fixed: Drill Compare failing on NSGLABAL. Added: Drill Compare to non-OneWorld. v 4.7.6586 - 12 January 2018 Updated: General bug fixes. v 4.7.6564 - 21 December 2017 Fixed: Solution 7 tab not appearing in Excel after installation. Updated: General bug fixes. v 4.7.6558 - 15 December 2017 Fixed: OutOfMemory Exception when locking very large worksheets. Fixed: 'Save as Sheets' fails during automation. Fixed: Lookup functions return empty string if no values returned, causing #VALUE in host function. Updated: General bug fixes. v 4.6.6411 - 21 July 2017 Updated: General bug fixes. v 4.6.6341 - 12 May 2017 Fixed: Allow whitespaces in the account number. Fixed: Formatting when refreshing a list. Updated: General bug fixes. v 4.6.6319 - 20 April 2017 Added: Count of locked/ unlocked cells. Fixed: Trim white spaces from parameters in the configuration settings. Fixed: Pop-up list updating/ selecting item in list so alignment is not reset. Fixed: Drilldown parameters to show in sub-menu. Fixed: UI issues in the configuration window. Updated: Ribbon labels. Updated: Diagnostics window. Updated: General bug fixes. NetSuite Version ---------------- Added: Support for statistical accounts in Transaction Detail Pivot. Fixed: Default Proxy for NetSuite. Removed: NetSuite v6 provider settings. v 4.6.6289 - 21 March 2017 Added: Max record count as a configuration option. Added: Clear cache option on automation. Updated: General bug fixes. NetSuite Version ---------------- Updated: NSGLxBAL / NSGLxBUD speed improvements on large balance sheet calculations v 4.6.6278 Fixed: NetSuite certificate not found when installed on a 32 bit operating system. Updated: Efficiency improvements. Updated: General bug fixes. NetSuite Version ---------------- Fixed: NSGLABAL.DATE.BETA function. Added: Drill Downs for NSGLABAL.DATE.BETA function. v 4.6.6243 Added: SmartView will automatically detect proxy server settings where required and possible (for webservices and https connections) Added: New column aggregate "Summary", like Group but automatically collapses rows. v 4.6.6198 Fixed: Filter columns for lists and pivots not working v 4.6.6194 Fixed: Lookup dialog crashing while filtering, and being unable to exit lookup dialog until it has loaded all values Fixed: Function drill down treating empty cells differently from empty values Fixed: Multiple issues for function parameters that can take array of values (not updating or not being passed to server correctly) Fixed: Drill compare (for NetSuite BETA Functions) Fixed: Error inserting a pivot table user switches to a different workbook while it is inserting v 4.6.6164 Fixed: Better error handling for automation, if it does fail the temporary workbook it creates is closed Fixed: Issues with formula columns Removed premature validation from automation, added "apply" button to save settings without running automation PSF Version ----------- Fixes for PSF version 6 v 4.6.6100 Fixed: chart labels not working in 64 bit Excel Fixed: In automation, email settings are validated before starting (where possible) rather than failing at the end of the process Netsuite Version ---------------- Fixed: License tracking bundle in NetSuite (was showing logged out users as "crashed") Transaction / Budget Drill-down columns changed to consistent order of Class / Department /Location v 4.6.6096 Fixed: Editing a list from the List & Pivot manager causes Excel not to close or to crash on close Fixed: Resized Pivot Table columns being set back to original size on refresh Fixed: Large spreadsheets slow to recalculate when some function parameters are invalid Fixed: Lookup function that returns arrays failing when being refreshed on the same spreadsheet as lists Fixed: Non-realtime functions not running (did not affect NetSuite users) Numerous stability improvements Netsuite Version ---------------- Fixed: NSXRATES not pulling rates for non-calendar fiscal years v 4.6.6073 Fixed: Excel not closing cleanly after SmartView fails license server check Fixed: Renamed Pivot Table fields revert to their original name on refresh Netsuite Version ---------------- Improved balance reporting performance v 4.6.6061 Fixed: Formula columns were not working unless they referenced other columns v 4.6.6011 Fixed: DrillDown fails when function references cell range (sheet reference wrapped in quotes) Fixed: Excel Crashing on close after using list and table manager Fixed: Excel Crashing on close after inserting a pivot Fixed: Excel crashing when refreshing sheet or list or suppressing range (serious TimeOut Exception) Fixed: Automation not dropping formulas on all sheets Fixed: "VeryHidden" sheets breaking automation Changed: Hard-coded limit of 65536 rows returned for lists and drilldowns is now a setting in Insight.Windows.Xll.Config Added: Add-In manager can detect if Excel is running and gives the option to end process (in case Excel is hanging) Added: User settings are now saved in roaming profile (does not affect users that do not use roaming profiles) NetSuite Version ---------------- Fixed: Standard NSGLABAL.BETA detail drill down v 4.6.5977 Added: Efficency improvements NetSuite Version ---------------- Fixed: NSGLABAL.BETA - Applies Currency Conversion to Statistical Accounts v 4.6.5976 Fixed: Lock/unlock not working in all cases Fixed: Send Email automation not working v 4.6.5963 Fixed: Automation not remembering settings (email and drop/lock/keep formulas) - settings are now saved with spreadsheet v 4.6.5960 Fixed: Lock/unlock not working in all cases v 4.6.5956 Fixed: Lock/unlock formulas not working for ranges of cells Fixed: Lock/unlock not working in all cases Fixed: Drilldown not working when there are multiple SmartView functions in a cell Added: Drop Formulas option to automation (had previously been removed) Fixed: Choose Columns screen blank if loaded quickly after activating SmartView Fixed: Choosing an invalid connection number shows "NullReferenceException" error Fixed: Changing the name of a formula column in a detail pivot causes formatting problems NetSuite Version ---------------- Changed: NSGLABAL.BETA Signature Added: NSGLABUD.BETA for standard (non-OneWorld) adapter Added: NSGLABAL.BETA - Applies Currency Conversion to Statistical Accounts v 4.6.5954 Fixed: Lock formulas removing lists Fixed: Improved updating of formulas adjacent to lists Fixed: Budget Upload appears to hang if subsidiary is invalid Fixed: SmartView Lookup button disparaging from Excel Function Arguments v 4.6.5942 Fixed: Budget Upload List not working and no items being uploaded Fixed: Budget Upload crashing on certain spreadsheets Fixed: Budget Upload giving "Value cannot be more than total" error on certain spreadsheets Fixed: Excel Crashing on close or process hanging (multiple causes) Fixed: Formula columns not supporting dates Fixed: Setting adapter paths to be relative NetSuite Version ---------------- Added: NSGLABUD.BETA & Consolidated NSGLABAL.BETA Fixed: Issue with Period Lookups when there are multiple fiscal calendars v 4.6.5927 Fixed: Automation null reference exception when any of the sheets to automate don't contain any formulas Fixed: Automation not working on computers with no accessible printer Fixed: Automation very slow when not dropping formulas Fixed: Automation very slow when suppressing ranges Fixed: Automation - When #VALUE errors occur, error number displayed instead Added: Budget Upload Improvements Fixed: Budget names not hidden Fixed: Netsuite Budget Upload - Error values being uploaded as numbers Added: NetSuite Webservices Timeout so that is can be changed independantly of main timeout Fixed: BudgetUpload - Selecting columns containing merged cells causing Excel to Lock up Added: Improvements to Configuration screens Added: Ability to allow adapter paths to be relative or absolute. Fixed: Incorrect range when selecting merged cells in List Arguments Fixed: Error refreshing pivot tables when multiple sheets selected Fixed: Random Freezing/Lockup bug(s) Fixed: Excel weirdness when inserting a drill down or automation sheet (any programmatic insertion of a sheet) Added: Support for Office 2016 Fixed: Excel Argument Dialog - Lookup button mis-aligned Fixed: Drop formulas not working when sheet contains hidden cells Fixed: Problems caused by cartesians in lists with virtual tables Fixed: When inserting and selecting text from a popup, always force the number format back to text and single quote the value Fixed: Adding lots of array items in list argument misses values on refresh Fixed: Inserting a row list the first column is always narrower Added: Formula column in Choose Columns Fixed: Horizontal Lists not filling down formulas correctly Added: Pop-up lists to be inserted into multiple cells at once Fixed: Error inserting list of Periods into a cell containing a period string (eg 'Jan 2015) Added: Query Snippets Added: Ability to undrop previously dropped formulas Fixed: Installer is not enabling the smart view add in correctly at install Added: Improve memory management and resolve memory problems Added: Zero Suppression - Supports for multiple ranges; removing the need for "Avoid cells" Fixed: Suppression gives error if no supression range defined NetSuite Version ---------------- Fixed: Drilldown issue on NSGLTBAL & NSGLTBUD Added: Subsidiary to BAL / BUD drilldown Added: "Build Model" (Developer Tools)tool to assist with customisations v 4.5.5708 NetSuite Version ---------------- Added support for multiple fiscal calendars Automation Fixes ---------------- Fixed automation not updating lists correctly if they are based on cells that are not the cells to automate v 4.5.5674 Increased limit of number of function parameters to 20 Fixed focus issue with lookup dialog from function wizard Automation now supports saving output workbooks as pdfs Fixed issue with automation not copying macros to output workbooks and defaulting output workbooks to .xlsx even when the source is .xlsm Fixed issue with drop formulas converting values to numbers and losing leading zeros (also applies to automation) v 4.5.5570 Fixed bug where opening large spreadsheets with data validation caused Excel to crash v 4.6.5564 Changing the configuration file in the configuration dialog gives options to change for current user only or for all users. Fixed memory leaks. Fixed display of lookup button in function dialog on non standard resolutions. v 4.5.5561 PSF Version ----------- Amended drill-down list to use DAF Description instead of D_DETAIL Description where available Amended drill-down to include document "Attachment" v 4.5.5555 Added unexpected error handler and error reporting Improved memory management Fixed error loading SmartView when using custom date formats for Windows date formats Automation Fixes ---------------- Fixed bug where two email addresses which differ only by case were not detected as being the same Fixed bug where email addresses where the domain (after the @) was not considered valid if it was upper case Fixed bug where sending a file of the same name to two different email addresses failed with a "file not found" error message Fixed list and pivot table updating v 4.5.5527 Fixed activation when bundle not installed Automation Changes ------------------ Speed improvements "Drop Formulas" option now also drops SmartView lists v 4.5.5512 Changed "fill down formulas" to apply after all lists are updated, in case the formula(s) adjacent to one list rely on another Automation Changes ------------------ Added option to update lists and pivot tables when performing automation Fixed bug where lists or formulas referencing sheets in the workbook not included in the result were not being updated correctly Some speed improvements V 4.6.5456 Fixed bug where SmartView formulas were being left behind after a list was removed Preliminary support for multiple languages NetSuite Version ---------------- Changed NSGLTRAN* (Beta) function to add separate parameters for Customer, Vendor, Project, Item that were previously in Entity. Added Projects List in Standard edition (already existed in OneWorld edition). Added Vendors List. Added Items List. * Please note that Beta functions may be altered or removed without prior notice. If you find these functions useful then let us know so that we can fully incorporate them. V 4.5.? Fix automation so that formulas and lists in the sheets to be automated can now reference other sheets without issue. Dream Version ------------- Fix double-drilldown issue when drilling down from DRMInBAL functions. V 4.5.5458 NetSuite Version ---------------- Added "Hierarchy Level" to Data Model (column selector) for the following: - Accounting Periods; Accounts; Classes; Customers; Departments; Items; Locations; Subsidiaries; PSF Version ----------- Added DocType and DocNo to Data Model (column selector) for Documents V 4.5.5429 Allow grouping and aggregation for detail pivots Automation fixes/improvment - conditional formatting is now supported Rename Pivot Table / Tabular Pivot on Ribbon to Summary / Detail Added Detail Pivot Grouping NetSuite Version ---------------- Improve System Configuration settings for use with SuiteConnect ODBC v7 Drivers V 4.4.5395 PSF Version ----------- Budget transactions filtered out of 'Documnet Details' list (Pivot Tables) In 'Choose Columns', additional 'Document Details (Extended)' section added to 'More info...' 'Remove Pivot Table...' with 'Clear cells' unchecked converts Pivot table to plain cells V 4.4.5385 NetSuite Budget Upload ----------- Fixed uploading to NetSuite accounts without mulitple budgets enabled V 4.4.5381 Fixed not allowing DataModel extensions PSF Version ----------- Added Create DAF SP to PSF6 Extensions Added DataType="Number" to D_DETAILS value fields V 4.4.5374 Changed file permission checks on automation Removed VSTO dependancy from installer V 4.4.5343 Dream Version ------------- Added 64bit Excel Support V 4.4.5340 PSF Version ----------- Added Budget parameter to PSFx3BUD V 4.4.5332 NetSuite Budget Upload ---------------------- Fixed uploading to NetSuite accounts without mulitple budgets enabled V 4.4.5311 Fixed array parameter bugs NetSuite Version ---------------- Enable missing array parameters for List of Accounts V 4.4.5304 NetSuite Version ---------------- Added Customer List (Standard) Added Project List (Standard) NetSuite Budget Upload ---------------------- Added support for uploading budgets by Customer Added support for multiple column headers Fixed issues with selecting merged cells UI improvements V 4.4.5296 Fixed incorrect dropping of formulas in automation V 4.4.5290 Fixed unhandled exception in automation caused by copying worksheets between workbooks NetSuite Budget Upload ---------------------- Added support for multiple row headers Added support for non-contiguous ranges Fixed stability issues from BETA V 4.4.5234 (Beta) Native 64-bit Excel support Multi-function drill down Automation bug fixes NetSuite Version ---------------- Added Budget Import (BETA) Fixed Budget Import preventing import to local budget categories NSGLxBAL improved calculation speed NSGLxTRAN improved calculation speed V 4.3 Updating lists bug fixes Automation bug fixes Zero Suppression bug fixes Office 365 / Click-to-run compatibility fixes Automation copy sheet per automation row / single PSF Version ----------- Added PSFx1BAL, PSFx2BAL, PSFx3BAL functions Deprecated foreign currency functions Shifted calculations from BALANCE to TRANSACTION tables V 4.2 Added asynchronous function calculation Move long running processes to background threads Bug fixes resulting from background threading