Applies to:

• Velixo NX
• Sage Intacct

Release date: April 30th, 2025

Version number: 2025.4 or higher

🚀 New:

We’re proud to announce a significant milestone for the Velixo integration with Sage Intacct - with the added support for querying the new Sage Intacct REST API!

Using the SI.XQUERY function, you can now query every object of the new Sage Intacct REST API. 

You will note the X prefix to differentiate this new function from the SI.QUERY function (which queries Sage Intacct's XML API). 

The new SI.XQUERY function is supported by two other functions, that are functionally equivalent to their XML API sibling, but should be used if you intend on using SI.XQUERY.

• SI.XEXPANDOBJECTRANGE allows you to list REST API objects.
• SI.XOBJECTDEFINITION provides you with metadata information about a specific REST API object and its attributes (such as: column description, enumerated values, etc..).

Note: The Sage Intacct XML API is not going away, and the SI.QUERY function will remain fully supported in Velixo.

There are a few notable differences between the two APIs, including: object names and the existence of recently introduced objects in the REST API (e.g. WIP, Assets or Tax objects), which you can now query with SI.XQUERY!

✨ Improved:

• Starting from this version, the Remember credentials checkbox in Connection Manager is checked by default for newly created connections.
• Balance functions and Project estimate functions, such as SI.TURNOVER and SI.PROJECTESTIMATEAMOUNT will now retrieve values and refresh more quickly.
• SI.EXPANDGLHISTORY now lets you specify AccountCodes to be returned, as well as their order.
• SI.OBJECTDEFINITION can now use an optional WithRelationships parameter to return details about Sage Intacct object relationships.

🔨 Fixed:

• Fixed an issue for users with Project or Construction Velixo licences who couldn't query user-defined books (RD-1699)
• SI.EXPANDGLHISTORY will no longer cause a logout when specifying multiple user-defined dimensions (RD-2129).
• SI.PROJECTESTIMATEAMOUNT returns amounts correctly for all lines when a range is defined in the CostTypeID parameter. (RD-2504)
• Running distribution in a file containing the SI.GETATTACHMENTSBYID function no longer results in a timeout error. (RD-2285)
• For SI.OBJECTDEFINITION, in cases when the list of valid values is too long, it is now truncated to 65,535 characters, as it is the maximal length of string supported by Excel. (RD-2115)
• The Snapshot feature in the Remove Velixo formulas only mode no longer fails when named items in the workbook contain non-string values. (RD-2057)
• Drilldown no longer fails when worksheets in a workbook are protected and works correctly for any cell of the spill range. (RD-1761, RD-1913)
• Fixed a bug in the mirrored tables functionality that caused plenty of blank pages to be printed because of the incorrect shrinking of the printing area when mirrored tables are updated. (RD-2272)