Functions:

Drilldown:

Writeback:

Calculation:

Drilldown:

Drilldown:

Calculation:

Drilldown:

Writeback:

Writeback:

Refresh:

Writeback:

New functions:

UX/UI:

GL writeback:

Generic writeback:

Refresh:

UX/UI:

Drilldown:

Generic writeback:

Refresh:

Drilldown:

UX:

New ERPs:

Writeback:

Writeback:

Refresh:

Formulas:

UX:

Copy without formulas:

General:

Writeback:

Connection:

Refresh:

Functions:

Refresh:

Functions:

Velixo range expressions:

Drilldown:

Copy without formulas:

Writeback:

Drilldown:

Refresh:

"Insert chart of accounts" ribbon button has been added, applicable to all supported ERP systems. (#2472)

A more familiar & convenient flow for removing formulas. Instead of removing formulas from the current workbook, Velixo NX will create a copy of the current workbook and then proceed to remove formulas there. (#2659)

Acumatica:

Sage Intacct:

Removing formulas will now also remove any hidden worksheets used by Velixo. (#2727)

Acumatica:

Sage Intacct:

Mitigated a potential hanging problem during writeback on Excel Desktop for Windows. (#2738, #2767)

Formula removal:

Acumatica:

Sage Intacct:

Velixo NX adds support for another option from Velixo "Classic": "Return zero value when an identifier is not found".

Acumatica:

Sage Intacct:

On Excel Desktop for Windows, Velixo NX's drill-down functionality will now be disabled in case Velixo "Classic" is already installed. (#2589)

Acumatica:

Sage Intacct:

Sometimes the connection list would misleadingly render with "401" validation errors upon start-up, even though the connections/credentials would de facto be valid. (#2591)

French language translations were brought in line with Velixo "Classic". (#2577)

Acumatica:

Sage Intacct:

Velixo NX ribbon is now enabled on Windows. (#2478, #2479)

We added UI hints for users who define a connection for the first time. They will see a message bar in the connection editor linking to a guide on building their first Velixo report. (#2505)

Renamed "URI" to "URL" on the user interface as this term seems is more common with the end users. (#2522)

Sage Intacct:

Budget writeback failed when writeback formulas on the same worksheet contained data for different ERP tenants. (#2503)

Writeback status did not change back to Pending upon refresh. (#2506)

Creating a new drilldown worksheet could fail if there was already a worksheet named "drilldown" (lowercase). (#2509).

Fixed progress indicator alignment problem on the Operations tab in Safari / Excel for Mac. (#2529)

On Excel for Windows Desktop, NX's mechanism of detecting whether Velixo "Classic" is installed could add redundant hidden sheets to the file on start-up. (#2532)

New Ribbon UI for Velixo NX (#2210), which looks similar to the one we recently introduced on Velixo "Classic" for Excel Desktop on Windows:

Acumatica-like systems: added support for uploading formula-based budget writeback worksheets (WRITEBACKBUDGET).

Sage Intacct: new supporting function SI.OBJECTDEFINITION, which returns the object structure to consult when building queries for functions such as SI.QUERY (#2287)

Supported the Blank rows handling option for Hide Zero Rows. (#2296)

Velixo NX will now detect if Velixo "Classic" for Excel Desktop on Windows is already installed on the computer, preventing duplication. (#2476).

Improved the drill-down speed and reduced the number of data requests on all systems, through more aggressive caching of function computation results. (#2426)

Better Velixo back-end database resiliency and recoverability. (#2411)

Drill-down will fail in case the user modifies the workbook while the process is running. (#2433)

Sage Intacct:

Acumatica-like systems:

Drill-down to a separate workbook was not working in some scenarios. (#2457)

Acumatica-like systems:

Remove formulas:

Sage Intacct: new generic function for retrieving lists of arbitrary entities in a tabular format - SI.QUERY (#2301)

Further radical improvements in RAM usage and refresh performance on both Excel Online and Excel Desktop for Mac - by up to 70% on benchmark reports 🚀. (#2320, #2327, #2333, #2335)

Fixed a "Something went wrong" message box displayed in Excel Online for some users on start-up. (#2321)

Support for drill-down in Sage Intacct. (#2022)

Velixo NX adds support for Hide Zero Rows / Columns and Auto Hide Zero Rows / Columns! (#2142, #2166)

Added support for GL writeback for Acumatica-like connections. (#2151)

New function for Acumatica: EXPANDPROJECTHISTORY

Added support for Acumatica 2022R2. (#2130)

The refresh performance on both Excel Online and Excel Desktop for Mac has improved by up to 50% 🚀. (#2188, #2227)

Velixo NX also uses up to 35% less memory. (#2188, #2225)

Improved Sage Intacct refresh performance when using account group codes. (#1972)

You can now drill down into the spill ranges of balance functions in Acumatica and Sage Intacct. (#2081)

Improved performance of "Remove formulas" functionality. (#2098)

Velixo will now complain if the start date is later than the end date in Sage Intacct functions. (#2192)

It will not be possible to set up an empty smart refresh field in Generic Inquiry options anymore. (#2190)

"All Velixo functions calculated" message could be shown instead of "Drilldown complete" after a successful drill-down. (#2076)

Error message is now shown when non-existent revision is specified for project forecast functions in Acumatica. (#2091)

Remember Me credentials were sometimes lost after the workbook was not used for a certain period of time. (#2144)

Velixo range expressions were unnecessarily case-sensitive with wildcards (e.g. ABARTEN??). (#2145)

Velixo NX could freeze for a long time when editing Generic Inquiry options. (#2142)

Error 401 occurred during report refresh in some circumstances. (#2160, #2171, #2176)

🔥 Acumatica GL balances could return incorrect values when dates were inside period boundaries. (#2162, #2183)

GL Budget writeback for Acumatica ☁️.

Saved connection credentials could be lost after restarting Excel. (#2101, #2132)

Fixed a potential crash on large workbooks using dynamic-aware Velixo formulas. (#2125)

Drill-down could end prematurely on large workbooks and not display the full results. (#2105)

Better consistency of GIFILTER results with Velixo Classic. (#2110)

Added an explicit error message for users trying to launch the add-in on unsupported older versions of Microsoft Office. (#2123)

Previously, when one of the results in a Velixo dynamic-aware function like ACCOUNTNAME(..., A1#) resulted in a calculation error, the whole formula failed and returned a single error cell. Now only the erroneous cells in the spill range will contain the error, and the other cells will contain a normal value. (#2112)

Dynamic-aware functions have reached Velixo NX!

Sage Intacct: new function SI.EXPANDACCOUNTRANGE, which allows you to use a Velixo range expression to return multiple accounts as a spill range (#1768).

Sage Intacct: all balance functions now support filtering balances by dimensions and user-defined dimensions! (#1751)

Sage Intacct: all balance functions now support Velixo range expressions for account codes and locations. The resulting value will be a sum of balances for all accounts and/or locations that match the specified Velixo range expression (#1794) (#1957).

ERP data requests on the Analysis tab will now display a circular progress bar instead of just a spinner: this way, you can better understand the data loading progress, which is useful for large reports.

"Drilldown sheet destination" on the Options tab allows you to drill-down into a new workbook instead of the current one.

Sage Intacct: API requests are now strictly queued as per ERP requirements to decrease the possibility of rate limiting (#1788).

Sage Intacct: we have implemented paging support for data requests: this ensures all data from the ERP gets processed even when the organisation has a very large charts of accounts (#1790).

GIFILTER() now supports null values and will not treat them as text anymore (#1836).

The calculation architecture of the product has been greatly simplified, resulting in fewer bugs and greater performance.

Functions could be infinitely stuck in #BUSY sometimes while the Analysis tab showed no ERP data requests. We addressed one of the significant potential root causes for the problem - please report to Velixo if you still observe the issue!

A "401 Unauthorized" error could be displayed for workbooks created in Velixo Classic and then opened in Velixo NX.

Drill-down for Sage Intacct is coming soon. 😎

Sage Intacct: in balance functions, support for reporting period names was dropped. Please use dates instead.

Sage Intacct: AccountGroup and Account arguments are now separate.

Added French language support (#1722).

New Intacct functions:

All GL balance Intacct functions now support specifying an account group instead of the account code, which can be useful for consolidated reporting purposes (#1729)

A deleted connection could reappear in the file on subsequent opening (#1758).

❗ Breaking change: SI.OPENINGBALANCE and SI.CLOSINGBALANCE now require either a pair of dates or a reporting period name.

Greatly improved the performance of Sage Intacct balance functions (#1676, #1682).

In case Microsoft Excel decides to automatically start recalculation when you open the file, this will be displayed as a refresh operation in the add-in.

During connection validation, Velixo NX will now detect not only missing required Generic Inquiries, but also those where someone has accidentally deleted a column (#1690)

🔥 Due to a bug in Excel Desktop for Mac, the Excel window could crash when you opened two workbooks with connections that did not have stored credentials (#1711).

Drill-down sometimes failed to identify Acumatica data in aggregated balances (#1662)

VELIXOVERSION did not have a help link associated with it (#1675)

In case some Velixo Generic Inquiries were missing in the ERP tenant, Velixo NX did not detect that fact for a few of the inquiries (#1687)

After a failed ERP connection, redundant error indications could be displayed in the connection list (#1693)

The support chat widget could overlap with user controls in the Generic Inquiry key fields editor (#1705)

Added a possibility to contact Velixo support right from the Velixo NX task pane. The help is now just one click away 💪 (#1639)

When creating a connection, you can select from multiple ERP types to easily distinguish the products in consolidation scenarios:

The standard Acumatica Velixo functions are supported for those connection types (#1651).

Raw experimental support added for Sage Intacct account names and balances (#1566).

Drill-down functionality support brought to Project module functions (#1575).

Greatly improved the drill-down performance for complex computations (#1249).

Drill-down worksheet formatting improved for mixed GL & PM drilldown scenarios (#1581).

Error status messages can now be dismissed by clicking on the red cross icon (#1623).

Error message will be displayed when multiple cells are selected for drill-down (#1628).

Added a check to validate the presence of the revision ID in project forecast functions (#1621).

Under some circumstances, Velixo NX could get stuck in an un-refreshable state when the connections in the file did not have credentials saved (#1670).

The drill-down engine could end drill-down prematurely, excluding some legitimate drill-down rows (#1662).

Drill-down could get stuck on non-Velixo functions like =SUM(100,200) (#1592).

There was an off-by-one error in FINANCIALPERIODSTARTDATE for adjustment periods (#1438).

The wildcard ? character in Velixo range expressions will not match the empty space anymore (#1626).

The Velixo license checks are not sensitive to connection URL casing anymore (#1637).

A connection created in NX might not show up in Velixo Classic (#1647).

Velixo NX now supports all Project module data retrieval functions from Classic!

Velixo NX's back end now has fail-over measures for improved uptime and stability.

Drill-down will now display a status message if it was not able to identify any Acumatica data in the source cells (#1481).

🔥 In reports spanning multiple financial years, for an asset/liability account that did not have any activity in the current financial year, Velixo could:

The cache database was not cleared correctly between version upgrades (#1547).

GI functions were not working in reports which were created in Classic with client-side filtering enabled (#1569).

Due to changes in Excel's calculation logic, removing formulas in large report could lead to them being saved as #CALC (#1571).

Refresh status message was stuck in case there were no Velixo formulas in the workbook (#1567).

After modifying a connection and then quickly deleting it, the connection could sometimes reappear in the list (#1576).

FINANCIALPERIODSTARTDATE: the result for adjustment periods was off by one day (#1438).

Drill-down support for PM entities.

Basic support for additional ERP systems in consolidation scenarios.

New functions from Velixo Classic are available:

When doing a long operation, such as refresh or drill-down, Velixo will display the status of the operation (running, completed, failed) in a special area of the task pane (#1430):

Internally, Velixo NX has unified the cache loaders infrastructure for different types of data (accounts, subaccounts, GIs etc.). It now does the same job with a much smaller amount of code, which means more predictable behaviour and fewer bugs down the line!

Velixo NX will now produce #N/A for technical errors (server unavailable, missing credentials, etc.) and #VALUE for user input errors (such as when "branch XXX was not found in the system") (#1394)

Inside Velixo range expressions, Velixo will now detect invalid unit references and report an error (#1392).

Introduced a default option to the "connect" buttons in the connection editor: by default, clicking Connect or Connect using single sign-on ("key" icon button) will not refresh the workbook, but an option to connect and refresh still exists under a drop-down arrow near the buttons (#1398)

Velixo will now validate if you try to add another connection with the same name as one of the existing ones (#1412).

To prevent unpredictable behaviour, it is now impossible to run several long-running operations at the same time, such as drill-down, repeated refreshes, removing formulas, or deleting drill-down worksheets (#1428)

Velixo NX now experimentally supports older, single-tenant Acumatica instances, which do not support logging in with an explicit tenant name (#1435)

A better error message when FINANCIALPERIOD / FINANCIALPERIODOFFSET results would be in a non-existent financial year (#1432, #1441)

Trailing spaces were present in branch names in ACCOUNTS...WITHHISTORY (#1402)

Smart refresh in GI() was not working when there was an "OR" condition in the user-defined filter (#1410)

GI options header was sometimes visible when no GI options existed for the workbook (#1477)

GIFILTER() function from Velixo Classic is now available! 🎉

New function added: EXPANDCOMPANYRANGE()

Function and argument descriptions are now available for every Velixo function.

Request progress is now indicated real-time in the Active ERP Requests section on the Analysis tab. It displays the amount of data loaded from the ERP.

New button has been added to remove all drill-down worksheets. It is available on the Analysis tab, under the Drilldown drop-down.

ACCOUNTSWITHHISTORY() and ACCOUNTSANDSUBACCOUNTSWITHHISTORY() support two additional arguments:

Performance, responsiveness, and RAM consumption were all significantly improved (#1293, #1296, #1314, #1318, #1319). In particular, drill-down is now 40% faster (#1249).

"Remove formulas" now has a progress indicator (#1223).

Drill-down rows for budget ledgers will now redirect to the correct screen (GL302010).

Asset and Expense account balances were erroneously impacted by the Reverse Balance Sign workbook option (#1327).

When a refresh request to an ERP system failed, the errors were not made explicit - cached data was silently re-used without a warning. Now, the error will make it into the cell (#1231).

Drill-down process got stuck when invoked on an empty cell (#1384).

Velixo NX now uses multi-threaded computations that proceed faster and allow the UI to be more responsive.

Local data caches are now shared between files, per-connection. This will drastically improve initial Smart Refresh speed on new files for those of our users who have very heavy GL history.

New function: FINANCIALPERIODOFFSET(), which allows you to add/subtract a given number of periods from the specified financial period.

GILOOKUP() and GILOOKUPF() functions from Velixo Classic are now available.

Upon editing a connection, the user now has an option to re-connect with or without refreshing the file.

Better handling of empty arguments specified to COLLATE() function (#1079)

Error message is now produced when IncludeUnposted argument is out of the allowed range (#1076)

The expanding section for Generic Inquiry options will not be displayed unless any GI options actually exist for the file (#1204)

Velixo NX will now produce an error message during refresh if the key columns set up in GI options do not uniquely identify each record in the dataset (#1125, #1172).

Smart Refresh is more resilient to cache database failures (#1172)

Asset / Liability account balance calculations for budget ledgers will refrain from using last year's balances when no corresponding budget record exists in the specified financial year (#1122).

It was impossible to use range subtraction operator in EXPAND...RANGE() functions when the value contained a space in Acumatica (#1072)

Removing formulas could fail on very large files due to the processed dataset size (#1200)

Connections imported from Classic were displayed as valid (✔️) in the connection list when no credentials in fact existed for them yet (#1221)

Velixo could not re-use an already computed function result when, during a single refresh or between refreshes, a single function was invoked multiple times with the same arguments (#1215).

EXPAND...RANGE() and BRANCHLIST() did not trim trailing spaces the output (#1114, #1120)

BRANCHLIST() returned an unsorted dataset when Company argument was not specified (#1117)

EXPAND...RANGE() functions did not explicitly sort their output as Velixo Classic does (#1112)

It was possible to set up Smart Refresh for a Generic Inquiry without specifying the last update column name (#1131).

No GI options could be accessed from the UI after removing a connection (#1107).

GI() function failed when invoked for the first time with a filter expression (#1060).

GI() output did not trim string values as it does in Velixo Classic (#1062).

More functions from Velixo Classic are now available:

Generic Inquiry options are now available on the Options tab. You can set up refresh mode, key fields and the smart refresh field.

A value for a different Velixo formula could incorrectly be returned into a cell when two or more Velixo formulas existed on the workbook with the same parameter values (#1057).

Ledger subtraction in ACCOUNT...BALANCE and ACCOUNT...TURNOVER function did not work (#977)

Blank values sometimes were showing up as "0" in GI() result (#1010)

Drill-down could display incorrect ending balances under some circumstances (#1016)

Excel Online with Internet Explorer 11 or Excel for Windows Desktop on older Windows versions:

Removing Velixo formulas did not work properly with formulas returning dynamic array values, such as EXPAND...RANGE (#1037)

Drill-down now additionally groups data by source cell (#1022).

We are excited to announce that the current release brings the basic support for the GI function!

❗ Note It has a number of limitations for now:

More functions from Velixo Classic are also available:

Multiple cold start-up performance improvements and reduced memory footprint (#776, #788).

Better calculation speed when there are multiple functions with identical arguments in the workbook (#765).

It was impossible to click on a support link in connection validation bubbles that appeared when hovering over a connection validation icon (#751, #910).

Fixed incorrect naming of the AsOf function argument in ACCOUNTBEGINNINGBALANCE and ACCOUNTENDINGBALANCE: the erroneous name was AsOfPeriod, however the functions also support date values (#914).

#N/A error when one specified more than one branch in an account balance calculation (#874)

The list of missing inquiries may contain duplicate inquiry names (#912)

Entering incorrect connection credentials once leads to the add-in continuously returning the "unauthorized" error, even if the user enters the correct credentials afterwards. (#810)

Add-in performance was improved in case multiple cells returned a "[...] does not exist" error.

Occasionally, the add-in could take a very long time (over a minute) to start up on large files.

Fixed a potential slow-down due to massive logging of a "connection credentials missing" error when the file contains a lot of Velixo functions and the user has not yet specified the credentials, or cleared the cache.

More functions from Velixo Classic are now available:

Velixo NX now supports parallel loading from multiple ledgers/years at once. If you use consolidated reports across multiple ledgers and financial years, you should see some serious speed-ups!

Performing a drill-down on a formula which includes unposted GL balances, for convenience will now include the post status column for every history record.

Significantly improved the caching performance.

If the necessary Acumatica generic inquiries are missing in the connection tenant, Velixo NX will now list the missing inquiry names.

The From/To Period in drilldown results will now correctly handle cases where the most recent GL activity occurred in an earlier period than the one specified in the formula.

The drill-down worksheet could contain amounts with a wrong balance sign when Account Balance Sign option was set to Reverse.

Drill-down could produce an empty result for a cell which contained an aggregate formula like SUM(), or depends on such a cell, directly or indirectly.

Drill-down could include GL history records from unrelated cells.

The refresh performance was significantly improved (up to 33%) on files containing a lot of Excel functions (mitigated a slow-down caused by unnecessarily frequent re-renders of the Analysis tab).

The reference list of active Velixo functions on the Analysis tab could be rendered incorrectly (missing or duplicate function entries).

Smart Refresh could count GL transactions multiple times, producing an incorrect balance. The bug affected Velixo NX on the following platforms:

Smart Refresh did not request the new / updated data from Acumatica unless the user reloaded the page.

You can now right-click directly on a cell and select the Drilldown option from the context menu.

The add-in could not be used on an old, pre-Chromium version of Microsoft Edge (Legacy) v. 44.

Financial reporting by date could return an incorrect balance or turnover when there were transactions posted to a date outside of the financial period boundaries (e.g. a transaction with a date of December 25, 2020 posted to a 11-2020 period corresponding to November).

Some users could not connect to Acumatica because of a missing inquiry.

Provisional reporting of unposted account balances could return an incorrect balance or turnover when no posted balance existed for a given ledger / year combination.

On large General Ledger datasets (>50000 GLHistory rows for a given combination of ledger and financial year), the add-in could be force-restarted by Microsoft Excel due to a long processing operation.

General Ledger balances drilldown has arrived - it works just the same as in Velixo Classic!

Single sign-on (SSO) with Acumatica is now supported!

Removing Velixo formulas. You may now remove any Velixo formulas, or even all formulas completely, from the workbook you're working on.

Forgetting all connection credentials under Options -> Security drop-down.

Information about currently calculating Velixo functions and active ERP requests is now available under the Analysis tab.

Provisional GL reporting for Acumatica was ported from Velixo Classic.

Connection list validation cues.

The usernames for your connections will now be encrypted just like the passwords were previously, for additional security.

Connection editor dialog will now display more informative error messages about why the connection could not be established.

Better Velixo session management: unless you use the add-in very rarely, you should stop seeing the "your session has expired, please log in again" error messages.

On rare occasions, the connections and workbook options saved in the file could disappear.

Until you reloaded the page, the Refresh button could sometimes use the cached function results instead of actually performing a refresh.

Connections and workbook options you added to new files created with Velixo NX would not show up in Velixo Classic.

Connections from files edited in old Velixo Classic versions (version 4 and lower) would not show up in Velixo NX.

Velixo NX taskpane would show unnecessarily when Refresh data when opening the file option was checked.

On medium-to-large files, the desktop version of Microsoft Excel for Windows may sometimes restart the add-in due to unresponsiveness during a refresh.

Porting of the Generic Inquiry functions and GI Options from Velixo Classic.

Improving the performance and responsiveness of the add-in's user interface.

Supported three new functions from Velixo Classic: FINANCIALPERIOD, FINANCIALPERIODSTARTDATE, and FINANCIALPERIODENDDATE.

Added help URLs to Acumatica functions.

The Acumatica instance URL that you paste into the connection editor will now have any unnecessary postfixes and whitespace automatically removed.

To prevent errors, the connection editor will not allow you to click Connect unless all required fields are entered: connection name, tenant, URL, username, and password.

Error message on the introduction / login screen remained even after re-loading the add-in.

Acumatica connections were not imported from Velixo Classic.

If you have both Velixo Classic and Velixo NX installed, if you add a connection in Velixo NX first, this connection will not appear in Velixo Classic after you open the same file. (On the other hand, connections created in Velixo Classic will still properly sync up to Velixo NX).

Refreshing your data may feel slower on Excel Windows and Mac than on the Web. The current versions of Internet Explorer and Safari, which are used by Excel under the hood to display the add-in, do not support fast database indices. For especially large files, the current work-around on Windows is to use Velixo Classic instead.

General Ledger functions drilldown.

Single Sign-On with Acumatica.