|
(108)Tutorials
|
(6)Installation
|
(46)Setup
|
|
(55)Connection
|
(59)Data & Table
|
|
|
|
|
(9)Version
|
|
|
||
|
(16)Others
|
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 includ...
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...
QODBC QUICK START GUIDE
Download: QODBC 2018 Quick Start Guide
[http://qodbc.com/download/QODBCQuickStartGuide.pdf] (PDF)
QODBC DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2479.HTM]
INTRODUCTION
WHAT IS ODBC?
ODBC (OPEN DATABASE CONNECTI...
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...
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...
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...
HOW TO USE QREMOTE WITH COLDFUSION
INSTRUCTIONS ABOUT USING QREMOTE WITH COLDFUSION
Using ColdFusion, whether it's an internal Intranet or on the World
Wide Web, requires the Server Edition of QODBC. QuickBooks must be
running with the company file op...
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 the problem running this SQL statement in VB Demo. The
application returns an error message: [QODBC] Not supported.
UPDATE Check SET IsToBePrinted = 1 WHERE TxnID = 'B...
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...
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 address of Customers.
I have tried to execute the qu...
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 - 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 ...
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 -...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN
SQL SERVER.
PROBLEM DESCRIPTION:
I am trying to create Linked Server on SQL Server.
VB DEMO connects successfully to QREMOTE on QuickBooks Server.
Setting up the Linked server - I...
TROUBLESHOOTING - PERFORMANCE ISSUE VB DEMO VERSUS MY C# APP.
PROBLEM DESCRIPTION:
I am running the same query on both returns a big difference. The VB
Demo app takes around 7 seconds and my C# app takes 1:20 minutes.
Are there any settings which I ne...
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 - CAN I USE DROPBOX/GOOGLE DRIVE WITH QUICKBOOKS &
QODBC?
PROBLEM DESCRIPTION:
Can I use Dropbox/Google Drive with QuickBooks & QODBC?
SOLUTION:
No, You can't use Dropbox/Google Drive with QuickBooks & QODBC because
Dropbox/Google Dri...
TROUBLESHOOTING - 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 - 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...
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 - [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 - 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...
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...
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...
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 ...
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 VB Demo 32...
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...
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 ...
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 ...
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 VB Demo.
However, after doing the initial read as an admin to QuickBooks, we
are unable to then read th...
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 - 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 BalanceSheetStandard report for specific date ranges as below.
sp_report Bala...
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...
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 sure...
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. VB Demo works fine when
I use QuickBooks Data as connection source.
If I use QRemote I get the "Evaluation Expired. QR...
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 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....
Help Desk Software by Kayako