RSS Feed
Knowledgebase : TroubleShooting > Database & Company File
TROUBLESHOOTING: MS SQL REPORTING SERVICES AND QUICKBOOKS  PROBLEM DESCRIPTION I am trying to deliver reports via Microsoft's SQL Server 2005 Reporting Services. I have a Windows 2003 server with QuickBooks 6 and the latest QODBC driver using DCOM. I ...
TROUBLESHOOTING: QUICKBOOKS DATA RETURN AS NULL(NVARCHAR ONLY) WITH SSIS PROBLEM DESCRIPTION We are using QODBC driver for connecting QuickBooks with SSIS. I can able to connect with QuickBooks through SSIS. But Quick books Ex: LIST ID) nvarchar data c...
TROUBLESHOOTING: ERROR IN DCOM INSTANCE IN W2003 SERVER PROBLEM DESCRIPTION I'm using Windows Server 2003 system. When I try to create a linked server from SQL 2008 express it fails and from the SDK messages, I see the error as remote client can't be ...
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...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING. PROBLEM DESCRIPTION: When I run report query, query works very slow & take about 1-5 mins per simple report like: "sp_report ARAgingSummary show Current parameters DateFrom={d'2014-11-12'}, Dat...
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 app...
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 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 withou...
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 - HOW TO VERIFY IF OPTIMIZER FILE CORRUPTED OR NOT PROBLEM DESCRIPTION: Is there any way 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...
TROUBLESHOOTING - HOW TO USE DATE() AND DATEADD() FUNCTION IN QODBC PROBLEM DESCRIPTION: I want to write some select statements on both InvoiceLine and SalesReceiptLine that returns all records dated WITHIN the past 30 days, relative to whatever TODAY ...
HOW TO USE QXL STEP 1 - DOWNLOAD QXL If you haven't already downloaded QXL, do it now by going to the download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/]. Don't forget to read the "Readme" file during installation for the latest infor...
TROUBLESHOOTING - GETTING MULTIPLE-STEP OLE DB OPERATION GENERATED ERRORS IN SQL SERVER PROBLEM DESCRIPTION: Trying to insert into SalesOrderLine and getting a 'Multiple-step' error. INSERT INTO QBREMOTE...SalesOrderLine (CustomerRefListID, TemplateR...
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...
EXAMPLES OF CREATING INVOICE USING QREMOTE FROM SQL SERVER NOTE: For multi-line invoices, some may find it easier to NOT include the header information with each line item, but rather to have separate smaller commands for the Invoice Lines and a final ...
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 loca...
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 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...
HOW TO USE QODBC WITH WINDOWS SCHEDULER /  HOW TO USE Z-CRON WITH QODBC / HOW TO RUN QODBC APPLICATIONS ON A REPEATING/NIGHTLY BASIS PROBLEM DESCRIPTION 1: My application needs read data from QuickBooks and update data in SQL server, up-to this I can ab...
PROBLEM DESCRIPTION: How can I add blank InvoiceLine in QuickBooks using QODBC? SOLUTION: You can create an empty Invoice, neither in QODBC nor QuickBooks. But in QuickBooks, you could leave lines blank and just make sure there is at least one line wi...
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: 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 Admi...
PROBLEM DESCRIPTION: How to insert employee time information from MS Excel time spreadsheet into QuickBooks using QODBC SOLUTION: You cannot perform insert/update operation directly in MS Excel because Excel is just exporting table in the spreadshee...
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 - QUICKBOOKS ADVANCED INVENTORY MODULE IN QODBC PROBLEM DESCRIPTION: Does your enterprise driver support the advanced inventory module for QuickBooks enterprise? Would we be able to query stock per item, per location? SOLUTION: You...
TROUBLESHOOTING - 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...
HOW TO CONNECT TO QUICKBOOKS ONLINE SANDBOX COMPANY FILE. For installation & configuring QODBC Online to work with QuickBooks Online live company file. Please refer: How to use QODBC Online with QuickBooks Online Edition (Apps.com) [http://support.flex...
TROUBLESHOOTING - 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 th...
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...
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...
HOW TO CREATE OR CONFIGURE A QODBC ONLINE DSN PROBLEM DESCRIPTION: I have one QuickBooks Online login, which provides access to multiple QuickBooks Online companies. When I initially configured the connection, I selected one of the clients that I hav...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code which reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV u...
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 - HOW CAN I GET LAST ITEMS SOLD TO CUSTOMER DETAILS PROBLEM DESCRIPTION: I was able to create a report using a customer set with the customer as the parent and InvoiceLine as the child giving me items ordered in the past. My problem ...
TROUBLESHOOTING - HOW CAN I GET LINKS BETWEEN ESTIMATE AND INVOICE USING QODBC PROBLEM DESCRIPTION: I've explored the related-to fields, but cannot determine how a line on the invoice is linked back to the estimate. I'm designing a report that needs...
TROUBLESHOOTING - HOW CAN I USE WILDCARD (*) WITH CRYSTAL REPORT AND SP_REPORT PROBLEM DESCRIPTION: I am using the following sql statement: sp_report JobProfitabilityDetail show AmountActualCost_Title, AmountActualRevenue_Title, AmountDifferenceActu...
TROUBLESHOOTING - HOW 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'...
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...
HOW TO SHARE/INVITE FLEXQUARTERS SUPPORT TEAM TO QUICKBOOKS ONLINE COMPANY FILE PROBLEM DESCRIPTION: How do I share/invite FLEXquarters Support team to access my QBO company file? SOLUTION: Please follow below steps to share/invite FLEXquarters Sup...
TROUBLESHOOTING - TRYING TO UPDATE ITEMINVENTORYASSEMBLYLINE TABLE PROBLEM DESCRIPTION: I am using MS Access connected to QuickBooks via QODBC. I am using queries in MS Access to load/synchronize Inventory data from my master inventory list, which is ...
TROUBLESHOOTING - HOW DO I SEE BACKORDER ITEMS THAT HAVE BEEN INVOICED BUT NOT SHIPPED PROBLEM DESCRIPTION: Could someone kindly provide me with a sample, or is there a stored procedure that would allow me to only pull out back ordered invoices from t...
TROUBLESHOOTING - QODBC LOGGING IN WITH WRONG USER ACCOUNT PROBLEM DESCRIPTION: I am using ms access. I have the integrated application certificate set up correctly (see screenshot). The username for this certificate is "odbc". QuickBooks is closed. ...
TROUBLESHOOTING - DSN CONNECTION NOT CONSISTENT ACROSS MULTIPLE COMPUTERS PROBLEM DESCRIPTION: I have a pass-through query for access: Select * from Item The connection string is as follows: ODBC;DRIVER={QODBC Driver for QuickBooks};SERVER=QODBC;DF...
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...
TROUBLESHOOTING - CHANGES TO THE INTEGRATED APPLICATION AUTHENTICATION FOR QUICKBOOKS Intuit is reinforcing existing security features that help protect QuickBooks customers' sensitive information. Refer: Intuit's News: Changes to the Integrated Applic...
TROUBLESHOOTING - CONNECTION SERIAL, LIMITATION, QUEUE AND UPPER LIMIT PROBLEM DESCRIPTION: How many concurrent connections does the Server edition support? Is the product QB version specific, requiring additional purchase with each version. AKA. Up...
TROUBLESHOOTING - CODE DIFFERENCES BETWEEN QODBC DESKTOP AND QODBC ONLINE PROBLEM DESCRIPTION: I have an MS Access application using QODBC to connect to desktop QuickBooks. Can I use the QODBC Online driver to connect to QuickBooks Online without chan...
TROUBLESHOOTING - REPORTING SHIP TO ADDRESSES PROBLEM DESCRIPTION: Has anyone run a report that will pull all the detail for a range of invoices? In particular, I'm looking to run a report that shows the ship to addresses for particular products over ...
TROUBLESHOOTING - HOW TO CLOSE SQL LINKED SERVER CONNECTION PROBLEM DESCRIPTION: We are using QRemote with SQL Linked Servers with several different QuickBooks files. How can we close the connection to a QuickBooks file after the query has run, then o...
TROUBLESHOOTING - HOW TO GET ADVANCED PRICING MODULE IN QODBC PROBLEM DESCRIPTION: We are using advanced pricing module in QuickBooks and would like to know what tables we need to access to pull that information from the system. SOLUTION: Advanced ...
TROUBLESHOOTING - QODBC RECORD SET ISSUE PROBLEM DESCRIPTION: I am using below code it is returning records & giving me the correct result. But If I change query from "SELECT Name FROM customer" to "SELECT * FROM customer" it does not return any recor...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL PACKAGE PROBLEM DESCRIPTION: I am getting Error SOCKET Closed because of abnormal package in QRemote client. I am accessing QuickBooks Data from the remote machine over the internet (WA...
CONNECTING MULTIPLE QUICKBOOKS COMPANIES VIA EXCEL Download Sample [http://support.flexquarters.com/esupport/newimages/MultipleCompany/MultipleQBCompanyConnection.zip] There is a limitation with the QuickBooks SDK that it can connect only 1 company fil...
HOW TO INSERT INVOICE USING EXCEL - VBA Download Sample [http://support.flexquarters.com/esupport/newimages/InsertInvoiceVBA/Insert_Invoice.zip] In this example, We will show you that How to insert Invoice in QuickBooks using the data available in Exce...
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 USE POWERSHELL WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/PowerShell/DisplaySQL.zip] SAMPLE CODE FOR USING QODBC DSN: $connectstring = "DSN=QuickBooks Data;" $sql = "Select TOP 10 Name from Customer" $conn ...
HOW TO USE QODBC SUPPORT WIZARD PROBLEM DESCRIPTION: How to use QODBC Support Wizard? SOLUTION: Please follow below-listed steps for using QODBC Support Wizard. "QODBC Support Wizard" application is included with QODBC v18.0.0.325 and above. In cas...