Applies to:

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

Release date: December 29th, 2023

Build no: 70e48aac1834b0f3d88f199cc71344d77f7cd65f

🚀 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 table, enabling 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)