Velixo NX Release notes 2023 Archive

Created by Damien Zwillinger, Modified on Fri, 23 Feb 2024 at 02:55 PM by Harry Lewis

Version 2023.12 (70e48aac1834b0f3d88f199cc71344d77f7cd65f) - December 29, 2023

Acumatica

🚀 New

  • New functions:
    • EXPANDSEGMENTVALUERANGE - returns distinct existing values for a given segment of a segmented key. We expect it to be most useful for subaccounts. For example, you can retrieve all matching values for the Department / Cost Centre dimension. (#4196)
    • SEGMENTDESCRIPTION - given a full segmented key value (most frequently a subaccount), provides the human-readable description of the specified segment. (#4196) 
      • For example, "SEGMENTDESCRIPTION("Acumatica", "SUBACCOUNT", 2, "000-COR")", where the second segment denotes a department, could return a description like "Corporate Office".
    • ❗ Using either of the above functions requires the installation of the latest update of Velixo's customization package
  • Drilldown:
    • The drilldown worksheet will now contain additional columns with human-readable descriptions of individual subaccount segments (department, product group, cost centre etc). (#4205)
    • Drilldown sheet will now be rendered as a data tableenabling you to facilitate sorts, filters, and Copilot insights. (#4136)
  • Calculation:
    • Added an ability to output the GI function dataset to a data table instead of a spilling range. (#4115)
  • UX/UI:
    • Revamped Help menu includes links to our new Community resources (discussions and feature requests), as well as to Velixo's video channel. (#3971)

✨ Improved

  • Calculation:
    • Significantly optimized report refresh performance when using GL balances by date as opposed to by financial period. (#4094)
    • Error messages about missing financial periods will now list the problematic companies when using multiple financial calendars in GL. (#4086)
  • Drilldown: 
    • Velixo will not render zero lines anymore during project function drilldown. (#4130)
  • Writeback:
    • The screen ID for generic writeback can now contain dots "." as per Acumatica's standard formatting. (#4279)
    • All writeback templates created from the ribbon now have updated Velixo branding. (#4037, #4058, #4068, #4150, #4159, #4161)
  • UX/UI:
    • Displaying a better error message in rare cases where Office extensibility framework fails to load. (#4283)
  • Copy without formulas:
    • Slightly improved the performance of the operation. (#4019)
    • Supported copying protected workbooks that are protected (without password only). (#4219)

🔨 Fixed

  • Drilldown:
    • During PM formula drill-down, when the UseProjectCurrency argument was set to TRUE, drill-down did not respect that and displayed amounts in the base currency. (#4088)
    • Drilldown did not work properly with unposted GL amounts. (#4166, #4208)
  • Hide zero rows:
    • Velixo prematurely stopped reporting calculation progress in the side panel even though the process had not yet finished. (#3811)



Sage Intacct


🚀 New

  • New functions:
    • SI.COSTTYPENAME (#4174)
    • Added important functions for building detailed trial balances:
      • SI.DEBITS - similar to SI.TURNOVER, but only displays the debit activity. (#4174)
      • SI.CREDITS - same as above, but for the credit activity. (#4174) 
      • SI.ADJDEBITS (#4174)
      • SI.ADJCREDITS (#4174) 
  • Connection:
    • Implemented secure sign-in (SSO) with Sage Intacct. To leverage this functionality, use the 🔑 icon in the connection editor without entering your username and password. Secure sign-in allows you to securely enter your credentials directly in Sage Intacct, or even use an external identity provider (Azure AD, Google, etc.) that you have configured for your Sage Intacct company. (#4139)
  • Calculation:
    • Introduced an ability to output the SI.QUERY function dataset to a data table instead of a spilling range. (#4115)
    • SI.QUERY now supports aggregate functions in the Select argument; the fields listed without an aggregate function effectively work as a GROUP BY clause. (#4191)
  • Drilldown:
    • First-level drilldown worksheet will now contain separate columns for debits and credits. (#4298)
    • Drilldown sheet will now be rendered as a data table, enabling you to facilitate sorts, filters, and Copilot insights. (#4136)
  • Writeback:
    • Added the ability to create a new project estimate writeback template. (#4002) 
  • UX/UI:
    • Revamped Help menu includes links to our new Community resources (discussions and feature requests), as well as to Velixo's video channel. (#3971)

✨ Improved

  • Calculation:
    • SI.QUERY: boolean values (TRUE / FALSE) are now accepted as valid criteria values besides strings and numbers. (#4032)
    • Improved reporting of server-side errors in Sage Intacct (FetchError). (#4227)
  • Copy without formulas:
    • Slightly improved the performance of the operation. (#4019)
    • Supported copying protected workbooks that are protected (without password only). (#4219)
  • Drilldown:
    • Supported drilldown when using location groups in balance formulas instead of location ranges. (#4091, #4170)
  • Writeback:
    • All writeback templates created from the ribbon now have updated Velixo branding. (#4037, #4058, #4068, #4150, #4159, #4161)
    • During budget writeback, Velixo will now validate whether the specified dimension values are active in the system, so as to avoid a cryptic error returned by the ERP system. (#4028)
    • Supported update / recreate scenarios in project estimate writeback. (#4044)
  • UX/UI:
    • Displaying a better error message in rare cases where Office extensibility framework fails to load. (#4283)

🔨 Fixed

  • Calculation:
    • Velixo range item subtraction did not correctly work with the intersection operator in all cases. (#4021)
  • Writeback:
    • WRITEBACKPROJECTESTIMATE formula did not update properly when changing dimension values. (#4287)
  • Hide zero rows:
    • Velixo prematurely stopped reporting calculation progress in the side panel even though the process had not yet finished. (#3811)





Version 2023.10 (d8080458be) - October 25, 2023

Acumatica

🚀 New features

  • Functions:
    • Leverage the master financial calendar in GL and PM functions! This is immensely useful in multi-company consolidation scenarios, where different companies utilize different financial calendars or shifted financial years. To enable this feature, set the new UseMasterFinancialCalendar argument to TRUE in supporting Velixo functions. (#3898)
      • Attention: utilizing this functionality requires setting up new generic inquiries on your ERP site. If your site uses the Velixo customization package, the updated inquiries are shipped as part of our latest customization package.
  • Support and feedback:
    • New in-app support widget connected to Velixo's new help & community portal (#3929)

    • User-aware support: when clicking "Get started" on the Velixo sign-in screen, you may now be prompted to sign in with your organizational Microsoft account. This should only happen on those occasions where if you're not logged into the Excel app itself. This allows us to better assist you in support scenarios - in particular, when you use our Help & Support widget from the add-in. (#3499, #4001)

✨ Enhancements

  • UX:
    • When Office takes more time than usual to load the Velixo add-in, we will display better visual feedback about the add-in being loaded. (#3966)
    • Refresh operation can now be queued even if the calculation is currently running. (#3959)
  • Calculation:
    • We redesigned the PM function calculation architecture from the ground-up for higher performance. (#3923)
    • The Refresh button drop-down on the ribbon now contains a "Cancel" button that you can use to interrupt the refresh operation. This is useful, for example, in case you have made a typo in a formula and need to interrupt the data load process to correct the mistake. (#3898)
  • Copy without formulas:
    • The informational dialogue in the new workbook, which informs the about the formula removal in progress, is now non-dismissible. (#3681, #3782)
    • Velixo connections redundantly remained in the target workbook after removing formulas (#3853)
    • Improved performance in Excel Online (#4019).
      • ❗ It's still much slower than on a desktop app due to various framework limitations on the Excel side. On medium-to-large files, we highly recommend using a desktop app for this functionality for the best experience.
  • Hide zero rows:
    • Improved performance of auto-hide zero rows. (#3776)
  • Dynamic-aware arguments:
    • In dynamic-aware functions (where you can specify one or more arguments as an Excel array (A1#), and the Velixo function spills as a result), we have improved the feedback mechanism for size mismatch between the provided array arguments. Now Velixo will report the offending argument names for easier troubleshooting. (#3706)
  • Connection:
    • Better timeout error message when your ERP instance is inaccessible when creating a new connection. (#3559)
  • Writeback:
    • Better error reporting when Acumatica returns an error message during GL / Budget / Project forecast writeback. (#4084) 
    • When creation of a new budget writeback worksheet fails, the side panel will not close automatically, allowing the user to observe and fix the error. (#3677)

🐛 Bug fixes

  • Functions:
    • When using Velixo range expressions, the intersection operator "^" did not behave intuitively when combined with the subtraction operator "-". (#3732, #4021)
    • The legacy VXTEXTSPLIT did not work as expected due to mistakenly expecting a connection argument. (#3742)
  • Calculation:
    • On rare occasions, Velixo could enter into an infinite calculation / login loop upon opening a workbook. (#3793)
  • Copy without formulas:
    • Copying workbook without formulas could sometimes result in the workbook remaining in Manual calculation mode. (#3849)
  • Drilldown:
    • When drill-down target is set up to a separate workbook, the cell linking to the original workbook did not navigate the user to it. (#3650)
      • Note that this link is not expected to work in Excel Online.
  • Connection:
    • The single sign-on button could show as enabled even if the ERP system did not support SSO connections from Velixo. (#3920)




Sage Intacct


❗ Important changes - action may be required

  • Intacct balance / turnover functions using dimensions will now not include subdimensions (e.g. child customers, projects, tasks etc.), for performance reasons. Please set the IncludeChildDimensionBalances to TRUE if you wish to restore the old behaviour. (#3759)
  • For a more intuitive behaviour of the subtraction operator, the meaning of the all-match wildcard (*) has changed when using dimensions in Intacct balance / turnover functions. (#3987)
    • Previously, for example, if you specified Customer | * in the dimensions argument, it meant "include both the transactions with any existing customer, or not associated with any customer at all".
    • In the new release, it means it means "include transactions with any existing customer". It will not account for those transactions that are not associated with a customer.
    • To simulate the old behaviour, leave the respective dimension empty or use the *? special syntax.
    • The *! syntax has been removed - please simply use in the current release.
  • SI.EXPANDCOSTTYPERANGE function now requires specifying a project and task (or a Velixo range expression thereof), since the same cost type ID may correspond to multiple project/task combinations (and have a different name and status there). (#3663, #3686)


🚀 New features

  • Support and feedback:
    • New in-app support widget connected to Velixo's new help & community portal (#3929)

    • User-aware support: when clicking "Get started" on the Velixo sign-in screen, you may now be prompted to sign in with your organizational Microsoft account. This should only happen on those occasions where if you're not logged into the Excel app itself. This allows us to better assist you in support scenarios - in particular, when you use our Help & Support widget from the add-in. (#3499, #4001)

  • Calculation:
    • More fine-tuneable advanced options for improving the refresh speed on very large databases (#3935)
  • New functions:
    • SI.QUERYFILTER, a helper function that simplifies building filter expressions for SI.QUERY. (#3829)
    • SI.EXPANDBUDGETRANGE (#3573)
    • SI.EXPANDSTANDARDCOSTTYPERANGE (#3694)
  • Writeback:
    • You can now create a new Journal Writeback (#3907) and Budget Writeback (#3962) worksheets for Sage Intacct connections from the Velixo NX ribbon.

✨ Enhancements

  • UX:
    • When Office takes more time than usual to load the Velixo add-in, we will display better visual feedback about the add-in being loaded. (#3966)
    • Refresh operation can now be queued even if the calculation is currently running. (#3959)
  • Calculation:
    • The Refresh button drop-down on the ribbon now contains a "Cancel" button that you can use to interrupt the refresh operation. This is useful, for example, in case you have made a typo in a formula and need to interrupt the data load process to correct the mistake. (#3898)
  • Copy without formulas:
    • The informational dialogue in the new workbook, which informs the about the formula removal in progress, is now non-dismissible. (#3681, #3782)
    • Velixo connections redundantly remained in the target workbook after removing formulas (#3853)
  • Hide zero rows:
    • Improved performance of auto-hide zero rows. (#3776)
  • Dynamic-aware arguments:
    • In dynamic-aware functions (where you can specify one or more arguments as an Excel array (A1#), and the Velixo function spills as a result), we have improved the feedback mechanism for size mismatch between the provided array arguments. Now Velixo will report the offending argument names for easier troubleshooting. (#3706)
  • Stability:

    • Technical infrastructure reuse across Sage Intacct functions and writebacks, reducing the amount of code and likelihood of bugs occurring. (#3730, #3802)

  • Performance:

    • Improved page load algorithm result in an up to 50% faster refresh experience on large datasets. (#3873)

    • Balance / turnover functions using project and task dimensions will now calculate faster. (#3722)

    • Project-estimate related functions now perform data loading by project, which is extremely important for sites containing extremely large number of estimate details (#3738, #3775)

  • Functions:

    • You can now specify dimension group names as values for balance / turnover dimension arguments. (#3870)

      • Previously, to filter balances by customer group instead of by customer, you first needed to clear the value for the "Customer" dimension, and add a separate "Customer group" dimension:

        • Customer | (empty)

        • Customer group | customergroupname

      • In this release, you can now reuse the customer dimension with the group name; to let Velixo know that this is a group you want to retrieve, simply prefix the value with the hash # symbol:

        • Customer | #customergroupname

    • For your convenience, SI.QUERY result set columns containing date values will now be formatted as an ISO date/time by default (YYYY-MM-DD). (#3780)

    • SI.PROJECTESTIMATE... functions now support filtering by the workflow type. (#3768)

    • IncludeChildDimensionBalances argument in balance / turnover functions allows you to include or exclude subdimension balances. (#3712)

    • SI.DIMENSIONS is now dynamic-aware and will spill in case one or more dimension values is an Excel array. (#3715)

    • SI.EXPANDCOSTTYPERANGE now allows one to include the corresponding project ID in the output. (#3663)

    • More EXPAND...RANGE functions have obtained an extra argument that allows you to include or exclude inactive records in the result set, or filter the records by their status. (#3664, #3674)

    • SI.TASKNAME - project ID and task ID arguments are now case-insensitive. (#3684)

  • Drilldown:

    • In second-level (transaction) drilldown, the transactions are now sorted by date. (#3716)

  • Writeback:

    • The dimensions can be passed to Sage Intacct writeback function both in the horizontal (dimension names in the first column) and vertical (dimension names in the first row) orientation.

    • Faster budget writeback with many writeback lines (#4040), as well as on large databases (#3980)

    • SI.WRITEBACKPROJECTESTIMATE:

      • now allows you to output the estimate line update key (RECORDNO) into an Excel cell in case you want to update those line in the future. (#3206)

      • workflow type is now case-insensitive. (#3881)

      • it not required anymore to explicitly specify Project ID in dimensions - the value will be taken from the header part of the function. (#3879)

      • you can now specify the special value #recreate as the line update key when updating an existing project estimate - this would remove the existing estimate lines and upload the ones that you intend to write back. (#3933)

    • Project forecast writeback will not attempt to validate its arguments (in particular, Project ID and Task ID) until the writeback is actually running. This allows chaining writeback operations on a single Excel worksheet. For example, Generic Writeback may create a project, output its project ID into an Excel cell, which is then used as an argument in project forecast writeback, instantly creating a project estimate for the new project in just one click of a button. (#3274)
    • In multi-entity shared companies, when you use entity-private values for writeback, Velixo is now smart enough to create the resulting record as private in the same entity. (#4039)
    • When creation of a new budget writeback worksheet fails, the side panel will not close automatically, allowing the user to observe and fix the error. (#3677)

🐛 Bug fixes

  • Functions:
    • When using Velixo range expressions, the intersection operator "^" did not behave intuitively when combined with the subtraction operator "-". (#3732, #4021)
    • The legacy VXTEXTSPLIT did not work as expected due to mistakenly expecting a connection argument. (#3742)
    • Balance / turnover functions will return 0 instead of an error when a Velixo range expression for a dimension (e.g. a Customer) contains no existing values. (#3726)
    • Balance / turnover functions could incorrectly return zero if the requested date range was in the closed books date interval for the company. (#3939)
    • When using balance / turnover functions with dimensions, subtraction syntax did not work when subtracting from the all-match wildcard (*). For example, "*;-ID1;-D2" did not work correctly. (#3728)
  • Calculation:
    • On rare occasions, Velixo could enter into an infinite calculation / login loop upon opening a workbook. (#3793)
  • Copy without formulas:
    • Copying workbook without formulas could sometimes result in the workbook remaining in Manual calculation mode. (#3849)
  • Drilldown:
    • When drill-down target is set up to a separate workbook, the cell linking to the original workbook did not navigate the user to it. (#3650)
      • Note that this link is not expected to work in Excel Online.
  • Writeback:
    • Journal writeback did not properly support the Department dimension. (#3770)
    • Budget writeback could fail in some cases when the input data was specified as a hard-coded value instead of the cell reference. (#3761)
    • Upon repeated budget writeback of the same worksheet, Velixo could create a duplicate line instead of updating the old one. (#4025, #4044)
    • Budget writeback could sometimes fail to find existing budget lines in Sage Intacct in update scenarios, due to unpredictable dimension sorting. (#3762)



Version 2023.8 (b0cbe4817e) - October 11, 2023

Extra update containing important performance enhancements and critical fixes.


Acumatica


New features

  • UX:

    • For select types of operations, Velixo now allows you to queue the next ribbon command instead of rejecting it with a "please wait" dialogue pop-up. For example, now you can click "drill-down" on the ribbon while your refresh is still in progress, and drill-down will start automatically as soon as refresh is completed. (#3497)

  • Writeback:

    • Support for ERP version 2023R2. (#3552, #3628)

    • Added a ribbon button to create new Project Forecast writeback templates. (#3286) 


✨Enhancements

  • Connection manager:

    • Velixo will not allow anymore to create two connections with the same name but different word casing. (#3535)

  • Hide zero rows:

    • To match the Classic behaviour, "Unhide all" will only unhide ranges on the current worksheet as opposed to the whole workbook. (#3661)

  • Copy without formulas:

    • Velixo will now prevent #CALC errors from appearing in the resulting workbook in case the source workbook contained volatile functions. (#3465)


Bug fixes

  • UX:

    • Sometimes the created writeback templates and drill-down worksheets were unnecessarily scrolled to the right. (#3480, #3495)

  • Writeback:

    • Due to an Acumatica bug, passing zero debit/credit values into a GL writeback could result in a non-zero amount from the previous line being posted to the specified account. The current Velixo version will skip such lines. (#3634)


Sage Intacct


✨ Enhancements

  • Writeback:

    • Improved performance of large budget writeback operations by only retrieving lines for relevant reporting periods. (#3980) 

  • Calculation:

    • Added a new Advanced option on the Options screen: "Frugal data retrieval -> Use minimal account ranges when retrieving balances". This option may benefit the report refresh speed for customers with very large amounts of account activity and/or heavy dimension usage. (#3935)

🐛 Bug fixes

  • Writeback:

    • During budget writeback, if the account code cell was formatted as a number instead of a text value, the operation returned an error message: "e.toLowerCase is not a function". (#3980)


Release date: August 11, 2023

Build no: 2ae938f5d3


The Velixo NX version 2023.8 includes the following new features, enhancements and bug fixes.


Breaking changes

Two important breaking changes were introduced for performance reasons:

  • SI.EXPANDTASKRANGE and SI.TASKNAME now always require specifying the project ID / range.

  • When specifying a range of Tasks / Cost Codes as a dimension, you will also need to specify the respective range of Projects.

In addition to that, for brevity, SI.GLOBALCONSOLIDATIONBOOKDESCRIPTION was renamed to SI.CONSOLIDATIONBOOKDESCRIPTION.


🚀 New features

  • UX:

    • For select types of operations, Velixo now allows you to queue the next ribbon command instead of rejecting it with a "please wait" dialogue pop-up. For example, now you can click "drill-down" on the ribbon while your refresh is still in progress, and drill-down will start automatically as soon as refresh is completed. (#3497)

  • Functions:

    • Dimensions argument in balance functions can now contain multiple Excel cells growing down or to the right. As a result, the balance function will also spill down, or to the right, respectively. (#3238)

      Dimensions spilling in Sage Intacct balance functions
    • Velixo syntax for dimensions in balance function got more expressive. (#3544) For example, when specifying a customer, it is now possible to retrieve balances that are associated:

      • With at least one customer, by specifying *!

        • Contrast this with the previously supported * wildcard, which pulled transactions that were posted with or without a customer.

      • With no customers, by specifying null

    • Added IncludeInactive/Status argument to multiple EXPAND...RANGE functions to allow filtering the result set by record status: e.g. active, inactive, or active non-posting. (#3510) 

    • New functions for Sage Intacct: 

      • Tax-related: SI.EXPANDTAXSOLUTIONRANGE, SI.EXPANDTAXTDETAILSRANGE, SI.TAXRATE. (#3541)

      • SI.EXPANDOBJECTRANGE function that returns a list of all matching platform objects in your system. Useful as an exploratory tool for building your SI.QUERY requests. (#3574)

      • SI.EXPANDSTANDARDTASKRANGE that returns a list of standard (as opposed to project-scoped) tasks or cost codes.

  • Writeback:

    • Introduced smart entity scoping in all types of writeback for multi-entity shared companies. Now it is possible to update entity-private records and use entity-private dimension values during writeback. In such a scenario, Velixo will smartly log into the necessary entity and update the record there instead of the top level. (#3469, #3520)

✨ Enhancements

  • Connection manager:

    • Velixo will not allow anymore to create two connections with the same name but different word casing. (#3535)

  • Hide zero rows:

    • To match the Classic behaviour, "Unhide all" will only unhide ranges on the current worksheet as opposed to the whole workbook. (#3661)

  • Copy without formulas:

    • Velixo will now prevent #CALC errors from appearing in the resulting workbook in case the source workbook contained volatile functions. (#3465)

  • Calculation:

    • Drastic balance calculation improvement on companies having complex/deep dimension hierarchies, due to an optimised building of the internal dimension hierarchy tree. (#3512)

  • Functions:

    • SI.EXPANDTASKRANGE now has an IncludeProjects argument that will output project IDs as the first column of the output spilling range.

    • When dimension values (e.g. Account groups) contain a comma , inside any given value, Velixo will not consider them as two separate values anymore. In such a scenario, use a semicolon ; to delimit values in a Velixo range expression. (#3631)

    • Improved error reporting upon various cases of invalid filter expressions for SI.QUERY. (#3459, #3490)

    • We will not issue two different requests anymore for two SI.QUERY calls where only the object name case differs. (#3461)

    • SI.EXPANDPERIODRANGE has stopped returning dynamic periods like "Today" or "End of Month", because using them is not supported by Sage Intacct's API (only on the site). (#3466)

    • When retrieving balances for an account group that has no accounts, Velixo will now return a zero value instead of an error message. (#3525)

  • Writeback:

    • Velixo used to report a successful status in the side panel if some of the writeback formulas failed to upload the data. In the current release, we will report an error in such scenarios, and only display the green light if everything was successful. (#3641, #3366)

    • Multiple minor improvements and fixes for tax entries in GL writeback. (#3486, #3500, #3516, #3556, #3563)

    • Better error message for SI.WRITEBACKBUDGET when all amounts are empty cells. (#3503)

    • Improved error message when an employee-type user attempts to use the writeback functionality. (#3638)

  • Drilldown:

    • For multi-entity shared companies, it is now possible to "View transaction" on the transaction drill-down worksheet even if it was posted as entity-private. (#3513)

    • Drill-down worksheets for Sage Intacct are now fully localised for French users. (#3451)

    • For your convenience, dimension columns in both the first-level drill-down and the transaction drill-down will now contain both the identifier and the name of the respective entity (e.g. "10100 – Account name"). (#3470, #3517, #3560)

🐛 Bug fixes

  • UX:

    • Sometimes the created writeback templates and drill-down worksheets were unnecessarily scrolled to the right. (#3480, #3495)

  • Drill-down

    • Clicking "View transaction" on the first-level drill-down worksheet could start the second-level transaction drill-down for an unrelated cell. (#3488)

    • Source cell link in second-level transaction drill-down could lead to an unexpected location. (#3527)

    • Second-level transaction drill-down balance total might not match the drilled cell value due to unnecessary inclusion of draft transactions. (#3533)

  • Calculation

    • Velixo occasionally failed to delete location groups created on-the-fly (for optimisation reasons) in multi-currency companies. (#3228)

    • Refresh operation hanged for employee-type users. (#3554)


❗ Known issues and limitations


  • Calculation:

    • When using both projects and tasks as dimensions in balance calculations, using an employee-type user is not supported, since Velixo needs access to create dimension groups on the fly (for performance reasons).  




Version 2023.6 (bac3d45b7f) - July 4, 2023

Acumatica


New features

  • Calculation:

    • An advanced workbook option has been added, allowing you to control the number of Velixo functions that are computed in parallel. We feel the default value is reasonable for most users and normally you won't have to tweak it. However, if you observe the add-in unexpectedly restarting during refresh, you can decrease that value as it helps with memory consumption on weaker computers.


✨Enhancements

  • Calculation:

    • Major improvements to calculation speed on large workbooks through a complete redesign of application state architecture. (#3151)

    • Fundamental simplification of Velixo NX's calculation architecture, resulting in faster refresh times on many workbooks and noticeable improvements in RAM consumption. (#3264)

  • Functions:

    • Velixo will now hint if a connection of wrong type is used in a formula, e.g. an Acumatica connection used in a Sage Intacct function. (#3319)

  • Drill-down:

    • Faster, more responsive drill-down that reuses calculation caches from the usual refresh process. (#3227)

    • "Separate workbook" drill-down destination is now supported for detailed ("View transactions") drill-down worksheets. (#3261)

    • Title Case will be used for headings in English language on drill-down worksheets. (#3354)

    • The top header row will now be frozen on drill-down result sheets for your convenience. (#3380)

  • UX:

    • In case Microsoft Office add-in framework fails to load for reasons outside of Velixo's control, the add-in will display a user-friendly error message along with the required actions on user's end. Previously, the user would just see a blank side panel (#3316)

    • The help centre overlay will now automatically be closed when the user navigates to other Velixo ribbon elements. (#3358)

  • Functions:

    • Velixo will now detect and report if you mix financial periods and dates in the same balance function call. (#3359)


Bug fixes

  • Calculation:

    • Fixed an old issue that led to the refresh process getting stuck in rare cases. (#3324)

  • Drill-down:

    • On a Mac, the "new workbook" drill-down destination could result in the Velixo side panel "jumping" and duplicating into the new workbook due to a bug in the Office platform. (#3410) 

    • Drill-down could crash or freeze for a long time in case the active cell contained a lot of blank precedents. (#3447, #3453)

  • Functions:

    • Date and time columns returned by the GI function were incorrectly shifted to the next calendar day if the source date/time was after mid-day. (#3412)

  • Drilldown:

    • The "View commitments" URL in PM drill-down did not set the cost code filter in Acumatica, resulting in a different observed balance.



Sage Intacct

New features

  • General - Calculation:

    • An advanced workbook option has been added, allowing you to control the number of Velixo functions that are computed in parallel. We feel the default value is reasonable for most users and normally you won't have to tweak it. However, if you observe the add-in unexpectedly restarting during refresh, you can decrease that value as it helps with memory consumption on weaker computers.

  • Functions:

    • All Intacct balance functions (opening/closing/turnover) now support adjustment books and user-defined books! Use them stand-alone or combine with the reporting or global consolidation books, e.g. "ACCRUAL;GAAP". (#3298)

    • New functions: 

      • SI.EXPANDCOSTTYPERANGE. (#3241)

      • SI.EXPANDACCOUNTGROUPRANGE. (#3404)

      • SI.EXPANDPERIODRANGE for reporting periods.

      • SI.PERIODSTARTDATE & SI.PERIODENDDATE, returning the start/end date of a given reporting period.

      • SI.BUDGETABLEPERIODBYDATE, returning a budgeting period that corresponds to the specified date value.

    • SI.PROJECTESTIMATEAMOUNT and SI.PROJECTESTIMATEQUANTITY now support Velixo range expressions and wildcards for project, task, cost type, and item parameters. (#3112, #3259)

    • Added new parameter "ProjectType" to SI.EXPANDPROJECTRANGE, allowing the user to output only parent projects, only child ("leaf") projects, or include both (default). (#3135)

    • SI.EXPANDACCOUNTRANGE now allows filtering to include only normal, only statistical, or all accounts (default). (#3396)

  • Writeback:

    • Support for budget writeback using SI.WRITEBACKBUDGET function. (#3222)

  • Drill-down:

    • Additional information is now available for your convenience on detailed drill-down worksheets ("View transactions"), such as Transaction description, Module, Journal number, and Reference. (#3234)

  • Calculation:

    • Added an advanced option that allows you to control how many data requests Velixo will batch together in every API request to Sage Intacct. It can help to decrease this value if you experience timeouts on large ERP sites. (#3309)


✨Enhancements

  • Calculation:

    • Major improvements to calculation speed on large workbooks through a complete redesign of application state architecture. (#3151)

    • Fundamental simplification of Velixo NX's calculation architecture, resulting in faster refresh times on many workbooks and noticeable improvements in RAM consumption. (#3264)

  • Functions:

    • Velixo will now hint if a connection of wrong type is used in a formula, e.g. an Acumatica connection used in a Sage Intacct function. (#3319)

  • Drill-down:

    • Faster, more responsive drill-down that reuses calculation caches from the usual refresh process. (#3227)

    • "Separate workbook" drill-down destination is now supported for detailed ("View transactions") drill-down worksheets. (#3261)

    • Title Case will be used for headings in English language on drill-down worksheets. (#3354)

    • The top header row will now be frozen on drill-down result sheets for your convenience. (#3380)

  • UX:

    • In case Microsoft Office add-in framework fails to load for reasons outside of Velixo's control, the add-in will display a user-friendly error message along with the required actions on user's end. Previously, the user would just see a blank side panel (#3316)

    • The help centre overlay will now automatically be closed when the user navigates to other Velixo ribbon elements. (#3358)

  • Functions:

    • When using a parent dimension value for hierarchical dimensions in balance functions (e.g. a parent class ID that encompasses several child classes), Velixo will now correctly incorporate balances from all child values. Previously, it only returned a balance that was directly posted under the parent dimension value. (#3294)

    • SI.QUERY now respects the order of the fields specified in the "Select" parameter, and outputs the columns in the same order. (#3232)

    • SI.PROJECTESTIMATEAMOUNT and SI.PROJECTESTIMATEQUANTITY will now complain if you specify a non-existent estimate ID, instead of misleadingly returning a zero value. (#3146)

    • SI.PROJECTESTIMATEAMOUNT and SI.PROJECTESTIMATEQUANTITY functions have become dynamic-aware and will spill as long as one of their arguments is a spill range. (#3285)

    • The WHENMODIFIED field returned by SI.QUERY will now be displayed as a date by default instead of a number. (#3268)

    • SI.EXPANDTASKRANGE will now filter out tasks that do not correspond to the specified project range expression. (#3299)

    • SI.BUDGETTURNOVER will return an error message instead of a zero value in case of a non-existent budget ID. (#3341)

    • Improved malformed filter expression detection capabilities in SI.QUERY, with significantly smarter error reporting. (#3369)

  • Calculation:

    • Improved speed of balance calculation through improved balance cache hit rate. (#3209)

    • On busy sites, Velixo will automatically retry any requests that hit a rate limit error from Sage Intacct's API. (#3300)

  • Drill-down:

    • Accounts and dimension values (customers, departments etc.) on the first-level drill-down worksheet will now display both the ID and the name of the respective record, for example "4000 - Accounts Payable" instead of just "4000". (#3307, #3431)

    • Better-looking, fitted column width and human-readable names on detailed drill-down worksheets ("View transactions"). (#3213)

    • More meaningful error message when you try to "View transactions" for a row that does not have any transactions associated with it, i.e. having no turnover in the specified period, or a budget-only value. (#3239)


Bug fixes

  • Calculation:

    • Fixed an old issue that led to the refresh process getting stuck in rare cases. (#3324)

  • Drill-down:

    • On a Mac, the "new workbook" drill-down destination could result in the Velixo side panel "jumping" and duplicating into the new workbook due to a bug in the Office platform. (#3410) 

    • Drill-down could crash or freeze for a long time in case the active cell contained a lot of blank precedents. (#3447, #3453)

  • Calculation:

    • Ad-hoc location groups that Velixo created on the fly for optimisation purposes could sometimes be left behind after the refresh, polluting the location drop-downs on the site. (#3228)

  • Drill-down:

    • Detailed transaction drill-down could fail if the user did not have access to the information about enabled features in the Sage Intacct company (usually this required them to be an admin). There is no longer such a restriction. (#3402)

    • One could not use a parent (e.g. entity-level) location ID in detailed drill-down. (#3236)

    • Redundant GLENTRY requests could occur while rendering the first-level drill-down. (#3347)

    • "View transactions" hyperlink displayed a redundant warning upon click in Excel Online. (#3349)

    • Drill-down failed in case the user omitted the Location ID parameter in a company with single base currency. (#3339)

    • "View transactions" hyperlink sometimes did not work on the first attempt. (#3443)


❗Known issues and limitations

  • Writeback:

    • On multi-entity shared companies, SI.WRITEBACKBUDGET will not allow you to use entity-private dimension values since at the moment, Velixo always logs you in to the top level. Our team is working to address this limitation in the next release by smartly scoping budget creation/update to the same entity as the dimension values specified. 


Version 2023.5 (35ab7f2833) - May 18, 2023

New

Sage Intacct

  • Functions:

    • SI.EXPANDTASKRANGE now has a TaskType argument which allows you to filter only for parent tasks, "leaf" child tasks, or both (default). (#3119) 

  • Drilldown:

    • After running a drilldown operation with Sage Intacct balances, Velixo now allows you to do a second drill down - all the way down to individual GL transactions, with a hyperlink back to Sage Intacct where you can review the batch. (#3056) 

      • Note: this functionality is not yet compatible with the "separate workbook" drilldown destination setting - use the "current workbook" to leverage this feature.

  • Writeback:

    • SI.JOURNALWRITEBACK now allows you to output the created batch number to an Excel cell, as well as to open the created batch in your browser after writeback. (#3183)

✨ Improved

Sage Intacct

  • Calculation:

    • For workbooks using multiple distinct dimension values, we have significantly improved the refresh speed and further optimized number of API calls Velixo NX makes to Sage. (#3120, #3122, #3130, #3134, #3144) 

    • Improved error message when the user forgets to specify the date range in Intacct balance functions. (#3157)

  • Drilldown:

    • Velixo will not display drill-down rows that contain all zero balance values. (#3167)

Fixed

General

  • Drilldown:

    • When drilling down to a separate workbook failed for any reason, sometimes Velixo was leaving redundant temporary worksheets in the source workbook. (#3204) 

Sage Intacct

  • Calculation:

    • For user-entered date values in Velixo formulas, time zones were shifted unnecessarily to UTC time, which could introduce edge cases in balance calculations. (#3124) 

    • Fixed a bug where Velixo could return a cached dimension-filtered balance value for a formula that did not use any dimension filters, and vice versa (#3149, #3170)

  • Drilldown:

    • Drilldown could get stuck on Sage balance formulas under certain circumstances. (#3152)

  • Writeback:

    • SI.JOURNALWRITEBACK mistakenly allowed the user to specify more than one value for each dimension, which then caused the writeback operation to fail server-side. (#3154)


Version 2023.4 (35ab7f2833) - May 8, 2023

New

General

  • Writeback:

    • Added support for "Writeback Selected Cells" option, working similarly to Velixo Classic. (#2968)

      • ❗ Due to the current restrictions in the modern Office.js framework, in contrast to Velixo "Classic", writing back selected worksheets as opposed to selected cells is not yet supported with this functionality.

Acumatica

  • Refresh:

    • Date values returned by the GI() function will now be formatted in the ISO format by default (YYYY-MM-DD). (#2994)

  • Writeback:

    • Added support for WRITEBACKPROJECTFORECAST. (#2958)

      • ❗ Creating project forecast templates is not yet available in Velixo NX; you can use templates created in Velixo "Classic" for Windows, or create a writeback template by hand.

    • Added the WRITEBACKREFRESHDATA function. (#2940)

Sage Intacct

  • New functions:

    • Added multiple EXPAND...RANGE functions for all common Sage Intacct dimensions: customers, departments, classes etc. The function accepts a Velixo range expression and spills a range of all IDs that match the specified range. (#2999, #3018)

    • Complementary to the above, also added the ...NAME functions for all predefined dimensions in Sage Intacct. Each of those function receives a dimension ID (e.g. Location ID "100") and returns the human-readable name of that object (e.g. "USA - New York"). (#2999)

    • SI.PROJECTSTATUS function to retrieve the status of a project / job. (#3002)

    • New functions to work with project / job estimates:

      • SI.EXPANDPROJECTESTIMATERANGE, which retrieves the estimate IDs corresponding to the specified project.

      • SI.PROJECTESTIMATEDESCRIPTION, accepting an ID of a project estimate and returning its human-readable name. (#3052)

      • SI.PROJECTESTIMATEAMOUNT (#3016)

      • SI.PROJECTESTIMATEQUANTITY (#3016)

      • SI.PROJECTSTARTDATE (#3008)

      • SI.PROJECTENDDATE (#3008)

    • SI.DIMENSIONS function, which accepts a sequence of dimension names and values (Name, Value, Name, Value, ...) and produces a 2D matrix expected by the balance functions such as SI.TURNOVER.

✨ Improved

General

  • UX/UI:

    • New look & feel of the side panel using modern colours and fonts. (#3043)

    • Velixo NX's side panel will now close automatically when a logical operation flow ends (e.g. when Insert Chart of Accounts or Create Writeback Template has run to completion). (#2974)

    • A descriptive error message will now be displayed if one attempts to Insert Chart of Accounts without a valid connection in the workbook. (#2979)

    • Velixo will not assume the Acumatica connection type anymore when creating a new connection, but instead remember the type of the last connection you used. (#3080)

Acumatica

  • GL writeback:

    • Velixo NX will be more resilient and not fail if non-required named ranges are removed from the GL writeback template (e.g. the Last Batch Nbr. field). (#2971)

  • Generic writeback:

    • When creating a new writeback template, the list of import scenarios will be refreshed from Acumatica as soon as you reopen the scenario selection page. (#2985)

    • Minor UX improvements during template creation for a case when no valid connections are available in the workbook. (#2976)

Sage Intacct

  • Refresh:

    • Significantly improved report refresh performance:

      • By caching definitions of Sage objects. (#3006)

      • By using dimension grouping (GROUP BY) instead of sending separate requests to the back end. (#2982)

      • By more aggressively batching API requests together.

      • By using a more performant back-end for the SI.QUERY function. (#2964).

      • By not unnecessarily re-requesting GL balances behind a date on which all company books have been closed. (#2803)

    • "Project" and "task" dimensions can also be specified as "Job" and "Cost code" for construction edition companies. (#2981)

    • SI.EXPANDTASKRANGE now accepts a project range expression that allows to filter down tasks by matching project IDs.

    • Velixo will now validate the fields you specify in "filter" and "select" arguments of SI.QUERY. (#3019)

Fixed

General

  • UX/UI:

    • Insert Chart of Accounts button did nothing if multiple cells were selected instead of one, (#2961) or if no valid connections were present (#2979).

  • Drilldown:

    • Multiple fixes for stuck drill-down and redundant/incomplete rows (#3031, #3045, #3101).

Acumatica

  • Generic writeback:

    • Generic writeback incorrectly assumed all its data to be present on the current worksheet, so that references to other worksheets were not working (#3094).

Sage Intacct

  • Refresh:

    • When refreshing GL balances and specifying both projects and tasks as dimension values, Velixo did not check whether the specified tasks matched the requested set of projects, overshooting the balance value. (#2993)

  • Drilldown:

    • Location was not being displayed in the drill-down result worksheet if a location group was used instead of a particular location value.


Version 2023.3 (b57d9e5670) - April 3, 2023

New

General

  • UX:

    • We completely redesigned the side panel, removing all buttons, tabs and elements that duplicated those already available on the Velixo NX ribbon. Enjoy the new uncluttered look of Velixo! (#2872, #2873, #2874, #2875, #2876) 

  • New ERPs:

    • Added support for the Haufe X360 ERP system. (#2804)

Acumatica

  • Writeback:

    • Support for "chaining" Generic Writeback operations where subsequent writebacks depend on the output of previous writebacks. (#2842)

Sage Intacct

  • Writeback:

    • Experimental support for journal transaction writeback using the new SI.JOURNALWRITEBACK function (#2837)

  • Refresh:

    • Smart refresh is now supported for:

      • List entities such as Accounts and predefined dimensions: Locations, Departments, Projects, and others. (#2646)

      • Entities retrieved by the user through SI.QUERY. (#2497)

  • Formulas:

    • When using the PredefinedDimensions parameter of balance functions, you can now specify the names of dimension groups defined in your company. For example, "Customer group ID" -> "Active customers".

✨ Improved

General

  • UX:

    • It is not possible anymore to view the saved password for a connection by reopening the connection editor. (#2815)

    • Ribbon button names have been harmonized with Velixo "Classic" for Excel Desktop on Windows. (#2814) 

  • Copy without formulas:

    • Velixo will now preserve the formatting of numbers stored as text. Previously, Excel could corrupt subaccounts like "000000" to number "0", and financial period values like "012023" to number "12023". (#2886)

    • Better error message in case any worksheets are password-protected. (#2904)

  • General:

    • More descriptive error messages upon connection errors like "400" or "401". (#2903)

Acumatica

  • Writeback:

    • Better error message when writeback Velixo web service endpoints are not found on the site. (#2944)

    • Subaccount has been made optional in budget writeback formulas, because some companies do not use subaccounts. (#2932)

    • GL writeback has become more resilient to changes made to the default template structure (such as moving the template table across the worksheets and/or renaming its columns). (#2799) 

    • Improved performance of GL writeback by uploading individual transaction lines in chunks. (#2697)

    • We worked around an authorization cookie limitation that did not allow you to use Generic Writeback in the Safari browser specifically. (#2781) The limitation only applied in case you were connected to Acumatica through username & password, as opposed to single sign-on. 

    • Velixo now disallows Generic Writeback to inactive import scenarios. (#2793)

    • Any empty rows specified for Generic Writeback will now receive the "Line skipped" status upon finish, instead of "Line uploaded". (#2825)

    • The created generic writeback template worksheet has been unified with Velixo "Classic" for Windows Desktop. (#2850)

    • When selecting an import scenario for Generic Writeback template worksheet:

      • Invalid connections are not shown for selection anymore. (#2848)

      • Better UX around the situation when an import scenario selected for the Generic Writeback is empty. (#2779)

      • There is now no more need to restart Excel in case you activate or deactivate a scenario in Acumatica - only to reopen the template creation dialogue. (#2889)

  • Connection:

    • Velixo will auto-fix the "https:/" typo (missing slash) when entering the connection URL. (#2800)

  • Refresh:

    • When a user creates or modifies a Generic Inquiry in the system, Velixo will now immediately become aware of those changes over the course of a Smart Refresh. Previously, it used not to "see" those changes for up to 30 seconds. (#2811)

  • Functions:

    • More consistent handling of segment values that contain user-input dashes (all supporting functions, but in particular, SUBACCOUNTNAME). (#2853, #2857)

    • IncludeInactive parameter in EXPAND... functions now only accepts TRUE, FALSE, 1, 0 as valid values. (#2854)

Intacct

  • Refresh:

    • The Operations tab was showing completed ERP data requests for GL balances for longer than needed. (#2832)

  • Functions:

    • The names of user-defined dimensions are no longer case-sensitive. (#2841)

Fixed

General

  • Velixo range expressions:

    • Velixo incorrectly returned an error when the user tried to match "everything except one account/subaccount/..." code in this manner: