Velixo NX 2023.12 Release Notes - Acumatica

Applies to:

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)

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)

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)