Velixo users whose ERP system was in "single-tenant mode" (not supporting fully qualified OData URLs containing the tenant name) could not log in with an error: "Root element is missing" (#2872)

Fixed a regression that caused drilldown on cells referencing a dynamic array to fail. (#2871)

Velixo formulas will short-circuit and not attempt to evaluate in case on of the arguments supplied to a formula is an Excel error. This significantly improves calculation performance in error scenarios. (#2857)

Better resiliency in making web requests on low-core CPUs. (#2823)

Improved error message when Distribution List fails due to pivot table slicers containing unsupported symbols like "$". (#2829)

Velixo will now detect if you have specified any invalid values in a Velixo range expression, e.g. "CUSTOMER1;CUTOMER2" instead of "CUSTOMER1;CUSTOMER2". (#2842)

Better drilldown performance on workbooks containing a lot of spill ranges. (#2846)

Better error message in WRITEBACKBUDGET when one of the required period amounts is left blank (probably due to an unintended extra comma in the formula). (#2848)

Velixo is now making a better effort to preserve value formatting after Copy without formulas, especially for number-like values formatted as text. (#2861)

Fixed an incorrect error message appearing randomly in the connection editor: "That doesn't look like a valid ERP website". (#2824)

Velixo could not detect whether single sign-on was available for a site when the user entered the tenant name with extra trailing spaces. (#2826)

0x800A03EC error occurred during Copy without Formulas whenever one of the values in a spilling range was longer than 255 characters. (#2835)

Excel could crash during opening when a file was split into the two-window mode. (#2838)

ExcelDNA error in ArrayResizer was observed by some users intermittently. (#2863)

Auto Hide Zero Rows did not properly re-triggering for rows that dynamically become blank depending on a formula. (#2865)

A minority of users observed Excel window becoming slow and laggy after a Velixo installation. We detected the problem in the underlying library and resolved it. (#2847)

Some JAMIS Prime users were not able to retrieve account balances using Velixo because their system was responding with an incorrect ERP version number. We worked around this issue. (#2868)

Fixed a situation where the Auto-Hide feature could leave some zero values when reapplied.

Fixed a race condition that could theoretically lead to inconsistent values when calculating reports with hundreds to thousands of Project balances.

Added a possibility to explicitly specify the maximum generic writeback chunk size to avoid accidentally splitting one document into many.

Writeback:

Distribution:

Copying without formulas:

Connection:

Refresh & calculation:

Drill-down:

Due to a limitation in the ERP system, smart-refreshing the GL balances using dates instead of financial periods could miss transactions occurring within a certain day, after a new transaction was posted in the period of interest. (The issue was always fixable by a full refresh). (#2800)

Fixed a race condition that could theoretically lead to an erroneous zero value when calculating GL balances using dates instead of financial periods. In practice, we have never seen this. (#2803)

If a user entered a tenant name using an incorrect case, the error would not disappear even after they re-entered it with proper capitalization. (#2777)

In cases where the GL batch numbering sequence was configured to contain only digits, the user could not execute writeback in case the format of the Last Batch Number template cell was anything other than "Text". (#2782)

Added Commitments column to PM drilldown (#2761)

Significantly decreased network traffic consumption by leveraging OData gzip compression. (#2742)

Project revision is now a required field in forecast writeback (#2743)

Consistent telemetry with NX re: workbook name hashes, we can now cross-correlate data with NX properly in that regard (#2745)

Added telemetry for VELIXOVERSION function invocations. (#2757)

EXPANDPROJECTHISTORY now accounts for rows with negative amounts too (previously it included only positive ones, but in reality we just want "non-zero") (#2737)

EXPANDPROJECTHISTORY complained about missing revisions if there were no forecast revisions in Acumatica/MYOB (#2739)

Added a fixed ProgID to the Ribbon COM component (for NX purposes)

In case GL writeback fails after a partial upload, Velixo will delete the created batch (#2747) - previously it would leave it partially uploaded.

Hotfix for customization package for Acumatica 2023R1 where customization would not publish (regression in Acumatica) (#2749).

IntelliSense stability fixes, more reliable arguments pop-up. (#2751)

Any updates to Velixo user license will now propagate immediately after "clear local cache" without anyone having to restart Excel. Previously, a restart was needed. (#2753).

Fixed a rare case where:

For longer workbook names, it was not possible to add more than 9 writeback / drilldown worksheets to the workbook due to the name overflow. (#2755)

Fixed a performance problem when entire rows were selected and the user pressed "Writeback selected cells" (#2763)

It was possible to accidentally launch two parallel drilldown operations or other ribbon operations by rapid-clicking the button, which we suspect leads to potential inconsistencies (#2766)

An "object reference" error could be observed at start-up time by a subset of users.

EXPANDPROJECTHISTORY now includes project forecast revisions column in the output. Use the ExpansionOrder parameter to exclude revisions if necessary. (#2664)

Velixo has a new look!

Brand-new ribbon icons, delivered as part of our unified experience across all the platforms supported by Velixo Reports and Velixo NX.

In Excel ribbon, instead of the ERP name (Acumatica / MYOB Advanced / CEGID etc.), you will now simply see "Velixo".

Significantly improved refresh speeds for reports that request balances by a specific date instead of a financial period. (#2645)

Improved reliability of large GL writebacks. (#2647)

Better user experience when your ERP single sign-on token expires: having previously just returned an error message, Velixo will now display the connection prompt. (#2642)

More responsive "Cancel" button during connection. (#2627)

Added support of BYROW() function being applied to Velixo writeback functions. (#2696)

Improved resulting file size for "Copy without all formulas" when the workbook contains spilling ranges. (#2715)

Generic Writeback and WRITEBACK() function:

Report distribution:

More meaningful error message when a user does not have access to a generic inquiry in the ERP. (#2623)

Improved detection of the 32/64 bitness of Microsoft Excel in Velixo's command line tool. (#2556)

Better error message for ACCOUNTS...WITHHISTORY functions when non-existent branch is specified. (#2555)

Velixo will now attempt to restore previous auto-filters after "Unhide All" is pressed. (#2662)

GIFILTER(..., "*") will now work even for non-string column types, which will allow any value for that column. (#2661)

EXPANDPROJECTHISTORY:

EXPANDPROJECTHISTORY mistakenly ignored the revision parameter when IncludeInactive was set to TRUE. (#2632)

The screen would flicker multiple times in some workbooks containing the VXTEXTSPLIT function. (#2634).

During Copy without formulas, Velixo could not copy some workbooks that had auto-filter values that were not readable through the Excel Interop model. In the current version, Velixo will preserve auto-filters on the best-effort basis only. (#2644)

Creating a distribution list on a system with French regional settings could incorrectly set up the distribution format drop-down. (#2703)

Velixo now uses FIPS-compliant hashing algorithms, allowing usage on systems with strict FIPS policy enabled. (#2610, #2626)

On older non-365 versions of Microsoft Excel, Velixo's experimental mechanism for displaying spilling ranges did not work with R1C1-style references, or on systems using the ";" list separator (#2617).

GL transaction writeback was not possible when default non-project code in the ERP system was renamed from "X" to anything else. (#2618)

Project functions could return zero balances in case Velixo inquiries were configured on legacy Acumatica versions (2018R2 and older) and never upgraded or recreated (#2611)

On older systems without WebView 2 browser engine, got rid of an unexpected error pop-up during start-up. (#2614, #2615)

New EXPANDPROJECTHISTORY() function - like ACCOUNTSWITHHISTORY(), but for project module.

Drill-down sheets will now contain the Turnover column in addition to separate Debits and Credits. (#2498).

Custom columns in GL writeback now support Excel date values. (#2494)

In Copy without formulas and Report Distribution, any spill range references like A9# will continue to work! (#2500)

Improved the general refresh performance by up to 10% (#2560), and improved performance of project reports in Velixo by up to several times on large reports! 📈. (#2549, #2569)

WRITEBACK() function arguments can now be used in a dynamic-aware manner. For example, you can now specify multiple Excel range references like A1# as separate arguments, and it will work seamlessly with the writeback function. (#2595)

Wildcard range patterns like ABC?? in Velixo functions are now case-insensitive. (#2588)

The "refresh pivot tables" distribution template setting now also works with the PDF report distribution format. (#2508)

Excel could crash during Copy Without Formulas or Report Distribution when Velixo could not break links to the source workbook. (#2602)

It was impossible to distribute locked worksheets in Report Distribution when those sheets contained auto-hiding zero rows or columns. (#2600)

For large reports consuming a lot of GI() data, Velixo could keep re-requesting the data without ever finishing the refresh. (#2593)

A drill-down COM error occurred when a drilled cell is part of a spilled range of a function that refers to a different worksheet.

Drill-down arrows would not be removed sometimes.

Velixo self-diagnostics generated a lot of network traffic on large reports.

Due to a bug in Acumatica 2022R1, a Velixo GL generic inquiry could be created incorrectly for a small subset of clients, leading to erroneous zero balances for some GL accounts. This update adds extended validation for the inquiry during the connection process. If any issues are found, Velixo will propose to automatically upgrade the inquiry.

Velixo range expressions (e.g. for ledgers and branches) were unnecessarily case-sensitive

Report Distribution and Copy Without Formulas: when the resulting copy of the workbook contains pivot tables still referencing the original workbook, Velixo will smartly try to rewire their data range to the copied workbook!

Additional performance improvements for Auto-Hide Zero Rows!

Ensured that Hide Zero Rows also hides rows containing mixed zeroes and blanks.

Fixed a potential COM exception that could occur during Copy Workbook Without Formulas or Report Distribution in case the report contained pivot tables.

Fixed the button caption for forgetting auto-hide ranges.

Auto-Hide Zero rows sometimes triggered prematurely during recalculation, which led to some zero rows remaining visible.

Distribute All button could sometimes remain disabled after report distribution.

Greatly improved the performance of the Auto-Hide Zero Rows/Columns functionality.

Improved the error message when a user tries to distribute hidden sheets in PDF/Excel formats

Velixo ribbon will not allow the user to create writeback worksheets when there is no active workbook.

"Type mismatch" error could sometimes surface during VBA macro execution due to Velixo's background processing logic.

If a report distribution into a OneDrive folder fails due to OneDrive holding access to the folder, Velixo will display a more descriptive error message.

When processing selected tabs during report distribution, Velixo will ignore the case in tab names.

Import scenarios in the Generic Writeback worksheet creation dialog are now sorted by name.

Improved the error message upon encountering a non-existent import scenario name in New Generic Writeback Worksheet.

Pivot tables in distributed reports were still looking at the original file for source data.

Unexpected error messages could be displayed after a user attempted to close an unsaved file and then clicked "Save" in the pop-up prompt.

A null reference error could very rarely occur during refresh.

Excel could sometimes freeze during the auto-connection process when connection credentials were not remembered in the file.

Some import scenarios could be missing from the Generic Writeback worksheet creation dialogue.

Fixed an error pop-up when the same file was opened in the two-window mode.

Added the option to attach files to records uploaded during Generic writeback.

Generic writeback now supports single sign-on connections (requires ERP version 2022R1 or newer).

Project functions are now dynamic-aware: their output will resize together with their input.

A welcome carousel pop-up is now displayed on start-up.

Better UX and status reporting during writeback.

Improved performance for import scenario list retrieval in generic writeback worksheet pop-up. You may need to click Validate inquiries in the connection manager and configure the VelixoReportsPro-ImportScenarios inquiry.

Generic writeback worksheet pop-up and function Intellisense hints now also display ERP screen IDs and titles in addition to the import scenario name.

Improved drill-down performance on large worksheets

Improved "single-click" writeback experience involving multiple writeback scenarios and subsequent writebacks reusing the result of previous write-backs.

Velixo now supports displaying total record count in the status bar during refresh on ERP version 2022R1 and newer.

WRITEBACKPROJECTUPDATEBUDGET will not be executed during write-back in case the preceding project budget writeback fails.

The "contains"-style smart expand in GIFILTER (*containedtext*) will now work without the user having to check "Always load the entire Generic Inquiry..." option.

GIFILTER now supports null literals as criteria.

GIFILTER will now return an error when a comparison operator has a criteria without an explicit operand ("=", "<", ">")

The "Validate inquiries" command will now display a success message in case no issues are found.

The "Recreate inquiries" command in the Connection Manager could create extra inquiries that were redundant given the licensed modules.

Hide Zero Rows / Columns always worked on the whole spill range of a cell even if the user selected only a part of it.

Excel workbooks embedded as COM objects in Word documents crashed when Velixo was installed on the system.

Invalid OData filters in GI function sometimes resulted in a diagnostic window being displayed instead of displaying as an in-cell error message.

The "Import selected cells or worksheets" command did not work when multiple worksheets were selected.

On older systems, clicking the Help button on the ribbon could result in an error.

New generic writeback sheet pop-up dialog could display an empty connection drop-down after saving the workbook under a new name.

Exception thrown upon Generic Writeback sheet creation when logged in under SSO.

COM exception could happen upon closing a distributed report

If "New workbook" was selected as a drill-down worksheet destination, and the name of the source tab was too long, the drill-down worksheet could not be created.

GI options were not created for GI function calls in case another workbook with the same connection, using the same GI, was opened in parallel.

Scheduled distribution invoked from the command line did not properly respect the "hidden" and "silent" command line flags.

Values returned as out-parameters from Generic Writeback could not always be used in subsequent writebacks because they contained trailing spaces.

Due to a bug in some ERP versions, using GIFILTER's "smart expand" feature or contains() / startswith() / endswith() functions in a GI filter, resulted in an error.

WRITEBACKARGUMENTS() will now return a row vector instead of a column vector because a row vector is expected by the WRITEBACK function. You may need to remove any TRANSPOSE() calls around this function in case you have already tested Generic Writeback under Velixo Insider program.

The DataColumnNames argument in generic WRITEBACK() function is now a required argument.

WRITEBACKREFRESHDATA() now does not have any argument.

During the writeback process, if there are no cells containing a writeback formula where Velixo can display a detailed error (e.g. during GL writeback which is not formula-based), an pop-up error box will be displayed instead.

The VBA method for writing back the specified worksheet was always writing back the active worksheet and ignored the specified parameter.

In GL writeback, several parameters, such as branch and currency, were redundantly being required by Velixo even when they could be filled in by default in Acumatica.

It was only possible to instantiate Velixo's VBA object as a variant type, due to updated VBA method signatures.

Velixo Reports includes a streamlined writeback experience - with just a single "smart" writeback button. The button will detect all different types of writeback used on the current worksheet, and act accordingly. In conjunction with other writeback improvements, this experience allows you to build quite interesting and complex scenarios: for example, you can create a customer, then a sales order for that new customer, and finally, update the project budget – all in just one click! 1813

There is now a Velixo option to create drill-down worksheets in a separate workbook. 1847

A brand-new "Support" button that allows you to access Velixo's body of knowledge in a task pane right beside your workbook. You can also chat with our support team in case none of the articles answer your question (An article search is required before a chat button becomes available at the bottom of the search results). 1964

A better sense of progress: during a long refresh, in the status bar, Velixo will additionally display the total record count to be loaded, in addition to the number of already loaded records. This feature will only work on supporting ERP versions (such as Acumatica 2022 R1). 1970

A VELIXOVERSION function is available to quickly retrieve the current add-in version (useful in communication with the support team). 1991

WRITEBACK now supports an additional argument to output the key fields of any created entities back onto the workbook. 2000

Running drill-down has been prohibited while Refresh is running. 1998

WRITEBACK will skip fully empty Excel rows during import. 1993

Better performance of GL and Project writeback. 1968

When closing the workbook, Velixo will offer to delete the created drill-down worksheets. 1951

The Refresh ribbon button will now change to a Cancel button whenever a refresh is in progress. 1891

Multiple lines can now be imported using a single WRITEBACK formula. 1887

Upgradeable inquiries will no longer be validated during the connection process, only the missing ones. To validate both the missing and upgradeable inquiries, the user will need to select "More" -> "Validate Inquiries" in the connection manager. The message about the upgradeable / missing inquiries was made clearer and less confusing. 1795

If a particular Velixo feature is unavailable under the current license, the product will direct the user towards a contact with Velixo. 1836 1840

Improved error messaging for the "403 Forbidden" error during refresh and inquiry configuration, indicating that it is not a problem with Velixo, but with the ERP access rights configuration. 1773 1819 1895

When specifying the connection URL, Velixo will now follow HTTP redirects and replace the connection URL with the final redirect location. 1799

Velixo Reports will not automatically propose to upgrade the customization project every time a new customization package is available for download. Instead, there is now a "minimum required customization version" information defined in every Velixo version itself; therefore, Velixo will offer to update the customization package if (and only if) it is a required update for an updated Velixo version. We will also strive to avoid or minimize such required updates and prompts. 1801

Tenants with a trailing dot in the name can now be accessed from Velixo. 1817

VBA refresh call-backs are now supported even when a distribution list was invoked via Velixo's CLI tool. 1837

"Hide zero rows" now works on spilled array results, too. 1902

Filling out both Debit and Credit fields in GL writeback is not required anymore, it is enough to fill either of those. 1907

Supported best match / possible value hints in the WRITEBACK function. 1956 1958

Velixo ribbon labels have been compacted to ensure that it is not collapsed on a 15" laptop. 2049

Hidden sheets will be ignored when distributing the report in the PDF format. 2081

Got rid of the screen flicker when creating a new generic writeback worksheet. 2086

Formula-based budget writeback now supports a single Excel cell range with the by-period budgeted amounts. 2093

GILOOKUP(F) became "dynamic aware" - it will output an array whenever one or more of its arguments is also an array. 2096

Important access rights related exceptions will be duplicated as a pop-up in addition to being displayed in the cell. 2099

Drill-down now supports legacy Ctrl+Shift-Enter (CSE) arrays. 2131

Drill-down result worksheet could display incorrect source cell addresses under certain conditions. 2127

It was impossible to create a generic writeback worksheet when scenario retrieval failed and the user was prompted to enter the screen ID manually. 2101

On certain files, the drill-down process did not set the "To" date when opening transactions in Acumatica.

Generic writeback: an IndexOutOfRange exception happened when importing multiple records with varying number of columns. 2041

The user could see a confusing error message if they passed an unsupported value into the IncludeUnposted argument in balance functions. 2014

Fixed a race condition affecting resource-constrained computers and preventing Refresh in some scenarios. 1952

When "load the full inquiry dataset and apply filters locally" option was enabled, GI filtering on date/time values incorrectly applied the local time zone instead of UTC. 1935

Retrieving unposted GL balances, or posted GL balances by date could bypass the restriction groups set up in the ERP system. 1945

Focus could shift from Excel to Windows Explorer upon performing writeback.

Getting a GL drill-down summary through VBA resulted in an error. 1913

A COM exception sometimes occurred on Refresh on complex WRITEBACK formulas. 1873

"Thread is not main" exception occurred sometimes when createing a writeback worksheet. 1884

When creating a generic writeback worksheet, after the user changed the connection in the drop-down, a scenario retrieval error could be shown for the previous connection. 1830

When distributing specific sheets only, the source workbook theme was not applied to the destination workbook. 1815

Fixed incomplete user-triggered cancellation during the inquiry configuration process. 1811

Velixo could complain that the user had not specified a project task code during GL writeback whenever non-project code "X" was specified. 1797

The lines in multi-line error messages will not be glued together in Excel cells anymore. 2016

Sometimes Velixo erroneously complained about an outdated customization project version when it was not even installed. 1762

When entering Velixo formulas in-cell, the best match and other possible values were not displaying. 1760

The single sign-on architecture was revamped to minimise the "invalid grant" errors frequently experienced by some of our users. 2020

The generic writeback formula did not return an error message when the field names argument was omitted. 1788

Distribution List could crash Microsoft Excel in certain scenarios. (#1809)

Drill-down support restored for non-365 versions of Microsoft Excel. (#1776)

Distribution List could crash Microsoft Excel in certain scenarios when worksheets were protected and contained external links. (#1767)

Fixed a 404 error upon connection affecting a small number of customers. (#1754)

In multi-connection workbooks, during generic writeback template creation, the import scenario list could be displayed for a wrong connection. (#1746)

Subaccount was always required in GL budget writeback, which makes no sense when the subaccounts feature is disabled. (#1744)

Generic Writeback functionality, allowing you to import data from Excel using any predefined Acumatica import scenario! Use the new "Generic Writeback" Ribbon button to create an import worksheet.

A "refresh finished" callback is now exposed by Velixo's VBA class, which can be used to reliably track when Velixo functions finished calculating.

During connection, Velixo will detect if someone accidentally removed a column from critical Generic Inquiries set up and used by the product. (#1510)

For customers using a Velixo customization package, to keep screen IDs consistent, you will not be able to re-create the inquiries from the Connection Manager anymore; you will need to re-publish the customization package. (#1547)

In a Distribution List, columns prefixed with an exclamation mark (!) will be ignored during distribution. This can be helpful for intermediate calculations. (#1559)

Clearer error reporting in formula-based GL budget writeback (#1394) and project forecast writeback. (#1424)

Added best match / possible matches IntelliSense support for the Company argument in Velixo functions. (#1656)

Significantly improved performance for worksheets containing multiple GILOOKUP functions. (#1661)

Better handling of spaces in Tab Selection in a Distribution List. (#1408)

Improved required fields validation to GL writeback. (#1410, #1666)

Velixo will now correctly display start and end dates for adjustment periods. (#1580)

Redundant rightmost spaces are now trimmed in ACCOUNTS...WITHHISTORY() functions. (#1431)

For companies using multiple base currencies, Velixo will report an error if one tries to aggregate ledgers with different currencies in ACCOUNTENDINGBALANCE() and other balance functions. (#1433)

Auto-Hide Zero Rows / Columns now triggers fewer times and more reliably. (#1430)

SUBACCOUNTNAME() will now return N/A for non-existent subaccounts when "Return zero..." workbook option is specified. (#1462)

Better error reporting in FINANCIALPERIOD() function for cases the resulting period is not set up in the system. (#1468)

Velixo will now prevent unnecessary new cross-file links after running a Distribution List with tab selection. (#1573)

Added important access rights warnings before and after Velixo adds/upgrades Generic Inquiries in Acumatica. (#1598)

For functions expecting a TRUE/FALSE value, Velixo now also supports "Yes" and "No". (#1693)

In formula-based project forecast writeback, the status of an invalid line could sometimes be displayed in front of a valid one. (#1406)

Argument names could be displayed incorrectly for functions with variable number of arguments - for example, GIFILTER(). (#1419)

Drill-down was not working on formulas using FINANCIALPERIODOFFSET(). (#1428)

Accounts having both posted and unposted transactions were excluded by ACCOUNTS...WITHHISTORY invoked with the "Posted only" flag. (#1441)

"Thread is not main" error sometimes occurred when one opened the Options window while refreshing. (#1443)

"Value cannot be null" error occurred when Velixo's XLL was manually attached to an already running instance of Microsoft Excel. (#1445)

Smart Refresh in GI() was not working when the supplied OData filter expression contained a top-level "OR" condition. (#1448)

A Velixo refresh invoked from VBA with AsyncCalculations = False could lead to Excel window closing. (#1452)

An error occurred if a blueprint column was referenced in a Distribution List, but that column contained an empty value. (#1559)

When opening a file for which connection credentials were not remembered, the single sign-on button was sometimes missing in the connection editor. (#1585)

And invalid connection name was not validated when a file was saved under a different name. (#1582)

Velixo could take a long time to produce a connection error when the computer was connected to a network without Internet access. (#1588)

Incorrect totals were displayed for Project module rows in case the drill-down dataset contained both GL and Project functions. (#1672)

The VBA method GetGLDrilldownSummary was not working correctly. (#1704)

In case the user didn't have enough access rights to Velixo inquiries, they could see a misleading message about the customization project being outdated. (#1645)

Multiple fixes and stability improvements for COM exceptions observed occasionally during start-up, shutdown, writeback, or distribution.

Resolved a calculation issue affecting users running reports with multiple connections to instances or tenants sharing the same chart of accounts. You can skip this update if your reports only contain a single connection.

New formula-based GL Budget Writeback worksheets, which allow one to reorganize writeback layouts and write back to multiple ledgers, branches, and/or years simultaneously.

GL Budget Writeback now supports being authenticated through Single sign-on.

New FINANCIALPERIODOFFSET() function, which allows you to add or subtract a given number of periods from a financial period.

New EXPANDCOMPANYRANGE() function, displaying the list of companies satisfying a Velixo range expression.

An option was added to determine how blank rows should be handled after Hide Zero Rows. The choice is among three possible strategies: to keep all blank rows; to hide all blank rows; and to hide consecutive blank rows, keeping at most one.

New parameters added to the ACCOUNTSANDSUBACCOUNTSWITHHISTORY() function and the ACCOUNTSWITHHISTORY() function:

New command-line helper to facilitate scheduled distribution of reports through the Windows Task Scheduler.

Drill-down view will always keep separate the history records from different source cells.

Asset / Liability balance calculations for budget ledgers will refrain from using last year's balances in case no corresponding budget record exists in the specified financial year. This is consistent with Acumatica behavior: since amounts are budgeted individually for each financial year, there is no ending balance transfer across financial years even for Asset/Liability accounts.

Improved GI() error messages in case the user removes a column from a generic inquiry.

VBA: one can now enable synchronous calculations upon updating cell values. This ensures that Velixo functions have finished calculating before executing any dependent logic.

The validation of sheet names in distribution lists is no longer case-sensitive.

Report distribution blueprints are now created in the specified order (rather than reverse order).

On a rare occasion, Excel could crash during balance calculations due to a concurrency issue.

Some array returning functions, such as EXPANDACCOUNTRANGE, did not expand properly on non-dynamic-aware versions of Excel (pre-Office 365).

It is now possible to use GI functions when working offline.

During Refresh, pivot tables were being refreshed before calculations finished, resulting in incorrect pivot data.

Under some circumstances, Excel could stop while executing Velixo scripts with DisplayAlerts = false.

It is now possible to copy workbook without formulas on protected worksheets.

Reversed Account Balance Sign option does no affect Asset and Expense account signs in drill-down.

Fixed an issue which could result in an error when creating a distribution list on the French version of Velixo.

Improved the performance of Hide Zero Rows/Hide Zero Columns on very large sheets.

Added an alternative algorithm for the Excel (remove all formulas) option of report distribution that can be enabled through Workbook options.

Automatic refresh of Pivot Tables can now be configured from a Distribution List.

Budget Writeback was failing on versions of Acumatica newer than 2020 R2 Update 7 (20.207+) and 2021 R1.

On a new spreadsheet, users could see an incorrect error message when entering an invalid connection name in formulas.

The Distribution List feature now allows you to generate multiple worksheets from a single template sheet

When emailing reports from a Distribution List, the email body can now be drawn directly from a cell range or named region within the report being sent.

You can also now calculate balances for posted transactions, unposted transactions, or both!

Hide Zero Rows and Hide Zero Columns settings are now automatically reapplied after a refresh or a recalculation and you can manually reapply those settings after using Excel’s row filters.

The new ACCOUNTSANDSUBACCOUNTSWITHHISTORY function displays the combination of those accounts and subaccounts which have transaction dates within your specified financial periods.

New COLLATE function, giving you the ability to join multiple ranges and arrays into a single table-like dynamic array.

Project Forecast Writeback

When working with multiple financial periods, the FINANCIALPERIODLIST function now supports displaying financial periods in descending order.

GL Writeback now supports the Create Tax Transactions feature.

New option in the application ribbon to remove Velixo and/or Excel functions from your report with the ability to automatically save the copy to the same folder as your original.

Improved formula auto-complete: Parameter suggestions are now provided for possible values when entering Velixo functions. Pressing F2 automatically picks the best match, when available.

Single Sign-on now uses your default browser for the authentication process.

Per-machine installation support for Citrix, Terminal Server and other multi-user environments.

Experimental support for Generic Inquiry functions in pre-Excel 365 versions.

Multiple performance and reliability improvements.

Pivot tables are now automatically refreshed after applying parameters in report distribution.

The "Open Draft" e-mail delivery option in report distribution no longer blocks the process until you close or send the draft and continues with other items item list.

Re-introduced the ability to force client-side filtering in Generic Inquiry in the Generic Inquiry options screen.

Error messages related to access rights and unsupported filtering options are now clearer and more actionable for end-users.

Blueprint Worksheets functionality has been restored.

IntelliSense was not providing argument suggestions in nested functions.

Report Distribution now automatically reapplies column filters to ensure changes to the data are reflected in the generated reports.

Resolved an issue introduced in the last update that was preventing client-side filtering by date when using GIFILTER.

Text formatting was sometimes affected when using 'Copy Workbook without formulas'.

Resolved an issue that occured when using 'Copy Workbook without formulas' on a filtered table.

Improved handling of date-based GL calculations when transactions are posted to past or future financial periods.

Resolved an issue that was affecting filtering by date using GIFILTER when the local time zone was different from the server time zone.

ACCOUNTCLASSLIST() now returns #N/A instead of throwing an exception when the account class contains no accounts.

Users logged in via single sign-on sometimes had to login again even when 'Remember Me' was checked.

Resolved an error that occured when using the GI() function with a generic inquiry that has duplicate column names (with different casing), such as MP-PayActivityDetail in MYOB Advanced People.

Multiple performance and stability improvements.

Resolved a problem that could cause Excel to close unexpectedly during a large copy-paste or refresh operation.

Resolved an error that would occasionally show up after writing back a project forecast.

Excel would hang when using Velixo functions through VBA.

When emailing reports from a Distribution List, the email body can now be drawn directly from a cell range or named region within the report being sent.

enhanced support for “Per-Machine” installations for use in multi-user and virtual desktop environments such as Citrix or Remote Desktop Services (formerly known as Terminal Services).

New TEXTSPLIT() function.

Velixo now informs you when the customization project installed on your instance is outdated.

GIFILTER() no longer trims spaces automatically in filter criterias.

Resolved an issue during report distribution that would cause #N/A# to be displayed in the resulting file.

Dialog boxes sometimes opened behind the current window.

Blueprint Worksheets in Distribution List - use one tab in the source report to generate multiple tabs with different parameters in the resulting report. Learn more here.

Improved the performance of the Copy Workbook without Formulas function.

Improved the responsiveness of the application during report distribution.

Added an option to remove all formulas in the main application toolbar; the default is to remove Velixo formulas only.

Added a Reveal Password button in the Connection Editor.

The status bar now updates more quickly when refreshing a report.

Added a fallback mechanism to process GI filters (locally) when they cannot be processed directly by the server (such as filters on formula fields).

Improved the performance of the auto-hide rows/columns feature.

Resolved the 'Busy' error that occasionally occurred when refreshing reports.

Resolved an error that could occur while saving a file as a copy to a remote network share over a slow connection.

Automatically close the browser window at the end of the single sign-on process.

Resolved an issue with GI filtering that would cause the function to return #N/A# when filtering.

Resolved an error that could occur when opening the Generic Inquiry options screen.

Added the ability to include unposted/unreleased transactions in account balance calculations.

The new COLLATE() function lets you join together multiple ranges and arrays into a single dynamic array.

Single sign-on now uses your default web browser to authenticate.

Simplified the configuration of the Velixo Reports caching mode for Generic Inquiries.

List and generic inquiry functions may now be used with every version of Excel 2007 or higher. Due to some limitations in older versions of Excel, your application may pause while the Velixo function is being evaluated.

Improved the performance of Hide Zero Rows / Hide Zero Columns.

Added a button to reapply the auto-hide logic for rows/columns; this is useful when using row filters in Excel.

The FINANCIALPERIODLIST is now able to return financial periods in descending order.

GL Writeback now waits for completion of the Release process and displays any error message that may have occurred.

Copy Workbook Without Formulas now defaults to the directory of the currently open file.

Opening another file now preserves the existing in-memory cache and avoids an unnecessary refresh.

Improved refresh performance over slow/unreliable connections.

Resolved an error which could occur when using the FINANCIALPERIOD function with a period formatted as text instead of a number (ex: '09)

Resolved an issue which could cause the refreshing to stop when you have multiple connections refreshing simultaneously in a workbook.

Resolved an issue where Copy Workbook Without Formulas would not complete when there were hidden sheets or hidden rows/columns in a dynamic array range.

The PROJECTENDDATE function now returns a blank value instead of an error message when the end date is not set.

Resolved an issue that was causing connection information to be lost when saving a copy of a file to a network share over a slow connection.

ACCOUNTSWITHHISTORY and ACCOUNTSANDSUBACCOUNTSWITHHISTORY now trim trailing spaces after account and subaccount codes like other functions.

Resolved a performance issue with Smart Refresh of GL History.

Resolved an issue that was preventing users from refreshing some files from the toolbar.

It is now possible to save distributed reports directly to SharePoint by entering the http/https path in the Distribution list.

It is now possible to drilldown on cells in protected sheets. This applies to the formula of the selected cell only; due to a limitation in Excel, it is not possible to navigate precedents and access cells that may be referenced by the current formula.

Trying to write back a budget to a financial year that does not exist now results in a clear error message.

The FINANCIALPERIOD function now ignores the leading 0 in period number (ex: 09) instead of returning an error.

Resolved a performance issue with Smart Refresh of GL History.

Resolved an issue opening files from a drive mapped to a SharePoint share.

Under some conditions, refreshing a spreadsheet could hang.

Dialog boxes and update dialogs were sometimes opening behind the current window, preventing the user from interacting with them.

New UNIQUEBYPATTERN function to reduce the list of subaccount and other segment values pattern.

When drilling down on a cell that calculates an account balance by cell, View Transactions now sets the Start Date and End Date filters automatically.

Improved the performance of drilldown.

The subtraction operator is now supported with the account class argument (ex: ININTEREST;-EXINTEREST).

In distribution lists, you can now use select the folder path visually.

The shortcut to automatically use the best match in Intellisense was changed from F4 to F2 to avoid conflicts with Excel.

Insert Chart of Accounts works again in data tables; we insert a static list since dynamic array functions can't be used in data tables.

Your Hide Zero Rows / Hide Zero Columns selections can now be memorized and automatically reapplied after a refresh or a recalculation.

GL Writeback now supports the Create Tax Transactions feature.

Automated refresh of external data sources is no longer ON by default and can be configured from Workbook Options.

Improved the responsiveness of the Velixo custom functions.

The native SQLite library used by Velixo is now digitally signed to avoid issues with BitLocker or Malware Bytes.

Resolved an error with the ACCOUNTSANDSUBACCOUNTSWITHHISTORY function.

Added the ability to calculate account balances by date.

Improved financial period validation in ACCOUNTTURNOVER, ACCOUNTTOTALDEBITS, ACCOUNTTOTALCREDITS.

Intellisense improvements.

Added support for Acumatica 2020 R2.

Intellisense now suggests possible values for Velixo function arguments.

Resolved an issue that could cause Excel to crash while editing a formula.

Resolved an issue preventing the Options screen from opening.

Resolved the error that occurred when trying to import a budget using the Budget Writeback functionality.

Added the ability to import multiple project forecast worksheets simultaneously.

New ACCOUNTSANDSUBACCOUNTSWITHHISTORY function to build dynamic trial balances by account and subaccount.

Added support for project forecast writeback.

When adding up a new connection, we now automatically remove unneeded sub-paths such as /Frames/**** from the URL.

When adding up a new connection, we now validate the tenant name for unsupported characters.

Resolved an issue with smart refresh.

Resolved 'Busy' errors that would sometimes occur while refreshing after changing the configuration of a generic inquiry.

Improved handling of very long generic inquiry filters.

Resolved an error that could occur while using the report distribution feature.

Improved performance and responsiveness of the user interface during refresh.

Resolved an issue with dates during writeback on non-US English systems.

Resolved an issue with subaccount ranges and validation when subaccount codes have a variable length.

Resolved an error with the Insert Chart of Accounts button.

The GI() function is now available on all versions of Excel and will return a clear error message if dynamic arrays functionality is unavailable.

This is the final version of Velixo Reports 5.0 that will be pushed to every customer. You can remain on the insider build to continue receiving early access to new Velixo features or switch to the official release channel by downloading the appropriate release.

Resolved an issue with the ACCOUNTCLASSLIST function.

The BRANCHLIST function now allows you to specify multiple companies in a range.

Improved error handling of generic inquiry functions.

Project functions now allow you to retrieve the amounts in the project currency by setting the UseProjectCurrency argument to TRUE.

Added a new set of list functions (EXPAND****) functions to retrieve dynamic lists of accounts, branches, projects, etc.

Multiple performance and stability improvements with the new generic inquiry functions.

The configuration of key fields for generic inquiries can now be done visually.

The GIFILTER function now allows you to specify multiple values to be joined via a logical "OR" as part of a bracketed group.

Resolved an issue that could cause Excel to hang during the refresh of a workbook containing generic inquiry functions.

Added a new GIFILTER() function to simplify filtering operations on generic inquiries.

The ACCOUNTCLASSLIST() function now takes into account the subtraction operator.

It is now possible to cancel an ongoing refresh from the Refresh menu.

Under some conditions, files generated from a distribution list required a recalculation on opening which would fail if the user does not have Velixo Reports installed.

Drilldown now considers the use of the subtraction operator, and automatically excludes accounts that have been excluded from the range.

Multiple performance and stability improvements with single sign-on.

Multiple performance and stability improvements with the new generic inquiry functions.

Changed how GI configuration is stored. ***IMPORTANT*** You will be asked to reconfigure the options of any generic inquiry you had previously setup the first time you refresh a spreadsheet using this version.

Multiple performance and stability improvements with the new generic inquiry functions.

It's now possible to include every item in a range by using the "*" character. This is useful when you a have variable length identifier and you want to include everything except a few items, for example exclude a few branches in a GL calculation. Example: *;-SOMEBRANCH;-ANOTHERBRANCH

Resolved multiple issues with the new generic inquiry functions and the associated GI options screen.

Improved the generic inquiry options screen.

Resolved an issue during initial installation that was causing the progress indicator to disappear during generic inquiry configuration.

GI(), GILOOKUP() and GILOOKUPF() functions make it easy to work with any generic inquiry from Velixo Reports. Please note that you must be on the Office 365 version of Excel (Monthly Channel) with the new Dynamic Arrays feature to be able to use the GI() function.

It's now possible to login to Acumatica using single sign-on. Acumatica 2019 R2 or later is required. Please contact us for setup instructions. Note: Budget Writeback not supported at the moment when logged in via single sign-on.

Added a new ACCOUNTCONSOLIST() function to retrieve the list of accounts based on a range of consolidation accounts.

Added new functions to retrieve Project Forecasts. Requires Acumatica 2019 R1 or later.

The Return Zero Values option now works in conjunction with financial periods. When enabled, functions that reference a financial period that does not exist will return 0 instead of an error.

It's now possible to intersect a range with another range by using the "^" character in any range. This is useful when you have a filter at the row-level, and another one at the column-level that you want to combine and ensure that you only include subaccounts that match both filters. For example, the following range: CON-???-???^???-123-??? would only return subaccounts that have CON as the first segment and 123 as the second segment.

Added the ability to attach files during report distribution; the path of the files to be attached needs to be set in the Attachments column. Separate multiple files by a semicolon if you need to attach multiple files.

Custom columns added to a GL Writeback worksheet are now uploaded to Acumatica. The column name must match the internal field name in Acumatica.

Increased the number of concurrent connections to speed up refresh on multi-connection reports

The user interface now shows up in French for users of a French version of Excel.

Enhanced Copy Workbook without formulas to work on protected sheets as well. The system will prompt you for a password if the sheets are password-protected.

Drilldown to project transactions now shows all inventory items when the summary is for the item.

Resolved an issue with report distribution in workbooks that contain chart-type sheets.

Resolved an issue preventing the "Copy Workbook Formulas" and Distribution list features to work on files shared to OneDrive.

Hide Zero Rows and Hide Zero Columns now available through VBA.

Added support for segmented account codes, cost codes, inventory items.

Improved validation of invalid items in ranges.

Resolved an issue with the Options screen when running Excel with a non-English language pack.