Velixo NX Release notes 2022 Archive

Created by Damien Zwillinger, Modified on Mon, 18 Sep, 2023 at 9:14 PM by Damien Zwillinger

Version 0.17.12-g203ef18394 - December 13, 2022

New

  • 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).

    • ⚠️ Note that creating budget writeback worksheets is not yet supported.

    • New budget writeback worksheets can be created in Velixo "Classic" for Excel Desktop on Windows. 

  • 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)

✨ Improved

  • 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: 

    • reduced the number of data requests made to the ERP system in general due to improved batching strategy. (#2361)

    • further reduced the number of requests in cases when the same GL account participates in different range expressions. (#2304)

    • when specifying multiple dimension values in balance functions, a comma "," can now be used as a separator in addition to the semicolon ";". (#2306)

  • Acumatica-like systems:

    • Velixo NX will not attempt to write back an empty GL transactions. (#2349)

    • Supported the asterisk symbol (*) when specifying balance types in EXPANDPROJECTHISTORY. (#2367)

    • Supported quoted numbers (e.g. "3") for the IncludeUnposted argument in account balance / turnover functions. (#2363)

    • GL writeback:

      • will now report an error in case releasing the batch was requested by the user but failed for whatever reason. (#2421)

      • will not report an error anymore when the batch is out of balance and the "Automatically release" option is set to "No". (#2432)

Fixed

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

  • Acumatica-like systems:

    • ACCOUNTSWITHHISTORY unnecessarily returned subaccounts, too. (#2448)

    • GL writeback failed when:

      • the template worksheet had been created in another language (#2344, #2461)

      • other Velixo functions were present on the worksheet. (#2289)

      • the template worksheet had been created on an older version of Velixo Reports with different column names. (#2419)

    • EXPANDPROJECTHISTORY did not account for combinations having negative amounts or quantities (only positive ones). (#2417)

  • Remove formulas:

    • Velixo connections were not removed from the resulting workbook. (#2291)

    • #CALC or #BUSY could be displayed after removing formulas in case Excel recalculated the worksheet during the formula removal process. (#2324)

Version 0.16.333 - November 2, 2022

New

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

✨ Improved

  • 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

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

Version 0.16.311.33370 - October 14, 2022

New

  • 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)

✨ Improved

  • 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)

Fixed

  • "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)

⏳ What's cooking

  • GL Budget writeback for Acumatica ☁️.

Version 0.15.613 - August 25, 2022

Fixed

  • 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)

✨ Improved

  • 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)

Version 0.15.582 - August 9, 2022

New

  • Dynamic-aware functions have reached Velixo NX!

    • For example, when using an EXPANDACCOUNTRANGE() spilling formula in cell A1, you can then use just a single ACCOUNTENDINGBALANCE(...,A1#,...) formula. It will return an entire column of balances for all corresponding accounts from A1's spill range!

    • ⚠️ Limitation: drill-down into spill ranges of dynamic-aware functions is not supported yet. We will be delivering support for that in subsequent releases of the product.

  • 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.

✨ Improved

  • 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.

Fixed

  • 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. 

⏳ What's cooking

  • Drill-down for Sage Intacct is coming soon. ?

⚠️ Breaking changes

  • 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.

Version 0.14 - March 6, 2022

New

  • Added French language support (#1722). 

    • The task pane interface should already be available in French.

    • Note: the functions help will only become localised as soon as Microsoft processes our updated store submission, as adding a new language support requires resubmission on our end. It may take several days.

  • New Intacct functions:

    • SI.BUDGETTURNOVER, which allows you to see budgeted turnover values in a given reporting period, or within the provided date interval (#1727).

    • SI.DEBITS - displays only debit activity for an account in a given reporting period, or within the provided date interval. This does not include any adjustment debits (#1726).

    • SI.CREDITS - displays only credit turnover for an account in a given reporting period, or within the provided date interval. This does not include any adjustment credits (#1745).

    • SI.ADJUSTEDDEBITS - like SI.DEBITS, but displays the debit total posted as an adjustment (#1746).

    • SI.ADJUSTEDCREDITS - like SI.CREDITS, but displays the credit total posted as an adjustment (#1747). 

  • 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)

Fixed

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

Version 0.13.56-gf72bff6fbc - February 3, 2022

New

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

    • Previously they only required one date or a reporting period name, but it produced counter-intuitive results for closing accounts (revenues / expenses).

    • Sage Intacct reports themselves always require a pair of dates. 

✨ Improved

  • 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 that time, Velixo NX will prevent users from starting another long-running operation, such as another refresh or drill-down, to avoid concurrency issues (#1688)

  • 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)

Fixed

  • ? 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) 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article