|
(988)Tutorials
|
(827)TroubleShooting
|
|
|
(17)Syntax
|
(215)QXL Support
|
(513)QODBC
|
|
(85)QODBC Online
|
(63)QODBC POS
|
PROBLEM
Created a VBS referring -
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/506/57/examples-of-how-to-use-qodbc-via-visual-basic
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Arti...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2007
CREATING A TABLE IN MICROSOFT ACCESS
Open MS Access 2007, and create a blank database.
Click on the "Create" button. Then you get a Microsoft Office Access
blank database.
The newly created database shall ...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2007
SETUP QODBC TO WORK WITH MICROSOFT OFFICE 2007
NOTE: QODBC allows you to quickly merge live QuickBooks data into the
cells of your Microsoft Excel worksheets for quick calculations and
graphs. The data will ret...
TROUBLESHOOTING: CANNOT FIND QODBC DRIVER/QUICKBOOKS DATA UNDER SYSTEM
DSN WITH ANY APPLICATION OTHER THAN THE QODBC TEST TOOL
PROBLEM DESCRIPTION
Testing under the 64-bit system, when using the QODBC Test Tool
application, the user can see DSN (QuickBo...
Please Also Refer: Connecting QODBC Driver to QuickBooks for the First
Time (Video)
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2512]
The QODBC Driver for QuickBooks runs differently under Microsoft
Vista/W7 t...
"HY111 database connector error invalid bookmark value" on crystal
report when refreshing the report.
SOLUTIONS
This could be the issue with the company file or Optimizer.
I kindly request you follow the steps and let us know if that resolves
the is...
TROUBLESHOOTING: GETTING A LIMITED NUMBER OF RECORDS OR A FEW OF THE
RECORDS ARE MISSING IN THE QODBC TABLE RESULT.
PROBLEM DESCRIPTION
1. When I Query my tables, e.g., Bill or Customer, I notice QODBC is
not returning all the records, and it seems a ...
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...
PROBLEM DESCRIPTION
Fields related to Balances and QuantityOnHand are showing a Null value
or Missing Value, wherein QuickBooks is showing the correct
information.
e.g., When using the below query with Optimizer On, it does not show
the detail, but whe...
There are multiple ways to execute SP_OPTIMIZEUPDATESYNC or
SP_OPTIMIZEFULLSYNC for selected/multiple tables.
For a Single Execution, follow the below steps.
Click on "START" and "PROGRAMS" and locate QODBC DRIVER FOR THE
QUICKBOOKS program group. Cl...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOWS XP
Please refer to How to Install QODBC POS and Connect to QuickBooks POS
on Windows 10
[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2871]
for using QOD...
TROUBLESHOOTING: SLOW PERFORMANCE / CANNOT GET FULL RECORDS FROM
QUICKBOOKS / HOW TO FIND MISSING DATA
PROBLEM DESCRIPTION 1:
1. QODBC is showing Partial data, or a few of my data is missing in
the result set.
2. I can create an IRL and IR using QODB...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION -
QBOE
PROBLEM DESCRIPTION:
When trying to update the memo field in the table Invoice or
InvoiceLine, QODBC reports the error:
[QODBC]Error:1030-Not Support
It is not only in the ...
TROUBLESHOOTING: ERROR CALLING OPEN QBCONNECTION RETURNED ERROR: 10061
- 10061 CONNECTION REFUSED
PROBLEM DESCRIPTION:
When doing a connection test using the "Test Connection" button in
QODBC Setup Screen->General Window, QODBC reports this error:
...
TROUBLESHOOTING: TIMETRACKING / TRANSACTION TABLE IS BLANK
PROBLEM DESCRIPTION:
The TimeTracking / Transaction table always returns null/ no rows. I
tried to reset the QODBC optimizer, but it didn't work.
SOLUTION:
Please update your QuickBooks to ...
TROUBLESHOOTING: EXPECTED LEXICAL ELEMENT NOT FOUND
PROBLEM DESCRIPTION
When trying to execute a query statement, I get the error message "
EXPECTED LEXICAL ELEMENT NOT FOUND."
SOLUTIONS
It seems to be the issue in the SQL Statement. Please check al...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 32-BIT
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 64-BIT
(MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)
QuickBooks 2022 and above are 64-Bit applications...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2010 (32-BIT)
FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK
WITH 64-BIT MS EXCEL
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-CONFIGURE-...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 TO BUILD LINKED
TABLE(32-BIT)
FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT
MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57/HOW-...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 (32-BIT) TO IMPORT
QUICKBOOKS DATA
FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT
MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019
32-BIT
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 64-BIT
(MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)
QuickBooks 2022 and above are 64-Bit applicatio...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 /
2019 32-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019
64-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES (MINIMUM
REQUIREMENT...
QODBC and Microsoft Excel
MICROSOFT ACCESS 2003 AND QODBC
CREATING A TABLE IN MICROSOFT ACCESS
NOTE: Microsoft Access has many uses and will allow you to use your
QuickBooks data files similarly to Access databases.
Selecting the menu FILE -> NEW -...
QODBC and Microsoft Excel
MICROSOFT EXCEL 2003 AND QODBC
Also, Refer:
How to Use QODBC with MS Excel 2007
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2449/57/how-to-use-qodbc-with-ms-excel-2007]
Using QuickBo...
PROBLEM
I need to update the old terms of a customer in QuickBooks. They used
to be due upon receipt, and we need to move them to net 30. I need to
go back and change all the old due dates to reflect the new terms. How
can I update the DueDate to remembe...
PROBLEM DESCRIPTION:
Trying to change the cost of an assembly using the following query:
UPDATE Item set SalesPrice = 1500.00, PurchaseCost = 700 where Name =
'Blueprints';
It fails with the error: "error: [QODBC] Not supported
or
UPDATE the price ...
ACTIVATING QODBC STILL SHOWS THE EVALUATION VERSION IN THE QODBC SETUP
SCREEN.
If you have activated QODBC with a purchased license CDKey and get the
"Activation Successful" message and then run an application trying to
use QODBC, you get the message t...
INSTALLATION STEPS FOR WINDOWS 8
After you have downloaded QODBC Installer, navigate to the "Downloads"
Folder or the location where you have saved QODBC Installer. Run the
installer as administrator by Right-clicking on the installer and
selecting "Run...
QODBC Limited Use Software License
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install
and operate the copy of the computer program contained in this package
("Program") on a single computer (one central processing unit)
ut...
HOW TO VIEW QODBC DRIVER DIGITAL CERTIFICATE
QODBC Driver does have a digital certificate. To verify or know more
about Digital Certificate details, Please right-click on
fqqb32.dll/properties in the Windows>System 32/SysWow64 Directory.
Below are det...
PROBLEM DESCRIPTION:
The TimeTracking / Transaction table always returns null/ no rows. I
tried to reset the QODBC optimizer, but it didn't work.
If the Solution provided here
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATIONS
UNDER QUICKBOOKS
Please follow the steps to remove QODBC Related Certificates from
Integrated Application Under QuickBooks:
Try removing all the integrated application entries in Qui...
QREMOTE TUTORIAL: USING QUICKBOOKS DATA REMOTELY VIA QODBC
Also, refer to Accessing QuickBooks Data Remotely using QODBC &
QRemote. (Video)
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/]
QODBC has the abi...
QODBC can allow SQL Server to Access QuickBooks Data Remotely.
"FileServer": having QuickBooks File
"Server": having QuickBooks Application
"Client": having SQL Server.
Below are the Steps
Install QODBC on "Server" & "Client." Not required on "FileSer...
SOLUTION:
To rebuild your company file via File->Utilities->Rebuild Data in
QuickBooks to see if it can fix your issue.
PROBLEM
I am unable to Activate/Deactivate the currently installed version. I
am logged in as Administrator, with admin rights, and right-clicking
on the Setup and selecting "Run As Administrator" does not change the
result.
You do not have Sufficient...
This method is Discontinued. Please refer new product QODBC for
QuickBooks Online:
How to use QODBC Online with QuickBooks Online Edition (Apps.com)
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2658]
How to Reconnect...
HOW TO RUN PAYROLL SUMMARY REPORT / PAYCHECK TRANSACTIONS USING QODBC
REPORT IN QUICKBOOKS
Paycheck transaction information is not stored in a separate table,
but you can refer to the Payroll Summary report in QuickBooks to view
the payroll records of...
How to Run VB Script on 64-bit Operating System
INSTRUCTION:
When running the VB Script on the 64-bit system, if you directly run
the Script by double-clicking the vbs file, the system will run the VB
Script as 64-bit. Then QODBC will report an error l...
TROUBLESHOOTING: QODBC POS REPORTS "TEST CONNECTION TO QUICKBOOKS POS
FAILED" ERROR.
PROBLEM DESCRIPTION:
QODBC POS reports a "Test Connection to QuickBooks POS failed" error
when trying to connect to QuickBooks POS:
SOLUTION:
This error shows a pro...
HOW TO FIND S.O NUMBER INFORMATION OF SALES ORDERS IN QODBC
INSTRUCTIONS:
Sometimes QODBC may have the field name the same as in QuickBooks. You
cannot find S.O Number or P.O Number in QODBC, but QODBC does have a
field in these tables to store the inf...
TROUBLESHOOTING: UPDATING JOURNALENTRY RECORDS VIA QODBC SHOWS ERROR,
TRANSACTION NOT IN BALANCE.
INSTRUCTION:
Under QuickBooks, when saving a Journal Entry record, the Debit total
should match the Credit total.
Even thou you are not changing the amo...
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...
During the installation, the following error occurs even when logged
in with an Administrator's account.
"You do not have access to make the required system configuration
modifications.
Please rerun this installation from an Administrator's account."
...
TROUBLESHOOTING: THIS APPLICATION IS NOT ALLOWED TO CHANGE ITS
AUTHENTICATION PREFERENCES UNLESS QUICKBOOKS IS RUNNING WITH THE
ADMINISTRATOR LOGGED IN
PROBLEM DESCRIPTION:
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session F...
TROUBLESHOOTING - LISTENING FAILED. QREMOTE SERVER IS SHUTTING DOWN
IN 15 SEC
PROBLEM DESCRIPTION 1:
When I start QRemote Server, I get QRemoteServer Started, and it shows
"Listening failed.QRemote Server is shutting down in 15 sec."
PROBLEM DESCRIPT...
TROUBLESHOOTING - QREMOTE INITIALIZATION ERROR, ERROR: LISTENING
FAILED. PLEASE RESTART APPLICATION
PROBLEM DESCRIPTION 1:
QRemote Initialization Error,
QRemote Error: Listening failed. Please restart application
QRemote Closing in 15 Seconds.
PR...
This method is Discontinued. Please refer new product QODBC for
QuickBooks Online:
How to use QODBC Online with QuickBooks Online Edition (Apps.com)
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2658]
How to Reconnect...
QODBC SHOWS A REGFILE1 LICENSE ERROR WHEN USING MS EXCEL 2013 OR
ACCESS 2013
MS EXCEL 2013 OR ACCESS 2013 SHOWS THIS FUNCTION REQUIRES ACTIVATION
OF QODBC READ WRITE OR SERVER EDITION.
MS EXCEL 2013 OR ACCESS 2013 (OFFICE 365) CRASHES WHEN TRYING TO
C...
PROBLEM :
QBXML components have not been installed. / Error Getting Version /
QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks
REASON :
There have been a few problems reported when Upgrading to QuickBooks
2013 R7.
After auto up...
Issue :
After updating to QuickBooks 2012 R14, you may encounter Unrecoverable
Error XXXXX XXXXX (the codes can appear random) while opening your
company file.
or
I COULD NOT OPEN THE QUICKBOOKS COMPANY FILE AFTER THE UPDATE.
SOLUTION
If you hav...
CONNECTING TO QUICKBOOKS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE.
THE TEST CONNECTION WAS NOT WORKING.
The QODBC Driver for QuickBooks runs differently under Microsoft
Vista/W7 than other versions of Windows because of its new strict
security setting...
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 set up QODBC Driver to auto-connect to QuickBooks. (Video)
Also, refer - How to set up QODBC to run without QuickBooks
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2518/0/how-to-setup-qodbc-to-run-without-quickb...
Connecting QODBC Driver to QuickBooks for the First Time (Video)
Go to: How to set up the QODBC Optimizer and Where are the Optimizer
options
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2358]for
the next step.
You...
Using QuickBooks data with MS SQL Server using QODBC Driver and
QRemote (Video)
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...
QODBC EVALUATION PERIOD EXPIRED AFTER UPGRADE TO INTUIT ENTERPRISE.
PROBLEM DESCRIPTION:
An older trial installation of QODBC (from before QB Enterprise and
long expired) was once on this computer.
How do I proceed to install the QODBC driver include...
Environment
QuickBooks 2014
QODBC 14.0.0.298
QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to
communicate with QuickBooks & QuickBooks company files. QODBC can
show/fetch only the information which is exposed/provided by
QuickBo...
Accessing QuickBooks Data Remotely using QODBC & QRemote
Using QuickBooks data remotely via QODBC
FOR USING QREMOTE OVER THE INTERNET & WITH DYNAMIC IP (NON-STATIC-IP):
You can make sure of services like Dynamic DNS (DDNS or DynDNS). It is
a method o...
HOW TO SETUP QODBC TO RUN WITHOUT QUICKBOOKS
PROBLEM DESCRIPTION
* I want to use QODBC, which does not have the QuickBooks program on
the machine.
* Do I need QuickBooks installed on the machine to use QODBC?
* Can QODBC read directly from QuickBo...
HOW TO REMOVE OPTIMIZER FILE
WHAT IS THE OPTIMIZER FILE?
When you turn on the Optimizer, QODBC will bring some data to a local
cache file (the optimizer file) to increase retrieval performance for
queries.
When you access any table, QODBC will gather...
HOW TO 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...
Check if the table you are importing has any long fields and exclude
them from the import. Some tables in QuickBooks have fields as long as
4095 characters and cannot fit in a single spreadsheet cell.
An excellent example of this is the InvoiceLine tabl...
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
cannot connect to QuickBooks.
I have a Read Only Desktop edition of QODBC, which is included with
QuickBooks Enterprise Edition.
I am getting the error: "Error ...
PROBLEM DESCRIPTION:
I am trying to insert data into the Invoice table, but QODBC is not
allowed me to write data in the Invoice table.
20131202.172908 E 2792 InvoiceStorage::DoAdd Cannot set unassigned RSB
in transaction line item(s). QuickBooks error...
PROBLEM DESCRIPTION
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed.
Error = 80040408, Could not start QuickBooks.
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed.
Error = 80040408, Could not start Reckon Accounts. ...
PROBLEM DESCRIPTION:
I am getting the error ODBC CALL FAILED- ERROR 10004 when trying to
connect QuickBooks through MS Access using QODBC.
SOLUTION:
Please keep QuickBooks running, Log in as Admin to your company file,
Switch to single-user mode and t...
PROBLEM DESCRIPTION:
I am attempting to apply payments to invoices. I have also determined
the TxnID of the Invoice I want to apply a payment to and used it in
the SQL code specified on How to apply a payment to an invoice
[http://support.flexquarters.co...
PROBLEM DESCRIPTION:
How can I add blank InvoiceLine in QuickBooks using QODBC?
SOLUTION:
There are empty Invoice line records in QuickBooks, and QODBC can view
them too, but you may not be able to create an empty InvoiceLine in
QODBC.
You cannot cr...
HOW TO APPLY DISCOUNTS TO EXISTING INVOICES
PROBLEM DESCRIPTION:
We have hundreds of invoices to that we want to apply a 10% discount,
as the customer is going into bankruptcy and is giving us the choice
of accepting a commitment to accept 10% of the i...
PROBLEM DESCRIPTION 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?...
PROBLEM DESCRIPTION:
When trying to connect to QuickBooks using QODBC Test Tool, I am
facing the error :
QB Begin Session Failed. Error Calling OpenQBConnection Returned
Error: 10061 - [10061] Connection refused
SOLUTION:
Please first keep QuickBoo...
TROUBLESHOOTING: QREMOTE REPORTS "CONNECTION TO DATA SOURCE FAILED"
WHEN WORKING WITH 64-BIT ACCESS OR EXCEL
PROBLEM DESCRIPTION:
Set up QRemote to work with 64-bit MS Excel. The Client DSN settings
are correct. But when access to "QRemote Data 64-bit,...
PROBLEM DESCRIPTION 1:
I'm working in PHP and using the QODBC Test Tool. I am trying to
Insert value into the Customer table.
But I am getting the below error:
EXPECTED LEXICAL ELEMENT NOT FOUND:
My insert statement is:
Insert into Customer (...
TROUBLESHOOTING: THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE
OR SERVER EDITION
PROBLEM DESCRIPTION
When I try to run a command in QODBC Test Tool, I get the error
message "This function requires QODBC read-write or server version."
I am try...
HOW TO APPLY DISCOUNTS TO EXISTING INVOICES
PROBLEM DESCRIPTION:
We have hundreds of invoices to that we want to apply a 10% discount,
as the customer is going into bankruptcy and is giving us the choice
of accepting a commitment to accept 10% of the i...
HOW TO BUILD ASSEMBLY REPORT VIA QODBC
PROBLEM DESCRIPTION:
How can I Build an Assembly report via QODBC
SOLUTION:
If you want to replicate the Build Assembly report via QODBC, I
suggest pulling CustomSummary records using QODBC. Below is an
example...
PROBLEM DESCRIPTION:
How to insert InvoiceLine item into an existing Invoice.
I am trying to run an INSERT statement that I have run before on
version 10, but I am now getting the following error.
SQL Statement: INSERT INTO InvoiceLine (TxnID, RefNum...
INSTRUCTION:
When inserting multiple records into a line item table, you can use
column FQSaveToCache.
Set column FQSaveToCache to 1 in all insert queries except the last
line set to 0. But table TimeTracking is not a line item table; there
is no FQSa...
INSTRUCTION:
In QODBC v12, we added a new component named QRemote to solve the
64-bit application support issue. This article is going to show you
how to install QODBC v14 or higher on a 64-bit system. ( Follow the
same installation steps for QODBC v12 &...
PROBLEM DESCRIPTION:
How can I trace the XML sent to/from QuickBooks by QODBC?
SOLUTION:
You can trace XML by the below steps:
1) Turn on Detail Trace from: Start >> All Programs >> QODBC Driver
for use with QuickBooks >> Configure QODBC Data Source...
PROBLEM DESCRIPTION:
How can I use the Case When statement query in QODBC
SOLUTION:
You can use the Case When statement query in QODBC as below:
The Simple CASE Statement is only used in the SELECT Statement to
check whether the value is equal.
B...
PROBLEM DESCRIPTION:
How can I use multiple QuickBooks
SOLUTION:
You can use multiple QuickBooks of the same region and the same
version year on the same machine. But for the best configuration of
QuickBooks, please get in touch with Intuit to take he...
QODBC does support standard SQL queries, but the function is
implemented differently.
Please refer to the below functions & try to execute them in QODBC
TEST TOOL.
FUNCTIONS IN SELECT QUERY:
You can use distinct like:
SELECT DISTINCT CustomerRefFull...
HOW TO USE QODBC WITH MULTIPLE COMPANY FILES
INTRODUCTION:
When multiple QuickBooks company files are located on one machine, how
do we use only one copy of QODBC to access those company files? Please
note that QODBC can only access one company file on ...
HOW TO VIEW DETAILS ON WHAT QODBC IS PERFORMING
PROBLEM DESCRIPTION:
QODBC and my application are not responding. How can I know what QODBC
is performing in the background?
SOLUTION:
You can enable the QODBC status panel via Start >> All Programs >>...
PROBLEM DESCRIPTION:
I have closed the QODBC connection to QuickBooks.
But It still shows running in task manager QBW32.EXE keeps running
even after QODBC closes the connection.
SOLUTIONS:
When the Disconnect command is sent to QODBC, QODBC sends th...
TROUBLESHOOTING: QREMOTESERVER NOT CONNECTING
PROBLEM DESCRIPTION:
I am trying to set up QRemote on our server.
I have set this up on a local machine as a test server fine. But I am
having issues getting this setup on our server.
When I configure a ...
HOW TO USE QODBC WITH OPENOFFICE BASE
FOR MS ACCESS 64-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK
WITH 64-BIT MS EXCEL
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-CONFIGURE-QODBC-TO-WO...
TROUBLESHOOTING: THE QBREPORTADMINGROUP VIEWS ARE NOT UPDATED FOR
CHANGES IN THE CUSTOM FIELD
PROBLEM DESCRIPTION:
The QBReport Admin Group views are not updated for changes in custom
field id's. The user can see QBReportAdminGroup and other tables in...
PROBLEM DESCRIPTION:
I have installed QODBC and QuickBooks. I have set the Company
Preferences / Integrated Applications to Allow Access to FLEXQuarters
QODBC. When I hit the Test Connection to QuickBooks button, I get a
message from QuickBooks saying TH...
HOW TO GET MEMORIZED TRANSACTIONS & MEMORIZED REPORTS IN QODBC
PROBLEM DESCRIPTIONS:
How can I get information about Memorized Transactions & Memorized
Reports using QODBC?
I can see them in QuickBooks, but I don't know how to get them in
QODBC.
SOL...
HOW DO SETUP QODBC TO ACCESS QUICKBOOKS WHEN THERE IS NO ONE LOGGED IN
INSTRUCTION:
QuickBooks is not a windows service, so it cannot run when no one is
logging into the system. This limit brings problems when the user
tries to set up QODBC to access Q...
NOT ABLE TO PULL ALL DATA IN TABLE SALESRECEIPT FROM QUICKBOOKS POS
PROBLEM DESCRIPTION:
When there is huge data in QuickBooks POS, QODBC POS cannot pull all
data in Table SalesReceipt from QuickBooks POS.
SOLUTION:
1. When there are huge data in Qu...
PROBLEM:
I have a customer who does their invoicing with an ASP.NET
application, and it flows into QuickBooks. I created the interface
with QODBC, and it works with no problem except that sometimes the
processes will lock up, and I have to remote into th...
PROBLEM DESCRIPTION:
VB DemoQODBC Test ToolTest Connection was crashing When I tried to
connect to QuickBooks using QODBC.
I have tried to reinstall QODBC & QuickBooks, but the QODBC Test
connection (via VB Demo or QODBC Test Tool) is still crashing. A...
TROUBLESHOOTING: UNABLE TO CONNECT TO THE QUICKBOOKS DATABASE.
PROBLEM DESCRIPTION:
I installed the QODBC driver as a new install. I have configured the
ODBC and made sure that the driver is referenced and checked in the
Integrated Applications window i...
TROUBLESHOOTING: QUICKBOOKS REPORTS "THE CERTIFICATE IS INVALID"
PROBLEM DESCRIPTION:
When first using the application to access QuickBooks via QODBC, a
will pop up a window to ask the user to give the certificate to this
application.
But now facing...
TROUBLESHOOTING: ERROR:3000-THE GIVEN OBJECT ID "IN THE FIELD "LISTID"
IS INVALID
PROBLEM DESCRIPTION:
When making an inventory adjustment in a company file whose multiple
inventory sites feature is not enabled, there are no values in the
field "Invent...
PROBLEM DESCRIPTION:
I called QuickBooks, and they said we could run QuickBooks Canada 2005
alongside QuickBooks USA 2004 on the same computer with no problem.
They said the problems happen when you try to run USA/Canada
QuickBooks on the same computer ...
QODBC SHOWS RUNTIME ERROR R6025 PURE VIRTUAL FUNCTION CALL WHEN USING
MS ACCESS
PROBLEM:
I have created the link to the Customer table in MS Access using
QODBC. I can link the table without any error, But when I try to edit
any field from the linked ta...
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...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 64-BIT USING
QODBC POS/QREMOTE
Start your "SQL Server Management Studio"
Login to your SQL Server.
On the left-hand side panel, you will find the Server, Right Click on
the "SQL Server" and Sele...
QODBC WITH QREMOTE LICENSING INFORMATION
Also Refer: QODBC Licensing Information
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2587/]
There are different types of Licenses required depends on your
requirement in QODBC...
HOW CAN I USE QODBC WITH TWO DIFFERENT VERSIONS OF QUICKBOOKS
INSTALLED?
PROBLEM DESCRIPTION:
I have two different versions of QuickBooks (i.e., QuickBooks
Enterprise 2012 & QuickBooks Enterprise 2014) installed on my machine.
I want to access both ...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC
PROBLEM DESCRIPTION:
Any errors related to the driver and custom software or packaged
software that does not work properly with QODBC.Example, Prepared
Statements in JDBCODBCDriver.
Sample
Connection qbCo...
USING QUICKBOOKS DATA WITH VBA
FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT
MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2472/57/MICROSOFT-ACCESS-2003-AND-QODBC].
PROBLEM DESCR...
The procedure entry point EnumProcessModuleEx could not be located in
the dynamic link library PSAPI.DLL
Source: http://www.sleeter.com/blog/2014/06/quickbooks-2014-r6-bugs/
[Source:http://www.sleeter.com/blog/2014/06/quickbooks-2014-r6-bugs/]
This is...
QODBC IS MISSING TABLES AND FIELDS AFTER UPGRADING TO QUICKBOOKS 2014
R6
The issue is noticed after installing QuickBooks 2014 R6 on Windows XP
and Windows 2003 machines.
PROBLEM:
When you connect VB Demo and list the tables, you will notice only 10...
HOW TO USE QLIKVIEW WITH QODBC
To use QlikView with QODBC, please follow the below steps.
1. Open QlikView & Create the new file.
2. Select Data Source. Click on Browse.
3. Please select the MS Excel file & click "Next."
4. Click "Next.
5. Save...
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 CAN I FIND THE CHECK REGISTER/CHECKBOOK USING QODBC?
PROBLEM DESCRIPTION:
I am trying to pull all the data in the "Check Register" section of
QuickBooks Enterprise 14 into my Excel spreadsheet. (What is the name
of the table or a table that contain...
HOW TO CANCEL FQSAVETOCACHE IN QODBC
PROBLEM DESCRIPTION:
We have some code to insert multiple lines into the invoice table. We
understand how the 'FQSaveToCache' field is used during this process.
And the code is running successfully until we found an...
HOW TO CREATE AN INVENTORY ADJUSTMENT THROUGH MS ACCESS USING QODBC
INSTRUCTIONS
Although QuickBooks automatically adjusts your inventory quantities
after every purchase and sale, sometimes you still need to adjust them
yourself from time to time. Quic...
HOW TO 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: SP_REPORT PROFITANDLOSSBUDGETPERFORMANCE IS
RETURNING NO ROWS.
PROBLEM DESCRIPTION 1:
I am running ProfitAndLossBudgetPerformance through MS Query & It is
returning no rows. But using QuickBooks UI, I can get records from the
ProfitAnd...
TROUBLESHOOTING: QUICKBOOKS CAN'T START BECAUSE IT IS ALREADY RUNNING.
PROBLEM DESCRIPTION 1:
I cannot Connect my trial version of QODBC to QuickBooks. I have gone
through your tutorials but am unable to connect. I have never had the
"Keep QuickBooks ...
PROBLEM DESCRIPTION:
When inserting an invoice via a looping SQL procedure, I have invoice
lines (InvoiceLine table) items that can potentially be assigned to
varying classes. Using the ClassRefListID field, I class the lines
accordingly and do not addre...
HOW TO REMOVE QREMOTE FROM STARTUP
PROBLEM DESCRIPTION:
QRemote Initialization Error.
QRemote Error: Listening failed. Please restart application
QRemote Closing in 15 Seconds.
SOLUTION:
QRemote Server reports "Error: Listening failed. Please re...
TROUBLESHOOTING: QUICK REPORT ON AN ACCOUNT
PROBLEM DESCRIPTION:
How can I get a Quick Report on an account from the Chart of Accounts?
In Quick Books 2006 Premier, I opened a chart of accounts (Ctrl+A),
selected an account, and then pressed Ctrl+Q.
S...
TROUBLESHOOTING: 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...
QODBC Driver for QuickBooks Online
Limited Use Software License
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install
and operate the copy of the computer program contained in this package
("Program") on a single computer (one...
QODBC SHOWS A REGFILE1 LICENSE ERROR WHEN USING MS EXCEL 2013 OR
ACCESS 2013
MS EXCEL 2013 OR ACCESS 2013 SHOWS THIS FUNCTION REQUIRES ACTIVATION
OF QODBC READ WRITE OR SERVER EDITION.
MS EXCEL 2013 OR ACCESS 2013 (OFFICE 365) CRASHES WHEN TRYING TO
CO...
PROBLEM DESCRIPTION:
When I run the program as an administrator, I can change the
optimizer settings, but it never gets saved. Everything I rerun the
Setup Screen, the grounds are back to the original settings, and my
changes aren't saved. Do I have to ...
TROUBLESHOOTING - 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 ...
QODBC ONLINE VERSION 14 IS DISCONTINUED
INSTRUCTIONS
We continue improving the user experience for QODBC for QuickBooks
Online and are now at version 15, so support for QODBC Online version
14 has been discontinued. You will not be able to create new
c...
QODBC ONLINE FOR QUICKBOOKS ONLINE - KNOWN ISSUE(S)/LIMITATION(S)
Table Invoice, InvoiceLine, and InvoiceLinkedTxn may have the initial
performance issue, but after the full load, the subsequent queries
should perform well.
ARAccountRefFullName, ARAcc...
DATA DOCUMENTATION
HOW QODBC INTERFACES WITH QUICKBOOKS
We have provided tools to help you determine where field information
comes from in QuickBooks, which tables contain the information you
want, how tables can be related, and sample SQL statement...
EXTERNAL APPLICATION SETUP
Tutorials on how to set up ODBC access in external applications so
you can see your QuickBooks data.
MICROSOFT ACCESS
How to set up an ODBC connection to QuickBooks data in Microsoft
Access.
* How to Use QODBC with Micro...
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 RUN QREMOTE SERVER AS A SERVICE
PROBLEM DESCRIPTION:
I have noticed that when I run the QRemote server on my server, the
server also shuts down if I log out of my session. Is there a way to
get the QRemote server to run as a se...
TROUBLESHOOTING - HOW TO 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...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE
PROBLEM DESCRIPTION:
When ting sets QODBC POS DSN to access the company file running in
QuickBooks POS (Version 10), it will fail to connect to the company
file. QuickBooks POS will search for th...
TROUBLESHOOTING - QODBC SETUP SCREEN DOES NOT DISPLAY ALL CONTENTS
PROBLEM DESCRIPTION:
I successfully installed QODBC in my Win7 Pro and am ready to purchase
it. However, I found the "Setup" dialog box is too small, and some of
the contents, such as th...
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 DO I CHECK WHICH REGION OF QUICKBOOKS IS
INSTALLED
PROBLEM DESCRIPTION:
How do I check which region of QuickBooks is installed?
SOLUTION:
You can query the Host table using QODBC Test Tool & get detail about
your QuickBooks ver...
TROUBLESHOOTING - HOW TO 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...
QXL Limited Use Software License
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install
and operate the copy of the computer program contained in this package
("Program") on a single computer (one central processing unit)
util...
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: QODBC SHOWS ERRORS 11118,11119,11120,11121,11122
PROBLEM:
I am getting an error "11118 - SYSTEM LICENSE ERROR."
I am getting an error "11119 - REGFILE1 LICENSE OPEN ERROR"
I am getting an error "11120 - REGFILE1 LICENSE ERROR"
I...
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...
HOW TO USE QODBC ONLINE WITH QUICKBOOKS ONLINE EDITION (APPS.COM)
SETUP OF QODBC ONLINE:
The first step is to download and install QODBC Online. QODBC Online
requires .NET Framework 4.6.1 or a later version. So you need to
install .NET Framework 4.6.1 t...
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 MICROSOFT ACCESS 2013 TO BUILD LINKED
TABLE
CREATING A TABLE IN MICROSOFT ACCESS:
NOTE: Microsoft Access has many uses and will allow you to use your
QuickBooks Online data files similarly to Access databases.
Open MS A...
HOW TO USE QODBC ONLINE WITH MICROSOFT EXCEL 2016 / 365 / 2013 32-BIT
SETUP QODBC TO USE WITH MS EXCEL
NOTE: QODBC allows you to quickly merge live QuickBooks Online data
into the cells of your Microsoft Excel worksheets for quick
calculations and graph...
SAMPLE CODE FOR VB.NET WITH QODBC ONLINE
SAMPLE CODE OF VB.NET TO CREATE DATASET
NOTE: The following is the minimal code required to create a DataSet
from the SQL statement and attach the dataset to a DataGrid.
Dim CNBC As System.Data.Odbc.OdbcConnecti...
USING QUICKBOOKS ONLINE DATA WITH VBA
CREATING A FORM IN MICROSOFT ACCESS:
NOTE: Microsoft Access has many uses and will allow you to use your
QuickBooks Online Data files similarly to Access databases.
Open MS Access. You can find it via Windows S...
WE ARE WRITING TO QUICKBOOKS SAFELY.
PROBLEM DESCRIPTION:
I'm a little concerned about the write feature and changing any
current data in QuickBooks from the Excel files I want to experiment
in. Are my concerns valid, or what is the best way for me to p...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 32-BIT USING
QODBC ONLINE/QREMOTE
For 64-bit Refer: How to create Link Server with MS SQL 2005/2008/2012
64-bit Using QODBC Online/QRemote
[http://support.flexquarters.com/esupport/index.php?/Defaul...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 64-BIT USING
QODBC ONLINE/QREMOTE
For 32-bit Refer: How to create Link Server with MS SQL 2005/2008/2012
32-bit Using QODBC Online/QRemote
[http://support.flexquarters.com/esupport/index.php?/Defaul...
HOW TO 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...
INSTRUCTIONS WHEN DESIGNING YOUR REPORTS
1. Use filters in a particular date range whenever possible.
2. When grouping by a table field, use a formula to put the field on
it. This allows Crystal to do the grouping in memory rather than the
driver, whic...
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...
For QODBC / QODBC-POS/ QODBC-Online/QXL-related issues, Click Here
[http://support.flexquarters.com/esupport/index.php?/Tickets/Submit].
To submit a new support ticket, Click Here
[http://support.flexquarters.com/esupport/index.php?/Tickets/Submit].
(...
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...
HOW TO RETRIEVE CHARACTER FIELDS THAT ARE RETURNED AS NULL IN SSIS
USING QODBC
PROBLEM:
Using SQL Server Integration Service (SSIS) and QODBC, All character
fields are being returned as NULL.
SOLUTION:
Please use the function CONVERT to convert the ...
PROBLEM DESCRIPTION:
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...
TROUBLESHOOTING - QUICKBOOKS ONLINE - QODBC REQUIRES API VERSION 1.1
OR 2.0 TO COMMUNICATE WITH QUICKBOOKS.
PROBLEM DESCRIPTION:
I was able to use QODBC Online with my QuickBooks Online (QBO), but
suddenly I am facing a connection issue.
Every time I t...
INSTRUCTIONS
QODBC Online accepts SQL commands through the ODBC Interface, then
converts those calls to qbXML navigational orders within the
QuickBooks Online API and returns recordsets that qualify for the
query results. This driver is not a Client/Ser...
TYPICAL PROFIT AND LOSS STANDARD REPORT IN QUICKBOOKS ONLINE
REPORT DISPLAYED IN QODBC
STORED PROCEDURE COMMAND
With QODBC Online, the same report can be generated using stored
procedure reports like this:
sp_report ProfitAndLossStandard show RowDa...
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 - MICROSOFT EXCEL 2013 (OFFICE 365 / 2016) CRASHES /
REQUIRED ACTIVATION
TROUBLESHOOTING - MICROSOFT ACCESS 2013 (OFFICE 365 / 2016) CRASHES
/ REQUIRED ACTIVATION
PROBLEM DESCRIPTION 1:
I have been having significant difficulties wit...
TROUBLESHOOTING - GETTING TIMEOUT ERROR IN SQL SERVER'S LINKED SERVER
USING QODBC
PROBLEM DESCRIPTION:
I recently upgraded from 1.0.0.7 to 1.0.0.312. Everything was pretty
smooth, except for our Linked Servers timeout now. I test the QODBC
connection,...
TROUBLESHOOTING - 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 - UPDATE QUERY TRUNCATING LEADING SPACES
PROBLEM DESCRIPTION:
I have to update a field with specific data; for some records, one of
the fields will have leading spaces that are required to be there. I
have tried numerous ways to get th...
TROUBLESHOOTING - "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...
WHAT IS JUMPIN TYPE?
PROBLEM DESCRIPTION:
I am looking for the definition and usage of "JUMPIN TYPE."
SOLUTION:
In QODBC JUMPIN provides relationship details with other tables and
information about value coming from another table.
Please refer to...
TROUBLESHOOTING - GETTING UNEXPECTED EXTRA TOKEN ERROR IN DATE FIELD
QUERY
PROBLEM DESCRIPTION:
I am trying to query the Transaction table based on the TxnDate field.
I tried the below code.
OdbcCommand SourceCmd = new OdbcCommand("Select * from Tra...
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 - [QODBC] COLUMN NOT FOUND REORDERBUILDPOINT
PROBLEM DESCRIPTION:
We just upgraded to v16 on both QB and QODBC, and now refreshes from
Excel aren't working. We're getting the message "[QODBC] Column not
found ReorderBuildPoint."
SOLUT...
TROUBLESHOOTING - FAULTING APPLICATION NAME: QREMOTESERVER.EXE
PROBLEM DESCRIPTION:
We recently had a few error messages pop up on the server related to
the QODBC driver on our server. We were wondering if you could provide
any information as to what ...
TROUBLESHOOTING - 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 - QUICKBOOKS UI GETTING LAUNCHED AFTER UPDATING QODBC
VERSION.
PROBLEM DESCRIPTION:
We recently upgraded from QODBC 14 to 16.00.00.313. It is functioning
normally, except now the QuickBooks window is opening up when it
didn't use to. I...
TROUBLESHOOTING - 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...
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 - QXL IS NOT LICENSED FOR THIS QUICKBOOKS EDITION
PROBLEM DESCRIPTION:
I was able to use QXL earlier. Our co recently upgraded to QB Pro 2016
and now unable to connect with QXL as it says QXL is not licensed for
this QuickBooks edition...
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...
QXL OPTIONS AND SETTINGS
QXL OPTIONS AND SETTINGS/CONFIGURATION:
The first step in configuring the application is to click on settings
icon for QXL options details.
GENERAL TAB:
From General Tab you can change:
1. Output Folder: - You can change the ...
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...
TROUBLESHOOTING - QXL 80040417 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. Make sure QuickBooks is running on
this machine and Company...
TROUBLESHOOTING - QXL 8004040A 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. You have QuickBooks open to a
particular company file that ...
TROUBLESHOOTING - QXL 8004041A,80040420,8004041D ERROR
PROBLEM DESCRIPTION 1:
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. Make sure QuickBooks is running on
this...
TROUBLESHOOTING - QXL 80040408 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. Make sure QuickBooks is running on
this machine and is logg...
TROUBLESHOOTING - QXL QUICKBOOKS ERROR: INVALID CERTIFICATE
PROBLEM DESCRIPTION:
I have installed the QXL and QuickBooks I have set the Company
Preferences / Integrated Applications to Allow Access to FLEXQuarters
QODBC. When I click on QXL export butt...
TROUBLESHOOTING - QXL GETTING THIS FEATURE IS NOT ENABLED OR NOT
AVAILABLE IN THIS VERSION OF QUICKBOOKS
PROBLEM DESCRIPTION:
I am trying export data from QXL. After the export is completed. I got
"Export Completed. One or more tables were not exporte...
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 ...
HOW TO CHANGE QXL SAMPLE REPORT DATA SOURCE
There is two way to Change QXL Sample Report Data Source.
1. Automated.
2. Manual
1. AUTOMATED
Open QXL Sample spreadsheet.
Click on Change Data Source button.
Choose QXL Export folder which you want t...
HOW TO CREATE A REPORT IN EXCEL USING QXL SPREADSHEET DATA
PROBLEM DESCRIPTION:
I want to refresh my spreadsheet automatically from QXL exported
spreadsheet. So, my spreadsheet data gets updated automatically using
QXL exported spreadsheet.
How to cre...
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 - 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...
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...
HOW TO GET DATA FROM TWO OR MORE TABLES INTO ONE SPREADSHEET.
In this example, We will show you that How to get data from two or
more tables into a single spreadsheet.
Open QXL, The first step in configuring the application is to click on
settings icon...
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 ...
QODBC QUICK START GUIDE
Download: QODBC 2023 Quick Start Guide
[https://qodbc.com/download/QODBCQuickStartGuide.pdf] (PDF)
QODBC DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2479.HTM]
INTRODUCTION
WHAT IS ODBC?
ODBC (OPEN DATABASE CONNECT...
QODBC POS QUICK START GUIDE
Download: QODBC POS 2019 Quick Start Guide
[http://qodbc.com/download/QODBC%20POS%20Quick%20Start%20Guide.pdf]
(PDF)
QODBC POS DRIVER LICENSE AGREEMENT
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Artic...
QODBC ONLINE QUICK START GUIDE
Download: QODBC Online Quick Start Guide
[http://qodbc.com/download/QODBC%20Online%20Quick%20Start%20Guide.pdf]
(PDF)
QODBC ONLINE DRIVER LICENSE AGREEMENT
[HTTP://WWW.QODBC.COM/LINKS/2599.HTM]
INTRODUCTION
WHAT IS OD...
QODBC LIMITED USE SOFTWARE LICENSE
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install
and operate the copy of the computer program contained in this package
("Program") on a single computer (one central processing unit)...
QXL ONLINE LIMITED USE SOFTWARE LICENSE
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install
and operate the copy of the computer program contained in this package
("Program") on a single computer (one central processing uni...
TROUBLESHOOTING - MS ACCESS DISPLAYS "#DELETED" IN EVERY FIELD
PROBLEM DESCRIPTION:
Using QuickBooks Accountant, QODBC and MS Access Linked table.
Sometimes, e.g. at present working with the InventoryAdjustment table,
a table view or query returns th...
TROUBLESHOOTING - HOW TO ZIP AND UPLOAD THE COMPANY FILE
PROBLEM DESCRIPTION:
How to zip and upload the company file on http://qodbc.com/send
SOLUTION:
Please download [http://www.7-zip.org/download.html] & install 7-zip
if you don't have any zip so...
QXL FOR QUICKBOOKS ONLINE - KNOWN ISSUE(S)/LIMITATION(S)
PROBLEM DESCRIPTION:
I am trying export data from QuickBooks Online using QXL Online. After
the export is completed. I got "Export Completed. One or more tables
were not exported" status in QXL On...
TROUBLESHOOTING - HOW TO ENABLE DETAIL ROWS FOR BALANCESHEETDETAIL,
GENERALLEDGER, JOURNAL, PROFITANDLOSSDETAIL, TXNDETAILBYACCOUNT
REPORTS
PROBLEM DESCRIPTION:
I am executing BalanceSheetDetail, GeneralLedger, Journal,
ProfitAndLossDetail, TxnDetail...
TROUBLESHOOTING - HOW CAN WE SELECT INVOICES FOR PAYMENT FROM
BILLTOPAY TABLE USING QODBC
PROBLEM DESCRIPTION:
In the BillToPay Table - How can we select invoices for payment using
QODBC?
We would like to have the Checkmark Selected for the respecti...
QXL ONLINE OPTIONS AND SETTINGS
QXL ONLINE OPTIONS AND SETTINGS/CONFIGURATION:
The first step in configuring the application is to click on settings
icon for QXL Online options details.
CONNECTIONS TAB:
From Connections Tab you can Add manage connecti...
HOW TO CONNECT AND USE FOXPRO WITH QODBC
Open Visual FoxPro from Start Menu:
FoxPro started:
Open "Command Window" from Windows Menu:
"Command Window" Opened. You can execute FoxPro commands from "Command
Window".
You need to write FoxPro command...
TROUBLESHOOTING - QODBC - USER RIGHTS WITHIN QUICKBOOKS
PROBLEM DESCRIPTION 1:
I would like to be able to access QuickBooks to extract inventory data
in database format. I believe this is possible with QODBC. My issue is
that I do not want this person ...
TROUBLESHOOTING - GETTING ODBC-CALL FAILED ERROR IN MS ACCESS WHEN
OPENING RECEIVEPAYMENTTODEPOSIT TABLE
PROBLEM DESCRIPTION:
I am trying link ReceivePaymentToDeposit table through the linked
table in MS Access. I am able to link ReceivePaymentToDeposi...
MICROSOFT WORD 2016 AND QODBC
CREATING A WORD MAIL MERGE TO LIVE QUICKBOOKS DATA
NOTE: QODBC allows you to easily merge QuickBooks data into your Word
documents either as tables or as mail-merged fields.
Open the Document you wish to mail merge Quick...
HOW TO USE QREMOTE WITH COLDFUSION
INSTRUCTIONS ABOUT USING QREMOTE WITH COLDFUSION
Using ColdFusion on an internal Intranet or the World Wide Web
requires the Server Edition of QODBC. QuickBooks must be running with
the company file opened on the sys...
HOW TO INSERT SALESORDERLINE ITEM TO AN EXISTING SALESORDER
PROBLEM DESCRIPTION:
I routinely create new sales orders with queries similar to this:
INSERT INTO SalesOrderLine ( "CustomerRefListID", "RefNumber",
"SalesOrderLineItemRefListID", "SalesOrd...
TROUBLESHOOTING - HOW TO CREATE PRICELEVELPERITEM &
PRICELEVELFIXEDPERCENTAGE USING QODBC
PROBLEM DESCRIPTION:
How to create PriceLevelPerItem & PriceLevelFixedPercentage using
QODBC.
SOLUTION:
To create a new PriceLevel and PriceLevelPerItem item (...
TROUBLESHOOTING - CREATING PO USING ALPHA FIVE BASIC SCRIPTING NOT
WORKING CORRECTLY
PROBLEM DESCRIPTION:
I am using Alpha 5 version 10.5 xbasic scripting to export our data to
QB Enterprise 2016.
I have successfully exported our customer and invento...
TROUBLESHOOTING - CREDITCARDINFOCREDITCARDNUMBER RETURNS ******1234
PROBLEM DESCRIPTION:
This used to work and I have no idea why it now blinds all reads of
the CreditCardInfoCreditCardNumber field in the Customer table.
I had used QODBC previously t...
NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING
ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER
JAVA-BASED APPLICATIONS.
Refer: Oracle JDBC-ODBC Bridge
[http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bri...
TROUBLESHOOTING - EASIEST WAY TO MAKE REPORT SHOWING AVERAGE TIME
BETWEEN RECEIPT AND INVOICE OF ITEM
PROBLEM DESCRIPTION:
I'd like to make a report to show me which items are selling quickly,
and which are selling slowly. I figure the thing I need to ...
TROUBLESHOOTING - HOW TO INSERT UPDATE PAYROLLITEMNONWAGE LIKE AUTO
ALLOWANCE, BENEFITS, FEDERAL INCOME ETC
PROBLEM DESCRIPTION:
How we can update Insert PayrollItemNonWage field as Auto Allowance,
Benefits, Federal Income etc.
If we add, Item Name -...
TROUBLESHOOTING - WHERE IS RETAINED EARNINGS DATA FOUND?
PROBLEM DESCRIPTION:
I cannot find a table with the retained earnings listed in it.
Furthermore, I find no transactions for this account, yet QB reports 2
closing entries?
In the account table,...
TROUBLESHOOTING - CHECK ISTOBEPRINTED UPDATE QUERY
PROBLEM DESCRIPTION:
I'm having a problem running this SQL statement in QODBC TEST TOOL.
The application returns an error message: [QODBC] Not supported.
UPDATE Check SET IsToBePrinted = 1 WHERE TxnI...
TROUBLESHOOTING - ERROR 3180 - THE CREDIT LIMIT FOR THE NAME ON THIS
TRANSACTION HAS BEEN EXCEEDED
PROBLEM DESCRIPTION:
We use QOBDC Read Write 8.00.00.234 With QuickBooks Enterprise 2007.
When trying to Save a SalesOrder with three SalesOrderLine ret...
TROUBLESHOOTING - DOES QODBC SUPPORT "LIKE 'I%'"?
PROBLEM DESCRIPTION:
How should the following SQL query be written to work with QODBC,
using the "like" filter to restrict records?
SELECT Sales.RefNumber,Sales.BillAddressAddr1,Sales.Type,Sales.TxnDa...
TROUBLESHOOTING - ERROR: 1000 - THERE HAS BEEN AN INTERNAL ERROR WHEN
PROCESSING THE REQUEST
PROBLEM DESCRIPTION:
I get a very strange error... I have a development system and a dummy
QB file (copy of the company file) that runs fine. However when I mo...
QODBC POS SETUP OPTIONS
QODBC POS GENERAL SETUP
The first step in configuring the driver is to click on the QODBC POS
Setup Screen and the following general setup screen will become
available.
CURRENT COMPANY SETTING allows QODBC POS to enter compa...
QREMOTE TUTORIAL: USING QUICKBOOKS POS DATA REMOTELY VIA QODBC POS
QODBC POS has the ability to talk to a copy of QuickBooks POS running
anywhere in the world over the Internet, or over a local area network.
This feature is built-in to the licensed versi...
HOW TO CONFIGURE QODBC POS TO WORK WITH 64-BIT APPLICATIONS
INSTRUCTIONS
64 and 32-bit worlds are kept totally separate in the Microsoft
Windows Operating System. QuickBooks POS is a 32-bit application, so
in order to communicate with it, a 32-bit ODBC...
HOW TO USE QODBC POS WITH MS ACCESS 2016 / 365 / 2013
CREATING A TABLE IN MICROSOFT ACCESS:
NOTE: Microsoft Access is a product with many uses, and will allow you
to use your QuickBooks data files in the same fashion as Access
databases.
Open MS Acces...
HOW TO USE QODBC POS WITH MS EXCEL 2016 / 365 / 2013
SETUP QODBC TO USE WITH MS EXCEL
NOTE: QODBC allows you to quickly merge live QuickBooks data into the
cells of your Microsoft Excel worksheets for quick calculations and
graphs. The data will retain ...
QODBC ONLINE SETUP OPTIONS
QODBC ONLINE GENERAL SETUP
The first step in configuring the driver is to click on the QODBC
Online Setup Screen and the following general setup screen will become
available.
SERVER: Indicates where the QODBC's Connector/...
TROUBLESHOOTING - GETTING ERROR THIS FILE IS IN USE
PROBLEM DESCRIPTION:
We are trying to use your drivers to connect to 3 different
QuickBooks files. But when I browse to the first file to setup the
ODBC data source I get this message:
We are dead ...
TROUBLESHOOTING - GETTING ERROR UNABLE TO BIND TO SPECIFIED IP
ADDRESS
PROBLEM DESCRIPTION:
QODBC stopped working and I get IP errors. All fixes that I can find
on support pages requires that QRemote Server is started. QRemote
Server will not start.
...
TROUBLESHOOTING - QREMOTE SERVER IS NOT RETURNING DATA TO SQL SERVER
PROBLEM DESCRIPTION:
Installed the server connection component, and began the process of
reconnecting
Ran a really simple set of tests:
select * from C01...Terms Select * from ope...
TROUBLESHOOTING - LOGGING OUT THE QUICKBOOKS USER THROUGH QODBC
PROBLEM DESCRIPTION:
We created a user expressly for QODBC access.
How can we facilitate a way for our QuickBooks users to log this user
off when single user mode is needed?
SOLUTION:...
TROUBLESHOOTING - UNABLE TO LOAD ALL CUSTOMER RECORDS DUE TO
CUSTOMERSHIPPINGADDRESS
PROBLEM DESCRIPTION:
I am unable to load all customer records through QODBC.
I have a large number of ship-to addresses of the customers.
I have tried to execute ...
TROUBLESHOOTING - REFUNDING CREDIT CARDS - THERE WAS AN ERROR WHEN
PARSING THE PROVIDED XML FILE.
PROBLEM DESCRIPTION:
Hello I am trying to refund CC payments in QuickBooks. I am able to
create the credit memo, however when attempting to add the refu...
TROUBLESHOOTING - HOW TO ADD DISCOUNT VALUE TO SALESRECEIPTITEM
PROBLEM DESCRIPTION:
I want to add a $50 discount on a sales receipt item.
Been using the "discount" field in my SQL statement. I keep getting an
error that: ERROR [42S00] [QODBCPOS] Er...
TROUBLESHOOTING - VB DEMO IS CRASHING WHEN USING NONEXISTING COLUMN
NAME IN LEFT OUTER JOIN QUERY
PROBLEM DESCRIPTION:
I am executing below query in VB Demo. But VB Demo is crashing at the
time of execution. I have checked the same query in MS Access ...
CONNECTING TO QUICKBOOKS POS FAILED BECAUSE OF A WINDOWS SECURITY
ISSUE, TEST CONNECTION NOT WORKING
PROBLEM DESCRIPTION:
The QODBC Driver for QuickBooks POS runs differently under Microsoft
Vista/W7 than other versions of Windows because of its new st...
CONNECTING TO QUICKBOOKS ONLINE FAILED BECAUSE OF A WINDOWS SECURITY
ISSUE, TEST CONNECTION NOT WORKING
PROBLEM DESCRIPTION:
The QODBC Driver for QuickBooks Online runs differently under
Microsoft Vista/W7 than other versions of Windows because of its ...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOWS 10
INSTALL QODBC POS
Please download the QODBC POS installer by clicking here
[http://www.qodbc.com/posDownload.htm]
Right Click on the Installer and select "Run As Administrator"
Ple...
INSTALLATION STEPS FOR WINDOWS 10
After you have downloaded QODBC Online Installer, navigate to the
"Downloads" Folder or the location where you have saved QODBC Online
Installer. Run the installer as administrator by Right clicking on the
Installer and...
TROUBLESHOOTING - GETTING ERROR [QODBC] REQUIRES AT LEAST ONE CHILD.
CANNOT DELETE LAST LINE
PROBLEM DESCRIPTION:
I entered a series of purchase orders with queries that look like
this:
INSERT INTO PurchaseOrderLine ("VendorRefListID",
"RefNumber","P...
HOW TO USE QODBC WITH TIBCO SPOTFIRE
This article walks you through using the QODBC Driver for QuickBooks
in TIBCO Spotfire. You will use the data import wizard to connect to a
DSN (data source name) for QuickBooks and build on the sample
visualizations ...
HOW TO USE QODBC WITH TALEND ETL
NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING
ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER
JAVA-BASED APPLICATIONS.
Refer: Oracle JDBC-ODBC Bridge
[http://docs.oracle.com/javas...
NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING
ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER
JAVA-BASED APPLICATIONS.
Refer: Oracle JDBC-ODBC Bridge
[http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bri...
HOW TO USE QODBC WITH MICROSTRATEGY
QODBC enable access to a wide variety of important data sources in
business intelligence tools such as Microstrategy. In this article, We
will show how to connect to QuickBooks data, import data with the UI
or with a q...
TROUBLESHOOTING - HOW TO TELL WHAT VERSION OF QODBC I AM USING
PROBLEM DESCRIPTION:
How to tell what version of QODBC I am using?
SOLUTION:
To find out which version of QODBC you are using please follow below
steps:
1. Click START -> ALL PROGRAMS -...
QXL ONLINE IS NO LONGER CONNECTED TO QUICKBOOKS ONLINE. YOUR USER
TOKEN IS NO LONGER VALID.
HOW TO CONNECT/RECONNECT QXL ONLINE
REFER: HOW TO DOWNLOAD AND INSTALL QXL ONLINE
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/KNOWLEDGEBASE/ARTICLE/VI...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN
SQL SERVER.
PROBLEM DESCRIPTION:
I am trying to create Linked Server on SQL Server.
QODBC TEST TOOL connects successfully to QREMOTE on QuickBooks Server.
Setting up the Linked se...
TROUBLESHOOTING - PERFORMANCE ISSUE QODBC TEST TOOL VERSUS MY C# APP.
PROBLEM DESCRIPTION:
I am running the same query on both returns, a big difference. The
QODBC Test Tool app takes around 7 seconds, and my C# app takes 1:20
minutes.
Are there any s...
TROUBLESHOOTING - UPDATE QUERY OPTIMIZATION.
PROBLEM DESCRIPTION:
Can you give me some insights on how to optimize an update query to
the PriceLevelPerItem table?
I am trying to update all of my existing price levels and I'm looping
through each invent...
TROUBLESHOOTING - RUNTIME ERROR (28) WHEN USING WINDOWS XP, BUT NOT
WINDOWS 2000.
PROBLEM DESCRIPTION:
We have four machines using the ODBC driver with QuickBooks and Access
2003 that work perfectly fine. The odd machine is a slightly higher
version of ...
TROUBLESHOOTING - HOW DO I RUN A COLLECTIONS REPORT?
PROBLEM DESCRIPTION:
How do I run a Collections Report?
SOLUTION:
A typical Collections Report in QuickBooks looks like this:
With QODBC the same report can be generated using stored procedure
re...
TROUBLESHOOTING - DOES MONTHLY FEE INCLUDE ALL OF MY COMPANY FILES OR
WILL I BE CHARGED PER COMPANY?
PROBLEM DESCRIPTION:
I'm using the trial for QuickBooks Online I see that the monthly fee
is $14.95. Will this include all of my company files or will I...
TROUBLESHOOTING - CAN I USE DROPBOX/GOOGLE DRIVE WITH QUICKBOOKS &
QODBC?
PROBLEM DESCRIPTION:
Can I use Dropbox/Google Drive with QuickBooks & QODBC?
SOLUTION:
No, You can't use Dropbox/Google Drive with QuickBooks & QODBC because
Dropbox/Google Dri...
HOW TO DOWNLOAD AND INSTALL QXL ONLINE
REFER: HOW TO CONNECT/RECONNECT QXL ONLINE
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/KNOWLEDGEBASE/ARTICLE/VIEW/2879]
STEP 1 - DOWNLOAD QXL ONLINE
If you haven't already downloaded QXL Online, do it now...
TROUBLESHOOTING - GETTING ERROR SPECIFIED DRIVER COULD NOT BE LOADED
DUE TO SYSTEM ERROR 182
PROBLEM DESCRIPTION:
We upgraded to QuickBooks Enterprise 15 and now we cannot get
QReportBuilder to refresh data.
The error is
Error message: Could not creat...
TROUBLESHOOTING - CANNOT LOAD CUSTOMER TABLE RECORDS
PROBLEM DESCRIPTION:
I am trying to query Customer table but it never opens for me in
datasheet view either double-clicking the table or running a query -
no error message is ever returned but the scr...
TROUBLESHOOTING - UNABLE TO CONNECT TO QUICKBOOKS POS 2015 (12.0)
USING OFFICE 365 / 2016
PROBLEM DESCRIPTION:
I have QuickBooks POS 2015 (12.0) & I want to connect to QuickBooks
POS using MS Access/Excel. I am unable to connect to QBPOS with Access
an...
TROUBLESHOOTING - HOW DO I GET COMPANY BUSINESS NUMBER
PROBLEM DESCRIPTION:
In QuickBooks enterprise, the company information form shows me the
company's business#.
In a custom report, the field is displayed as blank.
In VBDEMO, the field shows as bla...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING PHP
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVPHP/QODBC-Invoice-Insert-Sample-php.zip]
for download Sample Code.
Please refer below s...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING
C#.NET
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample.zip]
for download Sample Code.
Please refer below step...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING
C#.NET WEB APPLICATION
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net.zip]
to download Sample Code.
...
HOW TO USE QODBC WITH LAYER2 CLOUD CONNECTOR SOLUTION
This article shows how you can easily integrate the QODBC driver for
QuickBooks into Layer2 Cloud Connector Solution.
1. Open Connection Manager by clicking on "Start Connection Manager".
Connecti...
TROUBLESHOOTING - IS THERE A SALES JOURNAL REPORT BY CLASS
PROBLEM DESCRIPTION:
For months I've been trying to get a Sales journal report. All I seem
to get is either too detailed (by items), or too summary (sum by
customer). I need a list of invoices b...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING PHP
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/OLINVPHP/QODBCOL-Invoice-Insert-Sample.zip]
for downloading Sample Code.
Please refer belo...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING
C#.NET
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/OLINVC/QODBCOL-Invoice-Insert-Sample.zip]
for downloading Sample Code.
Please refer bel...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING
C#.NET WEB APPLICATION
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/OLINVCW/QODBCOL-Invoice-Insert-Sample-Asp.net.zip]
for downloading Sample...
TROUBLESHOOTING - HOW TO FIND ITEM NOT SOLD AFTER A CERTAIN DATE AND
MARK IT AS INACTIVE.
PROBLEM DESCRIPTION:
We would wish to make items that have not sold after a certain date
inactive. Is this possible? If so, any help would be appreciated.
SOLUTI...
TROUBLESHOOTING - QXL ERROR SYNTAX ERROR IN CREATE TABLE STATEMENT
PROBLEM DESCRIPTION:
I am trying export data to my ODBC database using QXL. After that, I
click on QXL export button I got below error after export.
Syntax error in CREATE TABLE stat...
TROUBLESHOOTING - QXL ERROR WHEN ATTEMPTING TO UPDATE THE VALUE
PROBLEM DESCRIPTION:
I am trying export data using QXL. After that, I click on QXL export
button I got below error after export.
Error when attempting to update the value
SOLUTION:
...
TROUBLESHOOTING - QXL ERROR SYSTEM.OUTOFMEMORYEXCEPTION
PROBLEM DESCRIPTION:
I am trying export data from QXL. I have selected Transaction & other
tables from "Table Setting" tab. After that, I click on QXL export
button I got below error message afte...
TROUBLESHOOTING - [FIXED] QODBC EXTREMELY SLOW AFTER LATEST QUICKBOOKS
2017 R5 UPDATE
PROBLEM DESCRIPTION:
We updated to the latest QuickBooks 2017 Patch, officially known as
Release R5P. After running seemingly OK for two days, QODBC is
*extremely* slu...
TROUBLESHOOTING - QXL ERROR OBJECT REFERENCE NOT SET TO AN INSTANCE
OF AN OBJECT
PROBLEM DESCRIPTION:
I am trying export data from QXL. After that, I click on QXL export
button I got below error after export.
Object reference not set to an instance ...
TROUBLESHOOTING - QXL ERROR INVALID TABLE NAME
PROBLEM DESCRIPTION:
I am trying export data from QXL. I have used Custom Query. After
that, I click on QXL export button I got below error after export.
ERROR [42S00] [QODBC] Invalid table name
SOLUT...
TROUBLESHOOTING - QXL ERROR INVALID FIELD DEFINITION
PROBLEM DESCRIPTION:
I am trying export data to my ODBC database using QXL. After that, I
click on QXL export button I got below error after export.
Invalid field definition
SOLUTION:
You may e...
TROUBLESHOOTING - QXL ERROR INSUFFICIENT PERMISSION LEVEL TO PERFORM
THIS ACTION
PROBLEM DESCRIPTION:
I am trying export data using QXL. After that, I click on QXL export
button I got below error after export.
[QODBC] Error: 3260 - Insufficient perm...
TROUBLESHOOTING - QXL ERROR COLUMN NOT FOUND
PROBLEM DESCRIPTION:
I am trying export data from QXL. I have used Custom Query. After
that, I click on QXL export button I got below error after export.
ERROR [42S00] [QODBC] Column not found
SOLUTION:...
TROUBLESHOOTING - QXL 80040409 ERROR
PROBLEM DESCRIPTION:
I am trying export data from QXL. But when I click on QXL export
button I got below error message.
The current version of QuickBooks cannot work with the specified
company data file.
Error ...
TROUBLESHOOTING - QXL ERROR 3120 - OBJECT X SPECIFIED IN THE REQUEST
CANNOT BE FOUND.
PROBLEM DESCRIPTION:
I am trying export data from QXL. I have selected
ItemAssembliesCanBuild & other tables from "Table Setting" tab. After
that, I click on QXL exp...
TROUBLESHOOTING - HOW TO CHANGE CONNECTION STRING STORED IN EXCEL
PROBLEM DESCRIPTION:
I have changed setting in QODBC Setup Screen from Open mode to same as
company file but my Excel still does not takes the changes and needs
company file to be in mul...
TROUBLESHOOTING - ERROR 3120 - OBJECT X SPECIFIED IN THE REQUEST
CANNOT BE FOUND.
PROBLEM DESCRIPTION:
I could link all tables to an MS Access DB from QuickBooks Database.
But I got the following error when I try to open
ItemAssembliesCanBuild table...
HOW TO USE QXL WITH SCHEDULER
PROBLEM DESCRIPTION:
I want to export QuickBooks Data using QXL.
I want to schedule QXL for exporting QuickBooks Data. So it will
automatically export QuickBooks Data on scheduled time.
But I don't know how can I use Q...
TROUBLESHOOTING - HOW TO USE QREMOTESERVER WITH MULTIPLE WINDOWS USER
PROBLEM DESCRIPTION:
I have a server where multiple users are logged in.
I want to run QRemoteServer for each Windows User.
Can I configure QRemoteServer user wise? So QRemote c...
TROUBLESHOOTING - HOW TO TURN ON/OFF ENCRYPTION ON QREMOTE
PROBLEM DESCRIPTION:
I am using QRemote to access QuickBooks Data & I want to add security
when I accessing my QuickBooks Data through QRemote.
How can I use Encryption is QRemote?
SOLUTIO...
HOW TO RUN GENERAL DETAIL (GENERAL LEDGER) REPORT - WITH PARAMETERS
PROBLEM DESCRIPTION:
I am using QXL & I want to run GeneralLedger report through QXL. I can
see the report on the list. But I want to change report parameter.
How can I change report...
HOW TO RUN PROFIT AND LOSS DETAIL REPORT - WITH DIFFERENT PARAMETERS
PROBLEM DESCRIPTION:
I am using QXL & I want to run Profit and Loss detail report through
QXL. I can see the report on the list. But I want to change report
parameter.
How can I cha...
HOW TO EXPORT TO MS ACCESS
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to MS Access.
How can I export QuickBooks Data to MS Access using QXL?
SOLUTION:
You can export QuickBooks Data to MS Access using QXL.
First, You ...
HOW TO EXPORT TO MYSQL
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to MySQL.
How can I export QuickBooks Data to MySQL using QXL?
SOLUTION:
You can export QuickBooks Data to MySQL using QXL.
First, You need MySQL ODBC ...
HOW TO EXPORT TO SQL SERVER - USING SQL DEFAULT DRIVER
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to SQL Server.
How can I export QuickBooks Data to SQL Server using QXL?
SOLUTION:
You can export QuickBooks Data to SQL S...
TROUBLESHOOTING - HOW TO RUN PROFITANDLOSSBUDGETOVERVIEW BY CLASS
REPORT
TYPICAL PROFIT & LOSS BUDGET OVERVIEW BY CLASS REPORT (FOR THE CURRENT
FISCAL YEAR TO DATE) IN QUICKBOOKS
NOTE: The QuickBooks Sample files set the QuickBooks date to December
15...
SAMPLE VB.NET SOURCE CODE FOR INSERTING INVOICELINE INTO EXISTING
INVOICE
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample-VB.zip]
for downloading Sample Code.
Please refer be...
SAMPLE VB.NET WEB APPLICATION FOR INSERTING INVOICELINE INTO EXISTING
INVOICE
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net-VB.zip]
for down...
HOW TO INSTALL QODBC READ ONLY EDITION FOR QUICKBOOKS ENTERPRISE
EDITION
PROBLEM DESCRIPTION:
I am using QuickBooks Enterprise & I want to use QODBC read only
edition for QuickBooks Enterprise.
How can I install QODBC read only edition for QuickBooks...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. 653 - THERE WAS AN ERROR
WHILE COMMUNICATING WITH THE IDS SERVER. THE RESPONSE STREAM WAS NULL
OR EMPTY.
PROBLEM DESCRIPTION:
I am using QODBC Online. I have authorized QODBC Online at QuickBooks
Online.
Wh...
HOW TO EXPORT QUICKBOOKS DATA DAILY FOR CURRENT DATE FILTER USING
QXL.
PROBLEM DESCRIPTION:
I am using QXL & I want to create a report that will pull the
following items.
Selectable Date Range, Invoice Number, Ship to Address 1-5, Ship to
City, Ship...
HOW TO CONFIGURE QXL TO EXPORT TO SQLITE
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to ODBC Database.
How can I export QuickBooks Data to ODBC Database using QXL?
SOLUTION:
You can export QuickBooks Data to ODBC Databas...
QXL PROFESSIONAL EDITION OPTIONS AND SETTINGS - SQL
QXL PROFESSIONAL EDITION OPTIONS AND SETTINGS / CONFIGURATION:
The first step in configuring the application is to click on settings
icon for QXL options details & navigate to Pro Edition tab.
PRO EDI...
HOW TO RUN BALANCE SHEET BY CLASS REPORT - WITH DIFFERENT PARAMETERS
PROBLEM DESCRIPTION:
I am using QXL & I want to run Balance sheet by class report through
QXL. I can see the report on the list. But I want to change report
parameter.
How can I ch...
TROUBLESHOOTING - TOP QUICKBOOKS ONLINE API ERRORS AND HOW TO HANDLE
THEM
HOW TO HANDLE FREQUENTLY RETURNED QUICKBOOKS ONLINE API ERROR MESSAGES
In this article, we'll go through a list of these error responses and
provide some recommendations and bes...
HOW TO EXPORT QUICKBOOKS INVOICES INTO CRYSTAL REPORT FORMAT
PROBLEM DESCRIPTION:
I would like to know if QODBC will convert QuickBooks Pro Desktop
invoices into Crystal Report.
The attached invoice is similar to what we need to export to Crystal
Re...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS ACCESS REPORT FORMAT
PROBLEM DESCRIPTION:
I would like to know if QODBC will convert QuickBooks Pro Desktop
invoices into Microsoft Access.
The attached invoice is similar to what we need to export to Access...
TROUBLESHOOTING - QODBC CUSTOMSUMMARY REPORT NOT RECONCILING WITH
QUICKBOOKS CUSTOMSUMMARY.
PROBLEM DESCRIPTION:
I am running the QODBC report "CustomSummary" and comparing to what
should be the identical report in QuickBooks and I am encountering an
...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS EXCEL REPORT FORMAT
PROBLEM DESCRIPTION:
I would like to know if QODBC will convert QuickBooks Pro Desktop
invoices into MS Excel Report.
The attached invoice is similar to what we need to export to MS Excel...
TROUBLESHOOTING - HOW TO ADD MULTIPLE FILTER ON PARAMETER IN
SP_REPORT
PROBLEM DESCRIPTION:
I am using sp_report through QODBC & I have noticed that using
QuickBooks UI we can add multiple TxnFilterTypes like 'Invoice',
'CreditMemo' and 'SalesReciept' ...
TROUBLESHOOTING - GETTING ERROR [HY004] [MICROSOFT][ODBC DRIVER
MANAGER] SQL DATA TYPE OUT OF RANGE (0) (SQLBINDPARAMETER) WHEN
RUNNING PYTHON SCRIPT
PROBLEM DESCRIPTION:
I am using Python script to access QuickBooks Data. I can select
QuickBooks Data ...
GENERAL QXL SHORTCUT COMMANDS AND PARAMETERS
PARAMETERS AVAILABLE IN THE QXL
Run = The parameter is used for running QXL in the foreground (i.e.
QXL will be visible during execution).
example: QXL.EXE Run
Silent = The parameter is used for runni...
HOW TO USE QXL WITH THE SCHEDULER FOR MULTIPLE COMPANY FILES
PROBLEM DESCRIPTION:
I want to export QuickBooks Data for multiple company files using QXL.
I want to schedule QXL for exporting QuickBooks Data. So it will
automatically export QuickBooks D...
TROUBLESHOOTING - "TRANSACTIONS" TABLE, BUT THEY DON'T APPEAR TO
"BALANCE"
PROBLEM DESCRIPTION:
I am attempting to extract data from a client's hosted QuickBooks
Enterprise system. I need every transaction in the system as we are
transitioning to a dif...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE
PROBLEM DESCRIPTION:
I am using QODBC access QuickBooks Data. I have linked all QuickBooks
tables using QODBC.
I want to use Customer table to be Optimizer OFF and rest of the
tables t...
HOW OPTIMIZER WORKS
PROBLEM DESCRIPTION:
I am using QODBC access QuickBooks Data. I am using Optimizer & I want
to know about How Optimizer Works.
SOLUTION:
The Optimizer brings some data to a local cache to increase retrieval
performance for querie...
TROUBLESHOOTING - GETTING ERROR A FOUR-PART NAME WAS SUPPLIED, BUT
THE PROVIDER DOES NOT EXPOSE THE NECESSARY INTERFACES TO USE A CATALOG
OR SCHEMA.
PROBLEM DESCRIPTION:
I am using QODBC to fetch QuickBooks Data in SQL Server. I have
created Linked S...
TROUBLESHOOTING - [FIXED] MICROSOFT EXCEL/ACCESS 365/2016 - INVALID
CERTIFICATE ERROR/DIGITAL SIGNATURE ERROR/CERTIFICATE ERROR/GETTING
INVALID CERTIFICATE ERROR WHEN TRYING TO CONNECT USING MS ACCESS OR
EXCEL
PROBLEM DESCRIPTION:
I am using QODBC to e...
TROUBLESHOOTING - QODBC DRIVER CRASHES QUICKBOOKS 2017 ON CLOSE
PROBLEM DESCRIPTION:
QODBC crashes QB Desktop 2017 after completing all SQL transactions.
Here are the details.
1. SQL command is sent to the QODBC connector
2. QODBC connector opens u...
TROUBLESHOOTING - UNKNOWN EXCEPTION QODBC CAN'T QUERY-SPECIFIC TABLE;
CRASHES QUICKBOOKS
PROBLEM DESCRIPTION:
QB Desktop Enterprise 2017 Manufacturing & Wholesale R5_88
Successfully installed QODBC using Optimizer. Can query every table
with QODBC TEST...
TROUBLESHOOTING - WHO CREATED AN INVOICE/SALESORDER
PROBLEM DESCRIPTION:
We don't have an operational problem, just a SQL/technical question --
we are currently pulling invoices like this:
SELECT * FROM Invoice WHERE RefNumber ='221206' (works great)...
TROUBLESHOOTING - HOW TO FIND ESTIMATE TO INVOICE CONVERSION TIME
PROBLEM DESCRIPTION:
I am using MS Excel access QuickBooks Data through QODBC. I have
Estimate & some of the Estimates are converted to QuickBooks. I want
to know how many Estimates are ...
TROUBLESHOOTING - MS ACCESS AND QUICKBOOKS FREEZE (NOT RESPONDING)
WHEN ACCESSING THE FIRST TIME
PROBLEM DESCRIPTION:
When pushing data from the access database to QuickBooks, the QODBC
message indicates waiting on QuickBooks and both Access and QuickB...
SAMPLE C#.NET WEB APPLICATION FOR CREATING SALESRECEIPT
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/SalesRcptCW/QODBCPOS-SalesReceipt-Insert-Sample-ASP.zip]
for downloading Sample...
SAMPLE C#.NET CODE FOR CREATING SALESRECEIPT
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/SalesRcptC/QODBCPOS-SalesReceipt-Insert-Sample.zip]
for downloading Sample Code.
Please ...
SAMPLE CODE FOR CREATING TO SALESRECEIPT USING PHP
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/SalesRcptPHP/QODBCPOS-SalesReceipt-Insert-Sample.zip]
for downloading Sample Code. ...
QODBC READ-ONLY TABLE LIST
PROBLEM DESCRIPTION:
I am using QODBC & trying to modify data into QuickBooks. In few
tables, I can't insert/update records.
I am getting "[QODBC] Not supported" error when trying to insert
records.
Also, I have noticed "E...
HOW TO AUTO ADD RELATIONSHIP BETWEEN TWO TABLES IN CRYSTAL REPORT
USING QODBC
PROBLEM DESCRIPTION:
How to Auto Add relationship Between two tables in Crystal Report
using QODBC?
SOLUTION:
Relationship can be extracted using the ODBC function "SQLFore...
TROUBLESHOOTING - DOES SP_REPORT SUPPORTS LIKE QUERY
PROBLEM DESCRIPTION 1:
Does sp_report support "Like" in the parameter?
For example: sp_report CustomTxnDetail show Text, Blank, TxnType,
Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAc...
TROUBLESHOOTING - HOW TO RECEIVE INVENTORY WITHOUT PURCHASE ORDERS
PROBLEM DESCRIPTION:
Is it possible to register an item's arrival without the purchase
order?
If yes, can I insert the rows in the "ItemReceiptItemLine" table using
the reference to B...
TROUBLESHOOTING - GETTING ERROR WHEN TRYING TO CONFIGURE QODBC IN SQL
SERVER
PROBLEM DESCRIPTION:
I'm trying to install the QODBC on our SQL Server, and I followed all
steps in your documentation How to create Link Server with MS SQL
2005/2008/2012 64-...
TROUBLESHOOTING - HOW TO LOCATE EMPLOYEE EMERGENCY CONTACT
INFORMATION USING QODBC
PROBLEM DESCRIPTION:
Is it possible to retrieve an employee's emergency contact
information? If so, from what table?
SOLUTION:
Employee Emergency Contact Information ...
HOW TO BUILD SHORTCUTS TO EXPORT MULTIPLE QUICKBOOKS COMPANY FILES
USING QXL WITH ONE CLICK (VIDEO)
PROBLEM DESCRIPTION:
How to build shortcuts to export multiple QuickBooks company files
using QXL with one click?
SOLUTION:
Please refer below steps &...
TROUBLESHOOTING - QODBC NO LONGER LICENSED FOR THIS RECKON VERSION
PROBLEM DESCRIPTION:
We have been using QODBC without problems with our current QuickBooks
version for months. Suddenly QODBC has stopped working on all our
computers.
I have tried a fe...
TROUBLESHOOTING - HOW CAN I ACCESS ONLINE BANKING ALIASES USING QODBC
PROBLEM DESCRIPTION:
Does anybody know which table the Online Banking Aliases data is
stored in QuickBooks?
To see what I'm talking about, go to the "Additional Info" tab of the
"E...
TROUBLESHOOTING - CAN I USE QODBC WITHOUT HAVING QUICKBOOKS
INSTALLED?
PROBLEM DESCRIPTION:
My clients give me a backup copy of their QuickBooks file. I don't
have QuickBooks installed on my computer but would like to bring the
data into Excel. Can I u...
TROUBLESHOOTING - HOW CAN I ADD LINE TO AN EXISTING CHECK
PROBLEM DESCRIPTION:
Is it possible to add a line to a check that already exists?
Here is an example form the QB Sample file. Below is a check for
$500.00
Now I want to add additional items ...
QUICKBOOKS SDK 4.0 FOR U.S. EDITIONS OF QUICKBOOKS 2005
QUICKBOOKS SDK 4.0 FEATURE LIST
QuickBooks SDK 4.0 includes a number of new features requested by IDN
member developers. Of course, SDK 4.0 also supports all features of
our previous versions of ...
MICROSOFT WINDOWS VISTA, VERSIONS OF QUICKBOOKS PRIOR TO 2007, AND
QODBC
AS OF DATE: 2006-12-16
IMPORTANT NOTE: To see how to install QODBC and connect to QuickBooks
for the first time using Microsoft Vista click here: How do I install
and connect QOD...
QUICKBOOKS SDK 5.0 FOR U.S. EDITIONS OF QUICKBOOKS 2006
AS OF DATE: 2006-07-13
QUICKBOOKS SDK 5.0 FEATURE LIST
QuickBooks SDK 5.0, which is available to IDN members for download
[https://developer.intuit.com/], includes a number of new features
requ...
QUICKBOOKS SDK 6.0 FOR U.S. EDITIONS OF QUICKBOOKS 2007
AS OF DATE: 2006-07-13
QUICKBOOKS SDK 6.0 FEATURE LIST
QuickBooks SDK 6.0, which is scheduled to be released in the fall of
2006, will include a number of new features requested by IDN member
d...
INTUIT ANNOUNCES QUICKBOOKS 2007
NEW FEATURES AND INTEGRATED SERVICES SOLVE SMALL BUSINESSES' MOST
IMPORTANT PROBLEMS
MOUNTAIN VIEW, Calif.--(BUSINESS WIRE)--Intuit Inc. (Nasdaq:INTU)
today announced the availability of QuickBooks(R) 2007. The new lin...
MICROSOFT WINDOWS VISTA UPDATE ALERT
AS OF DATE: 2007-03-29
For QuickBooks users within the USA
With Microsoft's release of Windows Vista, we wanted to ensure that
all our users are informed about using QuickBooks on Windows Vista.
First and foremost,...
QUICKBOOKS SPECIFICATIONS FOR MAXIMUM NUMBER OF RECORDS OR
TRANSACTIONS
AS OF DATE: 2007-07-25
QuickBooks can handle a maximum of 2 billion transactions. The maximum
number of transactions is limited more by your computer's disk space
and memory than ...
HOW TO ACTIVATE QODBC ONLINE
PURCHASE QODBC ONLINE CDKEY
When you first install QODBC Online it automatically activates a
"once-off" FREE 30 Day Evaluation... beyond which QODBC Online will
stop working and you will need to purchase a CDKEY. Once you ...
TROUBLESHOOTING - QREMOTE FOR QUICKBOOKS NOT LISTED AS CHOICE IN ODBC
SETUP SCREEN
PROBLEM DESCRIPTION:
I am trying to set up the QODBC Driver on a machine running Windows
Server 2016. Previously, I have had it set up and working fine on my
local Windo...
TROUBLESHOOTING - ERROR = 80040437, THE USER YOU ARE TRYING TO LOG IN
WITH IS ALREADY LOGGED IN FROM ANOTHER MACHINE.
PROBLEM DESCRIPTION:
Our company uses QuickBooks 2018 contractor edition which allows only
one user at the same time.
Yesterday, I h...
TROUBLESHOOTING - HOW TO USE ANY OTHER QUICKBOOKS USER OTHER THAN
ADMIN.
PROBLEM DESCRIPTION:
We have installed the QODBC and can read the tables in QODBC Test
Tool. However, after doing the initial read as an admin to QuickBooks,
we are unable to then...
TROUBLESHOOTING - ERROR 3180 - THERE WAS AN ERROR WHEN SAVING A DATA
EXTENSION NAMED "".QUICKBOOKS ERROR MESSAGE : ATTRIBUTE WITH SPECIFIED
NAME ALREADY EXISTS.
PROBLEM DESCRIPTION:
I am using QODBC for creating Invoice in QuickBooks. I am using
Custom...
TROUBLESHOOTING - WHERE ITEM SERIAL NUMBERS OR LOT NUMBERS ARE STORED
PROBLEM DESCRIPTION:
I'm having trouble finding where an Item's serial numbers are stored
in the QuickBooks database. I have gone through your table schema
online here http://doc.qod...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE WITH
QREMOTE
PROBLEM DESCRIPTION:
I am using QODBC access QuickBooks Data. I have linked all QuickBooks
tables using QRemote DSN.
I want to use Customer table to be Optimizer OFF and r...
HOW TO USE DBASE PLUS WITH QODBC
PROBLEM DESCRIPTION:
How to use dBase Plus with QODBC?
SOLUTION:
Please follow below steps for using dBase Plus with QODBC.
Please start dBase Plus & create a new form by clicking "New Form".
Select "Designer" opt...
HOW TO USE BARTENDER WITH QODBC
PROBLEM DESCRIPTION:
How to use BarTender with QODBC?
SOLUTION:
Please follow below steps for using BarTender with QODBC.
Please start BarTender & create a new document by clicking "Start a
new BarTender document..."...
TROUBLESHOOTING - UNABLE TO CONNECT TO QUICKBOOKS ONLINE USING QODBC
ONLINE - UPDATE QODBC ONLINE TO V18.0.0.325 OR ABOVE
Intuit requires an upgrade to TLS 1.2 in order to align with industry
best practices for security and data integrity.
On July 31, ...
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...
TROUBLESHOOTING - HOW TO CONNECT TO QUICKBOOKS USING PDO
PROBLEM DESCRIPTION:
We have a setup connecting a PHP application to QuickBooks with QODBC.
This works correctly using odbc_connect.
However, if we try to connect using PDO instead we get 500 ...
HOW TO USE QLIKSENSE DESKTOP WITH QODBC
To use QlikSense Desktop with QODBC, Please follow the below steps.
Open QlikSense Desktop & click on "CREATE A NEW APP" button.
Enter app name and click "Create" button.
A New application in QlikSense Deskto...
HOW TO AUTO ADD RELATIONSHIP BETWEEN TWO TABLES IN QLIKSENSE DESKTOP
USING QODBC
PROBLEM DESCRIPTION:
How to Auto Add relationship Between two tables in QlikSense Desktop
using QODBC?
SOLUTION:
Please create a new application in QlikSense Desktop & c...
TROUBLESHOOTING - HOW CAN I COMBINE TWO REPORTS AND GET THE REPORT OF
TRANSACTIONS OF A CUSTOMER.
PROBLEM DESCRIPTION:
I need a report by particular customer showing the beginning balance,
payments made by the customer, invoices with details showing th...
TROUBLESHOOTING - HOW CAN I EXTRACT BUDGET DATA
PROBLEM DESCRIPTION:
I'm trying to extract QuickBooks budget data to SQL for reporting
purposes. However, I don't see any tables that would hold budget. My
research is telling me this may not be possible....
TROUBLESHOOTING - HOW TO ADD QREMOTE TO STARTUP
PROBLEM DESCRIPTION 1:
How to add QRemote to ALL users Startup?
SOLUTION 1:
You need to reinstall QODBC for adding QRemoteServer to ALL user
Startup.
Please reinstall QODBC. After installation of QOD...
TROUBLESHOOTING - DATA SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER
SPECIFIED
PROBLEM DESCRIPTION:
I have QODBC running on a terminal server.
I can use 64-bit Excel to query QODBC via the "from other sources". I
have set up a 64-bit remote DSN which t...
TROUBLESHOOTING - HOW WOULD I PRODUCE A TRANSACTION LIST THAT
INCLUDES THE CLASS FIELD.
PROBLEM DESCRIPTION:
I am working on the transactions table but do not see a "class" field.
How would I produce a transaction list that includes the class field?
...
TROUBLESHOOTING - SERIAL NUMBER/LOT NUMBER QUANTITY ON HAND DOES NOT
MATCH WITH THE REPORT IN QUICKBOOKS.
PROBLEM DESCRIPTION:
I recently ran into an issue when querying the inventory on hand for
each lot number. In QuickBooks, there is a report called...
TROUBLESHOOTING - HOW TO USE PROMPTED DATE RANGES IN MS EXCEL WITH
SP_REPORTS
PROBLEM DESCRIPTION:
I am using QODBC for exporting QuickBooks reports in MS Excel. I am
using the BalanceSheetStandard report for specific date ranges as
below.
sp_report ...
TROUBLESHOOTING - EXCEL ONLY RETURNING AMOUNT_1 AND NOT AMOUNT_1
THROUGH AMOUNT_12.
PROBLEM DESCRIPTION:
I am working in Excel, I have set up 3 pass-through queries and had
them working to reference cells in for DateFrom and DateTo parameter.
The queri...
HOW TO CREATE OR CONFIGURE A QREMOTE DSN
LAUNCH QODBC DATA SOURCE CONFIGURATION
Locate the QODBC DRIVER FOR QUICKBOOKS program group from Startup
Program: Start >> All Programs >> QODBC Driver for use with QuickBooks
>> Configure QODBC Data Source
CR...
HOW TO MANUALLY START QREMOTESERVER
By default, QRemoteServer will start as soon as a user logs on to the
system.
You can manually start QRemoteServer by following below steps:
You can start QRemoteServer from: Start >> All Programs >> QODBC
Driver f...
TROUBLESHOOTING - GETTING ERROR THE RECEIPT IS NOT BALANCED.
UNDEFINED AMOUNT IS
PROBLEM DESCRIPTION:
I am trying to create sales receipt. I have a sales item that is 550,
the customer paid 3 dollars so that leaves 547 on their account.
"SalesReceipt...
HOW TO CREATE SP_REPORTS USING MICROSOFT EXCEL
HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL
OPEN MICROSOFT QUERY IN EXCEL
Open Microsoft Excel, get external data from Microsoft Query via Data
Menu -> "Get Data -> From Other Sources->From Microsoft...
HOW TO USE M-FILES WITH QODBC
PROBLEM DESCRIPTION:
How to use M-Files with QODBC?
SOLUTION:
Please follow below steps for using M-Files with QODBC.
1. Open M-Files Admin.
2. In the left-side tree view, expand the desired connection to
M-Files Ser...
TROUBLESHOOTING - HOW TO APPLY PAYMENT TO MULTIPLE INVOICE
PROBLEM DESCRIPTION:
How can a payment be applied to multiple invoices?
Scenario 1
- 3 Invoices are created.
- A payment is received that covers 2 of the invoices, but not
necessarily in ...
TROUBLESHOOTING - QODBC HUNG UP, OR EVERYTHING LOOKS LOCKED UP, OR
APPLICATION IS NOT RESPONDING WHEN FETCHING QUICKBOOKS DATA
PROBLEM DESCRIPTION:
I can access the database, but when I added another table & fetch
table data, it generally hung up. Not ...
TROUBLESHOOTING - HOW TO CONVERT MS OFFICE FROM 64-BIT TO 32-BIT
PROBLEM DESCRIPTION:
I am on Windows 64-bit and Office 365 64-bit. QODBC Test Tool works
fine when I use QuickBooks Data as a connection source.
If I use QRemote, I get the "Evaluation ...
TROUBLESHOOTING - GETTING ERROR THERE WAS AN ERROR WHILE
COMMUNICATING WITH THE IDS SERVER.
PROBLEM DESCRIPTION:
I am on Windows Server 2008 SP2 32-bit and try to connect QuickBooks
Online using QODBC Online.
I am using QODBC Online Version 18.0.0.32...
HOW TO USE QLIKSENSE DESKTOP (WEB-BASED) WITH QODBC
To use QlikSense Desktop with QODBC, Please follow the below steps.
Open QlikSense Desktop in the browser & click on "CREATE A NEW APP"
button.
Enter app name and click "Create" button.
A New appl...
TROUBLESHOOTING - VEHICLEMILEAGE TABLE SHOWING DELETED RECORDS
PROBLEM DESCRIPTION:
I am using QODBC for working with QuickBooks. I am able to delete the
VehicleMileage record. But After that when I query VehicleMileage
table it still showing deleted r...
HOW TO RUN PROFITANDLOSSBYCLASS REPORT - WITH DIFFERENT PARAMETERS
PROBLEM DESCRIPTION:
I am using QXL & I want to run Profit and Loss by Class report through
QXL. I can see the report in the list. But I want to change report
parameter.
How can I ch...
HOW TO RUN PROFITANDLOSSBYCLASS REPORT USING QXL ONLINE
PROBLEM DESCRIPTION:
I am using QXL Online & I want to run Profit and Loss by Class report
through QXL Online. I can't see the report on the list.
How can I run the Profit and Loss by Class rep...
HOW TO USE QODBC WITH TABLEAU DESKTOP
For using QODBC with Tableau Desktop, You need to use QODBC V
18.0.0.326 or later version.
In case you are using an older version of QODBC, please upgrade your
QODBC to the latest version. Click here
[http://qodbc....
HOW TO EXPORT TO DB2
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to DB2.
How can I export QuickBooks Data to DB2 using QXL?
SOLUTION:
You can export QuickBooks Data to DB2 using QXL.
First, You need to create ODBC DSN...
HOW TO EXPORT TO MARIADB
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to MariaDB.
How can I export QuickBooks Data to MariaDB using QXL?
SOLUTION:
You can export QuickBooks Data to MariaDB using QXL.
First, You need to...
HOW TO EXPORT TO ORACLE
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to Oracle.
How can I export QuickBooks Data to Oracle using QXL?
SOLUTION:
You can export QuickBooks Data to Oracle using QXL.
First, You need to cre...
HOW TO EXPORT TO POSTGRESQL
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to PostgreSQL.
How can I export QuickBooks Data to PostgreSQL using QXL?
SOLUTION:
You can export QuickBooks Data to PostgreSQL using QXL.
First,...
HOW TO EXPORT TO SYBASE
PROBLEM DESCRIPTION:
I am using QXL & I want to export QuickBooks Data to Sybase.
How can I export QuickBooks Data to Sybase using QXL?
SOLUTION:
You can export QuickBooks Data to Sybase using QXL.
First, You need to cre...
TROUBLESHOOTING - CANNOT MODIFY THE DESIGN OF THE TABLE - IT IS IN A
READ-ONLY DATABASE. SOURCE:ODBCJT32.DLL
PROBLEM DESCRIPTION:
I keep getting an error message that states
Error Occurred: unable to create table in destination
database-customer-access...
[QXL-DESKTOP] HOW TO RUN A BALANCE SHEET STANDARD REPORT - WITH
MULTIPLE LEVELS
PROBLEM DESCRIPTION:
I am using QXL & I want to run the Balance sheet standard report
through QXL. I can see the report on the list. But I want to change
report parameter. ...
[QXL-ALL] HOW TO ENABLE ENCRYPTED CONNECTION TO THE DATABASE
SQL Server
* Enable Encrypted Connections to the Database Engine
[https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?...
WHAT ARE THE BEST PRACTICES REGARDING DATA SECURITY ON THE INTERNET
WHEN USING QREMOTE?
QRemote can transfer data in an un-encrypted fashion (plain text), or
you can set up your own encryption key to encrypt the data which is
preferable for transfer over...
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...
Hello,
If you downloaded The QODBC Desktop product between the dates of
October 7th and 9th, this urgent message may apply to you.
During the dates above a possible trojan infected version of the
software was uploaded to our hosting company and you ma...
TROUBLESHOOTING: UNABLE TO CONNECT TO QUICKBOOKS USING QODBC. QODBC
FREEZE, QODBC HANGS, QODBC STUCK DURING CONNECTION.
PROBLEM DESCRIPTION 1:
I have the latest driver version and no errors during installation.
When I try to connect, it just stuck "con...
TROUBLESHOOTING - AN INCOMPLETE RECORD NOT FOUND FOR CDKEY / UNABLE
TO ACTIVATE CDKEY / REASON: UNABLE TO LOCATE THE SOFTWARE ID:
PROBLEM DESCRIPTION:
I am on Windows 64-bit and I am unable to activate QODBC.
SOLUTION:
Proxy or Firewall:
Please ch...
TROUBLESHOOTING - HOW DO I UPDATE AN EXPIRED CREDIT CARD INFORMATION
ON YOUR SYSTEM?
PROBLEM DESCRIPTION:
I am using QODBC Online & QXL Online, and I am using my credit card
for payment.
How do I update an expired credit card details on your system? ...
HOW TO CREATE A TRANSFER INVENTORY RECORD USING QODBC
NOTE: The following example uses the QuickBooks USA Sample Rock Castle
Construction company file.
TO CREATE A NEW TRANSFER INVENTORY RECORD
Please refer to the below-listed samples.
INSERT INTO ...
TROUBLESHOOTING - HOW TO CANCEL THE SUBSCRIPTION OF QXL ONLINE FOR
QUICKBOOKS ONLINE
PROBLEM DESCRIPTION:
I want to cancel my QXL Online monthly subscription.
How to cancel the subscription to QXL Online for QuickBooks Online?
SOLUTION:
Latest Me...
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 TO LINK INVOICE TO DEPOSIT USING QODBC?
PROBLEM DESCRIPTION 1:
I want to apply the Payment to a particular Invoice using Deposits.
How can I do so using the QODBC?
SOLUTIONS:
Refer to the screenshot of the QuickBooks UI Invoice...
QODBC ONLINE - UPGRADE QODBC ONLINE TO THE LATEST VERSION BEFORE
DECEMBER 17TH, 2019
WHY IS THE QODBC ONLINE UPGRADE REQUIRED?
QODBC Online version 19.0.0.333 and lower versions use an old security
system that is being discontinued in QuickBooks Online ...
[QODBC 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...
HOW TO DEACTIVATE QODBC ONLINE
DEACTIVATE QODBC ONLINE FROM YOUR COMPUTER
You can Deactivate QODBC Online license from:
Start >> All Programs >> QODBC Driver for QuickBooks Online>>
Configure QODBC Data Source
Go To "System DSN" Tab>> Select "Qui...
HOW TO EXPORT QUICKBOOKS DATA TO OPENOFFICE USING QXL
PROBLEM DESCRIPTION:
How to export QuickBooks Data to OpenOffice using QXL
SOLUTIONS:
Download and install OpenOffice on your system.
Start QXL Desktop
Export the QuickBooks Company Data
O...
USING MICROSOFT POWERBI WITH QUICKBOOKS DATA
PROBLEM DESCRIPTION 1:
How to connect to QuickBooks Data with Power BI using QODBC Desktop?
SOLUTIONS:
Open the QODBC setup screen and change the QODBC Compatibility mode
from "Default" to "3.8."
To cha...
SOLVED: [QODBC ONLINE] COLUMN NOT FOUND - ARAGINGSUMMARY AND
APAGINGSUMMARY
PROBLEM DESCRIPTION:
Unable to use ARAgingSummary and APAgingSummary
Error - Column not found: Amount_Title, Column not found: Amount_1,
Column not found: Amount
SOLUTIONS:
...
PROBLEM DESCRIPTION:
How to use Intuit's SDK Test Plus 3 Tool.
SOLUTION:
Download:
SDKTest Plus 3:
Direct download link - SDKTestPlus3.exe
[http://support.flexquarters.com//support.flexquarters.com/esupport/supportfiles/HowToUseSDKTestPlus3/SDKTe...
HOW TO MANUALLY SYNCHRONIZE (MANUAL SYNC) QODBC ONLINE LICENSE
Manual License synchronizes (Manual License Sync) can be used for
computers that do not have direct Internet access or where the
automated license sync fails.
Click on START -> ALL PROGRAM...
HOW TO MANUALLY SYNCHRONIZE (MANUAL SYNC) QODBC DESKTOP LICENSE
Manual License synchronizes (Manual License Sync) can be used for
computers that do not have direct Internet access or where the
automated activation fails.
Click on START -> ALL PROGRAMS...
HOW TO MANUALLY SYNCHRONIZE (MANUAL SYNC) QODBC POS LICENSE
Manual License synchronizes (Manual License Sync) can be used for
computers that do not have direct Internet access or where the
automated activation fails.
Click on START -> ALL PROGRAMS -> ...
[SOLVED] [QODBC-ALL] - TROUBLESHOOTING - QODBC SERVER EDITION
LICENSE REQUIRED - WHEN USING QODBC 2021 LICENSE
PROBLEM DESCRIPTION
I have purchased the QODBC Server edition license 2021.
I have activated the QODBC 2021 Server edition license on the m...
TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - EXCEL CRASH WHEN
USING SQL STATEMENT WITH TWO INNER JOINS ALONG WITH UNOPTIMIZED
PROBLEM DESCRIPTION
I am using Microsoft Excel.
I am using the following SQL statement.
SELECT TransferInventoryLine....
HOW TO USE QODBC SUPPORT WIZARD - REMOTE CONNECTIVITY
PROBLEM DESCRIPTION:
How to use QODBC Support Wizard - Remote Connectivity?
SOLUTION:
Please follow the below-listed steps for using QODBC Support Wizard.
"QODBC Support Wizard" application is i...
[QScheduler] QScheduler Limited Use Software License & QScheduler
Limited Warranties and Limitation Of Liability
HOW TO CHANGE AUTO LOGIN USER - ALTER QODBC RELATED CERTIFICATES FROM
INTEGRATED APPLICATION UNDER QUICKBOOKS.
Please follow the steps to change auto login user associated with
QODBC Certificates in Integrated Application Under QuickBooks:
Switch Quick...
SOLVED: [QODBC-DESKTOP] TROUBLESHOOTING - QUICKBOOKS 2022 - COULD NOT
START QUICKBOOKS - WINDOWS SERVER 2012 R2 & WINDOWS SERVER 8
ISSUE:
We upgraded our QuickBooks Enterprise from 2020 to 2022. We were using
QuickBooks 2020 and the QODBC driver versio...
TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - THE DRIVER DID NOT
SUPPLY AN ERROR - PYTHON
PROBLEM DESCRIPTION
I tried to connect to QODBC using python and it is giving me the
following error.
The python code I am using is this.
import pyodbc
...
THE INPUT STRING WAS NOT IN A CORRECT FORMAT
PROBLEM DESCRIPTION :
I am running QXL and MS Office 365.
I have tried exporting to XLSX, XLS, and even CSV format, but only the
file header row writes.
Also, I am getting the below error in QXL logs:
...
USING MS ACCESS APP 64-BIT AND 32-BIT (DIFFERENT MACHINES) WITH QODBC
PROBLEM DESCRIPTION:
My MS Access application links to QuickBooks tables via the QODBC ODBC
driver. The 64-bit QODBC calls the ODBC connection 'Quickbooks Data
64-Bit QRemote'. So my ...
DIFFERENCES IN DATA AVAILABLE BETWEEN QXL ONLINE AND QUICKBOOKS
ONLINE'S EXPORT FEATURE
You can export data using the QuickBooks Online export feature for
each of the tables/reports.
There are two ways to export data from QuickBooks Online.
1) Export...
SOLVED: [QODBC-DESKTOP] TROUBLESHOOTING - UNABLE TO CHANGE THE DEFAULT
CONFIGURATION OF NEWLY CREATED QODBC DSN - BUILD 348
ISSUE:
We created a new QODBC 32-Bit DSN with the name "QODBC-MyCompany.
The DSN was created successfully.
We tried to chang...
[QODBC-ALL] TROUBLESHOOTING - UNABLE TO EXECUTE UPDATE STATEMENT WHEN
USING SQL SERVER 2019 LINKED SERVER ON WINDOWS 11 OR WINDOWS SERVER
2019
ISSUE:
We recently upgraded our Windows OS to Windows 11 and SQL Server to
2019.
We can connect from SQL Se...
HOW TO USE THE COMPUTER NAME INSTEAD OF IP ADDRESS IN QREMOTE?
PROBLEM DESCRIPTION 1:
When running a QRemote Server or a query, the IP address changes
randomly.
SOLUTIONS:
If you are using a 32-Bit QODBC manager, Please follow the below
steps:
Ope...
HOW TO INTUIT OR QUICKBOOKS DEVELOPERS AND REPORT FIELDS NOT AVAILABLE
IN QUICKBOOKS SDK OR QUICKBOOKS ONLINE API
ISSUE:
We noticed a field or feature is not available in QuickBooks SDK or
QuickBooks API. How can I contact Intuit and request to add the...
[QODBC-ALL] TROUBLESHOOTING - WINDOWS CANNOT FIND FQQBSAV.EXE
PROBLEM DESCRIPTION
Issue 1:
I just updated QODBC to the latest build, 349. When trying to connect
to the QRemote DSN, I get the following error message.
Windows cannot find 'fqqbvsav.ex...
[QODBC ALL] - HOW TO INCREASE THE UPDATE OR DELETE SQL STATEMENT
PERFORMANCE.
PROBLEM DESCRIPTION:
Ran this SQL to move an invoice from one Customer to another:
Update invoice set CustomerRefListID = '1500' where TxnNumber = 8453
It took about 15+ min...
[QODBC-DESKTOP] - DO I REALLY NEED TO PURCHASE QUICKBOOKS TO DEVELOP A
ONE OFF APPLICATION FOR A CLIENT?
PROBLEM DESCRIPTION:
I need to develop a one-off application for a client.
I have their QuickBooks Desktop company file. Can I develop on that
dat...
[QODBC-ALL] TROUBLESHOOTING - TRAPPABLE ERROR (E06D7363) OCCURRED IN
AN EXTERNAL OBJECT
PROBLEM DESCRIPTION
A trappable error (E06D7363) occurred in an external object. The
script cannot continue running.
I receive this error when reading and writin...
[QODBC-ALL] TROUBLESHOOTING - LOAD UPDATED DATA DID NOT COMPLETE (3)
PROBLEM DESCRIPTION
When I try to run the optimizer from the QODBC configuration screen, I
get the following error when I click "Load Updated Data":
Load Updated Data did not comp...
[QODBC-DESKTOP] - HOW TO RENAME SOME OF MY BULK ITEMS (I.E., INVENTORY
ITEMS) AND THEIR RELATED CHILD ITEMS (I.E., ASSEMBLIES)
PROBLEM DESCRIPTION:
I would like to rename some of my bulk items (i.e., inventory items)
and their related child items (i.e.,...
[QODBC-ONLINE] TROUBLESHOOTING - PARTIAL DATA/INCOMPLETE DATA IN
GENERALLEDGER REPORT - UNABLE TO FETCH ALL ROWS
PROBLEM DESCRIPTION:
I am fetching one year of data from the QuickBooks Online General
Ledger report using QODBC Online.
I get partial dat...
[QODBC-DESKTOP] HOW TO USE QODBC WITH ALTERYX DESIGNER
PROBLEM DESCRIPTION:
I want to export the QuickBooks data using Alteryx Designer Studio?
How can I use Alteryx Designer with the QODBC?
SOLUTION:
Alteryx Designer Studio is a 64-Bit applicatio...
|
|
Help Desk Software by Kayako