Troubleshooting
Choose your topic of interest from the list below or use the search bar above.
ERP Connection & data discrepancies
- Account Balance Sign option has no impact
- Acumatica screen keeps trying to refresh after exporting to Velixo
- Acumatica user interface changes after installing Velixo customization
- Acumatica Velixo version compatibility
- Error 403 Forbidden (while connecting to data)
- Error: 504 or Load Failed connecting to your ERP
- Error: Acumatica has refused to provide data from... using the credentials specified
- Error: Can't Contact The Server
- Error: Internal Server Error 500
- Error: Required schema attribute 'Function' is not present
- Error: The ERP system failed to process the writeback request
- Message: Connections are a little busy
- Project summary balances do not match total of project transactions
- The following inquiries are not set up ... would you like to configure the inquiries now?
- The following inquiries are not set up (NX)
- Understanding Acumatica Tenants, Companies, and Branches
- Understanding external server connections
- Unposted amounts do not reflect in my Velixo reports
- Velixo couldn't reach any of its web service endpoints
Functions & formulas
- #CALC! errors - This calculation is not supported by this version of Excel
- #NAME? displays for all Velixo NX functions
- Account balances using date ranges: what if the transaction date does not match the financial period? (Troubleshooting)
- Date formats for Velixo Financial functions
- Dealing with subaccounts that include dashes
- Drilldown balances does not always match calculations results
- Error 403: #N/A error when using Velixo NX function
- Error: Could not convert string to integer
- 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: An error occurred during configuration of inquiry
- Error: Argument size mismatch
- Error: Keys for Inquiry... are not unique
- Error: Unable to read data from the transport connection: The connection was forcibly closed
- Functions appear as text and do not refresh
- GI function returns #VALUE! when using GIFILTER with Financial Period
- GI function returns #VALUE! when using GIFILTER with Financial Period (Troubleshooting)
- Liability accounts display Zero balance
- Maintaining Formatting of Financial Periods
- Object fields present in Acumatica cannot be used with ACU.QUERY and ACU.OBJECTDEFINITION
- Project Quantity does not match Cost Budget tab
- Report budget balances do not match the ERP Budgets screen
- 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
- Comparing Velixo NX and Velixo Classic
- Downloading Report Templates
- Error: Access Denied. A field with the name Ledger.LedgerID cannot be found
- Error: An item with the same key has already been added
- Error: Unable to set the NumberFormat property of the Range class
- Error: Violation of PRIMARY KEY constraint 'PK_MUISubcategory' during configuration of an inquiry
- Excel Undo feature is not working as expected
- Finding Help info for Velixo functions
- 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
- 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
- Cannot Install or Run the Velixo Add-In
- Deactivate the Velixo add-in
- Error 2349: Installer has encountered an unexpected error
- Error: Error Loading Add-Ins (on Mac)
- Error: The 18.200.001#Default base endpoint does not exist
- Error: The remote server returned an error: (403) Forbidden
- How to determine if Excel is 64-bit or 32-bit
- Lotus Settings Not Compatible with Velixo
- Manually Activating Velixo Tools
- Message: Customization Project Outdated
- Message: The following inquiries need upgrading... would you like to configure
- Message: Velixo Classic is already installed
- MYOB Error: Sorry, we couldn't find...VelixoReportsPro64.xll
- Report displays #N/A until each cell is edited
- Site accessibility & firewall considerations (Error 404 or Load Failed)
- The following inquiries are not set up (customization mode)
- Upgrading to a newer version of your ERP
- Warning: The Office Extensibility Library failed to load
- What edition and version of Velixo do I have?
- Why have I been switched to Velixo NX?
Login, licensing & authentication
- Cannot sign in to Velixo when opening a workbook in Teams
- Couldn't sign in to Velixo NX: an error occurs "Please enter a valid email address"
- Error: InvalidVelixoCredentials
- Error: Page VE300310.aspx does not exist
- Error: Server was unable to process request. Two-factor authentication is enabled for this user
- Error: unauthorized_client connecting with Single-Sign-On
- Error: You have logged out due to exceeding the number of users in the system
- 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
- Message: The server is asking for your user name and password
- MYOB Error: You are not allowed to log in as you don't have any API user licenses
- MYOB Error: You don't have any API licenses
- Universal/Generic Writeback not able to use two-factor authentication
- Your ERP user profile has insufficient access rights
Writeback, Distribution and other Velixo features
- 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 Creating Journal Transactions
- Error HTTP ERROR 401 or 401 Authorization Required when using WRITEBACK
- Error: An internal server error occurred (during Budget Writeback)
- Error: Operation Failed
- Error: String was not recognized as a valid DateTime
- Error: The current selection is invalid for this operation
- Error: The file ve300310 does not exist
- Error: The Save button is disabled during Journal/Budget Writeback
- Project Forecast issue on the Acumatica demo instance
- Slice: Substitute combinations of parameters and skip "irrelevant" combinations
- Slow Journal Writeback for a large number of transactions
- Subaccount is not showing in Acumatica after Journal Writeback