TWO EXAMPLES OF WRITING DEPOSITS
INSTRUCTIONS
NOTE: Deposit inserts are done only to the DEPOSITLINE table. The
Deposit table is a header table and cannot be inserted into without
cached DepositLine transactions.
TROUBLESHOOTING NOTE
If you encoun...

PROBLEM DESCRIPTION:
When I attempt to configure driver and data source, only QRemote for
QuickBooks driver is visible; please see below:
Where can I find QuickBooks Data driver? Don't I need to configure
QuickBooks Data driver instead of QRemote for Q...

TROUBLESHOOTING: CANNOT FIND QODBC DRIVER/QUICKBOOKS DATA UNDER SYSTEM
DSN WITH ANY APPLICATION OTHER THAN THE VB DEMO
PROBLEM DESCRIPTION
Testing under the 64-bit system, when using VB Demo test application,
the user can see DSN (QuickBooks Data) in th...

"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 to follow steps and let us know if that resolves
the iss...

TROUBLESHOOTING: GETTING A LIMITED NUMBER OF RECORDS OR FEW OF THE
RECORDS IS MISSING IN QODBC TABLE RESULT.
PROBLEM DESCRIPTION
1. When I Query my tables e.g. Bill or Customer, I noticed QODBC is
not returning all the records and seems few records ar...

PROBLEM DESCRIPTION
Fields related to Balances and QuantityOnHand is showing Null value or
is Missing Value, wherein QuickBooks is showing the correct
information.
e.g. When using below query with Optimizer On it does not show the
detail but when Optim...

TROUBLESHOOTING: SLOW PERFORMANCE / CANNOT GET FULL RECORDS FROM
QUICKBOOKS / HOW TO FIND MISSING DATA
PROBLEM DESCRIPTION 1:
1.QODBC is showing Partial data or few of my data is missing in the
result set.
2.I am able to create an IRL and IR using QO...

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 all...

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...

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 file. QODBC can
show/fetch only those information which is exposed/provided by
QuickB...

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...

PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks through SSIS using QODBC but I am
unable to connect to QuickBooks.
I have a Read Only Desktop edition of QODBC which is included with
QuickBooks Enterprise Edition.
I am getting the error: "Er...

PROBLEM DESCRIPTION:
I am attempting to apply payments to invoices I have also determined
the TxnID of the Invoice I want to apply payment to and used it in the
SQL code specified on How to apply payment to an invoice
[http://support.flexquarters.com/esu...

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
it too, but you may not be able to create an empty InvoiceLine in
QODBC.
You cannot crea...

TROUBLESHOOTING: QREMOTE REPORTS "CONNECTION TO DATA SOURCE FAILED"
WHEN WORKING WITH 64-BIT ACCESS OR EXCEL
PROBLEM DESCRIPTION:
Setup QRemote to work with 64-bit MS Excel. The Client DSN settings
are correct. But when access to "QRemote Data 64-bit" ...

HOW TO VIEW DETAILS ON WHAT QODBC IS PERFORMING
PROBLEM DESCRIPTION:
How can I view details on what QODBC is performing in the background?
SOLUTION:
You can enable QODBC status panel via: Start >> All Programs >> QODBC
Driver for use with QuickBooks...

PROBLEM DESCRIPTION:
I am getting the following error trying to delete a record from
InvoiceLine:
[QODBC] Requires at least one child. Cannot delete last line (#10074)
Does the invoice file require that there be at least one record in
InvoiceLine? If ...

ACTIVATION-DEACTIVATION FAQ
PROBLEM DESCRIPTION 1:
My old machine broke and I had to completely reinstall the OS. 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. ...

EXAMPLES OF CREATING INVOICE USING QODBC
First of all please create new MS Access database & link ALL table.
Please refer below mentioned article for How to Use QODBC with
Microsoft Access:
How to Use QODBC with Microsoft Access
[http://support.flexqua...

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 feed thes...

HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC
PROBLEM DESCRIPTION:
When using Prepared Statements with QRemote driver then it throws an
error called ODBC driver not supported. How can I use Prepared
Statements with QODBC/QRemote?
SOLUTIONS:
You may...

QODBC LICENSING INFORMATION
Also Refer: QODBC with QRemote Licensing Information
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2568/]
There are different types of License required depends on your
requirement in QODBC,...

HOW CAN I FIND SOURCE OF SP_REPORT
PROBLEM DESCRIPTION 1:
Is there a way to see the SQL that QuickBooks uses to generate their
reports?
Also, Which tool do they use to generate reports?
PROBLEM DESCRIPTION 2:
I need to access information that is u...

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 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 QuickB...

TROUBLESHOOTING: SP_REPORT BALANCESHEETSTANDARD REPORT ERROR "[QODBC]
AT LEAST ONE FIELD REQUESTED REQUIRES DATEFROM TO BE SET".
PROBLEM DESCRIPTION:
I am running BalanceSheetStandard through VB Demo & It is returning
below error.
When I run this que...

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 am able to get records
from ProfitA...

TROUBLESHOOTING: QUICK REPORT ON AN ACCOUNT
PROBLEM DESCRIPTION:
How can I get a Quick Report on an account from Chart of Accounts? In
Quick Books 2006 Premier, I opened chart of accounts (Ctrl+A) then
selected an account and then pressed Ctrl+Q.
SOLU...

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 the GL account. Running
sp_repor...

PROBLEM DESCRIPTION:
I can change the optimizer settings when I run the program as an
administrator but it never really gets saved. Everything I run the
Setup Screen again the settings are back to the original settings and
my changes aren't saved. Do I ...

TROUBLESHOOTING - CANNOT CREATE NEW TABLE USING QODBC / CANNOT ADD A
NEW FIELD TO QODBC TABLE
PROBLEM DESCRIPTION:
I'm trying to create a new table with VB Demo.
Can you send me a sample query to do this?
SOLUTIONS:
QODBC is an ODBC driver. Please...

PROBLEM DESCRIPTION:
We modified an invoice in QuickBooks and we are trying to get the data
out in Excel, but QODBC gives us the old data still.
Why?
SOLUTIONS:
QODBC failed to return full records is usually caused by either
corruption of QODBC opti...

TROUBLESHOOTING - APP_ALREADY_PURCHASED ERROR WHEN TRY 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
throu...

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: ERROR 3250 - THIS FEATURE IS NOT ENABLED OR NOT
AVAILABLE IN THIS VERSION OF QUICKBOOKS.
PROBLEM DESCRIPTION:
I am getting error "Error 3250 - This feature is not enabled or not
available in this version of QuickBooks." while I am tryi...

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 MS Access database & linked all QODBC tables through
QRemote DSN, After that...

TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040417
PROBLEM DESCRIPTION:
When using your QODBC Driver with my custom application, coded in
Java, the application is able to connect and retrieve data if
QuickBooks is running with the company file ...

TROUBLESHOOTING - SCHEDULED TASK JOB NOT WORKING AFTER UPGRADING QODBC
PROBLEM DESCRIPTION:
We use software called RemiCrystal to generate reports for emailing.
The reports have always worked fine using QB 2013 Pro and QODBC v14 (I
think v14). Then we u...

TROUBLESHOOTING - HOW TO ACCESS QUICKBOOKS DATA USING FILEMAKER
PROBLEM DESCRIPTION:
I downloaded the trial version of your driver this morning and am
really excited about the prospects. I've installed it and am able to
get the fields and tables to app...

TROUBLESHOOTING - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM
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 Email ...

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 - 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 - MULTIPLE TABLES EXIST ERROR IN 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 been t...

HOW TO USE QODBC WITH PHP
INSTRUCTIONS FOR USING QODBC WITH PHP:
Using PHP, whether it's an internal Intranet or on the World Wide
Web, requires the Server Edition of QODBC. QuickBooks must be running
with the company file open.
Download Sample
[http...

TROUBLESHOOTING - CAN QODBC / QREMOTE RUN AS A SERVICE
PROBLEM DESCRIPTION:
How do I run QODBC as windows services in the background? I notice it
required QuickBooks to be logged and windows server 2008 to be logged
on.
SOLUTIONS:
QODBC and QuickBoo...

TROUBLESHOOTING - HOW TO ADJUST VALUE OF A STOCK ITEM WITHOUT
ADJUSTING STOCK QUANTITY
PROBLEM DESCRIPTION:
Can I adjust the value of a stock item without adjusting the stock
quantity?
SOLUTIONS:
Yes, you can adjust the value of a stock item withou...

TROUBLESHOOTING - HOW TO CREATE 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 sending...

TROUBLESHOOTING - HOW TO TAKE SCREENSHOT
PROBLEM DESCRIPTION:
How do I take an error screenshot?
SOLUTIONS:
If you've got a problem with a program in Windows, you may be
wondering how to show the errors you're receiving. Luckily, taking a
screensho...

QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE
PROBLEM DESCRIPTION:
When set QODBC POS DSN to access the company file that is running in
QuickBooks POS (Version 10), it will fail to connect to the company
file. QuickBooks POS will search for ...

TROUBLESHOOTING - HOW TO VERIFY IF OPTIMIZER FILE CORRUPTED OR NOT
PROBLEM DESCRIPTION:
Is there any way to figure out when the Optimizer cache is corrupted
or if there's a way we can avoid it altogether in the future?
SOLUTIONS:
Please refer below...

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 later version. So you need to install .Net Framework
4.0 to work with QODBC Online.
Please refer...

TROUBLESHOOTING - HOW TO USE DATE() AND DATEADD() FUNCTION IN QODBC
PROBLEM DESCRIPTION:
I want to write some select statements on both InvoiceLine and
SalesReceiptLine that returns all records dated WITHIN the past 30
days, relative to whatever TODAY ...

TROUBLESHOOTING - HOW TO SELECT RECORD WHEN VALUE IS NULL
PROBLEM DESCRIPTION:
I am trying to run a report which returns ItemInventory where
LastReceived is NULL I have tried in vain to accomplish this. My
question is what syntax do you use to select a...

HOW TO USE QXL
STEP 1 - DOWNLOAD QXL
If you haven't already downloaded QXL, do it now by going to the
download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/].
Don't forget to read the "Readme" file during installation for the
latest infor...

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 Order...

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...

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, L...

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 get to the loca...

HOW TO USE QODBC ONLINE WITH QUICKBOOKS ONLINE EDITION (APPS.COM)
SETUP OF QODBC ONLINE:
First, we need to install QODBC Online. QODBC Online requires .Net
Framework 4.0 or later version. So you need to install .Net Framework
4.0 to work with QODBC Onl...

TROUBLESHOOTING - HOW TO USE QODBC ONLINE WITH FILEMAKER
PROBLEM DESCRIPTION:
I downloaded the trial version of your driver this morning and am
really excited about the prospects. I've installed it and am able to
get the fields and tables to appear in ...

SETUP IN ALPHA FIVE
CREATE A NEW WORKSPACE
Start Alpha Five and create a new workspace, it could be called
Online.adb - it is a holder for the entire application.
Click the WORKSPACE & TASKS tab -> Click -> choose CREATE A NEW,
EMPTY WORKSPACE -> ...

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 Jitte...

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 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...

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...

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 IDENTIFY IF 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, then you can identify it by
Starting your ...

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 into QB the line items
seem to go but wh...

TROUBLESHOOTING - HOW TO USE QODBC WITH MULTIPLE QUICKBOOKS COMPANY
FILE
PROBLEM DESCRIPTION:
I have a question about setting ODBC to auto login. We have two
different company files for accounting purpose. I am trying to
automate some of the tasks and I...

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 application &
"QuickBooks...

TROUBLESHOOTING - QODBC LICENSING ISSUES WITH WINDOWS 10 UPGRADES
PROBLEM DESCRIPTION:
I want to upgrade my Operating System to Windows 10 and want to know
is there any precautions/actions required for QODBC to keep working.
SOLUTIONS:
STEPS BEFORE U...

Connecting QODBC Online Driver to QuickBooks Online for the First Time
(Video)
How to install QODBC Online & Using Microsoft Excel/Access with QODBC
You can also see: How to use QODBC Online with QuickBooks Online
Edition
[http://support.flexquarters...

TROUBLESHOOTING - HOW TO USE QODBC ON MAC
PROBLEM DESCRIPTION:
I have MAC Operating System & I want to use QODBC on it. Is it
possible to use QODBC on MAC?
SOLUTIONS:
Yes, you can use QODBC on MAC. But you have to load some tools to use
it. You can ...

TROUBLESHOOTING - HOW TO GET VBA TO EXECUTE TWO STATEMENTS AT THE SAME
TIME
PROBLEM DESCRIPTION:
We are using a Visual Basic app which works with an SQL Server
database to write data to QB through QODBC. We are executing two SQL
statements as described...

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 that we just built, it keeps to using the wrong
QuickBooks user for the auto-login...

TROUBLESHOOTING - QODBC CONNECTION TO TALEND OPEN STUDIO
PROBLEM DESCRIPTION:
QuickBooks Enterprise comes with a tool called QODBC that enables
connecting to a QB database to read and write data. I have installed
it, and I can successfully see QB data ...

TROUBLESHOOTING - QODBC DRIVER DROPPING A FEW TRANSACTIONS ON INSERT
TO INVOICELINES
PROBLEM DESCRIPTION:
We seem to be having an issue with an insert into the InvoiceLines
table dropping a few transactions.
We need to create about 1000 invoices per m...

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...

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 read data from QuickBooks and update data in SQL
server, up-to this I can ab...

HOW TO RETRIEVE CHARACTER FIELDS WHICH 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 function CONVERT to convert the dat...

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:
I am are trying to use QODBC with Crystal Reports 11, but I'm also
having the similar results with the VB Demo included with the driver.
Many queries, such as "select * from invoice" cause the program to
hang. With Crystal Reports, ...

PROBLEM DESCRIPTION:
VB DemoTest Connection is crashing. When I tried to connect to
QuickBooks using QODBC.
I have tried to reinstall QODBC & QuickBooks but still, QODBC Test
connection (also via VB Demo) is crashing. Also, I tried to run QODBC
as Admi...

PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks through SSIS using QODBC, but I
am unable to connect to QuickBooks.
I have a Read Only Desktop edition of QODBC which is included with
QuickBooks Enterprise Edition.
I am getting the error:
...

PROBLEM DESCRIPTION:
How to insert employee time information from MS Excel time spreadsheet
into QuickBooks using QODBC
SOLUTION:
You cannot perform insert/update operation directly in MS Excel
because Excel is just exporting table in the spreadshee...

PROBLEM DESCRIPTION:
We keep getting "QB Begin Session Failed" error when trying to open
QODBC connection in a web page.
--> It happens when there are several users using QuickBooks at the
same time.
--> When it happens, We tried to use the 'VB Demo' and...

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 - 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 facing connection issue.
Every time I try to ...

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...

TROUBLESHOOTING - HOW TO LOCATE CONFIGURE QODBC DATA SOURCE
PROBLEM DESCRIPTION:
I am unable to find or configure the 32-Bit ODBC Data Source Manager
under a 64-Bit System. I will be more than happy to remote access to
you and my server representativ...

TROUBLESHOOTING - UPDATE QUERY TRUNCATING LEADING SPACES
PROBLEM DESCRIPTION:
I have to update a field with specific data and for some records, one
of the fields will have leading spaces that are required to be there.
I have tried numerous ways to get...

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 1...

WHAT IS JUMPIN TYPE?
PROBLEM DESCRIPTION:
I am looking for definition and usage of "JUMPIN TYPE."
SOLUTION:
In QODBC JUMPIN provides relationship details with other table and
also provides information about value comes from another table.
Please ...

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, says it has a connection but
does nothing. I...

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"
SOLUTIO...

TROUBLESHOOTING - FAULTING APPLICATION NAME: QREMOTESERVER.EXE
PROBLEM DESCRIPTION:
We have had a couple error messages pop up recently on the server
related to the QODBC driver on our server and were wondering if you
could provide any information as ...

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 - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL
SERVER
PROBLEM DESCRIPTION:
So the QODBC works great running on the machine. We have the intent to
integrate into our website / Intranet to create customers or make
changes from the web...

TROUBLESHOOTING - THIS RECORD HAS BEEN CHANGED BY ANOTHER USER SINCE
YOU STARTED EDITING IT.
PROBLEM DESCRIPTION:
I am using the QuickBooks Pro 2015 trial version and a purchased QODBC
latest version.
I have an Access database with linked QB tables. ...

TROUBLESHOOTING - INVOICE LINE RATE IS NOT LOADING INTO QBO
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 to create the i...

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 - 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 two different ways.
1. If I "Connect to QuickBooks" on th...

TROUBLESHOOTING - HOW DO I LIST THE SUBTOTAL OF INVOICES WITHIN DATE
RANGE
PROBLEM DESCRIPTION:
I would like to do is list find the subtotal of all Invoices by a
customer for not only that particular customer but all jobs assigned
to that customer, wi...

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 using the following stored procedure "s...

TROUBLESHOOTING - HOW CAN I CHANGE THE PRICING AND QUANTITY OF ITEMS
IN AN ITEMGROUP?
PROBLEM DESCRIPTION:
How can I change the price of each individual item in a group? Is it
possible? If yes please give me an example.
SOLUTION:
The price of an it...

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 GET DAILY BILL PAYMENT INFORMATION?
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 ...

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 start working with QODBC to get
...

TROUBLESHOOTING - HOW DO I VOID AN INVOICE?
PROBLEM DESCRIPTION:
How do I void an Invoice? And How do I query for invoices that have
been voided? I don't see any kind of indicator in the Invoice table.
SOLUTION:
You can use SP_VOID just like you wo...

TROUBLESHOOTING - HOW TO COMPUTE SUM WITHOUT COMPUTE CLAUSE
PROBLEM DESCRIPTION:
The following select gives me the right data using DISTINCT, but then
how do I get a sum of it, which is what I need?
select distinct billtopayduedate,
billtopayrefnumb...

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...

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 that I hav...

HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC
NOTE: QODBC does not support direct import, But you can write VBA code
which reads a CSV / Excel file & generates insert statements.
There are two ways to Import data to QuickBooks through CSV u...

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...

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...

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 - CORRELATED SUBQUERIES IN UPDATE STATEMENT
PROBLEM DESCRIPTION:
I would like to update the salesrep field in my existing invoices. I
would like to use the salesrep value that is stored in the Customer
file. I would normally do this in...

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 - HOW CAN I GET LAST ITEMS SOLD TO CUSTOMER DETAILS
PROBLEM DESCRIPTION:
I was able to create a report using a customer set with the customer
as the parent and InvoiceLine as the child giving me items ordered in
the past.
My problem ...

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 back to the estimate.
I'm designing a report that needs...

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 DO I GET TABLE RECORD COUNT 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. So ...

TROUBLESHOOTING - ODBC DRIVER DOESN'T SUPPORT THIS STATEMENT.
UPDATING EXISTING RECORD
PROBLEM DESCRIPTION:
I'm trying to programmatically make Inventory Items In-Active after a
sale or Active after voiding a sale.
I would have thought that the foll...

TROUBLESHOOTING - HOW TO USE BETWEEN IN QODBC
PROBLEM DESCRIPTION:
I need to use Between, in range of dates to return new customer in one
period, I try this:
SELECT FullName FROM Customer Where TimeCreated Between
{d'2007-12-18'} AND {d'2007-12-19'...

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 upgrading to
latest QuickBooks and QODBC require any code ...

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 that it
returns contains...

TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE BOUNDS OF THE
ARRAY." WHEN USING IMPORT/EXPORT TOOL IN SQL SERVER
PROBLEM DESCRIPTION:
I just recently installed QODBC to try to get data out of a QuickBooks
company file but I get this error: "In...

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...

HOW TO SHARE/INVITE FLEXQUARTERS SUPPORT TEAM TO QBO COMPANY FILE
PROBLEM DESCRIPTION:
How do I share/invite FLEXquarters Support team to access my QBO
company file?
SOLUTION:
Please follow below steps to share/invite FLEXquarters Support team to
Q...

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 - QODBC LOGGING IN WITH 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 closed.
...

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 - QB BEGIN SESSION FAILED. ERROR - UNAUTHORIZED-401
PROBLEM DESCRIPTION:
I was able to use QODBC Online. Suddenly, I am getting below error
when I tried to connect QBO using QODBC Online. It was working
properly. No known changes to Wi...

TROUBLESHOOTING - CAN I USE QODBC WITH QBB ( QUICKBOOKS BACKUP ) FILE
PROBLEM DESCRIPTION:
I am trying to find a way we can pull data from a .QBB file without
having to restore the .QBB file and/or go through QuickBooks.
Is QODBC capable of doing so...

HOW TO USE QODBC WITH SSIS
Either QODBC or QRemote is required on the machine where SSIS package
will be developed, deployed or SSIS services are installed.
Development - On the machine, you are developing SSIS package - You
should have QODBC install...

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 - 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 - SP_REPORT CHANGING DAYS PER AGING USING QODBC
PROBLEM DESCRIPTION:
I recently discovered QODBC and have been playing around with it for a
few days now. It's pretty good.
The problem I have is when I try to get an A/P aging. The A/P...

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 particular products over ...

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 - HOW TO GET ADVANCED PRICING MODULE IN QODBC
PROBLEM DESCRIPTION:
We are using advanced pricing module in QuickBooks and would like to
know what tables we need to access to pull that information from the
system.
SOLUTION:
Advanced ...

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 - QODBC RECORD SET ISSUE
PROBLEM DESCRIPTION:
I am using below code it is returning records & giving me the correct
result. But If I change query from "SELECT Name FROM customer" to
"SELECT * FROM customer" it does not return any recor...

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 that it can connect only
1 company fil...

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 that How to insert Invoice in
QuickBooks using the data available in Exce...

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 below error at the time of connection.
Please help me to resolve this error.
...

TROUBLESHOOTING - CD KEY HAS INVALID CHECKSUM
PROBLEM DESCRIPTION:
I am moving to a new server.
I have everything setup, but can't get the license to transfer. On the
old machine when I go to the 'deactivate' using my cd-key I get:
"CD Key has inva...

EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE
Download Sample
[http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip]
Before using MS Excel application, please make sure you have installed
MS Office C...

TROUBLESHOOTING - GETTING INCOMPLETE DATA WHEN RUNNING
PROFITANDLOSSBUDGETVSACTUAL REPORT
PROBLEM DESCRIPTION:
Good Day To You. Using This Sp_report And Having Some Problem With The
Column Layout. Command Text Is As Follows: Sp_report
Profitandlossbud...

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...

QODBC MENU ITEMS
When you install QODBC below menu items are created under QODBC Driver
for use with QuickBooks folder in start menu.
1. CONFIGURE QODBC DATA SOURCE 64-BIT
CONFIGURE QODBC DATA SOURCE 64-BIT will help you to
view/create/configure 64-...

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 "Down...

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:
Could not load the DLL library
C:WindowsSystem32fqqb32.dll. Invalid access to memo...

HOW TO USE QODBC SUPPORT WIZARD
PROBLEM DESCRIPTION:
How to use QODBC Support Wizard?
SOLUTION:
Please follow below-listed steps for using QODBC Support Wizard.
"QODBC Support Wizard" application is included with QODBC v18.0.0.325
and above. In cas...