|
(36)Installation
|
(119)Setup
|
(119)Connection
|
|
(119)Syntax
|
(109)Data & Table
|
|
|
|
(7)Version
|
|
|
|
(54)Others
|
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 ...
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...
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 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...
SOLUTION:
To rebuild your company file via File->Utilities->Rebuild Data in
QuickBooks to see if it can fix your issue.
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...
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...
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 ...
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...
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 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 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...
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-...
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...
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 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...
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...
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....
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...
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...
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...
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...
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...
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...
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 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...
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 Quick...
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...
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: 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 - 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:
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 - 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...
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 - 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 the error "Error 3250 - This feature is not enabled or
not available in this version of QuickBooks." while I am ...
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: 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 - 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 - 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 - 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 - 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 - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM A
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 Emai...
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 ...
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 - 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...
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 - 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 - 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 - 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 - 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 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 - 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 - "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 - 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...
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 ref...
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...
TROUBLESHOOTING - HOW TO SELECT A RECORD WHEN THE 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. What
syntax do you use to select a blank/n...
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 - 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...
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 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...
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...
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 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 - 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...
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 ...
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 - 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...
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 - 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 - 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 - 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...
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 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...
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...
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...
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...
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 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 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 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 QB, the line
items seem to go,...
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...
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 - 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...
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 - 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...
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 - 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 - 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 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 - 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 to read data from QuickBooks and update data in
the SQL server. Up to this, ...
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...
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 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...
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...
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 - 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...
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...
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 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 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,...
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...
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 =...
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:
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...
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...
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...
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 - [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...
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 - 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 - 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 - 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 - 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 - 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 excellently running on the machine. We intend to
integrate into our website / Intranet to create customers or make
changes from the web. I...
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 - [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 - 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...
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 - 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 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 - 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...
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 - 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 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 - 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...
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 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...
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...
FOREIGN AND UNICODE CHARACTERS NOT SUPPORTED BY QODBC
INFORMATION:
Evidently, QuickBooks allows users to put foreign (i.e. Chinese,
Japanese, etc...) characters into item descriptions, etc...
Unfortunately, these characters are not returned properly i...
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...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATION
UNDER QUICKBOOKS POS
Please follow the steps to remove QODBC Related Certificates from
Integrated Application Under QuickBooks POS:
Try removing all the integrated application entries...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE BOUNDS OF THE
ARRAY." WHEN USING IMPORT/EXPORT TOOL IN SQL SERVER
PROBLEM DESCRIPTION 1:
I just recently installed QODBC to try to get data out of a QuickBooks
company file but I get this error: "...
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 - QREMOTESERVER HANG ON CONNECTION
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks/QuickBooks POS using QRemote
Server, But QRemoteServer is Hang on Connection.
SOLUTION:
Please check if QuickBooks Or QuickBooks POS is hav...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT
FOR 32-BIT, PLEASE REFER: 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 MICROSOF...
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 SHARE/INVITE FLEXQUARTERS SUPPORT TEAM TO QUICKBOOKS ONLINE
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 Sup...
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...
TROUBLESHOOTING - TRYING TO UPDATE ITEMINVENTORYASSEMBLYLINE TABLE
PROBLEM DESCRIPTION:
I am using MS Access connected to QuickBooks via QODBC. I am using
queries in MS Access to load/synchronize Inventory data from my master
inventory list, which is ...
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...
SAMPLE CODE FOR C++ WITH QODBC
#include
#include
#include
#include
#include
#include
#include
#include
using namespace std;
void ConvertTimeStampStructToString(TIMEST...
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...
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 - 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 - 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 - QXL 80040414 MODAL POPUP ERROR
PROBLEM DESCRIPTION:
I am trying export data from QXL. But when I click on QXL export
button I got below error message.
Unable to connect to QuickBooks. Popup window(s) in the QuickBooks
application M...
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 New Standard EXE ...
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 purchase with
each version. AKA. Up...
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 - 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 - 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...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL
PACKAGE
PROBLEM DESCRIPTION:
I am getting Error SOCKET Closed because of abnormal package in
QRemote client. I am accessing QuickBooks Data from the remote machine
over the internet (WA...
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...
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 How to create Link Server with MS
SQL 2005/2008/2012 32-bit Using QODBC/QRemote
[http://suppor...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER
First, you need to create Linked Server in SQL Server.
For 32-bit SQL Server. Please refer How to create Link Server with MS
SQL 2005/2008/2012 32-bit Using QODBC/QRemote
[http://support.flexquarters.co...
SYSTEM REQUIREMENTS FOR USING QODBC, QODBC ONLINE, AND QODBC POS
QODBC DESKTOP
QODBC is a Windows Driver (DLL) and has the same system requirements
as the QuickBooks Desktop Accounting version it is communicating with.
QODBC POS
QODBC is a Windows...
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...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040438
PROBLEM DESCRIPTION:
I am testing the connection of QODBC & I am getting QODBC test
connection failed error:
Can you advise what is error and the solution for it?
SOLUTION:
The above erro...
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/...
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 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...
There is no performance difference between QODBC Server Edition
license and QODBC Read/Write license.
There is no difference in the commands, queries, data or schema
between QODBC Server Edition license and QODBC Read/Write license.
QODBC is a client-...
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 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 ...
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...
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 or...
HOW TO UPGRADE THE QODBC ONLINE VERSION WITHOUT REAUTHORIZING TO YOUR
QUICKBOOKS ONLINE.
PROBLEM DESCRIPTION
* I want to upgrade QODBC Online to the latest version, Do I have to
reauthorize QODBC Online to connect to my QuickBooks Online company?
* ...
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 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 ...
USING QODBC WITH OFFICE 64-BIT
QuickBooks is a 32-Bit application, but there are other applications
such as MS Excel, MS Access, and MS SQL Server which are also
available in 64-Bit architecture.
Since a 64-Bit application cannot talk to a 32-bit driv...
[QODBC DESKTOP] HOW DO I DETERMINE WHICH DATABASE IT IS USING TO SET
UP THE CONNECTION WITH QUICKBOOKS?
PROBLEM DESCRIPTION:
How do I determine which database it is using to set up the connection
with QuickBooks?
SOLUTIONS:
To determine which databa...
[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 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 below options.
Switch to the 'View' ...
[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...
[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...
TROUBLESHOOTING - THERE WAS AN ERROR SAVING AN EMPLOYEES LIST. THE
ADDRESS IS INVALID
PROBLEM DESCRIPTION:
We have searched the wiki, internet and tried endlessly to 'Insert an
Employee'.
Below is our latest effort all to no avail-
Insert into Emplo...
Help Desk Software by Kayako