Breadcrumbs

Velixo NX 2026.2 Release notes

Excel add-in

🚀 New

  • The new UseAccountCurrency argument lets you choose to return amounts in an account’s own currency in the following functions (RD-7464):

  • WRITEBACKJOURNAL now allows cell references for the LineBranch argument, enabling dynamic assignment from worksheet data. (RD-8679)

  • The built‑in Journal Transaction template for Acumatica is now formula‑based (with a separate formula for each Writeback line), making it easier to customize Excel templates for journal entries (for example, use Excel functions to include or exclude individual fields conditionally). (RD-8524)

✨ Improved

  • When using Slice with the Do not remove formulas option enabled, formulas that reference sheets not included in the new workbook are now automatically replaced with their last calculated values to avoid #REF! errors. (RD-8196)

  • The Formulas to review section in the Status panel is now automatically updated when formulas are edited or cleared, or when rows, columns, or sheets are inserted, deleted, or renamed, preventing resolved errors from lingering until a manual Clear or refresh. (RD-7202)

  • Query Builder now shows friendly column headers in mirrored tables that match the names you see in Acumatica when the Show column headers box is checked. You can also use the string caption in the IncludeHeaders argument of the ACU.QUERY function for the same effect. (RD-7788)

  • You can now write back journal transactions to open periods whose date belongs to a locked period. (RD-7818)

  • Velixo NX now caches metadata used by Query Builder across sessions and refreshes it in the background for improved speed and responsiveness. (RD-7786)

🔨 Fixed

  • Fixed an issue causing Generic Inquiry options to reset and become unavailable if GI and ACU.QUERY functions ran in the same Excel session, preventing users from configuring key columns and, consequently, using mirroring with user values. Now GI options will remain available. (RD-8539)

  • When WRITEBACKBUDGET fails, Velixo NX now shows a clear, formatted error message instead of a generic error. (RD-6953)

  • You can now write back GL journal transactions to open financial periods even when the transaction date falls in a locked period. (RD-7285)

  • Fixed a bug where slicing a worksheet without removing formulas could still result in formulas being removed, especially when the copied workbook recalculated on open. (RD-8528)

  • Auto-hide zero rows now works reliably even on very large ranges or entire worksheets, instead of failing with a “Maximum call stack size exceeded” error. (RD-8518)