Skip to main content
Home
Forums
Submit a ticket
Acumatica
Business Central
Sage Intacct
STACK Takeoff & Estimate
Velixo Classic
Main navigation
Close navigation
Acumatica
Business Central
Sage Intacct
STACK Takeoff & Estimate
Velixo Classic
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
Getting started with Writeback
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
Velixo NX 2026.2 Release notes
Velixo NX Releases
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
Templates
Financial Templates
On this Page
Business Central Financials
