RSS Feed
Knowledgebase : TroubleShooting

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...
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: ...
[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 ...
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...
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...
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...
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...
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 ...
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. ...
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 - 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...
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'...
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...
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 ...
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 ...
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...
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 - 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 - 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...
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 BALANCE SHEET REPORT IN QUICKBOOKS ONLINE REPORT DISPLAYED IN QODBC ONLINE STORED PROCEDURE COMMAND With QODBC, the same report can be generated using stored procedure reports like this: sp_report BalanceSheetDetail show RowData, Amount_1 a...
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...
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 ...
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...
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 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...
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 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 - 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, ...
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...
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...
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...
TROUBLESHOOTING - GETTING "WRONG CLIENT ENCYPTKEY SETTING" ERROR PROBLEM DESCRIPTION: I'm trying to establish a connection to QuickBooks using QRemote Server. But when I tried to connect, I got the below error message: "Wrong client Encyptkey setting"...
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 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...
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 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 - 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...
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 ...
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...
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...
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...
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 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 >>...
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: 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...
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...
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: 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: 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: 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...
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...
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...
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...
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...
PROBLEM DESCRIPTION: When I attempt to configure the driver and data source, only QRemote for the QuickBooks driver is visible; please see below: Where can I find QuickBooks Data, the driver? Don't I need to configure the QuickBooks Data driver instead...
TWO EXAMPLES OF WRITING DEPOSITS INSTRUCTIONS NOTE: Deposit inserts are done only to the DEPOSITLINE table. The Deposit table is a header table that cannot be inserted without cached DepositLine transactions. TROUBLESHOOTING NOTE If you encounter ...