Applies to:

• Velixo NX
• Acumatica, MYOB Acumatica, Cegid XRP Flex, JAMIS Prime, Haufe x360

Release date: December 29th, 2023

Build no: 70e48aac1834b0f3d88f199cc71344d77f7cd65f

🚀 New

Intacct:

• 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.ADJUSTEDDEBITS (#4174)
    • SI.ADJUSTEDCREDITS (#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.
• Writeback:
  • Added the ability to create a new project estimate writeback template. (#4002) 

Acumatica:

• 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)
• Calculation:
  • Added an ability to output the GI function dataset to a data table instead of a spilling range. (#4115)

Common:

• 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)
• Drilldown:
  • Drilldown sheet will now be rendered as a data table, enabling you to facilitate sorts, filters, and Copilot insights. (#4136)

✨ Improved

Acumatica:

• 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 during PM drill-down. (#4130)
• Writeback:
  • The screen ID for generic writeback can now contain dots "." as per Acumatica's standard formatting. (#4279)

Intacct:

• Calculation:
  • Further improved GL balance calculation speed on larger reports. (#4030)
  • 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) 
• Drilldown:
  • Supported drilldown when using location groups in balance formulas instead of location ranges. (#4091, #4170)
• Writeback:
  • 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)

Common:

• 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)
  • 
    
• Writeback:
  • All writeback templates created from the ribbon now have updated Velixo branding. (#4037, #4058, #4068, #4150, #4159, #4161)

🔨 Fixed

Acumatica:

• Drilldown:
  • During PM formula drill-down, when UseProjectCurrency argument was set to TRUE, drill-down did not respect that and still displayed amounts in the base currency. (#4088)
  • Drilldown did not work properly with unposted GL amounts. (#4166, #4208)

Intacct:

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

Common:

• Hide zero rows:
  • Velixo prematurely stopped reporting calculation progress in the side panel even though the process had not yet finished. (#3811)