Frequently Asked Questions
How to use QXL
Step 1 - Download QXL
If you haven't already downloaded QXL, go to the download page now. Don't forget to read the "Readme" file during installation for the latest information on QXL setup, new features, and other driver information...
Troubleshooting - QXL is not Licensed for this QuickBooks Edition.
Problem Description:
I was able to use QXL earlier. Our co recently upgraded to QB Pro 2016 and can now not connect with QXL as it says QXL is not licensed for this QuickBooks edition. ...
QXL options and settings
QXL options and settings/Configuration:
The first step in configuring the application is to click on the settings icon for QXL options details.
General Tab:From General Tab, you can change the following:1. Output Folder...
Troubleshooting - QXL 80040414 Modal Popup Error
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the below error message. Unable to connect to QuickBooks. Popup window(s) in the QuickBooks a...
Troubleshooting - QXL 80040417 Error
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the below error message. Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine, and ...
Troubleshooting - QXL 8004041a,80040420,8004041d Error
Problem Description 1:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the below error message. Unable to connect to QuickBooks. Make sure QuickBooks runs o...
Troubleshooting - QXL 80040408 Error
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the below error message. Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine and i...
Troubleshooting - QXL QuickBooks Error: Invalid Certificate
Problem Description:
I have installed QXL and QuickBooks. I have set the Company Preferences / Integrated Applications to Allow Access to FLEXQuarters QODBC. When I click on the QXL export but...
Troubleshooting - QXL Getting This feature is not enabled or not available in this version of QuickBooks
Problem Description:
I am trying to export data from QXL. After the export is completed. I got the "Export Completed. One or more tables were not ...
How to create a report in Excel using QXL spreadsheet data
Problem Description:
I want to refresh my spreadsheet automatically from QXL exported spreadsheet. So, my spreadsheet data gets updated automatically using QXL exported spreadsheet. How to ...
How to get data from two or more tables into one spreadsheet.
In this example, We will show you How to get data from two or more tables into a single spreadsheet.
Open QXL. The first step in configuring the application is to click on the settings icon f...
QXL for QuickBooks Online - Known Issue(s)/Limitation(s)
Problem Description:
I am trying to export data from QuickBooks Online using QXL Online. After the export is completed. I got the "Export Completed. One or more tables were not exported" status in...
How to download and Install QXL Online
Refer: How to connect/reconnect QXL Online
Step 1 - Download QXL Online
If you haven't already downloaded QXL Online, go to the download page now. Don't forget to read the "Readme" file during ...
Troubleshooting - QXL Error Syntax error in CREATE TABLE statement
Problem Description:
I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the below error after export.
Syntax error in CREAT...
Troubleshooting - QXL Error when attempting to update the value
Problem Description:
I am trying to export data using QXL. After that, I clicked on the QXL export button I got the below error after export.
Error when attempting to update the value
S...
Troubleshooting - QXL Error System.OutOfMemoryException
Problem Description:
I am trying to export data from QXL. I have selected Transaction & other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the bel...
Troubleshooting - QXL Error Object reference not set to an instance of an object
Problem Description:
I am trying to export data from QXL. After that, I clicked on the QXL export button I got the below error after export.
Object reference not set to ...
Troubleshooting - QXL Error Invalid table name
Problem Description:
I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the below error after export.
ERROR [42S00] [QODBC] Invalid table ...
Troubleshooting - QXL Error Invalid field definition
Problem Description:
I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the below error after export.
Invalid field definition
Solution:...
Troubleshooting - QXL Error Insufficient permission level to perform this action
Problem Description:
I am trying to export data using QXL. After that, I clicked on the QXL export button I got the below error after export.
[QODBC] Error: 3260 - Insuf...
Troubleshooting - QXL Error Column not found
Problem Description:
I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the below error after export.
ERROR [42S00] [QODBC] Column not found...
Troubleshooting - QXL 80040409 Error
Problem Description:
I am trying to export data from QXL. But when I clicked on the QXL export button, I got the below error message.
The current version of QuickBooks cannot work with the specified company data f...
Troubleshooting - QXL Error 3120 - Object X specified in the request cannot be found.
Problem Description:
I am trying to export data from QXL. I have selected ItemAssembliesCanBuild & other tables from the "Table Setting" tab. After that, I click...
How to export to MySQL
Problem Description:
I am using QXL & I want to export QuickBooks Data to MySQL.
How can I export QuickBooks Data to MySQL using QXL?
Solution:
You can export QuickBooks Data to MySQL using QXL.
First, You need a MySQL OD...
How to export to SQL Server - using SQL Default Driver
Problem Description:
I am using QXL & I want to export QuickBooks Data to SQL Server.
How can I export QuickBooks Data to SQL Server using QXL?
Solution:
You can export QuickBooks Data to SQL...
How to export QuickBooks Data daily for the current date filter using QXL.
Problem Description:
I am using QXL & I want to create a report that will pull the following items.
Selectable Date Range, Invoice Number, Ship to Address 1-5, Ship to Cit...
How to configure QXL to export to SQLite
Problem Description:
I am using QXL & I want to export QuickBooks Data to ODBC Database.
How can I export QuickBooks Data to ODBC Database using QXL?
Solution:
You can export QuickBooks Data to ODBC ...
QXL Professional Edition options and settings - SQL
QXL Professional Edition options and settings / Configuration:
The first step in configuring the application is to click on the settings icon for QXL options details & navigate to th...
How to Balance sheet by the class report - with different parameters
Problem Description:
I am using QXL & I want to Balance the sheet with a class report through QXL. I can see the information on the list. But I want to change the report paramete...
General QXL shortcut commands and parameters
Parameters available in the QXL
Run = The parameter is used for running QXL in the foreground (i.e., QXL will be visible during execution).
example: QXL.EXE Run
Silent = The paramete...
How to use QXL with the scheduler for multiple company files
Problem Description:
I want to export QuickBooks Data for multiple company files using QXL.
I want to schedule QXL for exporting QuickBooks Data. So it will automatically export QuickBoo...
How to build shortcuts to export multiple QuickBooks company files using QXL with one click (Video)
Problem Description:
How to build shortcuts to export multiple QuickBooks company files using QXL with one click?
Solution:
Please refer to the steps &...
How to run ProfitAndLossByClass report - with different parameters
Problem Description:
I am using QXL & I want to run a Profit and Loss by a Class report through QXL. I can see the report in the list. But I want to change the report parameter.
H...
How to run ProfitAndLossByClass report using QXL Online
Problem Description:
I am using QXL Online & I want to run a Profit and Loss by a Class report through QXL Online. I can't see the report on the list.
How can I run the Profit and Loss by Cl...
How to export to DB2
Problem Description:
I am using QXL & I want to export QuickBooks Data to DB2.
How can I export QuickBooks Data to DB2 using QXL?
Solution:
You can export QuickBooks Data to DB2 using QXL.
First, You need to create ODBC DS...
How to export to MariaDB
Problem Description:
I am using QXL & I want to export QuickBooks Data to MariaDB.
How can I export QuickBooks Data to MariaDB using QXL?
Solution:
You can export QuickBooks Data to MariaDB using QXL.
First, You need t...
How to export to Oracle
Problem Description:
I am using QXL & I want to export QuickBooks Data to Oracle.
How can I export QuickBooks Data to Oracle using QXL?
Solution:
You can export QuickBooks Data to Oracle using QXL.
First, You need to cr...
How to export to PostgreSQL
Problem Description:
I am using QXL & I want to export QuickBooks Data to PostgreSQL.
How can I export QuickBooks Data to PostgreSQL using QXL?
Solution:
You can export QuickBooks Data to PostgreSQL using QXL.
First...
How to export to Sybase
Problem Description:
You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL...
[QXL-Desktop] How to run a Balance Sheet Standard report - with multiple levels
Problem Description:
I am using QXL & I want to run the Balance sheet standard report through QXL. I can see the report on the list. But I want to change the repor...