Applies to:

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

Release date: April 26th, 2024

Build no: 2024.4.107-g4c5b4ef4e5 (or higher)

🚀 New

• UX
  • The status panel of Velixo NX will now accumulate and display error messages that occurred in Velixo formula cells during refresh, along with a clickable cell address that navigates you to the offending formula. (#4860) This is done on a best-effort and the following limitations apply:
    • Only errors in Velixo formulas can be detected.
    • If a given Velixo formula errors out due to an error in a precedent cell, Excel does not invoke our code at all; therefore, we cannot detect if there was an error.
    • The addresses in the panel will not automatically update if you insert/remove cells to your workbook, but we will try to display a notification that the information in the panel might be outdated.
  • We removed the Freshdesk support widget from the side panel; upon clicking the help button, we will now direct you to the fully fledged support experience in the browser.  (#4834)
• Distribution
  • Velixo NX now experimentally supports the Report Distribution functionality that you know and love from Velixo Classic!
    • This functionality is only available on Excel Desktop for Windows and requires installing a separate report distribution agent add-in as a pre-requisite. Download it here.
• Functions
  • WORKBOOKLASTREFRESHDATE() and WORKBOOKLASTREFRESHBY() for better visibility on whether the data in the workbook is up-to-date. (#4823)
  • COMPANYNAME() function that allows you to retrieve a name of a given Acumatica company. (#3068)
    • ❗Using this function requires installing the latest Velixo customization project.
• Writeback
  • In the generic WRITEBACK function, a new screen setting “WritebackBranch” has been supported that allows you to perform writeback in the sign-in scope of a given Acumatica branch. This comes in handy in a number of narrow scenarios such as using branch-restricted cash accounts. (#4759)

✨ Improved

• Integration with Acumatica
  • Better-looking template files exported using Acumatica’s Export to Velixo button (Generic Inquiries, Import Scenarios). (#4688)
• UX
  • Velixo now displays a confirmation dialogue when you try to delete a connection. (#4590)
  • The flow of signing you in with Microsoft 365 account has been made more explicit and reliable. (#4797)
    • The “Get started” button on the initial page has been renamed into “Sign in with Microsoft”.
    • If something goes wrong sign in with Microsoft does not work, we have introduced a fallback method of signing in using a one-time code sent to your email.
• Drilldown
  • Major improvement in the speed of drill-down table rendering after the data retrieval has completed. (#4720)
  • Better error message displayed when a user attempts to remove the drilldown worksheets in a protected workbook. (#4611)
• Calculation
  • The “Cancel refresh” operation became more responsive. (#4104)
  • Improved the error message when the user has insufficient access rights to access an Acumatica endpoint. (#4762)
  • More stable calculation behavior in workbooks containing Auto-Hide ranges and volatile formulas. (#4600)
• Writeback
  • Improved UX when a user attempts to insert a new generic writeback worksheet without selecting an import scenario (#4665)
  • Supported direct hard-coded values passed to the generic WRITEBACK function. (#4848)
  • More consistent amount rounding behavior in budget writeback.
  • Better stability of writeback operations in case the focus shifts away from Excel. (#4749)
  • Writeback for “Selected cells” has been supported in the context of the journal transaction writeback. (#4775)
  • Fixed a bug that could lead to infinite/stuck writeback in rare cases. (#4637)