RSS Feed
Knowledgebase
 

PROBLEM Created a VBS refering - http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/506/57/examples-of-how-to-use-qodbc-via-visual-basic [1] On Executing VBS an Error message came up - "[Microsoft][ODBC Driver ...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2007 CREATING A TABLE IN MICROSOFT ACCESS Open MS Access 2007, create a blank database. Click on "Create" button. Then you get a Microsoft Office Access blank database. The newly created database shall have one...
HOW TO USE QODBC WITH MS 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 retain a l...
TROUBLESHOOTING: CANNOT FIND QODBC DRIVER/QUICKBOOKS DATA UNDER SYSTEM DSN WITH ANY APPLICATION OTHER THAN THE VB DEMO PROBLEM DESCRIPTION Testing under the 64-bit system, when using VB Demo test application, the user can see DSN (QuickBooks Data) in th...
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 report. SOLUTIONS This could be issue with the company file, or Optimizer. I kindly request you to follow below steps and let us know if that resolve the...
TROUBLESHOOTING: GETTING LIMITED NUMBER OF RECORDS OR FEW OF THE RECORDS IS MISSING IN QODBC TABLE RESULT PROBLEM DESCRIPTION 1. When I Query my tables e.g Bill or Customer, I noticed QODBC is not returning all the records and seems few records are mi...
HOW TO ADD A NEW LINE ITEM TO AN EXISTING PURCHASE ORDER DESCRIPTION:We have already known how to create new PurchaseOderLine, Refer How to create a Purchase Order using QODBC [1] for more details. After creating a new line item, we found that the sys...
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 optimizer is on, QODBC will automatically create an opt file to store the optimized data. When you reset QODBC optimizer, deleting the opt file is required. But we hare received some reports that opt files...
PROBLEM DESCRIPTION Fields related to Balances and QuantityOnHand is showing Null value or is Missing Value, wherein QuickBooks is showing the correct information. e.g When using below query with Optimizer On it does not show the detail but when Optimi...
There are multiple ways to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for selected/multiple tables. For a Single Execution follow below steps Click on the VB DEMO icon to launch the Visual Basic Demo program supplied with QODBC. From the...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOW XP INSTALL QODBC POS Please download QODBC Installer from this site: http://www.qodbc.com/posDownload.htm [http://www.qodbc.com/posDownload.htm] Right Click on the Installer and selec...
TROUBLESHOOTING: SLOW PERFORMANCE / CANNOT GET FULL RECORDS FROM QUICKBOOKS / HOW TO FIND MISSING DATA PROBLEM DESCRIPTION 1: 1.QODBC is showing Partial data or few of my data is missing in the result set. 2.I am able to create an IRL and IR using QO...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION - QBOE PROBLEM DESCRIPTION: When tring to update memo field in the table Invoice or InvoiceLine, QODBC reports the error: [QODBC]Error:1030-Not Support It is not only in field mem...
TROUBLESHOOTING:ERROR CALLING OPEN QBCONNECTION RETURNED ERROR: 10061 - 10061 CONNECTION REFUSED PROBLEM DESCRIPTION: When do a connection test using "Test Connection" button in QODBC Setup Screen->General Window, QODBC reports this error: --------...
TROUBLESHOOTING:TABLE TIMETRACKING / TRANSACTION TABLE IS BLANK PROBLEM DESCRIPTION: The TimeTracking / Transaction table always return null/ no rows as a results. Tried to reset QODBC optimizer, but doesn't work. SOLUTION: Please update your Quick...
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 issue in the SQL Statement. Please check all...
HOW TO USE QODBC WITH MS EXCEL 2016 / 365 / 2013 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-CONFIGU...
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 CREATING A TABLE IN MICROSOFT ACCESS: NOTE: Microsoft Access is a product with many uses,...
HOW TO USE QODBC WITH MS ACCESS 2016 / 365 / 2013 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-ACCESS-2003-...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013TO IMPORT QUICKBOOKS DATAUSING IMPORT TABLES 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 ...
QODBC and Microsoft Excel MICROSOFT ACCESS 2003 AND QODBC 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. Selec...
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 QuickBoo...
PROBLEM I need to update 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 reflect ...
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 ...
ACTIVATING QODBC STILL SHOWS 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 to ...
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...
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 uni...
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 ar...
PROBLEM DESCRIPTION: The TimeTracking / Transaction table always return null/ no rows as a result. Tried to reset QODBC optimizer, but doesn't work. if the Solution provided here [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgeba...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATION UNDER QUICKBOOKS Please follow the steps to remove QODBC Related Certificates from Integrated Application Under QuickBooks: Try removing all the integrated application entries in Quic...
QREMOTE TUTORIAL: USING QUICKBOOKS DATA REMOTELY VIA QODBC Also refer: Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video) [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/] QODBC has the abilit...
QODBC can allow SQL Server to Access to QuickBooks Data Remotely. "FileServer" : having QuickBooks File "Server" : having QuickBooks Application "Client" : having SQL Server. Below are the Steps Install QODBC on "Server" font-size: x-small;"> ...
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 transactions information are not stored in separate table, but you can refer to 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 in 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 error like ...
TROUBLESHOOTING: QODBC POS REPORTS "TEST CONNECTION TO QUICKBOOKS POS FAILED" ERROR. PROBLEM DESCRIPTION: QODBC POS reports "Test Connection to QuickBooks POS failed" error when trying to connect to QuickBooks POS: SOLUTION: This error shows that th...
HOW TO FIND S.O NUMBER INFORMATION OF SALES ORDER IN QODBC INSTRUCTIONS: Sometimes QODBC may have the field name exactly the same as it is in QuickBooks. You cannot find S.O Number, P.O Number in QODBC, but QODBC do has a field in these tables to st...
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 with Credit total. Even thou you are not changing the ...
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 gets hang, and it Does Not Respond. Then After, appl...
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....
PROBLEM : IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040421, This application is not allowed to change its authentication preferences unless QuickBooks is running with the Administrator logged in....
PROBLEM When I start QRemote Server, I get QRemoteServer Started and it shows "Listening failed.QRemote Server is shutting down in 15 sec" SOLUTION: This means there is already a instance of QRemoteServer running on the same machine. Start ...
PROBLEM QRemote Initialization Error , QRemote Error: Listening failed. Please restart application QRemote Closing in 15 Seconds. SOLUTION There might be multiple instances of QRemoteServer.exe running or Machine would require Restart. ...
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 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 AS SOON AS TRYING TO...
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 few problems reported when Upgrading to QuickBooks 2013 R7. After auto upda...
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 COULD NOT OPEN QUICKBOOKS COMPANY FILE AFTER THE UPDATE. SOLUTION If you have upda...
CONNECTING TO QUICKBOOKS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE, TEST CONNECTION NOT WORKING The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security settings. If ...
DCOM / SERVER EDITION TAB MISSING IN QODBC SETUP SCREEN We recommend you to 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 wi...
ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS ACCESS 2010 Sample Files : Excel - Customer & Company Tables - Download [1] Excel - Majority of the Tables and Reports - Download [2] Links: ------ [1] http://support.flexquar...
How to build 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]
How to setup QODBC Driver to auto-connect to QuickBooks. (Video) Also refer - How to setup QODBC to run without QuickBooks [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2518/0/how-to-setup-qodbc-to-run-without-quickbook...
Connecting QODBC Driver to QuickBooks for the First Time (Video) Go to: How to setup 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 32-BIT USING QODBC/QREMOTE For 64 Bit Refer: How to create Link Server with MS SQL 2005/2008/2012 64-Bit Using QODBC/QRemote [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/...
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...
Environment QuickBooks 2014 QODBC 14.0.0.298 QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks & QuickBooks company file. QODBC can show/fetch only those information which are exposed/provided by...
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 and does not have QuickBooks program on the machine. * Do I need QuickBooks installed on the machine to use QODBC? * Can QODBC read directly from QuickBooks com...
HOW TO REMOVE OPTIMIZER FILE WHAT IS 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 dat...
HOW TO USE QODBC EXCEL TEMPLATE You can download the QODBC Excel Template, which has a majority of the tables and reports preconfigured.. All you have to do is download the Excel Template and copy the file to Default Template folder To downloa...
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. Solution to this issue is to re-create the linked table. Ope...
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 in the Customer table through QODBC. I was trying to insert customer d...
SETUP QODBC TO WORK WITH MICROSOFT EXCEL POWERPIVOT 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 o...
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-AC...
Check to see 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 they cannot fit in a single spreadsheet cell. A good example of this is the InvoiceL...
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 connect to QuickBooks through SSIS using QODBC but I am unable to connect to QuickBooks. I have a Read Only Desktop edition of QODBC which is included with QuickBooks Enterprise Edition. I am getting error:"Erro...
PROBLEM DESCRIPTION: I am trying to insert data in Invoice table but QODBC is not allowed me to write data in Invoice table. 20131202.172908 E 2792 InvoiceStorage::DoAdd Cannot set unassigned RSB in transaction line item(s). QuickBooks error messag...
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 error ODBC CALL FAILED- ERROR 10004 when I am trying to connect QuickBooks through MS Access using QODBC. SOLUTION: Please keep QuickBooks running, Logged in as Admin to your company file, Switch to single user mo...
PROBLEM DESCRIPTION: I am attempting to apply payments to invoices I have also determined the TxnID of the Invoice I want to apply payment to and used it in the SQL code specified on How to apply payment to an invoice [http://support.flexquarters.com/esu...
PROBLEM DESCRIPTION: How can I add blank InvoiceLine in QuickBooks using QODBC. SOLUTION: There are empty Invoice line records in QuickBooks, and QODBC can view it too, but you may not be able to create an empty InvoiceLine in QODBC. You cannot...
HOW TO APPLYING DISCOUNTS TO EXISTING INVOICES PROBLEM DESCRIPTION: We have a set of hundreds of invoices that we want to apply a 10% discount to, as the customer is going into bankruptcy and is giving us the choice of accepting a commitment to acce...
PROBLEM DESCRIPTION 1: Where are the "Company ">Is there any other way I can access values for 'Cash at the beginning of period' and 'Cash at the end of period' please? SOLUTION 1: I'm sorry to inform you that the Statement of Cash Flow report is ...
PROBLEM DESCRIPTION: When trying to connect to QuickBooks using VB Demo, I am facing error : QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused SOLUTION: Please first keep QuickBooks runn...
TROUBLESHOOTING: QREMOTE REPORTS \"CONNECTION TO DATA SOURCE FAILED\" WHEN WORK WITH 64-BIT ACCESS OR EXCEL PROBLEM DESCRIPTION: Setup QRemote to work with 64-bit MS Excel. The Client DSN settings are correct. But when access with "QRemote Data 64-b...
PROBLEM DESCRIPTION 1: I'm working in PHP and using the VB Demo 32. I am trying to Insert value in Customer table. But I am getting below error: EXPECTED LEXICAL ELEMENT NOT FOUND: My insert statement is: Insert into Customer ('CompanyName', ...
TROUBLESHOOTING: THIS FUNCTION REQUIRES ACTIVATION OF QODBC READWRITE OR SERVER EDITION PROBLEM DESCRIPTION When I try to run a command in VB Demo I am getting the error message " This function requires QODBC read-write or server version". I am tryin...
HOW TO APPLY DISCOUNTS TO EXISTING INVOICES PROBLEM DESCRIPTION: We have a set of hundreds of invoices that we want to apply a 10% discount to, as the customer is going into bankruptcy and is giving us the choice of accepting a commitment to accept ...
HOW TO BUILD ASSEMBLY REPORT VIA QODBC PROBLEM DESCRIPTION: How can I Build Assembly report via QODBC SOLUTION: If you want to replicate the Build Assembly report via QODBC, I kingly suggest you to pull CustomSummary records using QODBC, below a...
PROBLEM DESCRIPTION: How to insert InvoiceLine item to an existing Invoice. I am trying to run an INSERT statement that i have run before on version 10, but am now getting the following error. SQL Statement: INSERT INTO InvoiceLine (TxnID,RefNu...
INSTRUCTION: When you wants to insert multiple records into an 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, ...
INSTRUCTION: In QODBC v12, we added a new component named QRemote to solve 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 same installation steps fro QODBC v12 & QODBC v...
PROBLEM DESCRIPTION: How can I trace the XML that is sent to/from QuickBooks by QODBC. SOLUTION: You can trace XML by following below steps: 1) Turn on Detail Trace (QODBC Setup Screen>>Message Tab). 2) Switch to Advance tab display: block...
PROBLEM DESCRIPTION: How can I use Case When statement query in QODBC SOLUTION: You can use Case When statement query in QODBC as below: In SELECT Statement, Simple CASE Statement is only used to check whether the value is equal. Below is an exam...
PROBLEM DESCRIPTION: How can I use multiple QuickBooks SOLUTION: You can use multiple QuickBooks of same region and same version year on a same machine. But for the best configuration of QuickBooks, I would suggest you to contact Intuit to take he...
QODBC does support standard SQL queries, but function is implemented differently. Please refer below functions FONT-FAMILY: ARIAL,HELVETICA,SANS-SERIF;\">FUNCTIONS IN SELECT QUERY: You can use distinct like: SELECT DISTINCT CustomerRefFullName ...
HOW TO USE QODBC WITH MULTIPLE COMPANY FILES INTRODUCTION: When there are multiple QuickBooks company files located on one machine, then how do we use only one copy of QODBC to access those company files? Please note that in one machine, QODBC can on...
HOW TO VIEW DETAILS ON WHAT QODBC IS PERFORMING PROBLEM DESCRIPTION: How can I view details on what QODBC is performing in background. SOLUTION: You can enable QODBC status panel via QODBC Setup Screen->Message Window->Select "Display Driver Status"...
PROBLEM DESCRIPTION: I have closed QODBC connection to QuickBooks. But It still shows running in task manager QBW32.EXE keeps running even after QODBC closes connection. SOLUTIONS: When Disconnect command is sent to QODBC, QODBC sends the sam...
TROUBLESHOOTING: QREMOTESERVER NOT CONNECTING PROBLEM DESCRIPTION: I am trying to setup 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 go to c...
HOW TO USE QODBC WITH OPENOFFICE BASE For MS Access 64-Bit, Please Refer : How To Configure QODBC To Work With 64-bit MS Excel SETUP QODBC TO USE WITH OPENOFFICE BASE First open OpenOffice Base from: Start>>All Programs>>OpenOffice>>OpenOffice Base...
TROUBLESHOOTING:THE QBREPORTADMINGROUP VIEWS ARE NOT UPDATED FOR CHANGES IN CUSTOM FIELD PROBLEM DESCRIPTION: The QBReport Admin Group views are not updated for changes in custom field id\'s. User can see QBReportAdminGroup and other tables in MS A...
PROBLEM DESCRIPTION: I have installed the 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 ...
HOW TO GET MEMORIZED TRANSACTIONS FONT-FAMILY: ARIAL,HELVETICA,SANS-SERIF;\">PROBLEM DESCRIPTIONS: How can I get information about Memorized Transactions ">I can see them in QuickBooks but I don't know how to can I get it in QODBC. SOLUTIONS: I...
HOW TO SETUP QODBC TO ACCESS QUICKBOOKS WHEN THERE IS NO-ONE LOGGED IN INSTRUCTION: To use QODBC to access QuickBooks, an QB instance must be running at front or background for accessing. QuickBooks is not a windows service, so it cannot run when th...
NOT ABLE TO PULL ALL DATA IN TABLE SALESRECEIPT FROM QUICKBOOKS POS PROBLEM DESCRIPTION: When there are huge data in QuickBooks POS, QODBC POS not able to pull all data in Table SalesReceipt from QuickBooks POS. SOLUTION: 1.When there are huge data ...
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 in to t...
PROBLEM DESCRIPTION: VB DemoTest Connection is crashing, When I tried to connect to QuickBooks using QODBC. I have tried to reinstall QODBC & QuickBooks but still QODBC Test connection (also via VB Demo) is crashing. Also I tried to run QODBC as Admin/...
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 I have made sure that the driver is referenced and checked in the Integrated Application...
TROUBLESHOOTING:QUICKBOOKS REPORTS "THE CERTIFICATE IS INVALID" PROBLEM DESCRIPTION: When first using application to access QuickBooks via QODBC, it will pop up a window to ask the user to give certificate to this application. But now facing a probl...
TROUBLESHOOTING:ERROR:3000-THE GIVEN OBJECT ID \"\" IN THE FIELD \"LISTID\" IS INVALID PROBLEM DESCRIPTION: When do an inventory adjustment in a company file whose multiple inventory sites feature is not enabled, there is no values in the field "Inv...
PROBLEM DESCRIPTION: I called QuickBooks and they said we can run QuickBooks Canada 2005 alongside QuickBooks USA 2004 on the same computer no problem. They said the problems happen when you try to run USA/Canada QuickBooks on the same computer when bot...
QODBC SHOWS RUNTIME ERROR R6025 PURE VIRTUAL FUNCTION CALL WHEN USING MS ACCESS PROBLEM: I have created link to Customer table in MS Access using QODBC. I can link table without any error, But when I try to edit any field from linked table, I am get...
HOW CAN I USE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use 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 system? I...
HOW TO CREATE 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 Select...
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 License 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 "> I want to access both versions of QuickBooks using QODBC Auto Login. I...
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 qb...
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 DESCRI...
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 installation QuickBooks 2014 R6 on Windows XP and Windows 2003 machine. PROBLEM: When you connect VB Demo and list the tables you would notice only 1...
HOW TO USE QLIKVIEW WITH QODBC To use QlikView with QODBC, please follow the below steps. 1. Open QlikView "> 2. Select Data Source. Click on Browse. 3. Please select MS excel file "> 4. Click on Next. 5. Save QlikView file "> 6. ...
PROBLEM DESCRIPTION: I am getting the following error trying to delete a record from InvoiceLine: [QODBC] Requires at least one child. Cannot delete last line (#10074) Does the invoice file require that there be at least one record in InvoiceLine...
ACTIVATION-DEACTIVATION FAQ PROBLEM DESCRIPTION 1: My old machine broke and I had to completely reinstall the OS. Now I am moving to a new machine. I want to activate QODBC on my new machine. But I cannot deactivate the QODBC CDKEY on my old machine. S...
HOW TO ADD ADDITIONAL QUOTE (') IN INSERT STATEMENT USING QODBC PROBLEM DESCRIPTION: I have exported customer list from QB and Now I wanted to insert these using insert query. But some of them are failing because of having apostophe ('). How to deal w...
HOW CAN I FIND 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. Can you help me find this table via QODBC? (What is the ...
HOW TO CANCEL FQSAVETOCACHE IN QODBC PROBLEM DESCRIPTION: We have some code to insert multiple lines into invoice table. We understand how 'FQSaveToCache' field is used during this process. And the code is running successfully until we found an issue. ...
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. Q...
HOW TO CREATE AN ITEM INVENTORY ASSEMBLY THROUGH MS ACCESS USING QODBC AN EXAMPLE OF CREATING ONE ITEMINVENTORYASSEMBLY WITH TWO LINES First of all please create new MS Access database & link ItemInventoryAssembly, ItemInventoryAssemblyLine table. Pl...
EXAMPLES OF CREATING INVOICE USING QODBC First of all please create new MS Access database & link ALL table. Please refer below mentioned article for How to Use QODBC with Microsoft Access: How to Use QODBC with Microsoft Access [http://support.flexqua...
QUESTION: I've built a table in Access of invoice lines to be added to existing invoices. I have the TxnID and all the necessary xxxxListID fields etc., with the item, quantity and values coming from other sources. So "all" I have to do now is feed these...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: When using Prepared Statements with QRemote driver then it throws an error called ODBC driver not supported. How can I use Prepared Statements with QODBC/QRemote? SOLUTIONS: You...
PCI COMPLIANCE IN QODBC PROBLEM DESCRIPTION: We are working with a client that processes a lot of 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: I w...
QODBC LICENSING INFORMATION Also Refer: QODBC with QRemote Licensing Information [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2568/] There are different types of License required depends on your requirement in QODBC, ...
HOW CAN I FIND SOURCE OF SP_REPORT PROBLEM DESCRIPTION 1: Is there a way to see the SQL that QuickBooks uses to generate their reports? Also, Which tool do they use to generate reports? PROBLEM DESCRIPTION 2: I need to access information tha...
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....
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 a Invoice gets deleted from Q...
TROUBLESHOOTING : SP_REPORT BALANCESHEETSTANDARD REPORT ERROR \"[QODBC] AT LEAST ONE FIELD REQUESTED REQUIRES DATEFROM TO BE SET\". PROBLEM DESCRIPTION: I am running BalanceSheetStandard through VB Demo margin-left: auto; margin-right: auto;" src="...
TROUBLESHOOTING:SP_REPORT PROFITANDLOSSBUDGETPERFORMANCE IS RETURNING NO ROWS. PROBLEM DESCRIPTION 1: I am running ProfitAndLossBudgetPerformance through MS Query FONT-FAMILY: ARIAL, HELVETICA, SANS-SERIF;\">PROBLEM DESCRIPTION 2: Is there any w...
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 unable to connect. I have never had the "Keep QuickBooks r...
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 a...
PROBLEM QRemote Initialization Error . QRemote Error: Listening failed. Please restart application QRemote Closing in 15 Seconds. SOLUTION There might be multiple instances of QRemoteServer.exe running or Machine would require Restart. ...
TROUBLESHOOTING:QUICK REPORT ON AN ACCOUNT PROBLEM DESCRIPTION: How can I get a Quick Report on an account from Chart of Accounts? In Quick Books 2006 Premier, I opened chart of accounts (Ctrl+A) then selected an account and then pressed Ctrl+Q. SO...
TROUBLESHOOTING : HOW TO ACCESS ACCOUNT NAME DETAILS FROM JOURNAL REPORT USING SQL SERVER PROBLEM DESCRIPTION: I need some guidance with extracting data from the general ledger. In particular, I need to see the fullname of the GL account. Running sp...
TROUBLESHOOTING : UPDATE QUERY SCANNING ALL RECORDS IN LINKED SERVER PROBLEM DESCRIPTION 1: I am using MS SQL linked server with QRemote. I am updating a single EstimateItemLine, passing Ref Number and ItemFullName (also tried itemtxnlindid). 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 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 AS SOON AS TRYING TO ...
PROBLEM DESCRIPTION: I can change the optimizer settings when I run the program as an administrator but it never really gets saved. Everything I run the Setup Screen again the settings are back to the original settings and my changes aren't saved. Do...
TROUBLESHOOTING -CANNOT CREATE NEW TABLE USING QODBC / CANNOT ADD A NEW FIELD TO QODBC TABLE PROBLEM DESCRIPTION: I'm trying to create a new table with VB Demo. Can you send me a sample query to do this? SOLUTIONS: QODBC is an ODBC driver. Please ke...
PROBLEM DESCRIPTION: We modified an invoice in QuickBooks and we are trying to get the data out in Excel, but QODBC gives us the old data still. Why? SOLUTIONS: I would like to inform you that QODBC failed to return full records is usually caused b...
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 listed on your report help guide aren't accessible to m...
TROUBLESHOOTING - APP_ALREADY_PURCHASED ERROR WHEN TRY TO AUTHORIZE QODBC IN QUICKBOOKS ONLINE PROBLEM DESCRIPTION: We have some other users of QuickBooks online for the same company file. And when any other user tries to authorize and connect it throu...
TROUBLESHOOTING - ERROR [42S00] [QODBC] INSERT VALUE MUST BE A SIMPLE VALUE PROBLEM DESCRIPTION 1: we have a customer trying to import a credit memo from our database into Quickbooks using a vb.net program. They are getting the following error: ERROR...
TROUBLESHOOTING : ERROR 3250 - THIS FEATURE IS NOT ENABLED OR NOT AVAILABLE IN THIS VERSION OF QUICKBOOKS. PROBLEM DESCRIPTION: I am getting error "Error 3250 - This feature is not enabled or not available in this version of QuickBooks." while I am ...
TROUBLESHOOTING - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST PROBLEM DESCRIPTION: I have QuickBooks 2014 version FONT-FAMILY: ARIAL, HELVETICA, SANS-SERIF;\">SOLUTIONS: There might be some internal error occurred in processing request. To re...
TROUBLESHOOTING : MS ACCESS AS MIDDLEWARE IS NOT WORKING WITH MS SQL SERVER PROBLEM DESCRIPTION: I am trying to use MS Access as a middleware with MS SQL Server. I have created MS Access database margin-left: auto; margin-right: auto;" src="//suppo...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040417 PROBLEM DESCRIPTION: When using your QODBC Driver with my custom application, coded in java, the application is able to connect and retrieve data if Quickbooks is running with the company fi...
TROUBLESHOOTING - SCHEDULED TASK JOB NOT WORKING AFTER UPGRADING QODBC PROBLEM DESCRIPTION: We use a software called RemiCrystal to generate reports for emailing. The reports have always worked fine using QB 2013 Pro and QODBC v14 (I think v14). Then...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING. PROBLEM DESCRIPTION: When I run report query, query works very slow FONT-FAMILY: ARIAL, HELVETICA, SANS-SERIF;\">SOLUTIONS: I would suggest you to enable QODBC status panel via QODBC Setu...
TROUBLESHOOTING - HOW TO ACCESS QUICKBOOKS DATA USING FILEMAKER PROBLEM DESCRIPTION: I downloaded the trial version of your driver this morning and am really excited about the prospects. I've installed it and am able to get the fields and tables to ...
TROUBLESHOOTING - HOW TO GET ALT.EMAIL1,2 FONT-FAMILY: ARIAL, HELVETICA, SANS-SERIF;\">PROBLEM DESCRIPTION: How do I access the alternate email address 1 and 2 and the cc email fields? I don't see them in the customer table. SOLUTIONS: You can ge...
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. A...
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 ...
TROUBLESHOOTING - MULTIPLE TABLES EXIST ERROR IN LINKED SERVER PROBLEM DESCRIPTION: I am trying to run a query using a sql server database link to Quickbooks using QRemote. I can setup the linked server fine in sql server and the connection has been ...
QODBC ONLINE VERSION 14 IS DISCONTINUED INSTRUCTIONS We continue to improve the user experience for QODBC for QuickBooks Online and we are now at version 15, so support for QODBC Online version 14 has been discontinued. You will not be able to create n...
QODBC ONLINE FOR QUICKBOOKS ONLINE - KNOWN ISSUE(S)/LIMITATION(S) Table Invoice, InvoiceLine, InvoiceLinkedTxn may have initial performance issue, but after the full load, the subsequent queries should perform well. ARAccountRefFullName , ARAccountRef...
DATA DOCUMENTATION HOW QODBC INTERFACES WITH QUICKBOOKS We have provided the following 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 ...
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 ABOUT USING QODBC WITH PHP: Using PHP, whether it's an internal Intranet or on the World Wide Web, requires the Server Edition of QODBC. QuickBooks must be running with the company file open. Download Sample [ht...
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 is supporting only 1 region and thus we had only 1 region in QODBC...
TROUBLESHOOTING - CAN QODBC / QREMOTE RUN AS A SERVICE PROBLEM DESCRIPTION: How do I run qodbc as windows services in the background? I notice it required QuickBooks to be logged and windows server 2008 to be logon. SOLUTIONS: QODBC and QuickBo...
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:= Plea...
TROUBLESHOOTING - GETTING [QODBC] NOT SUPPORTED ERROR WHEN TRY TO MODIFY TXNDELETED TABLE PROBLEM DESCRIPTION: I am trying to modify txndeleted table from quickbooks in QODBC but getting "[QODBC] Not Supported" error. SOLUTIONS: TxnDeleted tabl...
TROUBLESHOOTING - HOW TO ADJUST VALUE OF A STOCK ITEM WITHOUT ADJUSTING STOCK QUANTITY PROBLEM DESCRIPTION: Can I adjust the value of a stock item without adjusting the stock quantity? SOLUTIONS: Yes, you can adjust the value of a stock item wi...
TROUBLESHOOTING - HOW TO CREATE BLANK INVOICE IN QUICKBOOKS ONLINE USING QODBC PROBLEM DESCRIPTION: How do I create a note (or a blank line) on the invoice? If I do it the same way that I do it using QODBC for QuickBooks I get an error : Error sendin...
TROUBLESHOOTING - HOW TO RUN QREMOTE SERVER AS A SERVICE PROBLEM DESCRIPTION: I have noticed that when I run the QRemote server on my server if I log out my session the server also shuts down. Is there a way to get the qremote server to run as a ser...
TROUBLESHOOTING - HOW TO TAKE SCREENSHOT PROBLEM DESCRIPTION: How do I take a error screenshot? SOLUTIONS: If you've got a problem with a program in Windows, you may be wondering how to show the errors you're receiving. Luckily, taking a screen...
TROUBLESHOOTING - INVOICE REFNUMBER FAQ PROBLEM DESCRIPTION: I have invoice number (refnumber) from my own table outside of QuickBooks. But if QuickBooks user creates invoices directly in QuickBooks then QuickBooks keeps new incrementing invoices au...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE PROBLEM DESCRIPTION: When set QODBC POS DSN to access the company file that is running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for ...
TROUBLESHOOTING - QODBC SETUP SCREEN DOES NOT DISPLAY ALL CONTENTS PROBLEM DESCRIPTION: I successfully installed QODBC in my Win7 Pro and ready to purchase it. However, I found the "Setup" dialog box is too small and some of the contents, such as "Brows...
TROUBLESHOOTING - \"ERROR PARSING COMPLETE XML RETURN STRING\" ERROR WHEN TRYING TO UPDATE TABLE PRICELEVELPERITEM IN MS ACCESS PROBLEM DESCRIPTION: I have constructed an Access database file (in 32bit Access 2003) with tables linked to QuickBooks. I...
TROUBLESHOOTING - HOW TO VERIFY IF OPTIMIZER FILE CORRUPTED OR NOT PROBLEM DESCRIPTION: Is there anyway to figure out when the Optimizer cache is corrupted or if there's a way we can avoid it altogether in the future? SOLUTIONS: Please refer below ...
HOW TO USE QODBC WITH QUICKBOOKS ONLINE EDITION SETUP OF QODBC ONLINE: First we need to install QODBC Online. QODBC Online requires .Net Framework 4.0 or later version. So you need to install .Net Framework 4.0 to work with QODBC Online. Please refer...
TROUBLESHOOTING - HOW TO USE DATE() AND DATEADD() FUNCTION IN QODBC PROBLEM DESCRIPTION: I'm wanting to write some select statements on both InvoiceLine and SalesReceiptLine that returns all records dated WITHIN the past 30 days, relative to whateve...
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 Host table using VB Demo & get detail about your QuickBooks version. If y...
TROUBLESHOOTING - HOW TO SELECT RECORD WHEN VALUE IS NULL PROBLEM DESCRIPTION: I am trying to run a report which returns ItemInventory where LastReceived is NULL I have tried in vain to accomplish this. My question is what syntax do you use to selec...
HOW TO USE QXL STEP 1 - DOWNLOAD QXL If you haven't already downloaded QXL, do it now by going to the download page. Don't forget to read the "Readme" file during installation for the latest information on QXL setup, new features and other driver inf...
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 below error message: "Wrong client Encyptkey setting": ...
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 parameter in OPENQUERY SOLUTIONS: OPENQUERY does not accept variables for its arguments. You need to Pass Basic Values as below example: DECLARE @TSQL varchar(8000), @ID varchar(25) SELECT @ID = '19650' SELE...
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, Templ...
TROUBLESHOOTING - QREMOTE DOES NOT CONSIDER FQSAVETOCACHE WITH WORKING WITH ODBCCOMMAND FONT-FAMILY: ARIAL, HELVETICA, SANS-SERIF;\">PROBLEM DESCRIPTION: QRemote Does not consider FQSaveToCache with working with OdbcCommand & Parameters I have an ...
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 ERROR 11118,11119,11120,11121,11122 PROBLEM: I am getting error \"11118 - SYSTEM LICENSE ERROR\" I am getting error \"11119 - REGFILE1 LICENSE OPEN ERROR\" I am getting error \"11120 - REGFILE1 LICENSE ERROR\" ...
TROUBLESHOOTING - QREMOTE ERROR "COULD NOT CONNECT TO SERVER/QREMOTESERVER" PROBLEM DESCRIPTION 1: I cannot connect through QRemote DSN. I have tested using VB Demo application as well as using QRemote DSN test connection. I am getting below error: PR...
TROUBLESHOOTING - HOW TO GET BANK RECONCILIATION DETAILS USING QODBC PROBLEM DESCRIPTION: How to get Bank Reconciliation details using QODBC I've not had success identifying any field/flag that identifies the Bank Reconciled status. Is this inform...
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 seperate smaller commands for the Invoice Lines and a fin...
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, Te...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040410 PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through QODBC using VB Demo application. I am consistently getting "80040410" error. Begin Session Failed. S0000 00000 [QODBC] QB Beg...
TROUBLESHOOTING - ERROR WHILE INSERTING BILL PROBLEM DESCRIPTION 1: I am following the below steps and getting the error. 1.First, we have inserted the records in Bill & BillExpenseLine table and records got inserted successfully. 2.Second, we are in...
TROUBLESHOOTING - GETTING QODBC NOT SUPPORTED ERROR WHILE INSERTING INVOICE PROBLEM DESCRIPTION: I am trying to insert Invoice, But I am getting below error: [QODBC] Not supported (#10003) I am using below SQL statements: INSERT INTO "InvoiceLine...
TROUBLESHOOTING - APPLICATION CONNECTIVITY DELAY PROBLEM DESCRIPTION: I have an inventory control system (c#,SQL Server) that needs Read Only access to four tables in the accounting system. I have deployed your multiuser version and can get to the local...
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: First, we need to install QODBC Online. QODBC Online requires .Net Framework 4.0 or later version. So you need to install .Net Framework 4.0 to work with QODBC Onl...
QODBC ONLINE IS NO LONGERCONNECTED TO QUICKBOOKS ONLINE. YOUR USER TOKEN IS NO LONGERVALID. HOW TO CONNECT / RECONNECT QODBC ONLINE WITH QUICKBOOKS ONLINE EDITION (APPS.COM) Please follow below mentioned steps to configure QODBC Online: 1) Open QODBC ...
HOW TO USE QODBC ONLINE WITH MICROSOFT ACCESS 2013 TO BUILD LINKED TABLE CREATING A TABLE IN MICROSOFT ACCESS: NOTE: Microsoft Access is a product with many uses, and will allow you to use your QuickBooks Online data files in the same fashion as Access ...
HOW TO USE QODBC ONLINE WITH MICROSOFT EXCEL 2013 32-BIT SETUP QODBC TO USE WITH MS EXCEL 2013 NOTE: QODBC allows you to quickly merge live QuickBooks Online data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The d...
SAMPLE CODE FOR VB.NET WITH QODBC ONLINE SAMPLE CODE OF VB.NET TO CREATE DATASET NOTE: The following code is the minimal code required to create a DataSet from the SQL statement and attaches the dataset to a DataGrid. Dim cnQODBC As System.Data.Odbc.Od...
USING QUICKBOOKS ONLINE DATA WITH VBA CREATING A FORM IN MICROSOFT ACCESS: NOTE: Microsoft Access is a product with many uses, and will allow you to use your QuickBooks Online Data files in the same fashion as Access databases. Open MS Access, you can...
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 prevent th...
HOW TO CREATE 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?/Default/...
HOW TO CREATE 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?/Default/...
HOW TO USE QODBC ONLINE WITH QLIKVIEW To use QlikView with QODBC Online, please follow the below steps. 1. Open QlikView & Create new file. 2. Select Data Source. Click on Browse. 3. Please select MS excel file & click on Next. 4. Click on Next. ...
TROUBLESHOOTING - HOW TO USE QODBC ONLINE WITH FILEMAKER PROBLEM DESCRIPTION: I downloaded the trial version of your driver this morning and am really excited about the prospects. I've installed it and am able to get the fields and tables to appear in ...
INSTRUCTIONS WHEN DESIGNING YOUR REPORTS 1. Use filters in 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, which...
SETUP IN ALPHA FIVE CREATE A NEW WORKSPACE Start Alpha Five and create a new workspace, it could be called Online.adb - it is a holder for the entire application. Click the WORKSPACE & TASKS tab -> Click -> choose CREATE A NEW, EMPTY WORKSPACE -> ...
CONFIGURE QODBC FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC with Jitterbit community edition 3.0.0 you should follow the steps below to configure your QODBC driver and Jitterbit connection. These steps work for QODBC with Jitte...
CONFIGURE QODBC POS FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC POS with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC POS driver and Jitterbit connection. These steps work for QOD...
CONFIGURE QODBC ONLINE FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC Online with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC Online driver and Jitterbit connection. These steps wor...
TROUBLESHOOTING - HOW TO GIVE REFUND TO EXISTING CREDITMEMO USING QODBC PROBLEM DESCRIPTION: How can I apply a refund check to an existing credit memo using QODBC? In QuickBooks, I can refund by opening the Create Credit Memos/Refunds dialogue box usin...
TROUBLESHOOTING - HOW TO LOCATE DATA FOUND IN QUICKBOOKS BY TABLE AND FIELD NAME INSIDE QODBC PROBLEM DESCRIPTION: I have a question about How to locate data found in QuickBooks by table and field name inside the QODBC system. SOLUTIONS: The fastest ...
TROUBLESHOOTING - HOW TO IDENTIFY IF APPLICATION IS 32-BIT OR 64-BIT PROBLEM DESCRIPTION: How can I Identify if the application is 32-bit or 64-bit? SOLUTIONS: SQL SERVER If your application is SQL Server, then you can identify it by Starting your "...
TROUBLESHOOTING - HOW TO 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 into QB the line items seem to go but wh...
TROUBLESHOOTING - HOW TO USE QODBC WITH MULTIPLE QUICKBOOKS COMPANY FILE PROBLEM DESCRIPTION: I have a question about setting ODBC to auto login. We have two different company files for accounting purpose. I am trying to automate some of the tasks and I...
GENERAL CONNECTION STRING INSTRUCTIONS The most difficult part of using QRemote in programming is the connection string. The simplest form includes a reference to a DSN. A system DSN called "QuickBooks Data QRemote" for 32 Bit application & "QuickBooks...
TROUBLESHOOTING - QODBC LICENSING ISSUES WITH WINDOWS 10 UPGRADES PROBLEM DESCRIPTION: I want to upgrade my Operating System to Windows 10 and want to know is there any precautions/actions required for QODBC to keep working. SOLUTIONS: STEPS BEFORE U...
For QODBC / QODBC-POS/ QODBC-Online/ QXL related issue 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] (If y...
Connecting QODBC Online Driver to QuickBooks Online for the First Time (Video) How to install QODBC Online & Using Microsoft Excel/Access with QODBC You can also see: How to use QODBC Online with QuickBooks Online Edition [http://support.flexquarters...
TROUBLESHOOTING - HOW TO USE QODBC ON MAC PROBLEM DESCRIPTION: I have MAC Operating System & I want to use QODBC on it. Is it possible to use QODBC on MAC? SOLUTIONS: Yes, you can use QODBC on MAC. But you have to load some tools to use it. You can ...
TROUBLESHOOTING - HOW TO GET VBA TO EXECUTE TWO STATEMENTS AT THE SAME TIME PROBLEM DESCRIPTION: We are using a Visual Basic app which works with an SQL Server database to write data to QB through QODBC. We are executing two SQL statements as described...
TROUBLESHOOTING - QODBC AUTO-CONNECTING WITH WRONG USER PROBLEM DESCRIPTION: We have a few stations where we utilize the read only QODBC desktop version. On a station that we just built, it keeps to using the wrong Quickbooks user for the auto-login. I ...
TROUBLESHOOTING - QODBC CONNECTION TO TALEND OPEN STUDIO PROBLEM DESCRIPTION: QuickBooks Enterprise comes with a tool called QODBC that enables connecting to a QB database to read and write data. I have installed it, and I can successfully see QB data ...
TROUBLESHOOTING - QODBC DRIVER DROPPING A FEW TRANSACTIONS ON INSERT TO INVOICELINES PROBLEM DESCRIPTION: We seem to be having an issue with an insert into the InvoiceLines table dropping a few transactions. We needs to create about 1000 invoices per...
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 we...
HOW TO USE QODBC WITH WINDOWS SCHEDULER / HOW TO USE KA-FIRETASK WITH QODBC /HOW TO RUN QODBC APPLICATIONS ON A REPEATING/NIGHTLY BASIS PROBLEM DESCRIPTION 1: My application needs read data from QuickBooks and update data in SQL server, up-to this I can...
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 data protection error when we click on "Refresh All" link. When you click on "OK" you will see below error. SOLUTION: You are receiving this error because your Excel sheet is in PROTECTED MODE. Wh...
HOW DO I CHANGE INVOICELINEITEM FROM INVOICELINEITEMREFFULLNAME1 TO INVOICELINEITEMREFFULLNAME2 PROBLEM: How do I go about replacing all Invoices that contain the InvoiceLineItemRefFullName "Framing" with the InvoiceLineItemRefFullName "Installation" ...
TROUBLESHOOTING - HOW TO CHANGE STATUS OF INVOICE IN QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I had inserted into table ReceivePaymentLine, but it not change status to "Paid"? How do I do it? I using InvoiceLine for insert Item sales, and ReceivePayment...
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 DemoTest Connection is crashing When I tried to connect to QuickBooks using QODBC. I have tried to reinstall QODBC & QuickBooks but still QODBC Test connection (also via VB Demo) is crashing. Also, I tried to run QODBC as Admin/...
HOW TO RETRIEVE CHARACTER FIELDS WHICH ARE RETURNED AS NULL IN SSIS USING QODBC PROBLEM: Using SQL Server Integration Service (SSIS) and QODBC, All character fields are being returned as NULL. SOLUTION: Please use function CONVERT to convert the dat...
PROBLEM DESCRIPTION: How can I add blank InvoiceLine in QuickBooks using QODBC. SOLUTION: You cannot create an empty Invoice, neither in QODBC nor QuickBooks. But in QuickBooks, you could leave lines blank and just make sure there is at least one line...
HOW TO CONNECT TO MULTIPLE COMPANY FILES AT THE SAME TIME/SIMULTANEOUSLY PROBLEM: There are multiple company files in QuickBooks. At a time, I can access only one company file. Is QODBC allow me to access multiple company files same time? SOLUTION: T...
PROBLEM DESCRIPTION: I am are trying to use QODBC with Crystal Reports 11, but I'm also having the similar results with the VB Demo included with the driver. Many queries, such as "select * from invoice" cause the program to hang. With Crystal Reports, ...
PROBLEM DESCRIPTION: VB DemoTest Connection is crashing. When I tried to connect to QuickBooks using QODBC. I have tried to reinstall QODBC & QuickBooks but still QODBC Test connection (also via VB Demo) is crashing. Also, I tried to run QODBC as Admin...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC, but I am unable to connect to QuickBooks. I have a Read Only Desktop edition of QODBC which is included with QuickBooks Enterprise Edition. I am getting error: "Err...
PROBLEM DESCRIPTION: How to insert employee time information from MS Excel time spreadsheet into QuickBooks using QODBC SOLUTION: You can not perform insert/update operation directly in MS Excel because Excel is just exporting table in the spreadshe...
PROBLEM DESCRIPTION: We keep getting "QB Begin Session Failed" error when trying to open QODBC connection in a web page. --> It happens when there are several users using QuickBooks at the same time. --> When it happens, We tried to use the 'VB Demo' and...
TROUBLESHOOTING - UNABLE TO IMPORT QBO CONNECTION KEY USING QODBC ONLINE PREVIOUS VERSION PROBLEM DESCRIPTION: I am importing QBO connection key using QODBC Online latest version & I am getting below error: FILE CAN NOT CONTAIN PROPER KEYS!!! I ha...
TYPICAL TRIAL BALANCE REPORT IN QUICKBOOKS ONLINE REPORT DISPLAYED IN QODBC STORED PROCEDURE COMMAND With QODBC the same report can be generated using stored procedure reports like this: sp_report TrialBalance show RowData as Account, Amount_1 as ...
TROUBLESHOOTING - QUICKBOOKS ONLINE - QODBC REQUIRES API VERSION 1.1 OR 2.0 TO COMMUNICATE WITH QUICKBOOKS. PROBLEM DESCRIPTION: I was able to use QODBC Online with my QuickBooks Online (QBO) but suddenly I facing connection issue. Every time I try to ...
INSTRUCTIONS QODBC Online works by accepting SQL commands through the ODBC Interface, then converting those calls to qbXML navigational commands within the QuickBooks Online API and returning recordsets that qualify for the query results. This driver is...
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 RowDat...
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 very generic error when I try and use QODBC to create an invoice. I am using below query: INSERT INTO InvoiceLine ("Temp...
HOW TO EXPORT QUICKBOOKS DATA NOT AVAILABLE IN QODBC PROBLEM DESCRIPTION 1: I have searched a lot of the tables connectable thru the QODBC and cannot find customer list information such as the customer's website, facebook, linked in, multiple phone numb...
TROUBLESHOOTING - MICROSOFT EXCEL 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION TROUBLESHOOTING - MICROSOFT ACCESS 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION PROBLEM DESCRIPTION 1: I am having significant difficulties with QODBC s...
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 now all our LinkedServers timeout. I test the QODBC connecti...
TROUBLESHOOTING - HOW TO LOCATE CONFIGURE QODBC DATA SOURCE PROBLEM DESCRIPTION: I am unable to find a configure the 32-Bit ODBC Data Source Manager under a 64-Bit System. I will be more than happy to remote access with you and my server representati...
TROUBLESHOOTING - HOW CAN I GET SINGLE USER ACCESS USING 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) In your notes about InventoryA...
TROUBLESHOOTING - SELECT STATEMENT IS NOT WORKING PROBLEM DESCRIPTION: I am evaluating the product. When I did this SQL Statement: select * from Customer where ListId=557 I was getting a column not found error. The QBO online documentation says the ...
TROUBLESHOOTING - UPDATE QUERY TRUNCATING LEADING SPACES PROBLEM DESCRIPTION: I have to update a field with specific data and for some records, one of the fields will have leading spaces that are required to be there. I have tried numerous ways to get...
TROUBLESHOOTING - "CANNOT UPDATE TABLE ITEMINVENTORY ERROR 10004" PROBLEM DESCRIPTION: I am trying to run an update on the Name field in ItemInventory. I've checked to see if it's updateable and it is. I get "Cannot update table ItemInventory Error 1...
WHAT IS JUMPIN TYPE? PROBLEM DESCRIPTION: I am looking for definition and usage of "JUMPIN TYPE." SOLUTION: In QODBC JUMPIN provides relationship details with other table and also provides information about value comes from another table. Please ...
TROUBLESHOOTING - 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, says it has a connection but does nothing. I...
TROUBLESHOOTING - [QODBC] COLUMN NOT FOUND REORDERBUILDPOINT PROBLEM DESCRIPTION: We just upgraded to v16 on both QB and QODBC and now refreshes from Excel aren't working. We're getting the message "[QODBC] Column not found ReorderBuildPoint" SOLUTIO...
TROUBLESHOOTING - FAULTING APPLICATION NAME: QREMOTESERVER.EXE PROBLEM DESCRIPTION: We have had a couple error messages pop up recently on the server related to the QODBC driver on our server and were wondering if you could provide any information as ...
TROUBLESHOOTING - QUICKBOOKS ADVANCED INVENTORY MODULE IN QODBC PROBLEM DESCRIPTION: Does your enterprise driver support the advanced inventory module for QuickBook enterprise? Would we be able to query stock per item, per location? SOLUTION: You ...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL SERVER PROBLEM DESCRIPTION: So the QODBC works great running on the machine. We have the intent to integrate on our website / Intranet to create customers or make changes from the web. ...
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. In...
TROUBLESHOOTING - THIS RECORD HAS BEEN CHANGED BY ANOTHER USER SINCE YOU STARTED EDITING IT. PROBLEM DESCRIPTION: I am using the Quickbooks Pro 2015 trial version and a purchased QODBC latest version. I have an Access database with linked QB tables. ...
TROUBLESHOOTING - [QODBC] INVALID OPERAND FOR OPERATOR: PROBLEM DESCRIPTION: I am getting the error "Invalid operand for operator: " while trying to insert an invoice line item: INSERT INTO InvoiceLine ( CustomerRefListID, T...
TROUBLESHOOTING - INVOICE LINE RATE IS NOT LOADING INTO QBO PROBLEM DESCRIPTION: The InvoiceLineRate value passed in the insert query to create the invoiceline record is not being loaded into QBO. Below are the two queries I am using to create the i...
HOW TO CONNECT TO QUICKBOOKS ONLINE SANDBOX. 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.flexquarters.com/...
TROUBLESHOOTING - CANNOT CONNECT TO MY QUICKBOOKS ONLINE SANDBOX PROBLEM DESCRIPTION: I am trying to do some testing and now have access to a QBO Sandbox company. I have tried to connect to it two different ways. 1. If I "Connect to QuickBooks" on t...
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 DATE RANGE PROBLEM DESCRIPTION: I would like to do is list find the subtotal of all Invoices by a customer for not only that particular customer but all jobs assigned to that customer, wi...
AN EXAMPLE OF PURCHASEORDER ITEM GROUPS CREATE AN ITEMGROUP WITH THREE LINES Note: Let's start by creating 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 IN...
TROUBLESHOOTING - EXPENSES WRITTEN TO BILLEXPENSELINE ARE NOT SHOWING AS BILLABLE WHEN VIEWED IN QUICKBOOKS PROBLEM DESCRIPTION: The field ExpenseLineBillableStatus contains the status of the BillExpenseLine and using the following stored procedure "s...
TROUBLESHOOTING - HOW CAN I CHANGE THE PRICING AND QUANTITY OF ITEMS IN A ITEMGROUP? PROBLEM DESCRIPTION: How can I change the price of each individual item in a group? Is it possible? If yes please give me an example. SOLUTION: The price of an ite...
TROUBLESHOOTING - HOW CAN I GET ALL THE RECORDS FOR A SPECIFIED YEAR PROBLEM DESCRIPTION: I need to compute a Year to Date total paid using the Invoice table.I'm working in MS-Access and need to run the following statement: SELECT SUM(Subtotal) FRO...
TROUBLESHOOTING - HOW CAN I GET DAILY BILL PAYMENT INFORMATION? PROBLEM DESCRIPTION: How can I get daily payment bill information? and How can I get daily Bill Payment information using QODBC, and How can I get this details? SOLUTION: You can use b...
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 TIME FRAME 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 wou...
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 into QuickBooks date. I want to insert txndate in ReceivePayment table; but it pop up t...
FOREIGN AND UNICODE CHARACTERS NOT SUPPORTED BY QODBC INFORMATION: Evidently QuickBooks allows users to put foreign (ie Chinese, Japanese, etc...) characters into item descriptions, etc... Unfortunately, these characters are not returned properly in q...
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 ha...
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 to 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, AmountDifferenceAct...
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: I just recently installed QODBC to try to get data out of a QuickBooks company file but I get this error: "In...
TROUBLESHOOTING - HOW DO I UPDATE CUSTOMER CUSTOM FIELDS PROBLEM DESCRIPTION: How do I update Customer custom fields? SOLUTION: You can update Customer custom fields using the update query. For Example: Update Customer Set CustomFieldContract='...
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 QBO COMPANY FILE PROBLEM DESCRIPTION: How do I share/invite FLEXquarters Support team to access my QBO company file? SOLUTION: Please follow below steps to share/invite FLEXquarters Support team to Q...
TROUBLESHOOTING - 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 in access: Select * from Item The connection string is as follows: ODBC;DRIVER={QODBC Driver for QuickBooks};SERVER=QODBC;DFQ...
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 am now unable to connect with QXL as it says QXL is not licensed for this QuickBooks edit...
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 Appl...
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 SUBSCRIPTION OF QODBC DESKTOP DRIVER FOR QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I want to cancel my QODBC Online monthly subscription. How to cancel the subscription of QODBC Desktop Driver for QuickBooks Online? SO...
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 EXCEL REPORT USING QXL'S EXCEL SHEET 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 create MS E...
TROUBLESHOOTING - CONNECTION SERIAL, LIMITATION , QUEUE AND UPPER LIMIT PROBLEM DESCRIPTION: How many concurrent connections does the Server edition support? Is the product QB version specific, requiring additional purchases with each version. AKA....
TROUBLESHOOTING - CODE DIFFERENCES BETWEEN QODBC DESKTOP AND QODBC ONLINE PROBLEM DESCRIPTION: I have a MS Access application using QODBC to connect to desktop QuickBooks. Can I use the QODBC Online driver to connect to QuickBooks Online without chang...
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 to get an A/P aging. The ...
TROUBLESHOOTING - REPORTING SHIP TO ADDRESSES PROBLEM DESCRIPTION: Has anyone run a report that will pull the all the detail for a range of invoices? In particular, I'm looking to run a report that shows 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 for the system. SOLUTION: Advanced p...
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 returns any reco...
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 to a single spreadsheet. Open QXL, The first step in configuring the application is to click on settings icon f...
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 in...
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 Minimum CPU required: Pentium II processor 450 MHz or better Minimum memory required: 64 MB Minimum hard disk space required: 15 MB Operating system version: QODBC supports Microsoft Windows 95, Windows 98, Wind...
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 Profitandlossbu...
TROUBLESHOOTING - UPDATE FROM A SELECT STATEMENT NOT WORKING PROBLEM DESCRIPTION: I am trying update records through select statement. But it is not working. UPDATE Customer SET CustomFieldProjectNumber = i.JobNumber FROM ( SELECT ListID, {fn SUBSTR...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040438 PROBLEM DESCRIPTION: I am testing connection of QODBC & I am getting QODBC test connection failed error: Can you advise what is error and solution for it? SOLUTION: The above error says t...
QODBC MENU ITEMS When you install QODBC below menu items are created under QODBC Driver for use with QuickBooks folder in start menu. 1. CONFIGURE QODBC DATA SOURCE 64-BIT CONFIGURE QODBC DATA SOURCE 64-BIT will help you to view/create/configure 64-...
QODBC POS MENU ITEMS When you install QODBC POS below menu items are created under QODBC Driver for use with QuickBooks POS folder in start menu. 1. CONFIGURE QODBC POS DATA SOURCE 64-BIT Configure QODBC POS Data Source 64-Bit option will help you t...
QODBC ONLINE MENU ITEMS When you install QODBC Online below menu items are created under QODBC Driver for use with QuickBooks Online folder in start menu. 1. CONFIGURE QODBC ONLINE DATA SOURCE 64-BIT Configure QODBC Online Data Source 64-Bit option ...
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" $con...
QODBC QUICK START GUIDE Download : QODBC 2017 Quick Start Guide [http://qodbc.com/download/builds/319/QODBC%202017%20Quick%20Start%20Guide.pdf] (PDF) QODBC DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2479.HTM] INTRODUCTION WHAT IS ODBC? ...
QODBC POS QUICK START GUIDE Download: QODBC POS 2015 Quick Start Guide [http://qodbc.com/download/builds/309/QODBC%20Driver%20ForQuickBooksPOS2015.pdf] (PDF) QODBC POS DRIVER LICENSE AGREEMENT [http://support.flexquarters.com/esupport/index.php?/Knowle...
QODBC ONLINE QUICK START GUIDE Download: QODBC Online 2015 Quick Start Guide [http://qodbc.com/download/builds/307/Online/QODBC%20Online2015QuickStartGuide.pdf] (PDF) QODBC ONLINE DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2599.HTM] INTROD...
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) uti...
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 t...
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 respect...
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 linked table in MS Access. I am able to link ReceivePaymentToDeposit ta...
MICROSOFT WORD 2016 AND QODBC CREATING A WORD MAIL MERGE TO LIVE QUICKBOOKS DATA NOTE: QODBC allows you to easily merge QuickBooks data onto 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, 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 & PRICELEVELFIXEDPERCENTAGEUSING QODBC PROBLEM DESCRIPTION: How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC. SOLUTION: To create a new PriceLevel and PriceLevelPerItem item (a...
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: TI'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 -- Amo...
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 Save a SalesOrder with three SalesOrderLine retur...
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 vers...
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 IN 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 - HOW TO ADD DISCOUNT VALUE TO SALESRECEIPTITEM PROBLEM DESCRIPTION: I am wanting to add a $50 discount to a sales receipt item. Been using the "discount" field in my SQL statement. I keep getting an error that: ERROR [42S00] [QODBCP...
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 QODBC POS installer by clicking here [http://www.qodbc.com/posDownload.htm] Right Click on the Installer and select, "Run As Administrator" Please...
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 This article shows how you can easily integrate the QODBC driver for QuickBooks into your workflow in Talend. Follow the steps below to connect to the DSN and create real-time data visualizations: 1. Open Talend ETL & c...
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 LONGERCONNECTED TO QUICKBOOKS ONLINE. YOUR USER TOKEN IS NO LONGERVALID. HOW TO CONNECT / RECONNECT QXL ONLINE REFER: HOW TO DOWNLOAD AND INSTALL QXL ONLINE [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/KNOWLEDGEBASE/ARTICLE/VIE...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN SQL SERVER. PROBLEM DESCRIPTION: I am trying to create Linked Server in SQL Server. VB DEMO connects successfully to QREMOTE on QuickBooks Server. Setting up Linked server - I get...
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 pricelevels and I'm looping through each invento...
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 no...
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 can not get QReportBuilder to refresh data. The error is Error message: Could not crea...
TROUBLESHOOTING - CANNOT LOAD CUSTOMER TABLE RECORDS PROBLEM DESCRIPTION: I am trying query Customer table but it never opens for me in datasheet view either by 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 and...
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] for 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 mult...
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 in 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 in 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 & ODBC 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 ...
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 TO 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 belo...
SAMPLE VB.NET WEB APPLICATION FOR INSERTING INVOICELINE TO 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 downlo...
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 ODBC 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 Database...
QXL PRO EDITION OPTIONS AND SETTINGS - ODBC QXL PRO 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 EDITION TAB: Using...
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 in 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 are needing to export to Cry...
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 are needing to export to...
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 are needing to export to M...
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 running...
HOW TO USE QXL WITH 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 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...
Most popular articles 
 
Newest articles