RSS Feed
Knowledgebase : Tutorials > Others
     

[QODBC ONLINE] HOW TO INSERT DATA INTO THE VENDORCREDIT TABLE PROBLEM DESCRIPTION: How to insert data into the VendorCredit table SOLUTION:  Open the "QODBC Online Test tool" from the start menu. Click on the "Connect" button. Used the below SQL ...
[QODBC-DESKTOP] HOW TO USE QODBC WITH ALTERYX DESIGNER PROBLEM DESCRIPTION: I want to export the QuickBooks data using Alteryx Designer Studio? How can I use Alteryx Designer with the QODBC? SOLUTION:  Alteryx Designer Studio is a 64-Bit applicatio...
[QODBC-ONLINE] TROUBLESHOOTING - PARTIAL DATA/INCOMPLETE DATA IN GENERALLEDGER REPORT - UNABLE TO FETCH ALL ROWS PROBLEM DESCRIPTION: I am fetching one year of data from the QuickBooks Online General Ledger report using QODBC Online. I get partial dat...
[QODBC-DESKTOP] - HOW TO RENAME SOME OF MY BULK ITEMS (I.E., INVENTORY ITEMS) AND THEIR RELATED CHILD ITEMS (I.E., ASSEMBLIES) PROBLEM DESCRIPTION: I would like to rename some of my bulk items (i.e., inventory items) and their related child items (i.e.,...
[QODBC-ALL] TROUBLESHOOTING - LOAD UPDATED DATA DID NOT COMPLETE (3)    PROBLEM DESCRIPTION When I try to run the optimizer from the QODBC configuration screen, I get the following error when I click "Load Updated Data": Load Updated Data did not comp...
[QODBC-ALL] TROUBLESHOOTING - TRAPPABLE ERROR (E06D7363) OCCURRED IN AN EXTERNAL OBJECT   PROBLEM DESCRIPTION A trappable error (E06D7363) occurred in an external object. The script cannot continue running. I receive this error when reading and writin...
[QODBC-DESKTOP] - DO I REALLY NEED TO PURCHASE QUICKBOOKS TO DEVELOP A ONE OFF APPLICATION FOR A CLIENT? PROBLEM DESCRIPTION: I need to develop a one-off application for a client. I have their QuickBooks Desktop company file. Can I develop on that dat...
[QODBC ALL] - HOW TO INCREASE THE UPDATE OR DELETE SQL STATEMENT PERFORMANCE. PROBLEM DESCRIPTION: Ran this SQL to move an invoice from one Customer to another: Update invoice set CustomerRefListID = '1500' where TxnNumber = 8453 It took about 15+ min...
HOW TO INTUIT OR QUICKBOOKS DEVELOPERS AND REPORT FIELDS NOT AVAILABLE IN QUICKBOOKS SDK OR QUICKBOOKS ONLINE API ISSUE: We noticed a field or feature is not available in QuickBooks SDK or QuickBooks API. How can I contact Intuit and request to add the...
[QODBC-ALL] TROUBLESHOOTING - UNABLE TO EXECUTE UPDATE STATEMENT WHEN USING SQL SERVER 2019 LINKED SERVER ON WINDOWS 11 OR WINDOWS SERVER 2019 ISSUE: We recently upgraded our Windows OS to Windows 11 and SQL Server to 2019. We can connect from SQL Se...
SOLVED: [QODBC-DESKTOP] TROUBLESHOOTING - UNABLE TO CHANGE THE DEFAULT CONFIGURATION OF NEWLY CREATED QODBC DSN - BUILD 348 ISSUE: We created a new QODBC 32-Bit DSN with the name "QODBC-MyCompany. The DSN was created successfully. We tried to chang...
[QODBC ALL] WHAT DOES 'RED TEXT' IN THE QODBC DRIVER DIALOGS MEANS PROBLEM DESCRIPTION: What does 'Red text' in the QODBC driver dialogs means SOLUTIONS:  Whenever you run any query for the first time, QODBC will first build the optimizer. Please r...
[QODBC ONLINE] - UNABLE TO USE QODBC ONLINE ON WINDOWS 7 PROBLEM DESCRIPTION: Unable to use QODBC Online on Windows 7 Error - session Failed. 653 - There was an error while communicating with the Ids Server. - - The Response Stream was null or empty ...
TROUBLESHOOTING - HOW DO I UPDATE EXPIRED CREDIT CARD INFORMATION ON YOUR SYSTEM? PROBLEM DESCRIPTION: I am using QODBC Online & QXL Online, and I am using my credit card for payment. How do I update expired credit card details on your system? My car...
Hello, If you downloaded The QODBC Desktop product between October 7th and 9th, this urgent message might apply to you. During the dates above, a possible trojan-infected software version was uploaded to our hosting company, and you may have gotten th...
HOW QODBC TALKS TO QUICKBOOKS SDK TO GET SAFE/ENCRYPTED/BALANCED DATA FROM QUICKBOOKS, PREVENTING DATA CORRUPTION. PROBLEM DESCRIPTION * How does QODBC validates all the business logic which are part of the QuickBooks application? * Can QODBC read o...
TROUBLESHOOTING - HOW TO CANCEL THE SUBSCRIPTION OF QODBC DRIVER FOR QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I want to cancel my QODBC Driver for QuickBooks Online monthly subscription. How to cancel the subscription of QODBC Driver for QuickBooks Onl...
TROUBLESHOOTING - [QODBC] INVALID OPERAND FOR THE OPERATOR: PROBLEM DESCRIPTION: I am getting the error "Invalid operand for the operator: " while trying to insert an invoice line item: INSERT INTO InvoiceLine ( CustomerRefL...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL SERVER PROBLEM DESCRIPTION: So the QODBC works excellently running on the machine. We intend to integrate into our website / Intranet to create customers or make changes from the web. I...
TROUBLESHOOTING - SELECT STATEMENT IS NOT WORKING. PROBLEM DESCRIPTION: I am evaluating the product. When I made this SQL Statement: Select * from Customer where ListId=557 I was getting a column not found the error. The QBO online documentation says...
CONNECTING QODBC ONLINE DRIVER TO QUICKBOOKS ONLINE FOR THE FIRST TIME  (VIDEO) For system requirement details of QODBC Online, click here [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2816]. How to install QODBC Onlin...
DIFFERENCE BETWEEN QODBC FOR QUICKBOOKS DESKTOP AND ONLINE. TABLE DIFFERENCES: Number of Tables available in QODBC DESKTOP QODBC ONLINE 150 83 List of Tables available in QODBC Desktop [http://doc.qodbc.com/qodbc/usa/TableList.php?catego...
TROUBLESHOOTING - QREMOTE DOES NOT CONSIDER FQSAVETOCACHE WITH WORKING WITH ODBCCOMMAND & PARAMETERS PROBLEM DESCRIPTION: QRemote Does not consider FQSaveToCache with working with OdbcCommand & Parameters. I have an application that creates Sales Orde...
PROBLEM DESCRIPTION: How to use parameters in OPENQUERY SOLUTIONS: OPENQUERY does not accept variables for its arguments. You need to Pass Basic Values as below example: SELECT QUERY: DECLARE @TSQL VARCHAR(8000), @ID VARCHAR(25) SELECT @ID = '1...
TROUBLESHOOTING - GETTING "WRONG CLIENT ENCYPTKEY SETTING" ERROR PROBLEM DESCRIPTION: I'm trying to establish the connection to QuickBooks using QRemote Server. But when I tried to connect, I got the below error message: "Wrong client Encyptkey settin...
HOW TO USE QXL STEP 1 - DOWNLOAD QXL If you haven't already downloaded QXL, go to the download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/] now. Don't forget to read the "Readme" file during installation for the latest information on QX...
TROUBLESHOOTING - HOW TO SELECT A RECORD WHEN THE VALUE IS NULL PROBLEM DESCRIPTION: I am trying to run a report that returns ItemInventory where LastReceived is NULL. I have tried in vain to accomplish this. What syntax do you use to select a blank/nu...
TROUBLESHOOTING - INVOICE REFNUMBER FAQ PROBLEM DESCRIPTION: I have the invoice number (RefNumber) from my table outside QuickBooks. But if a QuickBooks user creates invoices directly in QuickBooks, then QuickBooks keeps new incrementing invoices autom...
TROUBLESHOOTING - HOW TO TAKE A SCREENSHOT PROBLEM DESCRIPTION: How do I take an error screenshot? SOLUTIONS: If you've got a problem with a Windows program, you may wonder how to show the errors you're receiving. Luckily, taking a screenshot of yo...
TROUBLESHOOTING - HOW TO ADJUST THE VALUE OF A STOCK ITEM WITHOUT CHANGING THE STOCK QUANTITY PROBLEM DESCRIPTION: Can I adjust the value of a stock item without changing the stock quantity? SOLUTIONS: Yes, you can adjust the value of a stock item ...
TROUBLESHOOTING - MS ACCESS CRASHES HARD ON DATE QUERY PROBLEM DESCRIPTION: I've linked all the QODBC tables into an Access 2010 DB. I have created table subset queries on the original tables and would like to do selects based on date ranges - other thi...
TROUBLESHOOTING - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM A THE CUSTOMER TABLE PROBLEM DESCRIPTION: How do I access the alternate email address 1 and 2 and the cc email fields? I don't see them at the customer table. SOLUTIONS: You can get CC ...
TROUBLESHOOTING: UPDATE QUERY SCANNING ALL RECORDS IN LINKED SERVER PROBLEM DESCRIPTION 1: I am using an MS SQL-linked server with QRemote. I am updating a single EstimateItemLine, passing Ref Number and ItemFullName (I also tried itemtxnlineid). Every...
HOW TO USE QLIKVIEW WITH QODBC To use QlikView with QODBC, please follow the below steps. 1. Open QlikView & Create the new file. 2. Select Data Source. Click on Browse. 3. Please select the MS Excel file & click "Next." 4. Click "Next. 5. Save...
PROBLEM DESCRIPTION: How can I trace the XML sent to/from QuickBooks by QODBC? SOLUTION: You can trace XML by the below steps: 1) Turn on Detail Trace from: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source...
PROBLEM DESCRIPTION: When trying to connect to QuickBooks using QODBC Test Tool, I am facing the error : QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused SOLUTION: Please first keep QuickBoo...
HOW TO INSERT OPENING BALANCE IN CUSTOMER TABLE USING QODBC PROBLEM DESCRIPTION Initially, I received the error "[QODBC] Field not allowed in insert" when I tried to insert data into the Customer table through QODBC. I was trying to insert customer d...
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 Run VB Script on 64-bit Operating System INSTRUCTION: When running the VB Script on the 64-bit system, if you directly run the Script by double-clicking the vbs file, the system will run the VB Script as 64-bit. Then QODBC will report an error l...
HOW TO VIEW QODBC DRIVER DIGITAL CERTIFICATE QODBC Driver does have a digital certificate. To verify or know more about Digital Certificate details, Please right-click on fqqb32.dll/properties in the Windows>System 32/SysWow64 Directory. Below are det...
PROBLEM DESCRIPTION Fields related to Balances and QuantityOnHand show a Null or Missing Value, whereas QuickBooks shows the correct information. e.g., When using the below query with Optimizer On, it does not show the detail, but when Optimizer is tur...
HOW TO FIND OPTIMIZER FILE INSTRUCTIONS When the optimizer is on, QODBC automatically creates an opt file to store the optimized data. When you reset the QODBC optimizer, deleting the opt file is required. But we have received some reports that opt file...
Transaction or TimeTracking table is blank or not showing any data TRANSACTION OR TIMETRACKING TABLE IS BLANK OR NOT SHOWING ANY DATA INSTRUCTIONS Sometimes you can successfully connect to QuickBooks, but the QuickBooks Application shows no response w...
HOW TO LOCATE LOG FILES OF QODBC FOR TROUBLESHOOTING NOTE: The QODBC message, SDK message, and Detail Trace Log file could help locate the issue of QODBC itself quickly. Below is an instruction on how to locate them for troubleshooting. CLEAR ALL MESSA...
INSTRUCTIONS ABOUT ASPCOMPAT Using QODBC on ASP.NET is slow when retrieving field values. "SELECT * FROM Vendor" took ASP.NET to retrieve a 3 to 5-second avg per record or row. But switching to ASPCOMPAT="TRUE" will yield 45 to 60 records per second. Re...
ERROR CODE INFORMATION FOR QODBC   QUICKBOOKS ENTERPRISE USER EXPIRED MESSAGE? CLICK HERE [HTTP://WWW.QODBC.COM/QODBCUPGRADES_FLEXQUARTERS90.HTML]   NOTE: Each qbXML response message called by QODBC can include three status attributes: statusCode, st...
Vista/Windows 7 and 64-bit and QODBC SYSTEM ENVIRONMENT Operating system: Windows Vista / Windows 7 64-bit Software: QODBC version 9.0.0.259 (32-bit) QuickBooks Enterprise Solutions 9.0 (USA Version) SUMMARY OF USING 32-BIT ODBC DRIVER ON 64-BIT...
IMPORTANT NOTE: To see how to install QODBC and connect to QuickBooks for the first time using Microsoft Windows Vista, click here: How to install QODBC in Windows XP/Vista [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2...
INSTRUCTIONS FOR ALPHA FIVE AND QODBC Alpha Five is a preferred partner of FLEXquarters.com LLC, and the Alpha Five software is an excellent choice for end users to develop web and desktop applications based on the QODBC Driver for QuickBooks. We belie...
SAMPLE CODE FOR ASP C# QODBC CONNECTION STEPS TO CREATING CONNECTION IN C# Try adding a new data source to your project by selecting DATA -> ADD NEW DATA SOURCE -> Selecting Database -> Next Clicking on the NEW CONNECTION... button -> Selecting Data S...
QODBC PERFORMANCE INSTRUCTION QODBC is a high-speed ODBC driver. The QODBC driver works with all front-end applications which can access ODBC, some of which are faster than others. The QuickBooks interface SDK, which uses XML, is not the speediest file ...
NOTE:  DCOM COMPONENT IS DEPRECATED. AS AN ALTERNATIVE TO DCOM, YOU CAN USE QREMOTE. Please refer to the articles for more information: How to configure QRemote [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2...
WHAT TO EXPECT WHEN USING THE QODBC DRIVER WITH CRYSTAL REPORTS Your QuickBooks Company File (.qbw) is a flat-file database. Having an ODBC driver will not change it to a relational database. For this reason, relating more than several tables will sever...
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 SETUP USER PROMPTED DATE RANGES IN CRYSTAL REPORTS DATE RANGE SETUP WITH CRYSTAL REPORTS X AND BEFORE SETUP AS PARAMETERS DATEFROM AND DATETO With Crystal Reports X version and before, just set up DateFrom and DateTo parameters to be used in ...