Skip to main content

Home
Forums
Submit a ticket

Main

Home
Forums
Submit a ticket

Main

Functions

Dimension functions

SI.CUSTOMERNAME
SI.DEPARTMENTNAME
SI.DIMENSIONS
SI.EMPLOYEENAME
SI.EXPANDCLASSRANGE
SI.EXPANDCUSTOMERRANGE
SI.EXPANDDEPARTMENTRANGE
SI.EXPANDEMPLOYEERANGE
SI.EXPANDITEMRANGE
SI.EXPANDLOCATIONRANGE
SI.EXPANDUDDVALUERANGE
SI.EXPANDVENDORRANGE
SI.EXPANDWAREHOUSERANGE
SI.ITEMNAME
SI.LOCATIONNAME
SI.UDDVALUEID
SI.VENDORNAME
SI.WAREHOUSENAME

Financial functions

SI.ACCOUNTNAME
SI.ADJCREDITS
SI.ADJDEBITS
SI.BUDGETABLEPERIODBYDATE
SI.BUDGETTURNOVER
SI.CLOSINGBALANCE
SI.CONSOLIDATIONBOOKDESCRIPTION
SI.CREDITS
SI.DEBITS
SI.EXPANDACCOUNTGROUPRANGE
SI.EXPANDACCOUNTRANGE
SI.EXPANDACCOUNTSINGROUP
SI.EXPANDBUDGETRANGE
SI.EXPANDCONSOLIDATIONBOOKRANGE
SI.EXPANDGLHISTORY
SI.EXPANDPERIODRANGE
SI.EXPANDTAXDETAILSRANGE
SI.EXPANDTAXSOLUTIONRANGE
SI.EXPANDUSERBOOKRANGE
SI.OPENINGBALANCE
SI.PERIODENDDATE
SI.PERIODSTARTDATE
SI.TAXRATE
SI.TURNOVER
SI.USERBOOKDESCRIPTION

Project functions

SI.CLASSNAME
SI.COSTTYPENAME
SI.EXPANDCOSTTYPERANGE
SI.EXPANDPROJECTESTIMATERANGE
SI.EXPANDPROJECTESTIMATETYPERANGE
SI.EXPANDPROJECTRANGE
SI.EXPANDSTANDARDCOSTTYPERANGE
SI.EXPANDSTANDARDTASKRANGE
SI.EXPANDTASKRANGE
SI.PROJECTENDDATE
SI.PROJECTESTIMATEAMOUNT
SI.PROJECTESTIMATEDESCRIPTION
SI.PROJECTESTIMATEQUANTITY
SI.PROJECTNAME
SI.PROJECTSTARTDATE
SI.PROJECTSTATUS
SI.TASKNAME

Query functions

System functions

COLLATE
CONNECTIONINFO
EXPANDCONNECTIONRANGE
SI.GETATTACHMENTS
SI.GETATTACHMENTSBYID
SI.TRANSACTIONDRILLDOWN
TODAYNV
TOTABLE
UNIQUEBYPATTERN
VELIXOTOOLSVERSION
VELIXOVERSION
VX.ANALYSIS
VX.SETTINGS
VXTEXTSPLIT
WORKBOOKLASTREFRESHBY
WORKBOOKLASTREFRESHDATE

Writeback functions

SI.WRITEBACK
SI.WRITEBACKBUDGET
SI.WRITEBACKJOURNAL
SI.WRITEBACKPROJECTESTIMATE
SI.WRITEBACKWIP
WRITEBACKCOMMIT

Getting Started

Configure Single Sign-on for Sage Intacct
Connecting Velixo NX to Sage Intacct
Create your first Velixo report for Sage Intacct
Getting started with Velixo NX
Getting started with Writeback
Permissions for refreshing a Sage Intacct report
Sage Intacct configuration prerequisites
Training through Velixo Academy
Velixo NX Free Trial
Velixo Sample Reports for Sage Intacct

Release Notes

Release Notes Archive

Velixo 2023.12 release notes
Velixo NX 2023.10 Release Notes - Sage Intacct
Velixo NX 2023.12 Release Notes - Sage Intacct
Velixo NX 2023.6 Release Notes - Sage Intacct
Velixo NX 2023.8 Release notes - Sage Intacct
Velixo NX 2024.11 Release notes - Sage Intacct
Velixo NX 2024.12 Release Notes – Sage Intacct
Velixo NX 2024.2 Release Notes - Sage Intacct
Velixo NX 2024.4 Release Notes - Sage Intacct
Velixo NX 2024.7 Release Notes – Sage Intacct
Velixo NX 2024.9 Release Notes – Sage Intacct
Velixo NX 2025.10 Release Notes
Velixo NX 2025.11 Release Notes
Velixo NX 2025.12 Release Notes
Velixo NX 2025.2 Release Notes – Sage Intacct
Velixo NX 2025.3 Release Notes – Sage Intacct
Velixo NX 2025.4 Release notes - Sage Intacct
Velixo NX 2025.5 Release notes - Sage Intacct
Velixo NX 2025.6 Release Notes – Sage Intacct
Velixo NX 2025.7 Release Notes – Sage Intacct
Velixo NX 2025.8 Release Notes – Sage Intacct
Velixo NX 2025.9 Release Notes
Velixo NX 2025.9 Update Pack Release Notes
Velixo NX Release notes 2020-2021 Archive
Velixo NX Release notes 2022 Archive
Velixo NX Release notes 2023 Archive

Velixo NX 2026.1 Release notes
Velixo NX 2026.2 Release notes
Velixo NX Releases

Templates

Sage Intacct Report Templates register

Samples

Job Summary Sample Template - Sage Intacct

Understanding Sage Intacct's Account categories' use in Templates

Demo

Construction template demo - Cost to Complete (Amount)
Financials Demo report templates - Sage Intacct

Downloading Report Templates
Introduction to Report Templates

Troubleshooting

ERP Connection & data discrepancies

Balance functions like always return zero for a dimension, while you are able to filter by that "dimension" using the GLDETAIL object
Drilldown results for the SUBTOTAL function include hidden cells
Error 403 Forbidden (while connecting to data)
Error: 504 or Load Failed connecting to your ERP
Error: An unexpected error occurred while requesting data from Sage Intacct
Error: Can't Contact The Server
Error: Request retry count exceeded. Max retry count: 5
Error: XL03000012 A payment is due for the company ID
Message: Connections are a little busy
SI.BUDGETTURNOVER retrieves positive numbers, while the values in Sage Intacct are negative, and vice versa
The following inquiries are not set up (NX)
Understanding external server connections
Velixo couldn't reach any of its web service endpoints
Velixo Dimension group created in Sage Intacct
Manual entries in mirrored SI.QUERY tables are missing after refresh

Functions & formulas

#CALC! errors - This calculation is not supported by this version of Excel
#NAME? displays for all Velixo NX functions
255-character limit for arguments of a function e.g. SI.QUERY()
Error 403: #N/A error when using Velixo NX function
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
Sage Intacct does not support querying the field
SI.EXPANDGLHISTORY displays "null" instead of an empty cell
Velixo field names do not appear in the Excel function wizard
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: DL02000001 There was an error processing the request
Error: Unable to set the NumberFormat property of the Range class
General recovery guide for sporadic issues with Velixo NX
How does Velixo work?
How Excel UNDO works with multiple workbooks
Message: Macros have been disabled
Predefined dimensions... do not exist or are disabled in your company
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
Error: Error Loading Add-Ins (on Mac)
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
Manually Activating Velixo Tools
Site accessibility & firewall considerations (Error 404 or Load Failed)
Velixo NX does not appear in Excel after installation (migrating from Velixo Classic)
Warning: The Office Extensibility Library failed to load
What edition and version of Velixo do I have?

Login, licensing & authentication

Cannot sign in to Velixo when opening a workbook in Teams
Error "Please enter a valid email address" appears in the registration form when signing in to Velixo for the first time
Error: InvalidVelixoCredentials
Granting admin consent for access to all Velixo NX functionalities
Message: Looks like this connection is not licensed
Message: None of the connections are licensed to use the feature
Response Authentication Status Failure
Sage Intacct user... is not authorized to retrieve...
Signing into Velixo using Single Sign-On results in an authentication error

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
After using Freeze, the values inside Excel tables become identical across the entire column
Budget Writeback - "No data to process" message after upgrading to Velixo NX
Error HTTP ERROR 401 or 401 Authorization Required when using WRITEBACK
Error: BL01001973 Duplicate glbudgetitem found at request
Error: The current selection is invalid for this operation
Error: The Save button is disabled during Journal/Budget Writeback
Slice: Substitute combinations of parameters and skip "irrelevant" combinations

User guides

Advanced Topics

Asynchronous Data Retrieval - Sage Intacct
Message: Let this app access your info?
Velixo and Sage Intacct Console
Velixo NX and VBA interoperability (Excel Desktop for Mac)

Constructing reports and distribution

Creating dynamic dropdown lists
Creating interactive reports with pulldown lists
Cross-entity operations in Sage Intacct
Distribution with Sage Intacct
Drilldown for Sage Intacct
Embedding a Velixo report in Sage Intacct
Embedding your Velixo Data within PowerPoint
Filtering techniques for use with many Velixo functions
How to calculate Retained Earnings using Velixo
Ignore an area for the Formulas to Review panel
Merging Sage Intacct file attachments into a Distribution
Multiple connections per formula
Naming cells/ranges in Excel
Open a Velixo report from a link in an Excel workbook
Open a Velixo report from Sage Intacct
Restricting Date Ranges within reports - Sage Intacct
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 Dates with Sage Intacct functions
Using Dimensions

Using Distribution

Creating multiple report sheets from a single template

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

Budget Writeback
Budget Writeback (Sage Intacct)
Changing the language of Velixo NX
Connection Manager
Drilldown
Features specific to Velixo NX
Freeze / Unfreeze
Global Object Filters (Sage Intacct)
Granular Balance Loading (Sage Intacct)
Hide Zero Rows / Columns
Insert Chart of Accounts
Journal Writeback (Sage Intacct)
Options
Query Builder
Refresh
Refresh features (NX)
Slice
Snapshot
Status
Table Mirroring
Velixo NX interface

Sage Intacct Videos & Training

Sage Intacct Videos

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
Where are Velixo operations logged in my ERP?

Using Generic Inquiries

SI.QUERY for GL data (GLEntry vs GLDetail)

Velixo Portal

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

Writeback-related

Understanding Project Estimate Writeback's default entity mapping for multi-entity organizations
Universal Writeback for Sage Intacct - example

Breadcrumbs

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