Skip to main content

Home
Forums
Submit a ticket

Main

Home
Forums
Submit a ticket

Main

Functions

Dimension functions

BC.BUDGETDIMENSIONS
BC.DIMENSIONNAME
BC.DIMENSIONS
BC.DIMENSIONVALUENAME
BC.EXPANDDIMENSIONRANGE
BC.EXPANDDIMENSIONVALUERANGE

Financial functions

BC.ACCOUNTCATEGORY
BC.ACCOUNTNAME
BC.ACCOUNTSUBCATEGORY
BC.BUDGETDESCRIPTION
BC.BUDGETTURNOVER
BC.CLOSINGBALANCE
BC.CREDITS
BC.DEBITS
BC.EXPANDACCOUNTRANGE
BC.EXPANDACCOUNTSUBCATEGORYRANGE
BC.EXPANDBUDGETRANGE
BC.OPENINGBALANCE
BC.TURNOVER

Query functions

BC.EXPANDOBJECTRANGE
BC.EXPANDTABLERANGE
BC.OBJECTDEFINITION
BC.QUERY
BC.QUERYFILTER
BC.QUERYTABLE
BC.QUERYTABLEFILTER
BC.TABLEDEFINITION

System functions

COLLATE
CONNECTIONINFO
EXPANDCONNECTIONRANGE
TODAYNV
TOTABLE
UNIQUEBYPATTERN
VELIXOVERSION
VX.ANALYSIS
VX.SETTINGS
VXTEXTSPLIT
WORKBOOKLASTREFRESHBY
WORKBOOKLASTREFRESHDATE

Writeback functions

BC.WRITEBACK
BC.WRITEBACKBUDGET
BC.WRITEBACKJOURNAL
WRITEBACKCOMMIT

Getting Started

Connecting Velixo NX to MS Dynamics 365 Business Central
Create your first Velixo report for MS Dynamics 365 Business Central
Getting started with Velixo NX
Installing, removing and updating the Velixo Business Central extension
Velixo NX Free Trial

Release Notes

Release Notes Archive

Velixo NX 2025.10 Release Notes
Velixo NX 2025.11 Release Notes
Velixo NX 2025.12 Release Notes
Velixo NX 2025.7 Release Notes – Business Central
Velixo NX 2025.8 Release Notes – Business Central
Velixo NX 2025.9 Release Notes
Velixo NX 2025.9 Update Pack Release Notes

Velixo NX 2026.1 Release notes

Templates

Downloading Report Templates
Dynamics 365 Business Central Template register
Introduction to Report Templates

Troubleshooting

ERP Connection & data discrepancies

Drilldown results for the SUBTOTAL function include hidden cells
Error 403 Forbidden (while connecting to data)
Understanding external server connections

Functions & formulas

Error: "Text values in formulas are limited to 255 characters"
Error: "This function is not supported by your version of Excel"
Error: #N/A displays first when entering a Velixo function
Error: #NAME? is displayed when report is shared with others
Error: Argument size mismatch
Functions appear as text and do not refresh
Velixo functions only return a single result when combined with TEXTSPLIT

General errors & miscellaneous

#SPILL error instead of formula results
#VALUE! or #N/A error in cells with Velixo formulas
Comparing Velixo NX and Velixo Classic
Error: Unable to set the NumberFormat property of the Range class
Excel Undo feature is not working as expected
How does Velixo work?
How Excel UNDO works with multiple workbooks
Message: Macros have been disabled
Subscribe to the Velixo Newsletters
The file format and extension Of 'VelixoReportsPro64.xll' don't match
Velixo does not use Log4J
Worksheet and Workbook Protection with Velixo reports

Installation & setup

Antivirus software flags Velixo installer or workbook
Deactivate the Velixo add-in
Files created or updated in Velixo NX open in Velixo Classic
How to determine if Excel is 64-bit or 32-bit
Lotus Settings Not Compatible with Velixo
Site accessibility & firewall considerations (Error 404 or Load Failed)
Velixo NX does not appear in Excel after installation (migrating from Velixo Classic)
What edition and version of Velixo do I have?

Login, licensing & authentication

Error "Please enter a valid email address" appears in the registration form when signing in to Velixo for the first time
Granting admin consent for access to all Velixo NX functionalities

Performance & resource issues

Error: Not enough memory resources are available to complete this operation

Writeback, Distribution and other Velixo features

A privacy warning appears each time a file is distributed; cancelling the warning stops distribution
Error: The Save button is disabled during Journal/Budget Writeback
Slice: Substitute combinations of parameters and skip "irrelevant" combinations

User guides

Advanced Topics

Message: Let this app access your info?

Constructing reports and distribution

Creating dynamic dropdown lists
Creating interactive reports with pulldown lists
Embedding your Velixo Data within PowerPoint
Filtering techniques for use with many Velixo functions
Ignore an area for the Formulas to Review panel
Multiple connections per formula
Naming cells/ranges in Excel
Open a Velixo report from a link in an Excel workbook
Sharing Reports - FAQ
Using arrays or cell references as parameters in GL functions

Using custom VBA macros

Introduction to Velixo NX VBA commands
VBA commands: Refresh
VBA commands: RefreshFull
VBA commands for NX: HideZeroRowsAsync
VBA commands for NX: UnhideAllAsync
VBA commands for NX: RunDistributionListAsync
VBA commands for NX: HideZeroColumnsAsync
VBA commands for NX: CopyWorkbookWithoutFormulasAsync
VBA commands for NX: WritebackWorksheetAsync
VBA commands for NX: WritebackCurrentWorksheetAsync

Using Distribution Lists with Velixo NX
Using the Intersection operator ( ^ )

Guides for partners

Escalation process for VAR partners
Implementation process for VAR partners
Partner resources for Marketing, webinars and presales demos
Sales & Engagement process for VAR partners

Installation, updates and requirements

Controlling Velixo NX installation in your organization
Installing Velixo Tools
Saving Connection information for future access
Uninstalling Velixo NX
Using Velixo on ARM-based PCs
Velixo NX minimum requirements and usage notes
Velixo Technical Exit & Provider Switching Documentation

Reference

Clear Cache
Connection Manager
Drilldown
Drilldown for MS Dynamics 365 Business Central
Features specific to Velixo NX
Freeze / Unfreeze
Hide Zero Rows / Columns
Insert Chart of Accounts
Options
Refresh
Refresh features (NX)
Slice
Snapshot
Status
Table Mirroring
Velixo NX interface

Support and definitions

Self-troubleshooting techniques
Refreshing the Velixo license
Velixo Support guide and SLAs
Difference between Support and Services
How to provide feedback?
How to submit a ticket?
How to Safely Share Customer Credentials with Velixo Support

Using Generic Inquiries

Velixo Portal

Managing admins and features within organizations
Managing ERP Tenant connections, users, and admins
Portal Overview

Writeback-related

Breadcrumbs

Home
User guides
Constructing reports and distribution

On this Page

Using custom VBA macros

Introduction to Velixo NX VBA commands
VBA commands: Refresh
VBA commands: RefreshFull
VBA commands for NX: HideZeroRowsAsync
VBA commands for NX: UnhideAllAsync
VBA commands for NX: RunDistributionListAsync
VBA commands for NX: HideZeroColumnsAsync
VBA commands for NX: CopyWorkbookWithoutFormulasAsync
VBA commands for NX: WritebackWorksheetAsync
VBA commands for NX: WritebackCurrentWorksheetAsync

Terms of Use
Privacy Policy
Legal

Copyright Velixo. All rights reserved
Powered by Scroll Sites & Atlassian Confluence