RSS Feed
Knowledgebase

[QODBC-ALL] & [QXL- ALL] SQL LANGUAGE SUPPORT (SYNTAX) STORED PROCEDURES COMMAND LIST Applicable to [QODBC-Desktop], [QODBC-Online], [QODBC-POS], [QXL- Desktop] & [QXL- Online] STORED PROCEDURES SP_COLUMNS _table name_ INSTRUCTION: Returns a record...
[QODBC ALL] - HOW TO KNOW THE TIME TAKEN BY QUICKBOOKS SDK AND QODBC. PROBLEM DESCRIPTION: I would like to analyze how much time QuickBooks SDK takes to process the data request and how much time QODBC takes to format the data and send it back to the ca...
HOW TO ACTIVATE QODBC POS
QXL - QuickBooks Data Export Made Easy Limited Use Software License LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer...
QODBC Limited Use Software License LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing unit) ut...
[QODBC DESKTOP] - TROUBLESHOOTING - THE CERTIFICATE WAS REVOKED BY ITS CERTIFICATION AUTHORITY. REVOKED SECURITY CERTIFICATE. PROBLEM DESCRIPTION: We get an error message in QuickBooks saying that the application FLEXquarters QODBC's certificate was rev...
How to cancel the subscription of QODBC Driver for QuickBooks Online [https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2787] [QODBC-Desktop] Troubleshooting - No data returned - Unable to execute - InventoryStockStatusByIte...
[QODBC-DESKTOP] TROUBLESHOOTING - NO DATA RETURNED - UNABLE TO EXECUTE - INVENTORYSTOCKSTATUSBYITEM    PROBLEM DESCRIPTION Upon pulling QuickBooks data into Microsoft Access, I didn't see any values (all blank) in the QuantityonOrder field of either the...
 [QXL-DESKTOP] & [QXL-ONLINE] FUNCTION LIST QXL Desktop uses the QODBC Desktop driver to query QuickBooks Desktop. Commands available in QODBC Desktop will also work in the QXL desktop application. QXL Online uses the QODBC Online driver to query Quick...
[QXL- DESKTOP] & [QXL- ONLINE] STORED PROCEDURES COMMAND LIST QXL Desktop uses the QODBC Desktop driver to query QuickBooks Desktop. Commands available in QODBC Desktop will also work in the QXL desktop application. QXL Online uses the QODBC Online dri...
[QODBC-DESKTOP] HOW TO USE THE QODBC TEST TOOL FOR TESTING PROBLEM DESCRIPTION: How to use QODBC Test Tool to test my SQL statement? How to test QODBC connection with QuickBooks Data? SOLUTION:  Open a company file in QuickBooks. Start QuickBooks...
[QODBC ONLINE] HOW TO INSERT DATA INTO THE VENDORCREDIT TABLE PROBLEM DESCRIPTION: How to insert data into the VendorCredit table SOLUTION:  Open the "QODBC Online Test tool" from the start menu. Click on the "Connect" button. Used the below SQL ...
[QODBC-DESKTOP] HOW TO USE QODBC WITH ALTERYX DESIGNER PROBLEM DESCRIPTION: I want to export the QuickBooks data using Alteryx Designer Studio? How can I use Alteryx Designer with the QODBC? SOLUTION:  Alteryx Designer Studio is a 64-Bit applicatio...
[QODBC-ONLINE] TROUBLESHOOTING - PARTIAL DATA/INCOMPLETE DATA IN GENERALLEDGER REPORT - UNABLE TO FETCH ALL ROWS PROBLEM DESCRIPTION: I am fetching one year of data from the QuickBooks Online General Ledger report using QODBC Online. I get partial dat...
[QODBC-DESKTOP] - HOW TO RENAME SOME OF MY BULK ITEMS (I.E., INVENTORY ITEMS) AND THEIR RELATED CHILD ITEMS (I.E., ASSEMBLIES) PROBLEM DESCRIPTION: I would like to rename some of my bulk items (i.e., inventory items) and their related child items (i.e.,...
[QODBC-ALL] TROUBLESHOOTING - LOAD UPDATED DATA DID NOT COMPLETE (3)    PROBLEM DESCRIPTION When I try to run the optimizer from the QODBC configuration screen, I get the following error when I click "Load Updated Data": Load Updated Data did not comp...
[QODBC-ALL] TROUBLESHOOTING - TRAPPABLE ERROR (E06D7363) OCCURRED IN AN EXTERNAL OBJECT   PROBLEM DESCRIPTION A trappable error (E06D7363) occurred in an external object. The script cannot continue running. I receive this error when reading and writin...
[QODBC-DESKTOP] - DO I REALLY NEED TO PURCHASE QUICKBOOKS TO DEVELOP A ONE OFF APPLICATION FOR A CLIENT? PROBLEM DESCRIPTION: I need to develop a one-off application for a client. I have their QuickBooks Desktop company file. Can I develop on that dat...
[QODBC ALL] - HOW TO INCREASE THE UPDATE OR DELETE SQL STATEMENT PERFORMANCE. PROBLEM DESCRIPTION: Ran this SQL to move an invoice from one Customer to another: Update invoice set CustomerRefListID = '1500' where TxnNumber = 8453 It took about 15+ min...
SOLVED:[QODBC-ALL] TROUBLESHOOTING - WINDOWS CANNOT FIND FQQBSAV.EXE  PROBLEM DESCRIPTION Issue 1: I just updated QODBC to the latest build, 349. When trying to connect to the QRemote DSN, I get the following error message. Windows cannot find 'fqqb...
HOW TO INSTALL AND USE QSCHEDULER WITH QXL DOWNLOAD AND INSTALL QSCHEDULER Please refer to the following article for how to install QScheduler - https://qxl1.com/links/3047 [https://qxl1.com/links/3047] HOW TO USE QSCHEDULER WITH QXL QScheduler can b...
HOW TO INTUIT OR QUICKBOOKS DEVELOPERS AND REPORT FIELDS NOT AVAILABLE IN QUICKBOOKS SDK OR QUICKBOOKS ONLINE API ISSUE: We noticed a field or feature is not available in QuickBooks SDK or QuickBooks API. How can I contact Intuit and request to add the...
HOW TO USE THE COMPUTER NAME INSTEAD OF IP ADDRESS IN QREMOTE? PROBLEM DESCRIPTION 1: When running a QRemote Server or a query, the IP address changes randomly. SOLUTIONS:  If you are using a 32-Bit QODBC manager, Please follow the below steps: Ope...
[QODBC-ALL] TROUBLESHOOTING - UNABLE TO EXECUTE UPDATE STATEMENT WHEN USING SQL SERVER 2019 LINKED SERVER ON WINDOWS 11 OR WINDOWS SERVER 2019 ISSUE: We recently upgraded our Windows OS to Windows 11 and SQL Server to 2019. We can connect from SQL Se...
SOLVED: [QODBC-DESKTOP] TROUBLESHOOTING - UNABLE TO CHANGE THE DEFAULT CONFIGURATION OF NEWLY CREATED QODBC DSN - BUILD 348 ISSUE: We created a new QODBC 32-Bit DSN with the name "QODBC-MyCompany. The DSN was created successfully. We tried to chang...
DIFFERENCES IN DATA AVAILABLE BETWEEN QXL ONLINE AND QUICKBOOKS ONLINE'S EXPORT FEATURE You can export data using the QuickBooks Online export feature for each of the tables/reports. There are two ways to export data from QuickBooks Online. 1) Export...
USING MS ACCESS APP 64-BIT AND 32-BIT (DIFFERENT MACHINES) WITH QODBC PROBLEM DESCRIPTION: My MS Access application links to QuickBooks tables via the QODBC ODBC driver. The 64-bit QODBC calls the ODBC connection 'Quickbooks Data 64-Bit QRemote'. So my ...
THE INPUT STRING WAS NOT IN A CORRECT FORMAT / THE INPUT STRING WAS NOT IN THE CORRECT FORMAT PROBLEM DESCRIPTION: I am running QXL and MS Office 365. I have tried exporting to XLSX, XLS, and even CSV format, but only the file header row writes. Als...
TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - THE DRIVER DID NOT SUPPLY AN ERROR - PYTHON  PROBLEM DESCRIPTION I tried to connect to QODBC using python, gave me the following error. The python code I am using is this. import pyodbc cn = pyodbc...
SOLVED: [QODBC-DESKTOP] TROUBLESHOOTING - QUICKBOOKS 2022 - COULD NOT START QUICKBOOKS - WINDOWS SERVER 2012 R2 & WINDOWS SERVER 8 ISSUE: We upgraded our QuickBooks Enterprise from 2020 to 2022. We were using QuickBooks 2020 and the QODBC driver versio...
HOW TO CHANGE AUTO LOGIN USER - ALTER QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATION UNDER QUICKBOOKS. Please follow the steps to change the auto login user associated with QODBC Certificates in Integrated Application Under QuickBooks: Switch Q...
HOW TO INSTALL QSCHEDULER DOWNLOAD Please download the latest version of QScheduler from the QXL website - https://qxl1.com/qscheduler-download/ [https://qxl1.com/qscheduler-download/]. Download the installer. Right-click on the installer and click ...
[QScheduler] QScheduler Limited Use Software License & QScheduler Limited Warranties and Limitation Of Liability
HOW TO USE QODBC SUPPORT WIZARD - REMOTE CONNECTIVITY PROBLEM DESCRIPTION: How to use QODBC Support Wizard - Remote Connectivity? SOLUTION: Please follow the below-listed steps for using QODBC Support Wizard. The "QODBC Support Wizard" application ...
TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - EXCEL CRASHES WHEN USING SQL STATEMENT WITH TWO INNER JOINS ALONG WITH UNOPTIMIZED PROBLEM DESCRIPTION I am using Microsoft Excel. I am using the following SQL statement. SELECT TransferInventoryLin...
[SOLVED] [QODBC-ALL] - TROUBLESHOOTING - QODBC SERVER EDITION LICENSE REQUIRED - WHEN USING QODBC 2021 LICENSE PROBLEM DESCRIPTION I have purchased the QODBC Server edition license 2021. I have activated the QODBC 2021 Server edition license on the m...
HOW TO MANUALLY SYNCHRONIZE (MANUAL SYNC) QODBC POS LICENSE Manual License synchronizes (Manual License Sync) can be used for computers that do not have direct Internet access or where the automated activation fails. Click on START -> ALL PROGRAMS -> ...
HOW TO MANUALLY SYNCHRONIZE (MANUAL SYNC) QODBC DESKTOP LICENSE Manual License synchronizes (Manual License Sync) can be used for computers that do not have direct Internet access or where the automated activation fails. Click on START -> ALL PROGRAMS...
HOW TO MANUALLY SYNCHRONIZE (MANUAL SYNC) QODBC ONLINE LICENSE Manual License synchronizes (Manual License Sync) can be used for computers that do not have direct Internet access or where the automated license sync fails. Click on START -> ALL PROGRAM...
PROBLEM DESCRIPTION: How to use Intuit's SDK Test Plus 3 Tool. SOLUTION: Download: SDKTest Plus 3: Direct download link - SDKTestPlus3.exe [http://support.flexquarters.com//support.flexquarters.com/esupport/supportfiles/HowToUseSDKTestPlus3/SDKTe...
SOLVED: [QODBC ONLINE] COLUMN NOT FOUND - ARAGINGSUMMARY AND APAGINGSUMMARY PROBLEM DESCRIPTION: Unable to use ARAgingSummary and APAgingSummary Error - Column not found: Amount_Title, Column not found: Amount_1, Column not found: Amount SOLUTIONS: ...
USING MICROSOFT POWERBI WITH QUICKBOOKS DATA PROBLEM DESCRIPTION 1: How to connect to QuickBooks Data with Power BI using QODBC Desktop? SOLUTIONS:  Open the QODBC setup screen and change the QODBC Compatibility mode from "Default" to "3.8." To cha...
HOW TO EXPORT QUICKBOOKS DATA TO OPENOFFICE USING QXL PROBLEM DESCRIPTION: How to export QuickBooks Data to OpenOffice using QXL SOLUTIONS:  Download and install OpenOffice on your system. Start QXL Desktop Export the QuickBooks Company Data O...
HOW TO DEACTIVATE QODBC ONLINE DEACTIVATE QODBC ONLINE FROM YOUR COMPUTER You can Deactivate QODBC Online license from: Start >> All Programs >> QODBC Driver for QuickBooks Online>> Configure QODBC Data Source Go To "System DSN" Tab>> Select "Qui...
TROUBLESHOOTING - THERE WAS AN ERROR SAVING AN EMPLOYEES LIST. THE ADDRESS IS INVALID PROBLEM DESCRIPTION: We have searched the wiki and internet and tried endlessly to 'Insert an Employee.' Below is our latest effort, all to no avail- Insert into E...
[QXL DESKTOP] HOW TO EXPORT QUICKBOOKS DATA TO GOOGLE SHEETS USING QXL PROBLEM DESCRIPTION: How to export QuickBooks Data to Google Sheets using QXL SOLUTIONS:  Install the Google Drive desktop application and authorize it to connect to your Google D...
[QODBC ALL] WHAT DOES 'RED TEXT' IN THE QODBC DRIVER DIALOGS MEANS PROBLEM DESCRIPTION: What does 'Red text' in the QODBC driver dialogs means SOLUTIONS:  Whenever you run any query for the first time, QODBC will first build the optimizer. Please r...
[QODBC DESKTOP] MISSING QODBC MENUS IN THE START MENU PROBLEM DESCRIPTION: Missing QODBC Menus in the start menu SOLUTIONS:  Navigate to the path: C:UsersAdministrator In the Administrator folder, you will see the below options. Switch to the 'Vi...
[QODBC ONLINE] - UNABLE TO USE QODBC ONLINE ON WINDOWS 7 PROBLEM DESCRIPTION: Unable to use QODBC Online on Windows 7 Error - session Failed. 653 - There was an error while communicating with the Ids Server. - - The Response Stream was null or empty ...
QODBC ONLINE - UPGRADE QODBC ONLINE TO THE LATEST VERSION BEFORE DECEMBER 17TH, 2019 WHY IS THE QODBC ONLINE UPGRADE REQUIRED? QODBC Online version 19.0.0.333 and lower versions use an old security system that is being discontinued in QuickBooks Online ...
QODBC DESKTOP - HOW TO LINK INVOICE TO DEPOSIT USING QODBC? PROBLEM DESCRIPTION 1: I want to apply the Payment to a particular Invoice using Deposits. How can I do so using the QODBC? SOLUTIONS:  Refer to the screenshot of the QuickBooks UI Invoice...
USING QODBC WITH OFFICE 64-BIT QuickBooks is a 32-Bit application, but other applications such as MS Excel, MS Access, and MS SQL Server are also available in 64-Bit architecture. Since a 64-Bit application cannot talk to a 32-bit driver, we have to d...
TROUBLESHOOTING - HOW TO CANCEL THE SUBSCRIPTION OF QXL ONLINE FOR QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I want to cancel my QXL Online monthly subscription. How to cancel the subscription to QXL Online for QuickBooks Online? SOLUTION: Latest Me...
HOW TO CREATE A TRANSFER INVENTORY RECORD USING QODBC NOTE: The following example uses the QuickBooks USA Sample Rock Castle Construction company file. TO CREATE A NEW TRANSFER INVENTORY RECORD Please refer to the below-listed samples. INSERT INTO ...
TROUBLESHOOTING - HOW DO I UPDATE EXPIRED CREDIT CARD INFORMATION ON YOUR SYSTEM? PROBLEM DESCRIPTION: I am using QODBC Online & QXL Online, and I am using my credit card for payment. How do I update expired credit card details on your system? My car...
TROUBLESHOOTING - AN INCOMPLETE RECORD NOT FOUND FOR CDKEY / UNABLE TO ACTIVATE CDKEY / REASON: UNABLE TO LOCATE THE SOFTWARE ID: PROBLEM DESCRIPTION: I am on Windows 64-bit, and I am unable to activate QODBC. SOLUTION: Proxy or Firewall: Please c...
TROUBLESHOOTING: UNABLE TO CONNECT TO QUICKBOOKS USING QODBC. QODBC FREEZE, QODBC HANGS, QODBC STUCK DURING CONNECTION. PROBLEM DESCRIPTION 1: I have the latest driver version and no errors during installation. When I tried to connect, it just stuck "c...
Hello, If you downloaded The QODBC Desktop product between October 7th and 9th, this urgent message might apply to you. During the dates above, a possible trojan-infected software version was uploaded to our hosting company, and you may have gotten th...
ONLINE DATA LAYOUTS SOURCE   We have provided the tools to help you determine where field information comes from in QuickBooks Online, which tables contain the information you want, how tables can be related, and sample SQL statements. Please click here...
HOW TO UPGRADE THE QODBC ONLINE VERSION WITHOUT REAUTHORIZING YOUR QUICKBOOKS ONLINE. PROBLEM DESCRIPTION * I want to upgrade QODBC Online to the latest version. Can I reauthorize QODBC Online to connect to my QuickBooks Online company? * Can I upgr...
HOW QODBC TALKS TO QUICKBOOKS SDK TO GET SAFE/ENCRYPTED/BALANCED DATA FROM QUICKBOOKS, PREVENTING DATA CORRUPTION. PROBLEM DESCRIPTION * How does QODBC validates all the business logic which are part of the QuickBooks application? * Can QODBC read o...
WHAT ARE THE BEST PRACTICES REGARDING DATA SECURITY ON THE INTERNET WHEN USING QREMOTE? QRemote can transfer data in an unencrypted fashion (plain text), or you can set up your encryption key to encrypt the data, which is preferable for transfer over the...
[QXL-ALL] HOW TO ENABLE ENCRYPTED CONNECTION TO THE DATABASE SQL Server * Enable Encrypted Connections to the Database Engine [https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?...
[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 report paramet...
TROUBLESHOOTING - CANNOT MODIFY THE TABLE'S DESIGN - IT IS IN A READ-ONLY DATABASE. SOURCE:ODBCJT32.DLL PROBLEM DESCRIPTION: I keep getting an error message that states Error Occurred: unable to create table in destination database-customer-access, QXL...
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...
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 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 cre...
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 to...
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 DSN...
HOW TO USE QODBC WITH TABLEAU DESKTOP For using QODBC with Tableau Desktop, You need to use QODBC V 18.0.0.326 or a later version. If you are using an older version of QODBC, please upgrade your QODBC to the latest version. Click here [http://qodbc.com...
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 Class...
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. How ...
TROUBLESHOOTING - VEHICLEMILEAGE TABLE SHOWING DELETED RECORDS PROBLEM DESCRIPTION: I am using QODBC for working with QuickBooks. I can delete the VehicleMileage record. But After that, when I query the VehicleMileage table, it still shows deleted hist...
HOW TO USE QLIKSENSE DESKTOP (WEB-BASED) WITH QODBC To use QlikSense Desktop with QODBC, Please follow the below steps. Open QlikSense Desktop in the browser & click on the "CREATE A NEW APP" button. Enter the app name and click the "Create" button. ...
TROUBLESHOOTING - GETTING ERROR THERE WAS AN ERROR WHILE COMMUNICATING WITH THE IDS SERVER. PROBLEM DESCRIPTION: I am on Windows Server 2008 SP2 32-bit and trying to connect to QuickBooks Online using QODBC Online. Have authorized QODBC Online at Qui...
TROUBLESHOOTING - HOW TO CONVERT MS OFFICE FROM 64-BIT TO 32-BIT PROBLEM DESCRIPTION: I am on Windows 64-bit and Office 365 64-bit. QODBC Test Tool works fine when I use QuickBooks Data as a connection source. If I use QRemote, I get the "Evaluation ...
TROUBLESHOOTING - QODBC HUNG UP, EVERYTHING LOOKS LOCKED UP, OR THE APPLICATION IS NOT RESPONDING WHEN FETCHING QUICKBOOKS DATA. PROBLEM DESCRIPTION: I can access the database, but when I added another table & fetch table data, it generally hung up. No...
TROUBLESHOOTING - HOW TO APPLY PAYMENT TO MULTIPLE INVOICE PROBLEM DESCRIPTION: How can a payment be applied to multiple invoices? Scenario 1 - 3 Invoices are created. - A payment is received that covers 2 of the invoices, but not necessarily in ...
HOW TO USE M-FILES WITH QODBC PROBLEM DESCRIPTION: How to use M-Files with QODBC? SOLUTION: Please follow the below steps for using M-Files with QODBC. 1. Open M-Files Admin. 2. Expand the desired connection to M-Files Server in the left-side tre...
HOW TO CREATE SP_REPORTS USING MICROSOFT EXCEL HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL OPEN MICROSOFT QUERY IN EXCEL Open Microsoft Excel, get external data from Microsoft Query via Data Menu -> "Get Data -> From Other Sources->From Microsoft...
TROUBLESHOOTING - GETTING ERROR THE RECEIPT IS NOT BALANCED. UNDEFINED AMOUNT IS PROBLEM DESCRIPTION: I am trying to create a sales receipt. I have a sales item that is 550. The customer paid 3 dollars, so that leaves 547 in their account. "SalesRece...
HOW TO MANUALLY START QREMOTESERVER By default, QRemoteServer will start as soon as a user logs on to the system. You can manually start QRemoteServer by the below steps: You can begin to QRemoteServer from: Start >> All Programs >> QODBC Driver for ...
HOW TO CREATE OR CONFIGURE A QREMOTE DSN LAUNCH QODBC DATA SOURCE CONFIGURATION Locate the QODBC DRIVER FOR THE QUICKBOOKS program group from Startup Program: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source....
TROUBLESHOOTING - EXCEL ONLY RETURNING AMOUNT_1 AND NOT AMOUNT_1 THROUGH AMOUNT_12. PROBLEM DESCRIPTION: I am working in Excel. I have set up three pass-through queries and had them work on referencing cells for DateFrom and DateTo parameters. The quer...
TROUBLESHOOTING - HOW TO USE PROMPTED DATE RANGES IN MS EXCEL WITH SP_REPORTS PROBLEM DESCRIPTION: I am using QODBC for exporting QuickBooks reports in MS Excel. I am using the BalanceSheetStandard report for specific date ranges as below. sp_report ...
TROUBLESHOOTING - SERIAL NUMBER/LOT NUMBER QUANTITY ON HAND DOES NOT MATCH THE QUICKBOOKS REPORT. PROBLEM DESCRIPTION: I recently ran into an issue when querying the inventory for each lot number. In QuickBooks, there is a report called "Lot Numbers in...
TROUBLESHOOTING - HOW WOULD I PRODUCE A TRANSACTION LIST THAT INCLUDES THE CLASS FIELD? PROBLEM DESCRIPTION: I am working on the transactions table but do not see a "class" field. How would I produce a transaction list that includes the class field? ...
TROUBLESHOOTING - DATA SOURCE NAME NOT FOUND, AND NO DEFAULT DRIVER SPECIFIED PROBLEM DESCRIPTION: I have QODBC running on a terminal server.o I can use 64-bit Excel to query QODBC via the "from other sources." I have set up a 64-bit remote DSN that ...
TROUBLESHOOTING - HOW TO ADD QREMOTE TO STARTUP PROBLEM DESCRIPTION 1: How to add QRemote to ALL users Startups? SOLUTION 1: It would be best if you reinstalled QODBC for adding QRemoteServer to ALL user Startups. After installation of QODBC, QRem...
TROUBLESHOOTING - HOW CAN I EXTRACT BUDGET DATA PROBLEM DESCRIPTION: I'm trying to extract QuickBooks budget data to SQL for reporting purposes. However, I don't see any tables that would hold the budget. My research is telling me this may not be possi...
TROUBLESHOOTING - HOW CAN I COMBINE TWO REPORTS AND GET A CUSTOMER'S TRANSACTIONS REPORT? PROBLEM DESCRIPTION: I need a report by a particular Customer showing the beginning balance, payments made by the Customer, invoices with details showing the expe...
HOW TO AUTO ADD RELATIONSHIP BETWEEN TWO TABLES IN QLIKSENSE DESKTOP USING QODBC PROBLEM DESCRIPTION: How to Auto Add relationship Between two tables in QlikSense Desktop using QODBC? SOLUTION: Please create a new application in QlikSense Desktop & c...
HOW TO USE QLIKSENSE DESKTOP WITH QODBC To use QlikSense Desktop with QODBC, Please follow the below steps. Open QlikSense Desktop & click on the "CREATE A NEW APP" button. Enter the app name and click the "Create" button. A New application in Qlik...
TROUBLESHOOTING - HOW TO CONNECT TO QUICKBOOKS USING PDO PROBLEM DESCRIPTION: We have a setup connecting a PHP application to QuickBooks with QODBC. This works correctly using odbc_connect. However, if we try to connect using PDO instead, we get 500...
HOW TO USE QODBC SUPPORT WIZARD PROBLEM DESCRIPTION: How to use QODBC Support Wizard? SOLUTION: Please follow the below-listed steps for using QODBC Support Wizard. The "QODBC Support Wizard" application is included with QODBC v18.0.0.325 and above...
TROUBLESHOOTING - UNABLE TO CONNECT TO QUICKBOOKS ONLINE USING QODBC ONLINE - UPDATE QODBC ONLINE TO V18.0.0.325 OR ABOVE Intuit requires upgrading to TLS 1.2 to align with industry best practices for security and data integrity. On July 31, 2017, Intu...
HOW TO USE BARTENDER WITH QODBC PROBLEM DESCRIPTION: How to use BarTender with QODBC? SOLUTION: Please follow the below steps for using BarTender with QODBC. Please start BarTender & create a new document by clicking "Start a new BarTender document...
HOW TO USE DBASE PLUS WITH QODBC PROBLEM DESCRIPTION: How to use dBase Plus with QODBC? SOLUTION: Please follow the below steps for using dBase Plus with QODBC. Please start dBase Plus & create a new form by clicking "New Form." Select the "Desig...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE WITH QREMOTE PROBLEM DESCRIPTION: I am using QODBC to access QuickBooks Data. I have linked all QuickBooks tables using QRemote DSN. I want to use the Customer table to be Optimizer OF...
TROUBLESHOOTING - WHERE ITEM SERIAL NUMBERS OR LOT NUMBERS ARE STORED PROBLEM DESCRIPTION: I'm having trouble finding where an Item's serial numbers are stored in the QuickBooks database. I have gone through your table schema online here http://doc.qod...
TROUBLESHOOTING - ERROR 3180 - THERE WAS AN ERROR WHEN SAVING A DATA EXTENSION NAMED ". "QUICKBOOKS ERROR MESSAGE: ATTRIBUTE WITH THE SPECIFIED NAME ALREADY EXISTS. PROBLEM DESCRIPTION: I am using QODBC for creating Invoices in QuickBooks. I am using C...
TROUBLESHOOTING - HOW TO USE ANY OTHER QUICKBOOKS USER OTHER THAN ADMIN. PROBLEM DESCRIPTION: We have installed the QODBC and can read the tables in QODBC Test Tool. However, after doing the initial read as an admin to QuickBooks, we cannot read the ta...
TROUBLESHOOTING - ERROR = 80040437, THE USER YOU ARE TRYING TO LOG IN WITH IS ALREADY LOGGED IN FROM ANOTHER MACHINE. PROBLEM DESCRIPTION: Our company uses QuickBooks 2018 contractor edition, which allows only one user simultaneously. Yesterday, I se...
TROUBLESHOOTING - QREMOTE FOR QUICKBOOKS IS NOT LISTED AS A CHOICE IN ODBC SETUP SCREEN PROBLEM DESCRIPTION: I am trying to set up the QODBC Driver on a machine running Windows Server 2016. Previously, I have had it set up and working fine on my local ...
HOW TO ACTIVATE QODBC ONLINE PURCHASE QODBC ONLINE CDKEY When you first install QODBC Online, it automatically activates a "once-off" FREE 30-Day Evaluation... beyond which QODBC Online will stop working, and you will need to purchase a CDKEY. Once yo...
QUICKBOOKS SPECIFICATIONS FOR MAXIMUM NUMBER OF RECORDS OR TRANSACTIONS AS OF DATE: 2007-07-25 QuickBooks can handle a maximum of 2 billion transactions. The maximum number of transactions is limited more by your computer's disk space and memory than ...
MICROSOFT WINDOWS VISTA UPDATE ALERT AS OF DATE: 2007-03-29 For QuickBooks users within the USA With Microsoft's release of Windows Vista, we wanted to ensure that all our users are informed about using QuickBooks on Windows Vista. First and foremost,...
INTUIT ANNOUNCES QUICKBOOKS 2007 NEW FEATURES AND INTEGRATED SERVICES SOLVE SMALL BUSINESSES' MOST IMPORTANT PROBLEMS MOUNTAIN VIEW, Calif.--(BUSINESS WIRE)--Intuit Inc. (Nasdaq: INTU) today announced the availability of QuickBooks(R) 2007. The new li...
QUICKBOOKS SDK 6.0 FOR U.S. EDITIONS OF QUICKBOOKS 2007 AS OF DATE: 2006-07-13 QUICKBOOKS SDK 6.0 FEATURE LIST QuickBooks SDK 6.0, scheduled to be released in the fall of 2006, will include a number of new features requested by IDN member developers...
QUICKBOOKS SDK 5.0 FOR U.S. EDITIONS OF QUICKBOOKS 2006 AS OF DATE: 2006-07-13 QUICKBOOKS SDK 5.0 FEATURE LIST QuickBooks SDK 5.0, available to IDN members for download [https://developer.intuit.com/], includes a number of new features requested by ...
MICROSOFT WINDOWS VISTA, VERSIONS OF QUICKBOOKS BEFORE 2007, AND QODBC AS OF DATE: 2006-12-16 IMPORTANT NOTE: To see how to install QODBC and connect to QuickBooks for the first time using Microsoft Vista, click here: How do I install and connect QODB...
QUICKBOOKS SDK 4.0 FOR U.S. EDITIONS OF QUICKBOOKS 2005 QUICKBOOKS SDK 4.0 FEATURE LIST QuickBooks SDK 4.0 includes a number of new features requested by IDN member developers. Of course, SDK 4.0 also supports all parts of our previous versions of the...
TROUBLESHOOTING - HOW CAN I ADD A LINE TO AN EXISTING CHECK PROBLEM DESCRIPTION: Is it possible to add a line to a check that already exists? Here is an example from the QB Sample file. Below is a check for $500.00 Now I want to add additional item...
TROUBLESHOOTING - CAN I USE QODBC WITHOUT HAVING QUICKBOOKS INSTALLED? PROBLEM DESCRIPTION: My clients give me a backup copy of their QuickBooks file. I don't have QuickBooks installed on my computer but would like to bring the data into Excel. Can I u...
TROUBLESHOOTING - HOW CAN I ACCESS ONLINE BANKING ALIASES USING QODBC PROBLEM DESCRIPTION: Does anybody know which table the Online Banking Aliases data is stored in QuickBooks? To see what I'm talking about, go to the "Additional Info" tab of the "E...
TROUBLESHOOTING - QODBC IS NO LONGER LICENSED FOR THIS RECKON VERSION PROBLEM DESCRIPTION: We have been using QODBC without problems with our current QuickBooks version for months. Suddenly QODBC has stopped working on all our computers. I have tried a...
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 ...
TROUBLESHOOTING - HOW TO LOCATE EMPLOYEE EMERGENCY CONTACT INFORMATION USING QODBC PROBLEM DESCRIPTION: Is it possible to retrieve an employee's emergency contact information? If so, from what table? SOLUTION: Employee Emergency Contact Information ...
TROUBLESHOOTING - GETTING ERROR WHEN TRYING TO CONFIGURE QODBC IN SQL SERVER PROBLEM DESCRIPTION: I'm trying to install the QODBC on our SQL Server, and I followed all steps in your documentation on How to create a Link Server with MS SQL 2005/2008/201...
TROUBLESHOOTING - HOW TO RECEIVE INVENTORY WITHOUT PURCHASE ORDERS PROBLEM DESCRIPTION: Is it possible to register an item's arrival without the purchase order? If yes, can I insert the rows in the "ItemReceiptItemLine" table using the reference to B...
TROUBLESHOOTING - DOES SP_REPORT SUPPORT LIKE QUERY PROBLEM DESCRIPTION 1: Does sp_report support "Like" in the parameter? For example, sp_report CustomTxnDetail shows Text, Blank, TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAc...
HOW TO AUTO ADD RELATIONSHIP BETWEEN TWO TABLES IN CRYSTAL REPORT USING QODBC PROBLEM DESCRIPTION: How to Auto Add relationship Between two tables in Crystal Report using QODBC? SOLUTION: A relationship can be extracted using the ODBC function "SQLFo...
QODBC READ-ONLY TABLE LIST PROBLEM DESCRIPTION: I am using QODBC & trying to modify data in QuickBooks. In a few tables, I can't insert/update records. I am getting a "[QODBC] Not supported" error when inserting records. Also, I have noticed "Error ...
SAMPLE CODE FOR CREATING TO SALESRECEIPT USING PHP SAMPLE APPLICATION: Please click here [http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/SalesRcptPHP/QODBCPOS-SalesReceipt-Insert-Sample.zip] to download Sample Code. Pl...
SAMPLE C#.NET CODE FOR CREATING SALESRECEIPT SAMPLE APPLICATION: Please click here [http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/SalesRcptC/QODBCPOS-SalesReceipt-Insert-Sample.zip] to download Sample Code. Please refe...
SAMPLE C#.NET WEB APPLICATION FOR CREATING SALESRECEIPT SAMPLE APPLICATION: Please click here [http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/SalesRcptCW/QODBCPOS-SalesReceipt-Insert-Sample-ASP.zip] to download Sample Cod...
TROUBLESHOOTING - MS ACCESS AND QUICKBOOKS FREEZE (NOT RESPONDING) WHEN ACCESSING THE FIRST TIME PROBLEM DESCRIPTION: When pushing data from the access database to QuickBooks, the QODBC message indicates waiting on QuickBooks, and both Access and Quick...
TROUBLESHOOTING - HOW TO FIND AN ESTIMATE FOR INVOICE CONVERSION TIME PROBLEM DESCRIPTION: I am using MS Excel to access QuickBooks Data through QODBC. I have Estimate & some of the Estimates are converted to QuickBooks. I want to know how many Estimat...
TROUBLESHOOTING - WHO CREATED AN INVOICE/SALESORDER PROBLEM DESCRIPTION: We don't have an operational problem, just a SQL/technical question -- we are currently pulling invoices like this: SELECT * FROM Invoice WHERE RefNumber ='221206' (works great)...
TROUBLESHOOTING - UNKNOWN EXCEPTION QODBC CAN'T QUERY-SPECIFIC TABLE; CRASHES QUICKBOOKS PROBLEM DESCRIPTION: QB Desktop Enterprise 2017 Manufacturing & Wholesale R5_88 Successfully installed QODBC using Optimizer. Can query every table with QODBC TEST...
TROUBLESHOOTING - QODBC DRIVER CRASHES QUICKBOOKS 2017 ON CLOSE PROBLEM DESCRIPTION: QODBC crashes QB Desktop 2017 after completing all SQL transactions. Here are the details. 1. SQL command is sent to the QODBC connector 2. QODBC connector opens u...
TROUBLESHOOTING - [FIXED] MICROSOFT EXCEL/ACCESS 365/2016 - INVALID CERTIFICATE ERROR/DIGITAL SIGNATURE ERROR/CERTIFICATE ERROR/GETTING INVALID CERTIFICATE ERROR WHEN TRYING TO CONNECT USING MS ACCESS OR EXCEL PROBLEM DESCRIPTION: I am using QODBC to e...
TROUBLESHOOTING - GETTING ERROR A FOUR-PART NAME WAS SUPPLIED, BUT THE PROVIDER DOES NOT EXPOSE THE NECESSARY INTERFACES TO USE A CATALOG OR SCHEMA. PROBLEM DESCRIPTION: I am using QODBC to fetch QuickBooks Data in SQL Server. I have created Linked S...
HOW OPTIMIZER WORKS PROBLEM DESCRIPTION: I am using QODBC to access QuickBooks Data. I am using optimizer & I want to know How Optimizer Works. SOLUTION: The optimizer brings some data to a local cache to increase query retrieval performance. Below ...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE PROBLEM DESCRIPTION: I am using QODBC to access QuickBooks Data. I have linked all QuickBooks tables using QODBC. I want the Customer table to be Optimizer OFF and the rest to be Optim...
TROUBLESHOOTING - "TRANSACTIONS" TABLE, BUT THEY DON'T APPEAR TO "BALANCE." PROBLEM DESCRIPTION: I am attempting to extract data from a client's hosted QuickBooks Enterprise system. I need every transaction in the system as we are transitioning to a di...
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 QuickBooks D...
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 parameter is used for runn...
TROUBLESHOOTING - GETTING ERROR [HY004] [MICROSOFT][ODBC DRIVER MANAGER] SQL DATA TYPE OUT OF RANGE (0) (SQLBINDPARAMETER) WHEN RUNNING PYTHON SCRIPT PROBLEM DESCRIPTION: I am using Python script to access QuickBooks Data. I can select QuickBooks Data ...
TROUBLESHOOTING - HOW TO ADD MULTIPLE FILTER ON PARAMETER IN SP_REPORT PROBLEM DESCRIPTION: I am using sp_report through QODBC & I have noticed that using QuickBooks UI, we can add multiple TxnFilterTypes like 'Invoice,' 'CreditMemo,' and 'SalesReciept...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS EXCEL REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into MS Excel Report. The attached invoice is similar to what we need to export to MS Excel...
TROUBLESHOOTING - QODBC CUSTOMSUMMARY REPORT IS NOT RECONCILING WITH QUICKBOOKS CUSTOMSUMMARY. PROBLEM DESCRIPTION: I am running the QODBC report "CustomSummary" and comparing it to what should be the identical report in QuickBooks. I am encountering ...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS ACCESS REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into Microsoft Access. The attached invoice is similar to what we need to export to Access...
HOW TO EXPORT QUICKBOOKS INVOICES INTO CRYSTAL REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into Crystal Reports. The attached invoice is similar to what we need to export to Crystal R...
TROUBLESHOOTING - TOP QUICKBOOKS ONLINE API ERRORS AND HOW TO HANDLE THEM HOW TO HANDLE FREQUENTLY RETURNED QUICKBOOKS ONLINE API ERROR MESSAGES This article will list these error responses and provide recommendations and best practices for handling t...
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 parameter. ...
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 the Pro Edition tab. ...
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 Databas...
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 City, ...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. 653 - THERE WAS AN ERROR WHILE COMMUNICATING WITH THE IDS SERVER. THE RESPONSE STREAM WAS NULL OR EMPTY. PROBLEM DESCRIPTION: I am using QODBC Online. I have authorized QODBC Online at QuickBooks Online. Wh...
HOW TO INSTALL QODBC READ-ONLY EDITION FOR QUICKBOOKS ENTERPRISE EDITION PROBLEM DESCRIPTION: I am using QuickBooks Enterprise & I want to use QODBC read-only edition for QuickBooks Enterprise. How can I install QODBC read-only edition for QuickBooks...
SAMPLE VB.NET WEB APPLICATION FOR INSERTING INVOICELINE INTO EXISTING INVOICE SAMPLE APPLICATION: Please click here [http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net-VB.zip] for down...
SAMPLE VB.NET SOURCE CODE FOR INSERTING INVOICELINE INTO EXISTING INVOICE SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample-VB.zip] for downloading Sample Code. Please refer be...
TROUBLESHOOTING - HOW TO RUN PROFITANDLOSSBUDGETOVERVIEW BY CLASS REPORT TYPICAL PROFIT & LOSS BUDGET OVERVIEW BY CLASS REPORT (FOR THE CURRENT FISCAL YEAR TO DATE) IN QUICKBOOKS NOTE: The QuickBooks Sample files set the QuickBooks date to December 15...
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 S...
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 ODB...
HOW TO EXPORT TO MS ACCESS PROBLEM DESCRIPTION: I am using QXL & I want to export QuickBooks Data to MS Access. How can I export QuickBooks Data to MS Access using QXL? SOLUTION: You can export QuickBooks Data to MS Access using QXL. First, You ...
HOW TO RUN A PROFIT AND LOSS DETAIL REPORT - WITH DIFFERENT PARAMETERS PROBLEM DESCRIPTION: I am using QXL & I want to run a Profit and Loss detail report through QXL. I can see the report on the list. But I want to change the report parameter. How c...
HOW TO RUN GENERAL DETAIL (GENERAL LEDGER) REPORT - WITH PARAMETERS PROBLEM DESCRIPTION: I am using QXL & I want to run the GeneralLedger report through QXL. I can see the report on the list. But I want to change the report parameter. How can I chang...
TROUBLESHOOTING - HOW TO TURN ON/OFF ENCRYPTION ON QREMOTE PROBLEM DESCRIPTION: I am using QRemote to access QuickBooks Data & I want to add security when accessing my QuickBooks Data through QRemote. How can I use Encryption in QRemote? SOLUTION ...
TROUBLESHOOTING - HOW TO USE QREMOTESERVER WITH MULTIPLE WINDOWS USER PROBLEM DESCRIPTION: I have a server where multiple users are logged in. I want to run QRemoteServer for each Windows User. Can I configure QRemoteServer user-wise? So QRemote c...
HOW TO USE QXL WITH SCHEDULER PROBLEM DESCRIPTION: I want to export QuickBooks Data using QXL. I want to schedule QXL for exporting QuickBooks Data. So it will automatically ship QuickBooks Data at the scheduled time. But I don't know how I can use...
TROUBLESHOOTING - ERROR 3120 - OBJECT X SPECIFIED IN THE REQUEST CANNOT BE FOUND. PROBLEM DESCRIPTION: I could link all tables to an MS Access DB from QuickBooks Database. But I got the following error when I tried to open the ItemAssembliesCanBuild...
TROUBLESHOOTING - HOW TO CHANGE THE CONNECTION STRING STORED IN EXCEL PROBLEM DESCRIPTION:  I have changed the setting in QODBC Setup Screen from Open mode to the same as the company file, but my Excel still does not takes the changes and needs the comp...
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 clicked o...
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 ...
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 foun...
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 - Insu...
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 SOLUTIO...
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 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 - [FIXED] QODBC EXTREMELY SLOW AFTER LATEST QUICKBOOKS 2017 R5 UPDATE PROBLEM DESCRIPTION: We updated to the latest QuickBooks 2017 Patch, officially known as Release R5P. After running seemingly OK for two days, QODBC is *extremely* slu...
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 below e...
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 ...
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 CREA...
TROUBLESHOOTING - HOW TO FIND AN ITEM NOT SOLD AFTER A SPECIFIC DATE AND MARK IT INACTIVE. PROBLEM DESCRIPTION: We would wish to inactive items that have not sold after a certain date. Is this possible? If so, any help would be appreciated. SOLUTION: ...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING C#.NET WEB APPLICATION SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/OLINVCW/QODBCOL-Invoice-Insert-Sample-Asp.net.zip] to download Sample Cod...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING C#.NET SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/OLINVC/QODBCOL-Invoice-Insert-Sample.zip] to download Sample Code. Please refer below s...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING PHP SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/OLINVPHP/QODBCOL-Invoice-Insert-Sample.zip] to download Sample Code. Please refer below st...
TROUBLESHOOTING - IS THERE A SALES JOURNAL REPORT BY CLASS PROBLEM DESCRIPTION: For months I've been trying to get a Sales journal report. All I seem to get is either too detailed (by items) or too summary (sum by customer). I need a list of invoices by...
HOW TO USE QODBC WITH LAYER2 CLOUD CONNECTOR SOLUTION This article shows how you can easily integrate the QODBC driver for QuickBooks into Layer2 Cloud Connector Solution. 1. Open Connection Manager by clicking on "Start Connection Manager." Connecti...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING C#.NET WEB APPLICATION SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net.zip] to download Sample Code. ...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING C#.NET SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample.zip] to download Sample Code. Please refer below steps...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING PHP SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVPHP/QODBC-Invoice-Insert-Sample-php.zip] to download Sample Code. Please refer below st...
TROUBLESHOOTING - HOW DO I GET THE COMPANY BUSINESS NUMBER PROBLEM DESCRIPTION: In QuickBooks enterprise, the company information form shows me the company's business#. In a custom report, the field is displayed as blank. In VBDEMO, the field shows as...
TROUBLESHOOTING - UNABLE TO CONNECT TO QUICKBOOKS POS 2015 (12.0) USING OFFICE 365 / 2016  PROBLEM DESCRIPTION: I have QuickBooks POS 2015 (12.0) & I want to connect to QuickBooks POS using MS Access/Excel. I am unable to connect to QBPOS with Access an...
TROUBLESHOOTING - CANNOT LOAD CUSTOMER TABLE RECORDS. PROBLEM DESCRIPTION: I am trying to query the Customer table. The Title Bar of the Access Application says Not responding. Still, it never opens for me in the datasheet view, either double-clicking t...
TROUBLESHOOTING - GETTING ERROR SPECIFIED DRIVER COULD NOT BE LOADED DUE TO SYSTEM ERROR 182 PROBLEM DESCRIPTION: We upgraded to QuickBooks Enterprise 15, and now we cannot get QReportBuilder to refresh data. The error is Error message: Could not crea...
HOW TO DOWNLOAD AND INSTALL QXL ONLINE REFER: HOW TO CONNECT/RECONNECT QXL ONLINE [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/KNOWLEDGEBASE/ARTICLE/VIEW/2879] STEP 1 - DOWNLOAD QXL ONLINE If you haven't already downloaded QXL Online, go to the...
TROUBLESHOOTING - CAN I USE DROPBOX/GOOGLE DRIVE WITH QUICKBOOKS & QODBC? PROBLEM DESCRIPTION: Can I use Dropbox/Google Drive with QuickBooks & QODBC? SOLUTION: No, You can't use Dropbox/Google Drive with QuickBooks & QODBC because Dropbox/Google Dri...
TROUBLESHOOTING - DOES THE MONTHLY FEE INCLUDE ALL OF MY COMPANY FILES, OR WILL I BE CHARGED PER COMPANY? PROBLEM DESCRIPTION: I'm using the trial for QuickBooks Online I see that the monthly fee is $14.95. Will this include all of my company files, or ...
TROUBLESHOOTING - HOW DO I RUN A COLLECTIONS REPORT? PROBLEM DESCRIPTION: How do I run a Collections Report? SOLUTION: A typical Collections Report in QuickBooks looks like this: With QODBC, the same report can be generated using stored procedure r...
TROUBLESHOOTING - RUNTIME ERROR (28) WHEN USING WINDOWS XP BUT NOT WINDOWS 2000. PROBLEM DESCRIPTION: We have four machines using the ODBC driver with QuickBooks and Access 2003 that work perfectly fine. The odd machine is a slightly higher version of A...
TROUBLESHOOTING - UPDATE QUERY OPTIMIZATION. PROBLEM DESCRIPTION: Can you give me some insights on optimizing an update query to the PriceLevelPerItem table? I am trying to update all of my existing price levels, and I'm looping through each inventory ...
TROUBLESHOOTING - PERFORMANCE ISSUE QODBC TEST TOOL VERSUS MY C# APP. PROBLEM DESCRIPTION: I am running the same query on both returns, a big difference. The QODBC Test Tool app takes around 7 seconds, and my C# app takes 1:20 minutes. Are there any s...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN SQL SERVER. PROBLEM DESCRIPTION: I am trying to create Linked Server on SQL Server. QODBC TEST TOOL connects successfully to QREMOTE on QuickBooks Server. Setting up the Linked se...
QXL ONLINE IS NO LONGER CONNECTED TO QUICKBOOKS ONLINE. YOUR USER TOKEN IS NO LONGER VALID. HOW TO JOIN/RECONNECT QXL ONLINE REFER: HOW TO DOWNLOAD AND INSTALL QXL ONLINE [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/KNOWLEDGEBASE/ARTICLE/VIEW/2...
TROUBLESHOOTING - HOW TO TELL WHAT VERSION OF QODBC I AM USING PROBLEM DESCRIPTION: How to tell what version of QODBC I am using? SOLUTION: To find out which version of QODBC you are using, please follow the below steps: 1. Click START -> ALL PROGR...
HOW TO USE QODBC WITH MICROSTRATEGY QODBC enables access to various important data sources in business intelligence tools such as Microstrategy. In this article, We will show how to connect to QuickBooks data, import data with the UI or query, and create...
NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER JAVA-BASED APPLICATIONS. Refer: Oracle JDBC-ODBC Bridge [http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bri...
HOW TO USE QODBC WITH TALEND ETL NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER JAVA-BASED APPLICATIONS. Refer: Oracle JDBC-ODBC Bridge [http://docs.oracle.com/javas...
HOW TO USE QODBC WITH TIBCO SPOTFIRE This article walks you through using the QODBC Driver for QuickBooks in TIBCO Spotfire. You will use the data import wizard to connect to a DSN (data source name) for QuickBooks and build on the sample visualizations ...
TROUBLESHOOTING - GETTING ERROR [QODBC] REQUIRES AT LEAST ONE CHILD. I CANNOT DELETE THE LAST LINE PROBLEM DESCRIPTION: I entered a series of purchase orders with queries that look like this: INSERT INTO PurchaseOrderLine ("VendorRefListID", "RefNumb...
INSTALLATION STEPS FOR WINDOWS 10 After you have downloaded QODBC Online Installer, navigate to the "Downloads" Folder or the location where you have saved QODBC Online Installer. Run the installer as administrator by clicking on the installer and selec...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOWS 10 INSTALL QODBC POS Please download the QODBC POS installer by clicking here [http://www.qodbc.com/posDownload.htm] Right Click on the Installer and select "Run As Administrator." Pl...
CONNECTING TO QUICKBOOKS ONLINE FAILED BECAUSE OF A WINDOWS SECURITY ISSUE. TEST CONNECTION NOT WORKING. PROBLEM DESCRIPTION: The QODBC Driver for QuickBooks Online runs differently under Microsoft Vista/W7 than other versions of Windows because of its...
CONNECTING TO QUICKBOOKS POS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE. TEST CONNECTION WAS NOT WORKING PROBLEM DESCRIPTION: The QODBC Driver for QuickBooks POS runs differently under Microsoft Vista/W7 than other versions of Windows because of its ne...
TROUBLESHOOTING - VB DEMO IS CRASHING WHEN USING THE NON-EXISTING COLUMN NAME IN THE LEFT OUTER JOIN QUERY NOTE: VB DEMO IS DEPRECATED. Please refer to How to use the QODBC Test Tool for testing [https://support.flexquarters.com/esupport/index.php?/Kn...
TROUBLESHOOTING - HOW TO ADD DISCOUNT VALUE TO SALESRECEIPTITEM PROBLEM DESCRIPTION: I want to add a $50 discount on a sales receipt item. I have been using the "discount" field in my SQL statement. I keep getting an error: ERROR [42S00] [QODBCPOS] ...
TROUBLESHOOTING - REFUNDING CREDIT CARDS - THERE WAS AN ERROR WHEN PARSING THE PROVIDED XML FILE. PROBLEM DESCRIPTION: Hello, I am trying to refund CC payments in QuickBooks. I can create the credit memo. However, when attempting to add the refund us...
TROUBLESHOOTING - UNABLE TO LOAD ALL CUSTOMER RECORDS DUE TO CUSTOMERSHIPPINGADDRESS PROBLEM DESCRIPTION: I am unable to load all customer records through QODBC. I have a large number of ship-to addresses customers. I have tried to execute the que...
TROUBLESHOOTING - LOGGING OUT THE QUICKBOOKS USER THROUGH QODBC PROBLEM DESCRIPTION: We created a user expressly for QODBC access. How can we facilitate a way for our QuickBooks users to log this user off when the single-user mode is needed? SOLUT...
TROUBLESHOOTING - QREMOTE SERVER IS NOT RETURNING DATA TO SQL SERVER PROBLEM DESCRIPTION: Installed the server connection component and began the process of reconnecting I ran a really simple set of tests: select * from C01...Terms Select * from op...
TROUBLESHOOTING - GETTING ERROR UNABLE TO BIND TO SPECIFIED IP ADDRESS PROBLEM DESCRIPTION: QODBC stopped working, and I got IP errors. All fixes I can find on support pages require that QRemote Server is started. QRemote Server will not start. I ge...
TROUBLESHOOTING - GETTING ERROR THIS FILE IS IN USE PROBLEM DESCRIPTION: We are trying to use your drivers to connect to 3 different QuickBooks files. But when I browse to the first file to setup the ODBC data source, I get this message: We are dead...
QODBC ONLINE SETUP OPTIONS QODBC ONLINE GENERAL SETUP The first step in configuring the driver is to click on the QODBC Online Setup Screen, and the following general setup screen will become available. SERVER: Indicates where the QODBC's Connector...
HOW TO USE QODBC POS WITH MS EXCEL 2016 / 365 / 2013 SETUP QODBC TO USE WITH MS EXCEL NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain ...
HOW TO USE QODBC POS WITH MS ACCESS 2016 / 365 / 2013 CREATING A TABLE IN MICROSOFT ACCESS: NOTE: Microsoft Access has many uses and will allow you to use your QuickBooks data files similarly to Access databases. Open MS Access 2016/2013. You can find...
HOW TO CONFIGURE QODBC POS TO WORK WITH 64-BIT APPLICATIONS INSTRUCTIONS 64 and 32-bit words are kept separate in the Microsoft Windows Operating System. QuickBooks POS is a 32-bit application, so a 32-bit ODBC driver is required to communicate with it...
QREMOTE TUTORIAL: USING QUICKBOOKS POS DATA REMOTELY VIA QODBC POS QODBC POS can talk to a copy of QuickBooks POS running anywhere in the world over the Internet or a local area network. This feature is built-in into the licensed version and requires no ...
QODBC POS SETUP OPTIONS QODBC POS GENERAL SETUP The first step in configuring the driver is to click on the QODBC POS Setup Screen, and the following general setup screen will become available. THE COMPANY SET allows QODBC POS to enter the company ...
TROUBLESHOOTING - ERROR: 1000 - THERE HAS BEEN AN INTERNAL ERROR WHEN PROCESSING THE REQUEST PROBLEM DESCRIPTION: I get a very strange error... I have a development system and a dummy QB file (copy of the company file) that runs fine. However, when I m...
TROUBLESHOOTING - DOES QODBC SUPPORT "LIKE 'I%'"? PROBLEM DESCRIPTION: How should the following SQL query be written to work with QODBC, using the "like" filter to restrict records? SELECT Sales.RefNumber, Sales.BillAddressAddr1, Sales.Type, Sales.Tx...
TROUBLESHOOTING - ERROR 3180 - THE CREDIT LIMIT FOR THE NAME ON THIS TRANSACTION HAS BEEN EXCEEDED PROBLEM DESCRIPTION: We use QOBDC Read Write 8.00.00.234 With QuickBooks Enterprise 2007. When trying to Save a SalesOrder with three SalesOrderLine, re...
TROUBLESHOOTING - CHECK THE ISTOBEPRINTED UPDATE QUERY PROBLEM DESCRIPTION: I'm having a problem running this SQL statement in QODBC TEST TOOL. The application returns an error message: [QODBC] Not supported. UPDATE Check SET IsToBePrinted = 1 WHERE ...
TROUBLESHOOTING - WHERE IS RETAINED EARNINGS DATA FOUND? PROBLEM DESCRIPTION: I cannot find a table with the retained earnings listed in it. Furthermore, I find no transactions for this account, yet QB reports two closing entries. In the account tabl...
TROUBLESHOOTING - HOW TO INSERT UPDATE PAYROLLITEMNONWAGE LIKE AUTO ALLOWANCE, BENEFITS, FEDERAL INCOME, ETC PROBLEM DESCRIPTION: How can we update the Insert PayrollItemNonWage field as Auto Allowance, Benefits, Federal Income, etc.? Suppose we add,...
TROUBLESHOOTING - EASIEST WAY TO MAKE A REPORT SHOWING THE AVERAGE TIME BETWEEN RECEIPT AND INVOICE OF THE ITEM PROBLEM DESCRIPTION: I want to make a report to show me which items are selling quickly and slowly. I figure I need to look at the length of...
NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER JAVA-BASED APPLICATIONS. Refer: Oracle JDBC-ODBC Bridge [http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bri...
TROUBLESHOOTING - CREDITCARDINFOCREDITCARDNUMBER RETURNS ******1234 PROBLEM DESCRIPTION: This used to work, and I have no idea why it now blinds all reads of the CreditCardInfoCreditCardNumber field in the Customer table. I previously used QODBC to t...
TROUBLESHOOTING - CREATING PO USING ALPHA FIVE BASIC SCRIPTING IS NOT WORKING CORRECTLY PROBLEM DESCRIPTION: I am using Alpha 5 version 10.5 basic scripting to export our data to QB Enterprise 2016. I have successfully exported our customer and inven...
TROUBLESHOOTING - HOW TO CREATE PRICELEVELPERITEM & PRICELEVELFIXEDPERCENTAGE USING QODBC PROBLEM DESCRIPTION: How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC. SOLUTION: To create a new PriceLevel and PriceLevelPerItem item (...
HOW TO INSERT A SALESORDERLINE ITEM INTO AN EXISTING SALESORDER PROBLEM DESCRIPTION: I routinely create new sales orders with queries similar to this: INSERT INTO SalesOrderLine ("CustomerRefListID," "RefNumber," "SalesOrderLineItemRefListID," "Sales...
HOW TO USE QREMOTE WITH COLDFUSION INSTRUCTIONS ABOUT USING QREMOTE WITH COLDFUSION Using ColdFusion on an internal Intranet or the World Wide Web requires the Server Edition of QODBC. QuickBooks must be running with the company file opened on the sys...
MICROSOFT WORD 2016 AND QODBC CREATING A WORD MAIL MERGE TO LIVE QUICKBOOKS DATA NOTE: QODBC allows you to easily merge QuickBooks data into your Word documents as tables or mail-merged fields. Open the document you wish to mail merge QuickBooks data...
TROUBLESHOOTING - GETTING ODBC-CALL FAILED ERROR IN MS ACCESS WHEN OPENING THE RECEIVEPAYMENTTODEPOSIT TABLE PROBLEM DESCRIPTION: I am trying to link the ReceivePaymentToDeposit table through the linked table in MS Access. I can connect the ReceivePaym...
TROUBLESHOOTING - QODBC - USER RIGHTS WITHIN QUICKBOOKS PROBLEM DESCRIPTION 1: I want to be able to access QuickBooks to extract inventory data in database format. I believe this is possible with QODBC. My issue is that I do not want this person to hav...
HOW TO CONNECT AND USE FOXPRO WITH QODBC Open Visual FoxPro from Start Menu: FoxPro started: Open "Command Window" from Windows Menu: "Command Window" Opened. You can execute FoxPro commands from the "Command Window." You need to write FoxPro com...
QXL ONLINE OPTIONS AND SETTINGS QXL ONLINE OPTIONS AND SETTINGS/CONFIGURATION: The first step in configuring the application is to click on the settings icon for QXL Online options details. CONNECTIONS TAB: You can add manage connections from Connecti...
TROUBLESHOOTING - HOW CAN WE SELECT INVOICES FOR PAYMENT FROM THE BILLTOPAY TABLE USING QODBC PROBLEM DESCRIPTION: In the BillToPay Table - How can we select invoices for payment using QODBC? We would like to have the Checkmark Selected for the resp...
TROUBLESHOOTING - HOW TO ENABLE DETAIL ROWS FOR BALANCESHEETDETAIL, GENERALLEDGER, JOURNAL, PROFITANDLOSSDETAIL, TXNDETAILBYACCOUNT REPORTS PROBLEM DESCRIPTION: I am executing BalanceSheetDetail, GeneralLedger, Journal, ProfitAndLossDetail, and TxnDe...
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...
TROUBLESHOOTING - HOW TO ZIP AND UPLOAD THE COMPANY FILE PROBLEM DESCRIPTION: How to zip and upload the company file on http://qodbc.com/send SOLUTION: Please download [http://www.7-zip.org/download.html] & install 7-zip if you haven't installed zip...
TROUBLESHOOTING - MS ACCESS DISPLAYS "#DELETED" IN EVERY FIELD PROBLEM DESCRIPTION: Using QuickBooks Accountant, QODBC, and MS Access Linked table. Sometimes, e.g., at present, working with the InventoryAdjustment table, a table view or query returns...
QXL ONLINE LIMITED USE SOFTWARE LICENSE LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing uni...
QODBC LIMITED USE SOFTWARE LICENSE   LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing unit)...
QODBC ONLINE QUICK START GUIDE Download: QODBC Online Quick Start Guide [http://qodbc.com/download/QODBC%20Online%20Quick%20Start%20Guide.pdf] (PDF) QODBC ONLINE DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2599.HTM] INTRODUCTION WHAT IS OD...
QODBC POS QUICK START GUIDE Download: QODBC POS 2019 Quick Start Guide [http://qodbc.com/download/QODBC%20POS%20Quick%20Start%20Guide.pdf] (PDF) QODBC POS DRIVER LICENSE AGREEMENT [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Artic...
QODBC QUICK START GUIDE Download: QODBC 2023 Quick Start Guide [https://qodbc.com/download/QODBCQuickStartGuide.pdf] (PDF) QODBC DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2479.HTM] INTRODUCTION WHAT IS ODBC? ODBC (OPEN DATABASE CONNECT...
HOW TO USE POWERSHELL WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/PowerShell/DisplaySQL.zip] SAMPLE CODE FOR USING QODBC DSN: $connectstring = "DSN=QuickBooks Data;" $sql = "Select TOP 10 Name from Customer" $conn ...
INSTALLATION PROBLEM WITH QODBC PROBLEM DESCRIPTION 1: I am trying to install QODBC on my system installation hung (not responding) at 10 %, then gave the error below: I could not load the DLL library C:WindowsSystem32fqqb32.dll. Invalid access to me...
For Windows 8 or 8.1, click here [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2478/0/installation-steps-for-windows-8] INSTALLATION STEPS FOR WINDOWS 10 After you have downloaded QODBC Installer, navigate to the "Dow...
There is no performance difference between the QODBC Server Edition license and QODBC Read/Write license. There is no difference in the commands, queries, data, or schema between the QODBC Server Edition license and QODBC Read/Write license. QODBC is ...
QODBC ONLINE MENU ITEMS When you install QODBC Online below menu items are created under QODBC Driver for use with the QuickBooks Online folder in the start menu. 1. CONFIGURE QODBC ONLINE DATA SOURCE 64-BIT Configure QODBC Online Data Source 64-bit...
QODBC POS MENU ITEMS When you install QODBC POS below menu items are created under QODBC Driver for use with the QuickBooks POS folder in the start menu. 1. CONFIGURE QODBC POS DATA SOURCE 64-BIT Configure QODBC POS Data Source 64-bit option will he...
QODBC MENU ITEMS When you install QODBC, the below menu items are created under QODBC Driver for use with the QuickBooks folder in the start menu. 1. CONFIGURE QODBC DATA SOURCE 64-BIT CONFIGURE QODBC DATA SOURCE 64-BIT will help you to view/create/...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040438 PROBLEM DESCRIPTION: I am testing the connection of QODBC & I am getting the QODBC test connection failed error: Can you advise what is error and the solution for it? SOLUTION: The above ...
TROUBLESHOOTING - UPDATE FROM A SELECT STATEMENT NOT WORKING PROBLEM DESCRIPTION: I am trying to update records through the select statement. But it is not working. UPDATE Customer SET CustomFieldProjectNumber = i.JobNumber FROM ( SELECT ListID, {fn...
TROUBLESHOOTING - GETTING INCOMPLETE DATA WHEN RUNNING THE PROFITANDLOSSBUDGETVSACTUAL REPORT PROBLEM DESCRIPTION: Good Day To You. Using This Sp_report And Having Some Problems With The Column Layout. Command Text Is As Follows: Sp_report Profitandlo...
SYSTEM REQUIREMENTS FOR USING QODBC, QODBC ONLINE, AND QODBC POS  QODBC DESKTOP  QODBC is a Windows Driver (DLL) with the exact system requirements as the QuickBooks Desktop Accounting version it communicates with. QODBC POS  QODBC is a Windows Drive...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer to How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://support.flexquarters...
HOW TO IMPORT QUICKBOOKS DATA TO SQL SERVER DATABASE (LOCAL TABLE) First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer to How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://sup...
EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE Download Sample [http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip] Before using the MS Excel application, please ensure you have installed the MS Off...
TROUBLESHOOTING - CDKEY HAS AN INVALID CHECKSUM PROBLEM DESCRIPTION: I just purchased a QODBC 2024 license. I have everything set up, but I can't activate the CDKEY. "CDKEY has an invalid checksum." SOLUTION: QODBC 2024 CDKEY/license can only be...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. UNABLE TO LOAD COMPONENT PROBLEM DESCRIPTION: I am trying to connect to QuickBooks Online using QODBC Online. But I am getting the below error at the time of connection. Please help me to resolve this error...
HOW TO INSERT INVOICE USING EXCEL - VBA Download Sample [http://support.flexquarters.com/esupport/newimages/InsertInvoiceVBA/Insert_Invoice.zip] In this example, We will show you How to insert an Invoice in QuickBooks using the data available in an Exc...
CONNECTING MULTIPLE QUICKBOOKS COMPANIES VIA EXCEL Download Sample [http://support.flexquarters.com/esupport/newimages/MultipleCompany/MultipleQBCompanyConnection.zip] There is a limitation with the QuickBooks SDK: it can connect only one company file ...
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 ...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL PACKAGE PROBLEM DESCRIPTION: I am getting Error SOCKET Closed because of an abnormal package in the QRemote client. I am accessing QuickBooks Data from the remote machine over the inter...
TROUBLESHOOTING - QODBC RECORD SET ISSUE PROBLEM DESCRIPTION: I am using the below code. It is returning records & giving me the correct result. But If I change the query from "SELECT Name FROM customer" to "SELECT * FROM customer," it does not return...
TROUBLESHOOTING - HOW DO I KNOW WHICH VERSION OF QUICKBOOKS MY QODBC LICENSE WORKS WITH? PROBLEM DESCRIPTION: How do I know which version of QuickBooks my QODBC license works with? SOLUTION: To find out which version of QuickBooks with your QODBC l...
TROUBLESHOOTING - HOW TO GET ADVANCED PRICING MODULE IN QODBC PROBLEM DESCRIPTION: We are using an advanced pricing module in QuickBooks and would like to know what tables we need to access to pull that information from the system. SOLUTION: Advanc...
TROUBLESHOOTING - HOW TO CLOSE SQL LINKED SERVER CONNECTION PROBLEM DESCRIPTION: We are using QRemote with SQL Linked Servers with several different QuickBooks files. How can we close the connection to a QuickBooks file after the query has run, then o...
TROUBLESHOOTING - REPORTING SHIP TO ADDRESSES PROBLEM DESCRIPTION: Has anyone run a report that will pull all the detail for a range of invoices? In particular, I'm looking to run a report that shows the ship-to addresses for specific products over a ...
TROUBLESHOOTING - SP_REPORT CHANGING DAYS PER AGING USING QODBC PROBLEM DESCRIPTION: I recently discovered QODBC and have been playing with it for a few days. It's pretty good. The problem I have is when I try to get A/P aging. The A/P aging has a d...
TROUBLESHOOTING - CODE DIFFERENCES BETWEEN QODBC DESKTOP AND QODBC ONLINE PROBLEM DESCRIPTION: I have an MS Access application using QODBC to connect to desktop QuickBooks. Can I use the QODBC Online driver to connect to QuickBooks Online without chan...
TROUBLESHOOTING - CONNECTION SERIAL, LIMITATION, QUEUE, AND UPPER LIMIT PROBLEM DESCRIPTION: How many concurrent connections does the Server edition support? Is the product QB version specific, requiring additional purchases with each version? AKA. ...
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 cre...
HOW TO CHANGE QXL SAMPLE REPORT DATA SOURCE There is two way to Change QXL Sample Report Data Source. 1. Automated. 2. Manual 1. AUTOMATED Open the QXL Sample spreadsheet. Click on the Change Data Source button. Choose the QXL Export folder you ...
USING ADODC AND ADODB WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/VB6/QODBCVB6.zip] ADODB WITH QODBC Open VB6, you can find it via Windows Start->All Programs->Microsoft Visual Studio 6.0 : Create a New Standard EX...
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 ...
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 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...
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...
TROUBLESHOOTING - QXL 8004040A 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. You have QuickBooks open to a particular comp...
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, an...
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...
TROUBLESHOOTING - HOW TO CANCEL THE SUBSCRIPTION OF QODBC DRIVER FOR QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I want to cancel my QODBC Driver for QuickBooks Online monthly subscription. How to cancel the subscription of QODBC Driver for QuickBooks Onl...
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 - CHANGES TO THE INTEGRATED APPLICATION AUTHENTICATION FOR QUICKBOOKS Intuit is reinforcing existing security features that help protect QuickBooks customers' sensitive information. Refer: Intuit's News: Changes to the Integrated Applic...
TROUBLESHOOTING - QODBC INSTALLER ERROR WINDOWS CANNOT FIND EXPLORER.EXE. COULD NOT EXECUTE THE EXTERNAL PROGRAM PROBLEM DESCRIPTION: We downloaded the QODBC trial from your website. At the end of the installation process - after clicking the 'finish'...
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. ...
HOW TO USE QODBC WITH SSIS Either QODBC or QRemote is required on the machine where the SSIS package will be developed and deployed, or SSIS services are installed. Development - On the machine, you are developing, the SSIS package should have QODBC ...
TROUBLESHOOTING - CAN I USE QODBC WITH QBB ( QUICKBOOKS BACKUP ) FILE PROBLEM DESCRIPTION: I am trying to find a way to pull data from a . QBB file without having to restore the. QBB file and going through QuickBooks. Is QODBC capable of doing so? I...
[QODBC-ONLINE] TROUBLESHOOTING - QUICKBOOKS MESSAGE 653-UNAUTHORIZED - 401 - FAULT EXCEPTION OF TYPE: AUTHENTICATION HAS BEEN GENERATED. QB BEGIN SESSION FAILED. ERROR - UNAUTHORIZED-401 PROBLEM DESCRIPTION: I was able to use QODBC Online. Suddenly, I g...
SAMPLE CODE FOR C++ WITH QODBC #include #include #include #include #include #include #include #include using namespace std; void ConvertTimeStampStructToString(TIMEST...
TROUBLESHOOTING - DSN CONNECTION NOT CONSISTENT ACROSS MULTIPLE COMPUTERS PROBLEM DESCRIPTION: I have a pass-through query for access: Select * from Item The connection string is as follows: ODBC;DRIVER={QODBC Driver for QuickBooks};SERVER=QODBC;DF...
TROUBLESHOOTING - QODBC LOGGING IN WITH THE WRONG USER ACCOUNT PROBLEM DESCRIPTION: I am using ms access. I have the integrated application certificate set up correctly (see screenshot). The username for this certificate is "odbc." QuickBooks is clos...
TROUBLESHOOTING - HOW DO I SEE BACKORDER ITEMS THAT HAVE BEEN INVOICED BUT NOT SHIPPED PROBLEM DESCRIPTION: Could someone kindly provide me with a sample, or is there a stored procedure that would allow me to only pull out back ordered invoices from t...
TROUBLESHOOTING - TRYING TO UPDATE THE ITEMINVENTORYASSEMBLYLINE TABLE PROBLEM DESCRIPTION: All our products are Inventory Assemblies. I am using MS Access connected to QuickBooks via QODBC. I am using queries in MS Access to loading/synchronize Inven...
TROUBLESHOOTING - QUICKBOOKS DISPLAYS A REVOKED CERTIFICATE WARNING PROBLEM DESCRIPTION: I am trying to connect to QuickBooks using QODBC. At a time of connection, QuickBooks Displays a Revoked Certificate Warning. SOLUTION: Please update your QODBC...
HOW TO SHARE/INVITE THE FLEXQUARTERS SUPPORT TEAM TO THE QUICKBOOKS ONLINE COMPANY FILE PROBLEM DESCRIPTION: How do I share/invite the FLEXquarters Support team to access my QBO company file? SOLUTION: Please follow the below steps to share/invite ...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 (64-BIT) FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2771] SETUP QODBC TO US...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT FOR 32-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK WITH 32-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2470]. CREATING A TABLE IN MICR...
TROUBLESHOOTING - QREMOTESERVER HANG-ON CONNECTION PROBLEM DESCRIPTION: I am trying to connect to QuickBooks/QuickBooks POS using QRemote Server, But QRemoteServer is Having on Connection. SOLUTION: Please check if QuickBooks Or QuickBooks POS has ...
TROUBLESHOOTING - HOW DO I UPDATE CUSTOMER CUSTOM FIELDS PROBLEM DESCRIPTION: How do I update Customer custom fields? SOLUTION: You can update Customer custom fields using the update query. For Example: Update Customer Set CustomFieldContract='QO...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE ARRAY BOUNDS." WHEN USING THE IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I recently installed QODBC to get data out of a QuickBooks company file, but I get this error: "Index was outs...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATIONS UNDER QUICKBOOKS POS Please follow the steps to remove QODBC Related Certificates from the Integrated Application Under QuickBooks POS: Try removing all the integrated application en...
TROUBLESHOOTING - HOW DO I REMOVE SUBTOTALS AND BLANK LINES IN SP_REPORT PROBLEM DESCRIPTION: I'm trying to link a general ledger report in Excel. I've created the sp_report SQL query in Microsoft Query just fine, but the data it returns contains subt...
TROUBLESHOOTING - UPGRADING TO QUICKBOOKS AND QODBC PROBLEM DESCRIPTION: I have a custom program written in Access 2003 communicating with QuickBooks 2013 using QODBC 13, which works fine. Will upgrade to the latest QuickBooks and QODBC require any co...
TROUBLESHOOTING - HOW TO USE BETWEEN IN QODBC PROBLEM DESCRIPTION: I need to use Between, in a range of dates, to return new customers in one period. I try this: SELECT FullName FROM Customer Where TimeCreated Between {d'2007-12-18'} AND {d'2007-12...
TROUBLESHOOTING - ODBC DRIVER DOESN'T SUPPORT THIS STATEMENT. UPDATING EXISTING RECORD PROBLEM DESCRIPTION: I'm trying to make Inventory Items In-Active after a sale programmatically or Active after voiding a sale. I thought the following SQL statem...
TROUBLESHOOTING - HOW DO I GET TABLE RECORD COUNT THE FASTEST WAY USING QODBC PROBLEM DESCRIPTION: What is the fastest way to get the number of records from a table? SOLUTION: QODBC would need to scan the whole table to get the record or row count....
TROUBLESHOOTING - HOW CAN I USE WILDCARD (*) WITH CRYSTAL REPORT AND SP_REPORT PROBLEM DESCRIPTION: I am using the following SQL statement: sp_report JobProfitabilityDetail show AmountActualCost_Title, AmountActualRevenue_Title, AmountDifferenceActu...
TROUBLESHOOTING - HOW CAN I GET LINKS BETWEEN ESTIMATE AND INVOICE USING QODBC PROBLEM DESCRIPTION: I've explored the related-to fields but cannot determine how a line on the invoice is linked to the estimate. I'm designing a report that needs to se...
TROUBLESHOOTING - HOW CAN I GET THE LAST ITEMS SOLD TO CUSTOMER DETAILS PROBLEM DESCRIPTION: I created a report using a custom set with the customer as the parent and InvoiceLine as the child giving me items ordered in the past. My problem is I only...
TROUBLESHOOTING - HOW TO EXTRACT PRINTED CHECKS INFORMATION USING QODBC PROBLEM DESCRIPTION: We are involved in a new project with our bank involving a 'Positive Payment' solution that requires I send them a file with the check summary data each time ...
TROUBLESHOOTING - CORRELATED SUBQUERIES IN THE UPDATE STATEMENT PROBLEM DESCRIPTION: I want to update the salesrep field in my existing invoices. I want to use the salesrep value stored in the Customer file. I would normally do this in SQL using a cor...
TROUBLESHOOTING - BILLABLE PAYROLL - NEED TO DISPLAY MORE FIELDS ON INVOICE PROBLEM DESCRIPTION: We need to bill all payroll costs to various customers. Payroll costs are defined as all of the following: 1. Employee's gross salary 2. Company share ...
TROUBLESHOOTING - WHERE IS THE BIN LOCATION FOR ITEMS STORED? PROBLEM DESCRIPTION 1: I am using QuickBooks Enterprise with Advanced Inventory enabled. I am trying to find where the bin location for items is stored in QuickBooks through QODBC. PROBL...
HOW TO USE QODBC WITH MS EXCEL POWER QUERY NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one click wi...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code that reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV us...
HOW TO CREATE OR CONFIGURE A QODBC ONLINE DSN PROBLEM DESCRIPTION: I have one QuickBooks Online login, which provides access to multiple QuickBooks Online companies. When I initially configured the connection, I selected one of the clients to that I ...
FOREIGN AND UNICODE CHARACTERS NOT SUPPORTED BY QODBC INFORMATION: QuickBooks allows users to put foreign (i.e., Chinese, Japanese, etc...) characters into item descriptions, etc... Unfortunately, these characters are not appropriately returned in qbX...
TROUBLESHOOTING - HOW TO STOP ANY QUERY ON VB DEMO APPLICATION PROBLEM DESCRIPTION: How to Stop any query on VBDEMO when it takes time. How to convert the date to QuickBooks date. I want to insert TxnDate in the ReceivePayment table, but it pops u...
TROUBLESHOOTING - HOW TO COMPUTE SUM WITHOUT COMPUTE CLAUSE PROBLEM DESCRIPTION: The following selection gives me the correct data using DISTINCT, but how do I get a sum of it, which is what I need? Select distinct billtopayduedate, billtopayrefnumb...
TROUBLESHOOTING - HOW DO I VOID AN INVOICE? PROBLEM DESCRIPTION: I don't see any indicator in the Invoice table. How do I void an Invoice? And How do I query for invoices that have been voided? SOLUTION: You can use SP_VOID just like you would use ...
TROUBLESHOOTING - HOW DO I GET TIMEFRAME INFORMATION - SALES BY HOUR REPORTING USING QODBC PROBLEM DESCRIPTION: This is a no technical question but one I need to answer myself before jumping into QODBC. I'm considering working with QODBC to get the in...
TROUBLESHOOTING - HOW DO I DELETE ORPHANED INVOICELINE RECORDS? PROBLEM DESCRIPTION: The InvoiceLine table contains orphan records (the parent invoice record no longer exists). I tried: DELETE FROM Invoice WHERE TxnID = 'xxxx-xxxxxxxxx' The TxnID is...
PROBLEM DESCRIPTION: How can I get daily payment bill information? And How can I get daily Bill Payment information using QODBC, and How can I get these details? SOLUTION: You can use the query below to get details about daily Bill Payments. For Exa...
TROUBLESHOOTING - HOW CAN I GET ALL THE RECORDS FOR A SPECIFIED YEAR PROBLEM DESCRIPTION: I need to compute a Year to Date total paid using the Invoice table. I'm working in MS-Access and need to run the following statement: SELECT SUM(Subtotal) FRO...
TROUBLESHOOTING - HOW CAN I CHANGE THE PRICING AND QUANTITY OF ITEMS IN AN ITEMGROUP? PROBLEM DESCRIPTION: How can I change the price of each item in a group? Is it possible? If yes, please give me an example. SOLUTION: The ItemInventory, ItemServi...
TROUBLESHOOTING - EXPENSES WRITTEN TO BILLEXPENSELINE ARE NOT SHOWING AS BILLABLE WHEN VIEWED IN QUICKBOOKS PROBLEM DESCRIPTION: The field ExpenseLineBillableStatus contains the status of the BillExpenseLine and uses the following stored procedure "sp...
AN EXAMPLE OF PURCHASEORDER ITEM GROUPS CREATE AN ITEMGROUP WITH THREE LINES Note: Let's create a new item group example with three lines using QODBC. Note the FQSaveToCache field, set to True except on the last one. FIRST LINE INSERT INTO "ITEMGRO...
TROUBLESHOOTING - HOW DO I LIST THE SUBTOTAL OF INVOICES WITHIN THE DATE RANGE PROBLEM DESCRIPTION: I want to list the subtotal of all Invoices by a customer for not only that particular customer but all jobs assigned to that customer within a specifi...
HOW TO CONNECT TO QODBC USING PYTHON Download Sample [http://support.flexquarters.com/esupport/newimages/python/DisplaySQL.zip] SAMPLE CODE FOR USING QODBC DSN: import pyodbc cn = pyodbc.connect('DSN=QuickBooks Data;') cursor = cn.cursor() cursor....
TROUBLESHOOTING - I CANNOT CONNECT TO MY QUICKBOOKS ONLINE SANDBOX PROBLEM DESCRIPTION: I am trying to do some testing and now have access to a QBO Sandbox company. I have tried to connect to it in two different ways. 1. If I "Connect to QuickBooks" ...
HOW TO CONNECT TO QUICKBOOKS ONLINE SANDBOX COMPANY FILE. For installation & configuring QODBC Online to work with QuickBooks Online live company file. Please refer: How to use QODBC Online with QuickBooks Online Edition (Apps.com) [http://support.flex...
TROUBLESHOOTING - INVOICE LINE RATE IS NOT LOADING INTO QUICKBOOKS ONLINE. PROBLEM DESCRIPTION: The InvoiceLineRate value passed in the insert query to create the InvoiceLine record is not being loaded into QBO. Below are the two queries I am using t...
TROUBLESHOOTING - [QODBC] INVALID OPERAND FOR THE OPERATOR: PROBLEM DESCRIPTION: I am getting the error "Invalid operand for the operator: " while trying to insert an invoice line item: INSERT INTO InvoiceLine ( CustomerRefL...
TROUBLESHOOTING - ANOTHER USER HAS CHANGED THIS RECORD SINCE YOU STARTED EDITING IT. PROBLEM DESCRIPTION: I used the QuickBooks Pro 2015 trial version and purchased QODBC's latest version. I have an Access database with linked QB tables. I also have ...
TROUBLESHOOTING - QUICKBOOKS UI GETTING LAUNCHED AFTER UPDATING QODBC VERSION. PROBLEM DESCRIPTION: We recently upgraded from QODBC 14 to 16.00.00.313. It is functioning normally, except now the QuickBooks window is opening up when it didn't use to. I...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL SERVER PROBLEM DESCRIPTION: So the QODBC works excellently running on the machine. We intend to integrate into our website / Intranet to create customers or make changes from the web. I...
TROUBLESHOOTING - QUICKBOOKS ADVANCED INVENTORY MODULE IN QODBC PROBLEM DESCRIPTION: Does your enterprise driver support the advanced inventory module for QuickBooks enterprise? Would we be able to query stock per item, per location? SOLUTION: You...
TROUBLESHOOTING - FAULTING APPLICATION NAME: QREMOTESERVER.EXE PROBLEM DESCRIPTION: We recently had a few error messages pop up on the server related to the QODBC driver on our server. We were wondering if you could provide any information as to what ...
TROUBLESHOOTING - [QODBC] COLUMN NOT FOUND REORDERBUILDPOINT PROBLEM DESCRIPTION: We just upgraded to v16 on both QB and QODBC, and now refreshes from Excel aren't working. We're getting the message "[QODBC] Column not found ReorderBuildPoint." SOLUT...
TROUBLESHOOTING - QODBC/QREMOTE TRIES TO CONNECT FOR 2 MINUTES OVER AND OVER PROBLEM DESCRIPTION: I am using QRemote DSN to connect to QuickBooks. QODBC/QRemote tries to connect for 2 minutes over and over and says it has a connection but does nothing...
TROUBLESHOOTING - GETTING UNEXPECTED EXTRA TOKEN ERROR IN DATE FIELD QUERY PROBLEM DESCRIPTION: I am trying to query the Transaction table based on the TxnDate field. I tried the below code. OdbcCommand SourceCmd = new OdbcCommand("Select * from Tra...
WHAT IS JUMPIN TYPE? PROBLEM DESCRIPTION: I am looking for the definition and usage of "JUMPIN TYPE." SOLUTION: In QODBC JUMPIN provides relationship details with other tables and information about value coming from another table. Please refer to...
TROUBLESHOOTING - "CANNOT UPDATE TABLE ITEMINVENTORY ERROR 10004." PROBLEM DESCRIPTION: I am trying to run an update on the Name field in ItemInventory. I've checked to see if it's updateable, and it is. I get "Cannot update table ItemInventory Error...
TROUBLESHOOTING - UPDATE QUERY TRUNCATING LEADING SPACES PROBLEM DESCRIPTION: I have to update a field with specific data; for some records, one of the fields will have leading spaces that are required to be there. I have tried numerous ways to get th...
TROUBLESHOOTING - SELECT STATEMENT IS NOT WORKING. PROBLEM DESCRIPTION: I am evaluating the product. When I made this SQL Statement: Select * from Customer where ListId=557 I was getting a column not found the error. The QBO online documentation says...
TROUBLESHOOTING - HOW CAN I GET SINGLE-USER ACCESS USING THE QODBC CONNECTION STRING PROBLEM DESCRIPTION: I am in access and need to update the Inventory. I have made a table that contains the adjustments. (Thousands of them) Your notes about Inventor...
TROUBLESHOOTING - HOW TO LOCATE CONFIGURE QODBC DATA SOURCE PROBLEM DESCRIPTION: I cannot find or configure the 32-bit ODBC Data Source Manager under a 64-bit System. I will be happy to remote access you and my server representatives to resolve this....
TROUBLESHOOTING - GETTING TIMEOUT ERROR IN SQL SERVER'S LINKED SERVER USING QODBC PROBLEM DESCRIPTION: I recently upgraded from 1.0.0.7 to 1.0.0.312. Everything was pretty smooth, except for our Linked Servers timeout now. I test the QODBC connection,...
TROUBLESHOOTING - MICROSOFT  EXCEL 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION TROUBLESHOOTING - MICROSOFT  ACCESS 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION PROBLEM DESCRIPTION 1: I have been having significant difficulties wit...
HOW TO EXPORT QUICKBOOKS DATA NOT AVAILABLE IN QODBC PROBLEM DESCRIPTION 1: I have searched many of the tables connectable thru the QODBC. I cannot find customer list information such as the customer's website, Facebook, linked in, multiple phone number...
TROUBLESHOOTING - [QODBC] ERROR 3000 - THE GIVEN OBJECT ID "IN THE FIELD "LIST ID" IS INVALID PROBLEM DESCRIPTION: I get a generic error when using QODBC to create an invoice. I am using the below query: INSERT INTO InvoiceLine ("TemplateRefListID...
DETAILED DIFFERENCE BETWEEN QODBC FOR QUICKBOOKS DESKTOP AND ONLINE. TABLE DIFFERENCES: QODBC for QuickBooks Desktop has 150 tables while QODBC for QuickBooks Online has 83 tables. TABLE IN QODBC FOR QUICKBOOKS DESKTOP BUT NOT IN QODBC FOR QUICKBOOKS...
TYPICAL PROFIT AND LOSS STANDARD REPORT IN QUICKBOOKS ONLINE REPORT DISPLAYED IN QODBC STORED PROCEDURE COMMAND With QODBC Online, the same report can be generated using stored procedure reports like this: sp_report ProfitAndLossStandard show RowDa...
INSTRUCTIONS QODBC Online accepts SQL commands through the ODBC Interface, then converts those calls to qbXML navigational orders within the QuickBooks Online API and returns recordsets that qualify for the query results. This driver is not a Client/Ser...
TROUBLESHOOTING - QUICKBOOKS ONLINE - QODBC REQUIRES API VERSION 1.1 OR 2.0 TO COMMUNICATE WITH QUICKBOOKS. PROBLEM DESCRIPTION: I was able to use QODBC Online with my QuickBooks Online (QBO), but suddenly I am facing a connection issue. Every time I t...
TYPICAL TRIAL BALANCE REPORT IN QUICKBOOKS ONLINE REPORT DISPLAYED IN QODBC STORED PROCEDURE COMMAND With QODBC, the same report can be generated using stored procedure reports like this: sp_report TrialBalance show RowData as Account, Amount_1 as...
TROUBLESHOOTING - UNABLE TO IMPORT QUICKBOOKS ONLINE CONNECTION KEY USING QODBC ONLINE PREVIOUS VERSION PROBLEM DESCRIPTION: I am importing the QBO connection key using QODBC Online's latest version & I am getting the below error: THE FILE CAN NOT CON...
PROBLEM DESCRIPTION: We keep getting the "QB Begin Session Failed" error when opening a QODBC connection on a web page. --> It happens when several users are using QuickBooks at the same time. --> When it happens, We try to use the 'QODBC Test Tool,' and...
PROBLEM DESCRIPTION: How to insert employee time information from MS Excel time spreadsheet into QuickBooks using QODBC SOLUTION: You cannot perform insert/update operations directly in MS Excel because Excel is just exporting tables in the spreadsh...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC, but I cannot link to QuickBooks. I have a Read Only Desktop edition of QODBC, which is included with QuickBooks Enterprise Edition. I am getting the error: "Error =...
NOTE: VB DEMO IS DEPRECATED. Please refer to How to use the QODBC Test Tool for testing [https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/] PROBLEM DESCRIPTION: VB DemoQODBC Test ToolTest Connection was crashing Wh...
PROBLEM DESCRIPTION: I am trying to use QODBC with Crystal Reports 11, but I'm also having similar results with the QODBC TEST TOOL included with the driver. Many queries, such as "select * from invoice," cause the program to hang. With Crystal Reports,...
HOW TO CONNECT TO MULTIPLE COMPANY FILES AT THE SAME TIME/SIMULTANEOUSLY PROBLEM: There are multiple company files in QuickBooks. At a time, I can access only one company file. Is QODBC allow me to access multiple company files same time? SOLUTION: T...
PROBLEM DESCRIPTION: How can I add a blank InvoiceLine in QuickBooks using QODBC? SOLUTION: You can create an empty Invoice, neither in QODBC nor QuickBooks. But in QuickBooks, you could leave lines blank and ensure at least one line with data in your...
HOW TO RETRIEVE CHARACTER FIELDS THAT ARE RETURNED AS NULL IN SSIS USING QODBC PROBLEM: Using SQL Server Integration Service (SSIS) and QODBC, All character fields are being returned as NULL. SOLUTION: Please use the function CONVERT to convert the ...
PROBLEM DESCRIPTION: VB DemoQODBC Test ToolTest Connection was crashing When I tried to connect to QuickBooks using QODBC. I have tried reinstalling QODBC & QuickBooks, but the QODBC Test connection (also via QODBC Test Tool) is still crashing. Also, I...
TROUBLESHOOTING - VISUAL STUDIO CONNECTION TO QODBC PROBLEM DESCRIPTION: I am getting the following message from Visual Studio 2015 when trying to connect to QRemote using the ODBC data source: "An error occurred while retrieving the information fro...
TROUBLESHOOTING - HOW TO CONVERT BIT TO INTEGER USING QODBC PROBLEM DESCRIPTION: I am trying to get our ODBC extension module interface working with QODBC. Everything seems to work fine except trying to read SQL_BIT type fields. It causes the Script BA...
TROUBLESHOOTING - HOW TO CHANGE THE STATUS OF THE INVOICE IN QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I had inserted it into the table ReceivePaymentLine, but it not changes the status to "Paid"? How do I do it? I use InvoiceLine to insert Item sales an...
How do I change InvoiceLineItem from InvoiceLineItemRefFullName1 to InvoiceLineItemRefFullName2 PROBLEM: How do I replace all invoices containing the InvoiceLineItemRefFullName "Framing" with the InvoiceLineItemRefFullName "Installation." First, we w...
REFRESH ON MS EXCEL FAILS. PROBLEM: MS Excel shows a data protection error when we click on the "Refresh All" link. When you click "OK," you will see the error below. SOLUTION: You are receiving this error because your Excel sheet is in PROTECTED M...
HOW TO GET CONVERSION RATIO INFORMATION FROM UNITOFMEASURESETRELATEDUNIT TABLE IN QODBC Conversion ratio information is stored in a table called UnitOfMeasureSetRelatedUnit. PROBLEM: How to get Conversion Ratio information from UnitOfMeasureSetRelated...
HOW TO USE QODBC WITH WINDOWS SCHEDULER /  HOW TO USE Z-CRON WITH QODBC / HOW TO RUN QODBC APPLICATIONS ON A REPEATING/NIGHTLY BASIS PROBLEM DESCRIPTION 1: My application needs to read data from QuickBooks and update data in the SQL server. Up to this, ...
TROUBLESHOOTING - QREMOTE DOES NOT WORK WITH IIS PROBLEM DESCRIPTION: We've been having steady success with QODBC for a good while. We're running QB on a VM and our custom application that queries it on another VM; both VMs are Server 2012. All was wel...
TROUBLESHOOTING - QODBC DRIVER DROPPING A FEW TRANSACTIONS ON INSERT TO INVOICELINES PROBLEM DESCRIPTION: We seem to have an issue with an insert into the InvoiceLines table, dropping a few transactions. We need to create about 1000 invoices per month...
TROUBLESHOOTING - QODBC CONNECTION TO TALEND OPEN STUDIO NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER JAVA-BASED APPLICATIONS. Refer: Oracle JDBC-ODBC Bridge [http...
TROUBLESHOOTING - QODBC AUTO-CONNECTING WITH THE WRONG USER PROBLEM DESCRIPTION: We have a few stations where we utilize the read-only QODBC desktop version. On a station we just built, it keeps using the wrong QuickBooks user for the auto-login. I conf...
TROUBLESHOOTING - HOW TO GET VBA TO EXECUTE TWO STATEMENTS AT THE SAME TIME PROBLEM DESCRIPTION: We use a Visual Basic app with an SQL Server database to write data to QB through QODBC. We are executing two SQL statements as described in your help. We ...
TROUBLESHOOTING - HOW TO USE QODBC ON MAC OR LINUX PROBLEM DESCRIPTION: I have MAC Operating System & I want to use QODBC on it. Is it possible to use QODBC on MAC? I have Linux Operating System & I want to use QODBC on it. Is it possible to use QODBC...
CONNECTING QODBC ONLINE DRIVER TO QUICKBOOKS ONLINE FOR THE FIRST TIME  (VIDEO) For system requirement details of QODBC Online, click here [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2816]. How to install QODBC Onlin...
For QODBC / QODBC-POS/ QODBC-Online/QXL-related issues, Click Here [http://support.flexquarters.com/esupport/index.php?/Tickets/Submit]. To submit a new support ticket, Click Here [http://support.flexquarters.com/esupport/index.php?/Tickets/Submit]. (...
TROUBLESHOOTING - QODBC LICENSING ISSUES WITH WINDOWS 10 UPGRADES PROBLEM DESCRIPTION: I want to upgrade my Operating System to Windows 10 and know if any precautions/actions are required for QODBC to keep working. SOLUTIONS: STEPS BEFORE UPGRADING T...
GENERAL CONNECTION STRING INSTRUCTIONS The most difficult part of using QRemote in programming is the connection string. The simplest form includes a reference to a DSN. A system DSN called "QuickBooks Data QRemote" for 32-bit applications & "QuickBook...
TROUBLESHOOTING - HOW TO USE QODBC WITH MULTIPLE QUICKBOOKS COMPANY FILE PROBLEM DESCRIPTION: I have a question about setting ODBC to auto-login. I am trying to automate some tasks and wanted to auto-login. We have two different company files for accoun...
TROUBLESHOOTING - HOW TO RE-LINK QUICKBOOKS DATA IN MS ACCESS USING QODBC PROBLEM DESCRIPTION 1: We are adding invoice records to QuickBooks using an Access front end. When we create the records and try to insert them into QuickBooks, the line items see...
TROUBLESHOOTING - HOW TO RECORD THE ISSUE I AM FACING AND SHOW/SHARE THE SCREEN. PROBLEM DESCRIPTION: How to record the issue I am facing and show/share the screen. SOLUTIONS: Please follow below steps for recording the issue you are facing. 1) Dow...
TROUBLESHOOTING - HOW TO IDENTIFY IF THE APPLICATION IS 32-BIT OR 64-BIT PROBLEM DESCRIPTION: How can I Identify if the application is 32-bit or 64-bit? SOLUTIONS:  SQL SERVER If your application is SQL Server, you can identify it by Starting your "...
TROUBLESHOOTING - HOW TO LOCATE DATA FOUND IN QUICKBOOKS BY TABLE AND FIELD NAME INSIDE QODBC PROBLEM DESCRIPTION: I have a question about How to locate data found in QuickBooks by table and field name inside the QODBC system. SOLUTIONS: The fastest ...
TROUBLESHOOTING - HOW TO GIVE REFUND TO EXISTING CREDITMEMO USING QODBC PROBLEM DESCRIPTION: How can I apply a refund check to an existing credit memo using QODBC? In QuickBooks, I can refund by opening the Create Credit Memos/Refunds dialogue box usin...
CONFIGURE QODBC ONLINE FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC Online with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC Online driver and Jitterbit connection. These steps wor...
CONFIGURE QODBC POS FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC POS with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC POS driver and Jitterbit connection. These steps work for QOD...
CONFIGURE QODBC FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC driver and Jitterbit connection. These steps work for QODBC with Jitt...
SETUP IN ALPHA FIVE CREATE A NEW WORKSPACE Start Alpha Five and create a new workspace. It could be called Online. adb - a holder for the entire application. Click the WORKSPACE & TASKS tab -> Click -> choose to CREATE A NEW, EMPTY WORKSPACE -> cl...
INSTRUCTIONS WHEN DESIGNING YOUR REPORTS 1. Use filters in a particular date range whenever possible. 2. When grouping by a table field, use a formula to put the field on it. This allows Crystal to do the grouping in memory rather than the driver, whic...
TROUBLESHOOTING - HOW TO USE QODBC ONLINE WITH FILEMAKER PROBLEM DESCRIPTION: I downloaded the trial version of your driver this morning and am excited about the prospects. I've installed it and can get the fields and tables to appear in QODBC TEST TOO...
HOW TO USE QODBC ONLINE WITH QLIKVIEW To use QlikView with QODBC Online, please follow the below steps. 1. Open QlikView & Create the new file. 2. Select Data Source. Click on Browse. 3. Please select the MS Excel file & click "Next." 4. Click "N...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 64-BIT USING QODBC ONLINE/QREMOTE For 32-bit Refer: How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC Online/QRemote [http://support.flexquarters.com/esupport/index.php?/Defaul...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 32-BIT USING QODBC ONLINE/QREMOTE For 64-bit Refer: How to create Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC Online/QRemote [http://support.flexquarters.com/esupport/index.php?/Defaul...
WE ARE WRITING TO QUICKBOOKS SAFELY. PROBLEM DESCRIPTION: I'm a little concerned about the write feature and changing any current data in QuickBooks from the Excel files I want to experiment in. Are my concerns valid, or what is the best way for me to p...
USING QUICKBOOKS ONLINE DATA WITH VBA   CREATING A FORM IN MICROSOFT ACCESS: NOTE: Microsoft Access has many uses and will allow you to use your QuickBooks Online Data files similarly to Access databases. Open MS Access. You can find it via Windows S...
SAMPLE CODE FOR VB.NET WITH QODBC ONLINE SAMPLE CODE OF VB.NET TO CREATE DATASET NOTE: The following is the minimal code required to create a DataSet from the SQL statement and attach the dataset to a DataGrid. Dim CNBC As System.Data.Odbc.OdbcConnecti...
HOW TO USE QODBC ONLINE WITH MICROSOFT EXCEL 2016 / 365 / 2013 32-BIT SETUP QODBC TO USE WITH MS EXCEL NOTE: QODBC allows you to quickly merge live QuickBooks Online data into the cells of your Microsoft Excel worksheets for quick calculations and graph...
HOW TO USE QODBC ONLINE WITH MICROSOFT ACCESS 2013 TO BUILD LINKED TABLE   CREATING A TABLE IN MICROSOFT ACCESS: NOTE: Microsoft Access has many uses and will allow you to use your QuickBooks Online data files similarly to Access databases. Open MS A...
QODBC ONLINE IS NO LONGER CONNECTED TO QUICKBOOKS ONLINE. YOUR USER TOKEN IS NO LONGER VALID. HOW TO CONNECT/RECONNECT QODBC ONLINE WITH QUICKBOOKS ONLINE EDITION (APPS.COM) Please follow the below-mentioned steps to configure QODBC Online: 1) Open QO...
HOW TO USE QODBC ONLINE WITH QUICKBOOKS ONLINE EDITION (APPS.COM) SETUP OF QODBC ONLINE: The first step is to download and install QODBC Online. QODBC Online requires .NET Framework 4.6.1 or a later version. So you need to install .NET Framework 4.6.1 t...
TROUBLESHOOTING - QUICKBOOKS DATA DSN NOT SHOWING UP IN ODBCAD32.EXE ODBC DATA SOURCE ADMINISTRATOR IN WIN8 PROBLEM DESCRIPTION: I can't configure QuickBooks Data DSN from Configure QODBC Data Source window. When I click on QuickBooks Data, configure is...
TROUBLESHOOTING - APPLICATION CONNECTIVITY DELAY PROBLEM DESCRIPTION: I have an inventory control system (c#, SQL Server) that needs Read Only access to four tables in the accounting system. I have deployed your multiuser version and can access the loca...
TROUBLESHOOTING - GETTING QODBC NOT SUPPORTED ERROR WHILE INSERTING INVOICE PROBLEM DESCRIPTION: I am trying to insert an Invoice, But I am getting the below error: [QODBC] Not supported (#10003) I am using below SQL statements: INSERT INTO "Invo...
TROUBLESHOOTING - ERROR WHILE INSERTING BILL PROBLEM DESCRIPTION 1: I am following the below steps and getting the error. 1. First, we inserted the records in Bill & BillExpenseLine table, and the papers got inserted successfully. 2. Second, we are i...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040410 PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through QODBC using the QODBC TEST TOOL application. I am consistently getting an "80040410" error. Begin Session Failed. S0000 00000...
TYPICAL PROFIT AND LOSS BY CLASS REPORT IN QUICKBOOKS REPORT DISPLAYED IN QODBC STORED PROCEDURE COMMAND With QODBC, the same report can be generated using stored procedure reports like this: sp_report ProfitAndLossByClass show Amount_Title, Text, ...
EXAMPLES OF CREATING INVOICE USING QREMOTE FROM SQL SERVER NOTE: For multi-line invoices, some may find it easier to NOT include the header information with each line item, but rather to have separate smaller commands for the Invoice Lines and a final ...
TROUBLESHOOTING - HOW TO GET BANK RECONCILIATION DETAILS USING QODBC PROBLEM DESCRIPTION: How to get Bank Reconciliation details using QODBC I've not successfully identified any field/flag identifying the bank reconciliation status. Is this informatio...
TROUBLESHOOTING - QREMOTE ERROR "COULD NOT CONNECT TO SERVER/QREMOTESERVER." PROBLEM DESCRIPTION 1: I have tested using QODBC Test Tool and the QRemote DSN test connection. I cannot connect to QRemote DSN. I am getting the below error: PROBLEM DESCRIPT...
TROUBLESHOOTING: QODBC SHOWS ERRORS 11118,11119,11120,11121,11122  PROBLEM: I am getting an error "11118 - SYSTEM LICENSE ERROR." I am getting an error "11119 - REGFILE1 LICENSE OPEN ERROR" I am getting an error "11120 - REGFILE1 LICENSE ERROR" I...
DIFFERENCE BETWEEN QODBC FOR QUICKBOOKS DESKTOP AND ONLINE. TABLE DIFFERENCES: Number of Tables available in QODBC DESKTOP QODBC ONLINE 150 83 List of Tables available in QODBC Desktop [http://doc.qodbc.com/qodbc/usa/TableList.php?catego...
TROUBLESHOOTING - QREMOTE DOES NOT CONSIDER FQSAVETOCACHE WITH WORKING WITH ODBCCOMMAND & PARAMETERS PROBLEM DESCRIPTION: QRemote Does not consider FQSaveToCache with working with OdbcCommand & Parameters. I have an application that creates Sales Orde...
TROUBLESHOOTING - GETTING MULTIPLE-STEP OLE DB OPERATION GENERATED ERRORS IN SQL SERVER PROBLEM DESCRIPTION: Trying to insert into SalesOrderLine and getting a 'Multiple-step' error. INSERT INTO QBREMOTE...SalesOrderLine (CustomerRefListID, TemplateR...
PROBLEM DESCRIPTION: How to use parameters in OPENQUERY SOLUTIONS: OPENQUERY does not accept variables for its arguments. You need to Pass Basic Values as below example: SELECT QUERY: DECLARE @TSQL VARCHAR(8000), @ID VARCHAR(25) SELECT @ID = '1...
QXL Limited Use Software License LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing unit) util...
TROUBLESHOOTING - GETTING "WRONG CLIENT ENCYPTKEY SETTING" ERROR PROBLEM DESCRIPTION: I'm trying to establish the connection to QuickBooks using QRemote Server. But when I tried to connect, I got the below error message: "Wrong client Encyptkey settin...
HOW TO USE QXL STEP 1 - DOWNLOAD QXL If you haven't already downloaded QXL, go to the download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/] now. Don't forget to read the "Readme" file during installation for the latest information on QX...
TROUBLESHOOTING - HOW TO SELECT A RECORD WHEN THE VALUE IS NULL PROBLEM DESCRIPTION: I am trying to run a report that returns ItemInventory where LastReceived is NULL. I have tried in vain to accomplish this. What syntax do you use to select a blank/nu...
TROUBLESHOOTING - HOW DO I CHECK WHICH REGION OF QUICKBOOKS IS INSTALLED PROBLEM DESCRIPTION: How do I check which region of QuickBooks is installed? SOLUTION: You can query the Host table using QODBC Test Tool & get detail about your QuickBooks ver...
TROUBLESHOOTING - HOW TO USE DATE() AND DATEADD() FUNCTION IN QODBC PROBLEM DESCRIPTION: I want to write some select statements on InvoiceLine and SalesReceiptLine that return all records dated WITHIN the past 30 days relative to whatever TODAY is. I'm...
HOW TO USE QODBC WITH QUICKBOOKS ONLINE EDITION SETUP OF QODBC ONLINE: First, we need to install QODBC Online. QODBC Online requires .NET Framework 4.0 or a later version. So, you need to install .NET Framework 4.0 to work with QODBC Online. Please re...
TROUBLESHOOTING - HOW TO VERIFY IF THE OPTIMIZER FILE IS CORRUPTED OR NOT PROBLEM DESCRIPTION: Is there any way to figure out when the Optimizer cache is corrupted, or is there a way we can avoid it altogether in the future? SOLUTIONS: Please refer...
TROUBLESHOOTING - "ERROR PARSING COMPLETE XML RETURN STRING" ERROR WHEN TRYING TO UPDATE TABLE PRICELEVELPERITEM IN MS ACCESS PROBLEM DESCRIPTION: I constructed an Access database file (32bit Access 2003) with tables linked to QuickBooks. I can pull inf...
TROUBLESHOOTING - QODBC SETUP SCREEN DOES NOT DISPLAY ALL CONTENTS PROBLEM DESCRIPTION: I successfully installed QODBC in my Win7 Pro and am ready to purchase it. However, I found the "Setup" dialog box is too small, and some of the contents, such as th...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE PROBLEM DESCRIPTION: When ting sets QODBC POS DSN to access the company file running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for th...
TROUBLESHOOTING - INVOICE REFNUMBER FAQ PROBLEM DESCRIPTION: I have the invoice number (RefNumber) from my table outside QuickBooks. But if a QuickBooks user creates invoices directly in QuickBooks, then QuickBooks keeps new incrementing invoices autom...
TROUBLESHOOTING - HOW TO TAKE A SCREENSHOT PROBLEM DESCRIPTION: How do I take an error screenshot? SOLUTIONS: If you've got a problem with a Windows program, you may wonder how to show the errors you're receiving. Luckily, taking a screenshot of yo...
TROUBLESHOOTING - HOW TO RUN QREMOTE SERVER AS A SERVICE PROBLEM DESCRIPTION: I have noticed that when I run the QRemote server on my server, the server also shuts down if I log out of my session. Is there a way to get the QRemote server to run as a se...
TROUBLESHOOTING - HOW TO CREATE A BLANK INVOICE IN QUICKBOOKS ONLINE USING QODBC PROBLEM DESCRIPTION: How do I create a note (or a blank line) on the invoice? If I do it the same way that I do it using QODBC for QuickBooks, I get an error : Error send...
TROUBLESHOOTING - HOW TO ADJUST THE VALUE OF A STOCK ITEM WITHOUT CHANGING THE STOCK QUANTITY PROBLEM DESCRIPTION: Can I adjust the value of a stock item without changing the stock quantity? SOLUTIONS: Yes, you can adjust the value of a stock item ...
TROUBLESHOOTING - GETTING [QODBC] NOT SUPPORTED ERROR WHEN TRYING TO MODIFY THE TXNDELETED TABLE PROBLEM DESCRIPTION: I am trying to modify the TxnDeleted table from QuickBooks in QODBC but getting the "[QODBC] Not Supported" error. SOLUTIONS: The T...
TROUBLESHOOTING - CANNOT USE ALIAS IN MS QUERY PROBLEM DESCRIPTION: I am getting the below error message when trying to SELECT data fields AS Alias, the statement runs fine otherwise. [sql syntax error] Expected lexical element not found:= Please se...
TROUBLESHOOTING - CAN QODBC / QREMOTE RUN AS A SERVICE PROBLEM DESCRIPTION: How do I run QODBC as windows services in the background? I noticed it required QuickBooks and windows server 2008 to be logged on. SOLUTIONS: QODBC and QuickBooks are deskt...
TROUBLESHOOTING - CAN QODBC ONLINE HAVE REGION-WISE FIELDS? PROBLEM DESCRIPTION: Can QODBC Online have region-wise fields like QODBC Desktop driver? SOLUTIONS: QuickBooks Online API supports only one region; thus, we had only one part in QODBC Onli...
HOW TO USE QODBC WITH PHP INSTRUCTIONS FOR USING QODBC WITH PHP: Using PHP on an internal Intranet or the World Wide Web requires the Server Edition of QODBC. QuickBooks must be running with the company file open. Download Sample [http://support.flex...
EXTERNAL APPLICATION SETUP Tutorials on how to set up ODBC access in external applications so you can see your QuickBooks data. MICROSOFT ACCESS How to set up an ODBC connection to QuickBooks data in Microsoft Access. * How to Use QODBC with Micro...
DATA DOCUMENTATION HOW QODBC INTERFACES WITH QUICKBOOKS We have provided tools to help you determine where field information comes from in QuickBooks, which tables contain the information you want, how tables can be related, and sample SQL statement...
QODBC ONLINE FOR QUICKBOOKS ONLINE - KNOWN ISSUE(S)/LIMITATION(S) Table Invoice, InvoiceLine, and InvoiceLinkedTxn may have the initial performance issue, but after the full load, the subsequent queries should perform well. ARAccountRefFullName, ARAcc...
QODBC ONLINE VERSION 14 IS DISCONTINUED INSTRUCTIONS We continue improving the user experience for QODBC for QuickBooks Online and are now at version 15, so support for QODBC Online version 14 has been discontinued. You will not be able to create new c...
TROUBLESHOOTING - MULTIPLE TABLES EXIST ERROR IN THE LINKED SERVER PROBLEM DESCRIPTION: I am trying to run a query using an SQL Server database link to QuickBooks using QRemote. I can set up the linked server fine in SQL Server, and the connection has b...
TROUBLESHOOTING - MS ACCESS CRASHES HARD ON DATE QUERY PROBLEM DESCRIPTION: I've linked all the QODBC tables into an Access 2010 DB. I have created table subset queries on the original tables and would like to do selects based on date ranges - other thi...
TROUBLESHOOTING - HOW TO USE QODBC FOR DEVELOPMENT WITH VISUAL STUDIO PROBLEM DESCRIPTION: I am trying to use a demo file for development, but QODBC is not allowing me to do this now that the evaluation period on my development machine has expired. Are ...
TROUBLESHOOTING - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM A THE CUSTOMER TABLE PROBLEM DESCRIPTION: How do I access the alternate email address 1 and 2 and the cc email fields? I don't see them at the customer table. SOLUTIONS: You can get CC ...
TROUBLESHOOTING - HOW TO ACCESS QUICKBOOKS DATA USING FILEMAKER PROBLEM DESCRIPTION: I downloaded the trial version of your driver this morning and am excited about the prospects. I've installed it and can get the fields and tables to appear in QODBC T...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING. PROBLEM DESCRIPTION: When I run a report query, the query works very slowly & takes about 1-5 mins per simple report like: "sp_report ARAgingSummary show Current parameters DateFrom={d'2014-11-...
TROUBLESHOOTING - SCHEDULED TASK JOB NOT WORKING AFTER UPGRADING QODBC PROBLEM DESCRIPTION: We use software called RemiCrystal to generate reports for emailing. The words have always worked fine using QB 2013 Pro and QODBC v14 (I think v14). Then we upg...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040417 PROBLEM DESCRIPTION: When using your QODBC Driver with my custom application, coded in Java, the application can connect and retrieve data if QuickBooks is running with the company file already...
TROUBLESHOOTING: MS ACCESS AS MIDDLEWARE IS NOT WORKING WITH MS SQL SERVER PROBLEM DESCRIPTION: I am trying to use MS Access as a middleware with MS SQL Server. I have created an MS Access database & linked all QODBC tables through QRemote DSN. After t...
TROUBLESHOOTING - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST PROBLEM DESCRIPTION: I have QuickBooks 2014 version & I am using QODBC's latest version. I have a problem with querying the customer table using QODBC. QODBC driver consistently gets s...
TROUBLESHOOTING: ERROR 3250 - THIS FEATURE IS NOT ENABLED OR NOT AVAILABLE IN THIS VERSION OF QUICKBOOKS. PROBLEM DESCRIPTION: I am getting the error "Error 3250 - This feature is not enabled or not available in this version of QuickBooks." while I am ...
TROUBLESHOOTING - ERROR [42S00] [QODBC] INSERT VALUE MUST BE A SIMPLE VALUE PROBLEM DESCRIPTION 1: We have a customer trying to import a credit memo from our database into QuickBooks using a vb.net program. They are getting the following error: ERROR [4...
TROUBLESHOOTING - APP_ALREADY_PURCHASED ERROR WHEN TRYING TO AUTHORIZE QODBC IN QUICKBOOKS ONLINE PROBLEM DESCRIPTION: We have some other users of QuickBooks online for the same company file. And when any other user tries to authorize and connect it th...
TROUBLESHOOTING - UNABLE TO FIND TABLE QBADVANCEDREPORTGROUP. PROBLEM DESCRIPTION 1: 1. I'm attempting to utilize your ODBC driver for reporting through Excel from QuickBooks Enterprise. The tables in your report help guide aren't accessible to me and a...
PROBLEM DESCRIPTION: We modified an invoice in QuickBooks and are trying to get the data out in Excel, but QODBC gives us the old data. Why? SOLUTIONS: QODBC failure to return full records is usually caused by corruption of the QODBC optimizer file....
TROUBLESHOOTING - CANNOT CREATE A NEW TABLE USING QODBC / CANNOT ADD A NEW FIELD TO THE QODBC TABLE PROBLEM DESCRIPTION: I'm trying to create a new table with VB DEMO or QODBC TEST TOOL. Can you send me a sample query to do this? SOLUTIONS: QODBC ...
PROBLEM DESCRIPTION: When I run the program as an administrator, I can change the optimizer settings, but it never gets saved. Everything I rerun the Setup Screen, the grounds are back to the original settings, and my changes aren't saved. Do I have to ...
QODBC SHOWS A REGFILE1 LICENSE ERROR WHEN USING MS EXCEL 2013 OR ACCESS 2013  MS EXCEL 2013 OR ACCESS 2013 SHOWS THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE OR SERVER EDITION. MS EXCEL 2013 OR ACCESS 2013 (OFFICE 365) CRASHES WHEN TRYING TO CO...
QODBC Driver for QuickBooks Online Limited Use Software License LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one...
TROUBLESHOOTING: UPDATE QUERY SCANNING ALL RECORDS IN LINKED SERVER PROBLEM DESCRIPTION 1: I am using an MS SQL-linked server with QRemote. I am updating a single EstimateItemLine, passing Ref Number and ItemFullName (I also tried itemtxnlineid). Every...
TROUBLESHOOTING: HOW TO ACCESS ACCOUNT NAME DETAILS FROM JOURNAL REPORT USING SQL SERVER PROBLEM DESCRIPTION: I need some guidance on extracting data from the general ledger. In particular, I need to see the FullName of GL account. Running sp_report Jo...
TROUBLESHOOTING: QUICK REPORT ON AN ACCOUNT PROBLEM DESCRIPTION: How can I get a Quick Report on an account from the Chart of Accounts? In Quick Books 2006 Premier, I opened a chart of accounts (Ctrl+A), selected an account, and then pressed Ctrl+Q. S...
HOW TO REMOVE QREMOTE FROM STARTUP PROBLEM DESCRIPTION: QRemote Initialization Error. QRemote Error: Listening failed. Please restart application QRemote Closing in 15 Seconds. SOLUTION: QRemote Server reports "Error: Listening failed. Please re...
PROBLEM DESCRIPTION: When inserting an invoice via a looping SQL procedure, I have invoice lines (InvoiceLine table) items that can potentially be assigned to varying classes. Using the ClassRefListID field, I class the lines accordingly and do not addre...
TROUBLESHOOTING: QUICKBOOKS CAN'T START BECAUSE IT IS ALREADY RUNNING. PROBLEM DESCRIPTION 1: I cannot Connect my trial version of QODBC to QuickBooks. I have gone through your tutorials but am unable to connect. I have never had the "Keep QuickBooks ...
TROUBLESHOOTING: SP_REPORT PROFITANDLOSSBUDGETPERFORMANCE IS RETURNING NO ROWS. PROBLEM DESCRIPTION 1: I am running ProfitAndLossBudgetPerformance through MS Query & It is returning no rows. But using QuickBooks UI, I can get records from the ProfitAnd...
TROUBLESHOOTING: SP_REPORT BALANCESHEETSTANDARD REPORT ERROR "[QODBC] AT LEAST ONE FIELD REQUESTED REQUIRES DATEFROM TO BE SET." PROBLEM DESCRIPTION: I am running BalanceSheetStandard through QODBC Test Tool, and & it is returning the below error. Wh...
HOW CAN I FIND QUICKBOOKS DELETED RECORD INFORMATION FROM QODBC? PROBLEM DESCRIPTION: Is there a stored procedure that provides all deleted transactions? I.e., Voided/Deleted Transactions Detail? For Example: If an Invoice gets deleted from Quick...
CONFIGURE QODBC FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 To use QODBC with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC driver and Jitterbit connection. These steps work for QODBC with Jitterbit 3.0.0...
HOW CAN I FIND A SOURCE OF SP_REPORT PROBLEM DESCRIPTION 1: Is there a way to see the SQL QuickBooks uses to generate their reports? Also, Which tool do they use to create reports? PROBLEM DESCRIPTION 2: I need to access information used in the Qu...
QODBC LICENSING INFORMATION  Also Refer: QODBC with QRemote Licensing Information [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2568/] Different types of licenses are required depending on your requirement in QODBC; pl...
PCI COMPLIANCE IN QODBC PROBLEM DESCRIPTION: We are working with a client that processes many credit cards and must be PCI compliant. Do you have any insight into what needs to be done on the QODBC side to maintain PCI compliance? SOLUTIONS: QODBC us...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: When using Prepared Statements with the QRemote driver, it throws an error called ODBC driver not supported. How can I use Prepared Statements with QODBC/QRemote? SOLUTIONS: You may...
QUESTION: I've built a table in Access of invoice lines to be added to existing invoices. I have the TxnID and all the necessary xxxxListID fields etc., with the item, quantity, and values coming from other sources. So "all" I have to do now is to feed t...
EXAMPLES OF CREATING INVOICE USING QODBC First, please create a new MS Access database & link ALL tables. Please refer to the below-mentioned article for How to Use QODBC with Microsoft Access: How to Use QODBC with Microsoft Access [http://support.fle...
HOW TO CREATE AN ITEM INVENTORY ASSEMBLY THROUGH MS ACCESS USING QODBC AN EXAMPLE OF CREATING ONE ITEMINVENTORYASSEMBLY WITH TWO LINES First, please create a new MS Access database & link ItemInventoryAssembly, and ItemInventoryAssemblyLine tables. P...
HOW TO CREATE AN INVENTORY ADJUSTMENT THROUGH MS ACCESS USING QODBC  INSTRUCTIONS Although QuickBooks automatically adjusts your inventory quantities after every purchase and sale, sometimes you still need to adjust them yourself from time to time. Quic...
HOW TO CANCEL FQSAVETOCACHE IN QODBC PROBLEM DESCRIPTION: We have some code to insert multiple lines into the invoice table. We understand how the 'FQSaveToCache' field is used during this process. And the code is running successfully until we found an...
HOW CAN I FIND THE CHECK REGISTER/CHECKBOOK USING QODBC? PROBLEM DESCRIPTION: I am trying to pull all the data in the "Check Register" section of QuickBooks Enterprise 14 into my Excel spreadsheet. (What is the name of the table or a table that contain...
HOW TO ADD ADDITIONAL QUOTE (') IN INSERT STATEMENT USING QODBC PROBLEM DESCRIPTION: I have exported the customer list from QB, and Now I want to insert these using the insert query. But some of them fail because of the apostrophe ('). How to deal with...
ACTIVATION-DEACTIVATION FAQ  PROBLEM DESCRIPTION 1: My old machine broke, and I had to reinstall the OS completely. Now I am moving to a new machine. I want to activate QODBC on my new machine. But I cannot deactivate the QODBC CDKEY on my old machine....
PROBLEM DESCRIPTION: I am getting the following error trying to delete a record from InvoiceLine: [QODBC] Requires at least one child. Cannot delete the last line (#10074) Does the invoice file require at least one record in InvoiceLine? If so, will d...
HOW TO USE QLIKVIEW WITH QODBC To use QlikView with QODBC, please follow the below steps. 1. Open QlikView & Create the new file. 2. Select Data Source. Click on Browse. 3. Please select the MS Excel file & click "Next." 4. Click "Next. 5. Save...
QODBC IS MISSING TABLES AND FIELDS AFTER UPGRADING TO QUICKBOOKS 2014 R6 The issue is noticed after installing QuickBooks 2014 R6 on Windows XP and Windows 2003 machines. PROBLEM: When you connect VB Demo and list the tables, you will notice only 10...
The procedure entry point EnumProcessModuleEx could not be located in the dynamic link library PSAPI.DLL Source: http://www.sleeter.com/blog/2014/06/quickbooks-2014-r6-bugs/ [Source:http://www.sleeter.com/blog/2014/06/quickbooks-2014-r6-bugs/] This is...
USING QUICKBOOKS DATA WITH VBA FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2472/57/MICROSOFT-ACCESS-2003-AND-QODBC]. PROBLEM DESCR...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: Any errors related to the driver and custom software or packaged software that does not work properly with QODBC.Example, Prepared Statements in JDBCODBCDriver. Sample Connection qbCo...
HOW CAN I USE QODBC WITH TWO DIFFERENT VERSIONS OF QUICKBOOKS INSTALLED? PROBLEM DESCRIPTION: I have two different versions of QuickBooks (i.e., QuickBooks Enterprise 2012 & QuickBooks Enterprise 2014) installed on my machine. I want to access both ...
QODBC WITH QREMOTE LICENSING INFORMATION  Also Refer: QODBC Licensing Information [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2587/] There are different types of Licenses required depends on your requirement in QODBC...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 64-BIT USING QODBC POS/QREMOTE Start your "SQL Server Management Studio" Login to your SQL Server. On the left-hand side panel, you will find the Server, Right Click on the "SQL Server" and Sele...
HOW CAN I USE THE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use the same Excel files in 64 & 32-bit Systems? Is it possible to have a connection setup in an Excel file and be able to refresh on either a 64 or 32-bit syst...
QODBC SHOWS RUNTIME ERROR R6025 PURE VIRTUAL FUNCTION CALL WHEN USING MS ACCESS PROBLEM: I have created the link to the Customer table in MS Access using QODBC. I can link the table without any error, But when I try to edit any field from the linked ta...
PROBLEM DESCRIPTION: I called QuickBooks, and they said we could run QuickBooks Canada 2005 alongside QuickBooks USA 2004 on the same computer with no problem. They said the problems happen when you try to run USA/Canada QuickBooks on the same computer ...
TROUBLESHOOTING: ERROR:3000-THE GIVEN OBJECT ID "IN THE FIELD "LISTID" IS INVALID PROBLEM DESCRIPTION: When making an inventory adjustment in a company file whose multiple inventory sites feature is not enabled, there are no values in the field "Invent...
TROUBLESHOOTING: QUICKBOOKS REPORTS "THE CERTIFICATE IS INVALID" PROBLEM DESCRIPTION: When first using the application to access QuickBooks via QODBC, a will pop up a window to ask the user to give the certificate to this application. But now facing...
TROUBLESHOOTING: UNABLE TO CONNECT TO THE QUICKBOOKS DATABASE. PROBLEM DESCRIPTION: I installed the QODBC driver as a new install. I have configured the ODBC and made sure that the driver is referenced and checked in the Integrated Applications window i...
PROBLEM DESCRIPTION: VB DemoQODBC Test ToolTest Connection was crashing When I tried to connect to QuickBooks using QODBC. I have tried to reinstall QODBC & QuickBooks, but the QODBC Test connection (via VB Demo or QODBC Test Tool) is still crashing. A...
PROBLEM: I have a customer who does their invoicing with an ASP.NET application, and it flows into QuickBooks. I created the interface with QODBC, and it works with no problem except that sometimes the processes will lock up, and I have to remote into th...
NOT ABLE TO PULL ALL DATA IN TABLE SALESRECEIPT FROM QUICKBOOKS POS PROBLEM DESCRIPTION: When there is huge data in QuickBooks POS, QODBC POS cannot pull all data in Table SalesReceipt from QuickBooks POS. SOLUTION: 1. When there are huge data in Qu...
HOW DO SETUP QODBC TO ACCESS QUICKBOOKS WHEN THERE IS NO ONE LOGGED IN INSTRUCTION: QuickBooks is not a windows service, so it cannot run when no one is logging into the system. This limit brings problems when the user tries to set up QODBC to access Q...
HOW TO GET MEMORIZED TRANSACTIONS & MEMORIZED REPORTS IN QODBC PROBLEM DESCRIPTIONS: How can I get information about Memorized Transactions & Memorized Reports using QODBC? I can see them in QuickBooks, but I don't know how to get them in QODBC. SOL...
PROBLEM DESCRIPTION: I have installed QODBC and QuickBooks. I have set the Company Preferences / Integrated Applications to Allow Access to FLEXQuarters QODBC. When I hit the Test Connection to QuickBooks button, I get a message from QuickBooks saying TH...
TROUBLESHOOTING: THE QBREPORTADMINGROUP VIEWS ARE NOT UPDATED FOR CHANGES IN THE CUSTOM FIELD PROBLEM DESCRIPTION: The QBReport Admin Group views are not updated for changes in custom field id's. The user can see QBReportAdminGroup and other tables in...
HOW TO USE QODBC WITH OPENOFFICE BASE FOR MS ACCESS 64-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS EXCEL [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-CONFIGURE-QODBC-TO-WO...
TROUBLESHOOTING: QREMOTESERVER NOT CONNECTING PROBLEM DESCRIPTION: I am trying to set up QRemote on our server. I have set this up on a local machine as a test server fine. But I am having issues getting this setup on our server. When I configure a ...
PROBLEM DESCRIPTION: I have closed the QODBC connection to QuickBooks. But It still shows running in task manager QBW32.EXE keeps running even after QODBC closes the connection. SOLUTIONS: When the Disconnect command is sent to QODBC, QODBC sends th...
HOW TO VIEW DETAILS ON WHAT QODBC IS PERFORMING PROBLEM DESCRIPTION: QODBC and my application are not responding. How can I know what QODBC is performing in the background? SOLUTION: You can enable the QODBC status panel via Start >> All Programs >>...
HOW TO USE QODBC WITH MULTIPLE COMPANY FILES INTRODUCTION: When multiple QuickBooks company files are located on one machine, how do we use only one copy of QODBC to access those company files? Please note that QODBC can only access one company file on ...
QODBC does support standard SQL queries, but the function is implemented differently. Please refer to the below functions & try to execute them in QODBC TEST TOOL. FUNCTIONS IN SELECT QUERY: You can use distinct like: SELECT DISTINCT CustomerRefFull...
PROBLEM DESCRIPTION: How can I use multiple QuickBooks SOLUTION: You can use multiple QuickBooks of the same region and the same version year on the same machine. But for the best configuration of QuickBooks, please get in touch with Intuit to take he...
PROBLEM DESCRIPTION: How can I use the Case When statement query in QODBC SOLUTION: You can use the Case When statement query in QODBC as below: The Simple CASE Statement is only used in the SELECT Statement to check whether the value is equal. B...
PROBLEM DESCRIPTION: How can I trace the XML sent to/from QuickBooks by QODBC? SOLUTION: You can trace XML by the below steps: 1) Turn on Detail Trace from: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source...
INSTRUCTION: In QODBC v12, we added a new component named QRemote to solve the 64-bit application support issue. This article is going to show you how to install QODBC v14 or higher on a 64-bit system. ( Follow the same installation steps for QODBC v12 &...
INSTRUCTION: When inserting multiple records into a line item table, you can use column FQSaveToCache. Set column FQSaveToCache to 1 in all insert queries except the last line set to 0. But table TimeTracking is not a line item table; there is no FQSa...
PROBLEM DESCRIPTION: How to insert InvoiceLine item into an existing Invoice. I am trying to run an INSERT statement that I have run before on version 10, but I am now getting the following error. SQL Statement: INSERT INTO InvoiceLine (TxnID, RefNum...
HOW TO BUILD ASSEMBLY REPORT VIA QODBC PROBLEM DESCRIPTION: How can I Build an Assembly report via QODBC SOLUTION: If you want to replicate the Build Assembly report via QODBC, I suggest pulling CustomSummary records using QODBC. Below is an example...
HOW TO APPLY DISCOUNTS TO EXISTING INVOICES PROBLEM DESCRIPTION: We have hundreds of invoices to that we want to apply a 10% discount, as the customer is going into bankruptcy and is giving us the choice of accepting a commitment to accept 10% of the i...
TROUBLESHOOTING: THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE OR SERVER EDITION PROBLEM DESCRIPTION When I try to run a command in QODBC Test Tool, I get the error message "This function requires QODBC read-write or server version." I am try...
PROBLEM DESCRIPTION 1: I'm working in PHP and using the QODBC Test Tool. I am trying to Insert value into the Customer table. But I am getting the below error: EXPECTED LEXICAL ELEMENT NOT FOUND: My insert statement is: Insert into Customer (...
TROUBLESHOOTING: QREMOTE REPORTS "CONNECTION TO DATA SOURCE FAILED" WHEN WORKING WITH 64-BIT ACCESS OR EXCEL PROBLEM DESCRIPTION: Set up QRemote to work with 64-bit MS Excel. The Client DSN settings are correct. But when access to "QRemote Data 64-bit,...
PROBLEM DESCRIPTION: When trying to connect to QuickBooks using QODBC Test Tool, I am facing the error : QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused SOLUTION: Please first keep QuickBoo...
PROBLEM DESCRIPTION 1: Where is the "Company & Financial" sp_report for "Statement of Cash Flow" and "Cash Flow Forecast"? Is there any other way I can access values for 'Cash at the beginning of the period' and 'Cash at the end of the period,' please?...
HOW TO APPLY DISCOUNTS TO EXISTING INVOICES PROBLEM DESCRIPTION: We have hundreds of invoices to that we want to apply a 10% discount, as the customer is going into bankruptcy and is giving us the choice of accepting a commitment to accept 10% of the i...
PROBLEM DESCRIPTION: How can I add blank InvoiceLine in QuickBooks using QODBC? SOLUTION: There are empty Invoice line records in QuickBooks, and QODBC can view them too, but you may not be able to create an empty InvoiceLine in QODBC. You cannot cr...
PROBLEM DESCRIPTION: I am attempting to apply payments to invoices. I have also determined the TxnID of the Invoice I want to apply a payment to and used it in the SQL code specified on How to apply a payment to an invoice [http://support.flexquarters.co...
PROBLEM DESCRIPTION: I am getting the error ODBC CALL FAILED- ERROR 10004 when trying to connect QuickBooks through MS Access using QODBC. SOLUTION: Please keep QuickBooks running, Log in as Admin to your company file, Switch to single-user mode and t...
PROBLEM DESCRIPTION Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start Reckon Accounts. ...
PROBLEM DESCRIPTION: I am trying to insert data into the Invoice table, but QODBC is not allowed me to write data in the Invoice table. 20131202.172908 E 2792 InvoiceStorage::DoAdd Cannot set unassigned RSB in transaction line item(s). QuickBooks error...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC, but I cannot connect to QuickBooks. I have a Read Only Desktop edition of QODBC, which is included with QuickBooks Enterprise Edition. I am getting the error: "Error ...
PROBLEM DESCRIPTION: I am attempting to add InvoiceLine records to a sample company. I exported 15 InvoiceLine records from QuickBooks via QODBC, then built a table with these records trimmed down to what I believe are the minimum required fields, then a...
Check if the table you are importing has any long fields and exclude them from the import. Some tables in QuickBooks have fields as long as 4095 characters and cannot fit in a single spreadsheet cell. An excellent example of this is the InvoiceLine tabl...
USING QUICKBOOKS POS DATA WITH ACCESS 2013 (LINKED TABLES) 32-BIT FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2472/57/MICROSOFT-ACC...
SETUP QODBC TO WORK WITH MICROSOFT EXCEL POWERPOINT NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one-...
HOW TO INSERT OPENING BALANCE IN CUSTOMER TABLE USING QODBC PROBLEM DESCRIPTION Initially, I received the error "[QODBC] Field not allowed in insert" when I tried to insert data into the Customer table through QODBC. I was trying to insert customer d...
HOW TO GET UPDATED CUSTOM FIELD WITH MS-ACCESS (LINKED TABLE) IN QUICKBOOKS New Custom Fields are created within QuickBooks. In MS Access Newly created Custom Fields are not visible. The solution to this issue is to re-create the linked table. ...
HOW TO USE THE QODBC EXCEL TEMPLATE  You can download the QODBC Excel Template, which has most of the tables and reports preconfigured. All you have to do is download the Excel Template and copy the file to the Default Template folder. To download t...
HOW TO REMOVE OPTIMIZER FILE WHAT IS THE OPTIMIZER FILE? When you turn on the Optimizer, QODBC will bring some data to a local cache file (the optimizer file) to increase retrieval performance for queries. When you access any table, QODBC will gather...
HOW TO SETUP QODBC TO RUN WITHOUT QUICKBOOKS PROBLEM DESCRIPTION * I want to use QODBC, which does not have the QuickBooks program on the machine. * Do I need QuickBooks installed on the machine to use QODBC? * Can QODBC read directly from QuickBo...
Accessing QuickBooks Data Remotely using QODBC & QRemote Using QuickBooks data remotely via QODBC FOR USING QREMOTE OVER THE INTERNET & WITH DYNAMIC IP (NON-STATIC-IP): You can make sure of services like Dynamic DNS (DDNS or DynDNS). It is a method o...
Environment QuickBooks 2014 QODBC 14.0.0.298 QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks & QuickBooks company files. QODBC can show/fetch only the information which is exposed/provided by QuickBo...
QODBC EVALUATION PERIOD EXPIRED AFTER UPGRADE TO INTUIT ENTERPRISE. PROBLEM DESCRIPTION: An older trial installation of QODBC (from before QB Enterprise and long expired) was once on this computer. How do I proceed to install the QODBC driver include...
HOW TO CREATE LINK SERVER WITH MS SQL 2005/2008/2012/2016 32-BIT USING QODBC/QREMOTE For 64-bit Refer: How to create Link Server with MS SQL 2005/2008/2012/2016 64-bit Using QODBC/QRemote [http://support.flexquarters.com/esupport/index.php?/Default/Knowl...
Using QuickBooks data with MS SQL Server using QODBC Driver and QRemote (Video)
Connecting QODBC Driver to QuickBooks for the First Time (Video) Go to: How to set up the QODBC Optimizer and Where are the Optimizer options [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2358]for the next step. You...
How to set up QODBC Driver to auto-connect to QuickBooks. (Video) Also, refer - How to set up QODBC to run without QuickBooks [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2518/0/how-to-setup-qodbc-to-run-without-quickb...
How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video) Download the sample code: Click Here [http://support.flexquarters.com/supportfiles/QODBC%20onASP.NET.zip] Also, refer to Sample C#.NET Web Application for ...
ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS ACCESS 2010 (VIDEO) - 32-BIT ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS ACCESS 2010 (VIDEO) - 64-BIT (MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 202...
DCOM / SERVER EDITION TAB MISSING IN QODBC SETUP SCREEN We recommend you use QRemote instead of DCom. This is because QRemote is easy to configure and works for 32 & 64-bit applications. For SQL Server 64-bit, Click Here "How to create Link Server with...
CONNECTING TO QUICKBOOKS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE. THE TEST CONNECTION WAS NOT WORKING. The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security setting...
Issue : After updating to QuickBooks 2012 R14, you may encounter Unrecoverable Error XXXXX XXXXX (the codes can appear random) while opening your company file. or I COULD NOT OPEN THE QUICKBOOKS COMPANY FILE AFTER THE UPDATE. SOLUTION If you hav...
PROBLEM : QBXML components have not been installed. / Error Getting Version / QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks REASON : There have been a few problems reported when Upgrading to QuickBooks 2013 R7. After auto up...
QODBC SHOWS A REGFILE1 LICENSE ERROR WHEN USING MS EXCEL 2013 OR ACCESS 2013  MS EXCEL 2013 OR ACCESS 2013 SHOWS THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE OR SERVER EDITION. MS EXCEL 2013 OR ACCESS 2013 (OFFICE 365) CRASHES WHEN TRYING TO C...
This method is Discontinued. Please refer new product QODBC for QuickBooks Online: How to use QODBC Online with QuickBooks Online Edition (Apps.com) [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2658] How to Reconnect...
TROUBLESHOOTING - QREMOTE INITIALIZATION ERROR, ERROR: LISTENING FAILED. PLEASE RESTART APPLICATION PROBLEM DESCRIPTION 1: QRemote Initialization Error, QRemote Error: Listening failed. Please restart application QRemote Closing in 15 Seconds. PR...
TROUBLESHOOTING - LISTENING FAILED. QREMOTE SERVER IS SHUTTING DOWN IN 15 SEC PROBLEM DESCRIPTION 1: When I start QRemote Server, I get QRemoteServer Started, and it shows "Listening failed.QRemote Server is shutting down in 15 sec." PROBLEM DESCRIPT...
TROUBLESHOOTING: THIS APPLICATION IS NOT ALLOWED TO CHANGE ITS AUTHENTICATION PREFERENCES UNLESS QUICKBOOKS IS RUNNING WITH THE ADMINISTRATOR LOGGED IN PROBLEM DESCRIPTION: IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session F...
During the installation, the following error occurs even when logged in with an Administrator's account. "You do not have access to make the required system configuration modifications. Please rerun this installation from an Administrator's account." ...
TROUBLESHOOTING: QODBC HANGS WHEN TRYING TO EXECUTE QUERY OR VIEW TABLES PROBLEM DESCRIPTION: When executing a simple query like: SELECT * FROM Invoice Application and QuickBooks will both get hang, and it Does Not Respond. Then After, the applic...
TROUBLESHOOTING: UPDATING JOURNALENTRY RECORDS VIA QODBC SHOWS ERROR, TRANSACTION NOT IN BALANCE. INSTRUCTION: Under QuickBooks, when saving a Journal Entry record, the Debit total should match the Credit total. Even thou you are not changing the amo...
HOW TO FIND S.O NUMBER INFORMATION OF SALES ORDERS IN QODBC INSTRUCTIONS: Sometimes QODBC may have the field name the same as in QuickBooks. You cannot find S.O Number or P.O Number in QODBC, but QODBC does have a field in these tables to store the inf...
TROUBLESHOOTING: QODBC POS REPORTS "TEST CONNECTION TO QUICKBOOKS POS FAILED" ERROR. PROBLEM DESCRIPTION: QODBC POS reports a "Test Connection to QuickBooks POS failed" error when trying to connect to QuickBooks POS: SOLUTION: This error shows a pro...
How to Run VB Script on 64-bit Operating System INSTRUCTION: When running the VB Script on the 64-bit system, if you directly run the Script by double-clicking the vbs file, the system will run the VB Script as 64-bit. Then QODBC will report an error l...
HOW TO RUN PAYROLL SUMMARY REPORT / PAYCHECK TRANSACTIONS USING QODBC REPORT IN QUICKBOOKS Paycheck transaction information is not stored in a separate table, but you can refer to the Payroll Summary report in QuickBooks to view the payroll records of...
This method is Discontinued. Please refer new product QODBC for QuickBooks Online: How to use QODBC Online with QuickBooks Online Edition (Apps.com) [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2658] How to Reconnect...
PROBLEM I am unable to Activate/Deactivate the currently installed version. I am logged in as Administrator, with admin rights, and right-clicking on the Setup and selecting "Run As Administrator" does not change the result. You do not have Sufficient...
SOLUTION: To rebuild your company file via File->Utilities->Rebuild Data in QuickBooks to see if it can fix your issue.
QODBC can allow SQL Server to Access QuickBooks Data Remotely. "FileServer": having QuickBooks File "Server": having QuickBooks Application "Client": having SQL Server. Below are the Steps Install QODBC on "Server" & "Client." Not required on "FileSer...
QREMOTE TUTORIAL: USING QUICKBOOKS DATA REMOTELY VIA QODBC Also, refer to Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video) [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/] QODBC has the abi...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATIONS UNDER QUICKBOOKS Please follow the steps to remove QODBC Related Certificates from Integrated Application Under QuickBooks: Try removing all the integrated application entries in Qui...
PROBLEM DESCRIPTION: The TimeTracking / Transaction table always returns null/ no rows. I tried to reset the QODBC optimizer, but it didn't work. If the Solution provided here [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/...
HOW TO VIEW QODBC DRIVER DIGITAL CERTIFICATE QODBC Driver does have a digital certificate. To verify or know more about Digital Certificate details, Please right-click on fqqb32.dll/properties in the Windows>System 32/SysWow64 Directory. Below are det...
QODBC Limited Use Software License LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer (one central processing unit) ut...
INSTALLATION STEPS FOR WINDOWS 8 After you have downloaded QODBC Installer, navigate to the "Downloads" Folder or the location where you have saved QODBC Installer. Run the installer as administrator by Right-clicking on the installer and selecting "Run...
ACTIVATING QODBC STILL SHOWS THE EVALUATION VERSION IN THE QODBC SETUP SCREEN.  If you have activated QODBC with a purchased license CDKey and get the "Activation Successful" message and then run an application trying to use QODBC, you get the message t...
PROBLEM DESCRIPTION: Trying to change the cost of an assembly using the following query: UPDATE Item set SalesPrice = 1500.00, PurchaseCost = 700 where Name = 'Blueprints'; It fails with the error: "error: [QODBC] Not supported or UPDATE the price ...
PROBLEM I need to update the old terms of a customer in QuickBooks. They used to be due upon receipt, and we need to move them to net 30. I need to go back and change all the old due dates to reflect the new terms. How can I update the DueDate to remembe...
QODBC and Microsoft Excel MICROSOFT EXCEL 2003 AND QODBC Also, Refer: How to Use QODBC with MS Excel 2007 [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2449/57/how-to-use-qodbc-with-ms-excel-2007] Using QuickBo...
QODBC and Microsoft Excel MICROSOFT ACCESS 2003 AND QODBC CREATING A TABLE IN MICROSOFT ACCESS NOTE: Microsoft Access has many uses and will allow you to use your QuickBooks data files similarly to Access databases. Selecting the menu FILE -> NEW -...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 32-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 64-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES (MINIMUM REQUIREMENT...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 32-BIT HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 64-BIT (MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)   QuickBooks 2022 and above are 64-Bit applicatio...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 (32-BIT) TO IMPORT QUICKBOOKS DATA FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 TO BUILD LINKED TABLE(32-BIT) FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57/HOW-...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2010 (32-BIT) FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS EXCEL [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-CONFIGURE-...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 32-BIT HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 64-BIT (MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)   QuickBooks 2022 and above are 64-Bit applications...
TROUBLESHOOTING: EXPECTED LEXICAL ELEMENT NOT FOUND PROBLEM DESCRIPTION  When trying to execute a query statement, I get the error message " EXPECTED LEXICAL ELEMENT NOT FOUND." SOLUTIONS It seems to be the issue in the SQL Statement. Please check al...
TROUBLESHOOTING: TIMETRACKING / TRANSACTION TABLE IS BLANK PROBLEM DESCRIPTION: The TimeTracking / Transaction table always returns null/ no rows. I tried to reset the QODBC optimizer, but it didn't work. SOLUTION: Please update your QuickBooks to ...
TROUBLESHOOTING: ERROR CALLING OPEN QBCONNECTION RETURNED ERROR: 10061 - 10061 CONNECTION REFUSED PROBLEM DESCRIPTION: When doing a connection test using the "Test Connection" button in QODBC Setup Screen->General Window, QODBC reports this error: ...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION - QBOE PROBLEM DESCRIPTION: When trying to update the memo field in the table Invoice or InvoiceLine, QODBC reports the error: [QODBC]Error:1030-Not Support It is not only in the ...
TROUBLESHOOTING: SLOW PERFORMANCE / CANNOT GET FULL RECORDS FROM QUICKBOOKS / HOW TO FIND MISSING DATA PROBLEM DESCRIPTION 1: 1. QODBC is showing Partial data, or a few of my data is missing in the result set. 2. I can create an IRL and IR using QODB...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOWS XP NOTE: VB DEMO IS DEPRECATED. Please refer to How to use the QODBC Test Tool for testing [https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/] Pleas...
There are multiple ways to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for selected/multiple tables. For a Single Execution, follow the below steps. Click on "START" and "PROGRAMS" and locate QODBC DRIVER FOR THE QUICKBOOKS program group. Cl...
PROBLEM DESCRIPTION Fields related to Balances and QuantityOnHand show a Null or Missing Value, whereas QuickBooks shows the correct information. e.g., When using the below query with Optimizer On, it does not show the detail, but when Optimizer is tur...
HOW TO FIND OPTIMIZER FILE INSTRUCTIONS When the optimizer is on, QODBC automatically creates an opt file to store the optimized data. When you reset the QODBC optimizer, deleting the opt file is required. But we have received some reports that opt file...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOWS VISTA/ WINDOWS 7 OPERATING  SYSTEM INSTALL QODBC POS Please download QODBC Installer from this site: http://www.qodbc.com/posDownload.htm [http://www.qodbc.com/posDownload.htm] Then...
HOW TO ADD A NEW LINE ITEM TO AN EXISTING PURCHASE ORDER DESCRIPTION: We know how to create a new PurchaseOderLine; refer to How to create a Purchase Order using QODBC [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/Vie...
TROUBLESHOOTING: GETTING A LIMITED NUMBER OF RECORDS OR A FEW OF THE RECORDS ARE MISSING IN THE QODBC TABLE RESULT. NOTE: VB DEMO IS DEPRECATED. Please refer to How to use the QODBC Test Tool for testing [https://support.flexquarters.com/esupport/index...
"HY111 database connector error invalid bookmark value" on crystal report when refreshing the report. SOLUTIONS This could be the issue with the company file or Optimizer. I kindly request you follow the steps and let us know if that resolves the is...
Please Also Refer: Connecting QODBC Driver to QuickBooks for the First Time (Video) [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2512] The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 t...
TROUBLESHOOTING: CANNOT FIND QODBC DRIVER/QUICKBOOKS DATA UNDER SYSTEM DSN WITH ANY APPLICATION OTHER THAN THE QODBC TEST TOOL PROBLEM DESCRIPTION Testing under the 64-bit system, when using the QODBC Test Tool application, the user can see DSN (QuickBo...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2007 SETUP QODBC TO WORK WITH MICROSOFT OFFICE 2007 NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will ret...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2007 CREATING A TABLE IN MICROSOFT ACCESS Open MS Access 2007, and create a blank database. Click on the "Create" button. Then you get a Microsoft Office Access blank database. The newly created database shall ...
PROBLEM Created a VBS referring - http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/506/57/examples-of-how-to-use-qodbc-via-visual-basic [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Arti...
Most popular articles 
 
Newest articles