RSS Feed
Knowledgebase : TroubleShooting > Data & Table
TROUBLESHOOTING: CAN SELECT BUT GET ERRORS WHEN INSERT/UPDATE/DELETE RECORDS PROBLEM DESCRIPTION Can successfully run the SELECT query to get records but get errors when trying to edit, create or delete records. SOLUTIONS CHECK RIGHTS First, mak...
TROUBLESHOOTING: QODBC SLOW OR FAILS ON LARGE INVOICELINE DATASET PROBLEM DESCRIPTION 1 I have tried several ways (unsuccessfully) to get a complete data dump of the InvoiceLine data from QB Ent. 6 Mfg. Ed. There are over 100K records in that data set...
TROUBLESHOOTING: CUSTOM FIELDS VALUE ARE BLANK AFTER ADDED TO THE TABLE PROBLEM DESCRIPTION When recently added Custom Fields to the Purchase Order. The fields show up in the PurchaseOrderLine table as CustomFieldPurchaseOrderLineTEST, CustomFieldPurch...
TROUBLESHOOTING: ITEM NOT PROPERLY LINKED TO AN ACCOUNT PROBLEM DESCRIPTION When cross-referencing Items to the Account table using the 6 different account listID related fields listed here: http://doc.qodbc.com/qodbc/20/tables/table_relations_us726...
The Template Type Problem When Creating a Sales Order TROUBLESHOOTING: THE TEMPLATE TYPE PROBLEM WHEN CREATING A SALES ORDER PROBLEM DESCRIPTION QUERY IN VB DEMO Here is a query, its function is to create a sales order line. INSERT INTO "SalesOrd...
TROUBLESHOOTING: GETTING A 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 ar...
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 trying 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 me...
TROUBLESHOOTING: TIMETRACKING / TRANSACTION TABLE IS BLANK PROBLEM DESCRIPTION: The TimeTracking / Transaction table always return null/ no rows as a result. Tried to reset QODBC optimizer, but doesn't work. SOLUTION: Please update your QuickBooks ...
PROBLEM DESCRIPTION: Trying to change the cost of an assembly using the following query: UPDATE Item set SalesPrice = 1500.00, PurchaseCost = 700 where Name = 'Blueprints'; It fails with the error: "error: [QODBC] Not supported or UPDATE the price ...
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 amou...
TROUBLESHOOTING: QODBC HANGS WHEN TRYING TO EXECUTE QUERY OR VIEW TABLES PROBLEM DESCRIPTION: When executing a simple query like: SELECT * FROM Invoice Application and QuickBooks will both get hang, and it Does Not Respond. Then After, the applic...
PROBLEM DESCRIPTION: I am attempting to add InvoiceLine records to a sample company. I exported 15 InvoiceLine records from QuickBooks via QODBC, then built a table with these records trimmed down to what I believe are the minimum required fields, then a...
PROBLEM DESCRIPTION: I am trying to insert data into Invoice table but QODBC is not allowed me to write data in the Invoice table. 20131202.172908 E 2792 InvoiceStorage::DoAdd Cannot set unassigned RSB in transaction line item(s). QuickBooks error mess...
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 crea...
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. The user can see QBReportAdminGroup and other tables in MS ...
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 ...
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 - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM 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 Email ...
TROUBLESHOOTING - MS ACCESS CRASHES HARD ON DATE QUERY PROBLEM DESCRIPTION: I've linked all the QODBC tables into an Access 2010 DB. I have created table subset queries on the original tables and would like to do selects based on date ranges - other thi...
TROUBLESHOOTING - MULTIPLE TABLES EXIST ERROR IN LINKED SERVER PROBLEM DESCRIPTION: I am trying to run a query using an SQL Server database link to QuickBooks using QRemote. I can set up the linked server fine in SQL Server and the connection has been t...
QODBC ONLINE FOR QUICKBOOKS ONLINE - KNOWN ISSUE(S)/LIMITATION(S) Table Invoice, InvoiceLine, InvoiceLinkedTxn may have the initial performance issue, but after the full load, the subsequent queries should perform well. ARAccountRefFullName , ARAccoun...
TROUBLESHOOTING - CANNOT USE ALIAS IN MS QUERY PROBLEM DESCRIPTION: I am getting the below error message when trying to SELECT data fields AS Alias, the statement runs fine otherwise. [sql syntax error] Expected lexical element not found:= Please se...
TROUBLESHOOTING - GETTING [QODBC] NOT SUPPORTED ERROR WHEN TRY TO MODIFY TXNDELETED TABLE PROBLEM DESCRIPTION: I am trying to modify the TxnDeleted table from QuickBooks in QODBC but getting "[QODBC] Not Supported" error. SOLUTIONS: The TxnDeleted t...
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 sending...
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 autom...
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 can ...
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 ...
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 select a...
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...
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 Order...
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 - 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 informatio...
EXAMPLES OF CREATING INVOICE USING QREMOTE FROM SQL SERVER NOTE: For multi-line invoices, some may find it easier to NOT include the header information with each line item, but rather to have separate smaller commands for the Invoice Lines and a final ...
HOW TO USE QODBC ONLINE WITH QLIKVIEW To use QlikView with QODBC Online, please follow the below steps. 1. Open QlikView & Create the new file. 2. Select Data Source. Click on Browse. 3. Please select MS Excel file & click "Next". 4. Click "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 ...
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 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 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...
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 Online...
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 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 need to create about 1000 invoices per m...
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...
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...
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: 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: 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...
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...
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 - 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] 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 - 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 - 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 - INVOICE LINE RATE IS NOT LOADING INTO QUICKBOOKS ONLINE PROBLEM DESCRIPTION: The InvoiceLineRate value passed in the insert query to create the InvoiceLine record is not being loaded into QBO. Below are the two queries I am using to...
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 - 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 AN 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 it...
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 these details? SOLUTION: You can use ...
TROUBLESHOOTING - HOW DO I DELETE ORPHANED INVOICELINE RECORDS? PROBLEM DESCRIPTION: The InvoiceLine table contains orphan records (the parent invoice record no longer exists). I tried: DELETE FROM Invoice WHERE TxnID = 'xxxx-xxxxxxxxx' the TxnID is...
TROUBLESHOOTING - HOW DO I GET TIMEFRAME INFORMATION - SALES BY HOUR REPORTING USING QODBC PROBLEM DESCRIPTION: This is a no technical question but one I need to answer myself before jumping into QODBC. I'm considering start working with QODBC to get ...
TROUBLESHOOTING - HOW DO I VOID AN INVOICE? PROBLEM DESCRIPTION: How do I void an Invoice? And How do I query for invoices that have been voided? I don't see any kind of indicator in the Invoice table. SOLUTION: You can use SP_VOID just like you wo...
TROUBLESHOOTING - HOW TO COMPUTE SUM WITHOUT COMPUTE CLAUSE PROBLEM DESCRIPTION: The following select gives me the right data using DISTINCT, but then how do I get a sum of it, which is what I need? select distinct billtopayduedate, billtopayrefnumb...
TROUBLESHOOTING - HOW TO STOP ANY QUERY ON VB DEMO APPLICATION PROBLEM DESCRIPTION: How to Stop any query on VBDEMO when it takes time. How to convert the date to QuickBooks date. I want to insert TxnDate in the ReceivePayment table, but it pops u...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code which reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV u...
HOW TO USE QODBC WITH MS EXCEL POWER QUERY NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one click wi...
TROUBLESHOOTING - WHERE IS THE BIN LOCATION FOR ITEMS STORED? PROBLEM DESCRIPTION 1: I am using QuickBooks Enterprise with Advanced Inventory enabled. I am trying to find where the bin location for items is stored in QuickBooks through QODBC. PROBL...
TROUBLESHOOTING - BILLABLE PAYROLL - NEED TO DISPLAY MORE FIELDS ON INVOICE PROBLEM DESCRIPTION: We need to bill all payroll costs to various customers. Payroll costs are defined as all of the following: 1. Employee's gross salary 2. Company share ...
TROUBLESHOOTING - CORRELATED SUBQUERIES IN UPDATE STATEMENT PROBLEM DESCRIPTION: I would like to update the salesrep field in my existing invoices. I would like to use the salesrep value that is stored in the Customer file. I would normally do this in...
TROUBLESHOOTING - HOW TO EXTRACT PRINTED CHECKS INFORMATION USING QODBC PROBLEM DESCRIPTION: We are involved in a new project with our bank involving a 'Positive Payment' solution that requires I send them a file with the check summary data each time ...
TROUBLESHOOTING - HOW CAN I GET LAST ITEMS SOLD TO CUSTOMER DETAILS PROBLEM DESCRIPTION: I was able to create a report using a customer set with the customer as the parent and InvoiceLine as the child giving me items ordered in the past. My problem ...
TROUBLESHOOTING - HOW CAN I GET LINKS BETWEEN ESTIMATE AND INVOICE USING QODBC PROBLEM DESCRIPTION: I've explored the related-to fields, but cannot determine how a line on the invoice is linked back to the estimate. I'm designing a report that needs...
TROUBLESHOOTING - HOW CAN I USE WILDCARD (*) WITH CRYSTAL REPORT AND SP_REPORT PROBLEM DESCRIPTION: I am using the following sql statement: sp_report JobProfitabilityDetail show AmountActualCost_Title, AmountActualRevenue_Title, AmountDifferenceActu...
TROUBLESHOOTING - HOW DO I GET TABLE RECORD COUNT FASTEST WAY USING QODBC PROBLEM DESCRIPTION: What is the fastest way to get the number of records from a table? SOLUTION: QODBC would need to scan the whole table to get the record or row count. So ...
TROUBLESHOOTING - ODBC DRIVER DOESN'T SUPPORT THIS STATEMENT. UPDATING EXISTING RECORD PROBLEM DESCRIPTION: I'm trying to programmatically make Inventory Items In-Active after a sale or Active after voiding a sale. I would have thought that the foll...
TROUBLESHOOTING - HOW TO USE BETWEEN IN QODBC PROBLEM DESCRIPTION: I need to use Between, in range of dates to return new customer in one period, I try this: SELECT FullName FROM Customer Where TimeCreated Between {d'2007-12-18'} AND {d'2007-12-19'...
TROUBLESHOOTING - UPGRADING TO QUICKBOOKS AND QODBC PROBLEM DESCRIPTION: I have a custom program written in Access 2003 communicating with QuickBooks 2013 using QODBC 13 which works fine. Will upgrading to latest QuickBooks and QODBC require any code ...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE BOUNDS OF THE ARRAY." WHEN USING IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I just recently installed QODBC to try to get data out of a QuickBooks company file but I get this error: "...
TROUBLESHOOTING - HOW DO I UPDATE CUSTOMER CUSTOM FIELDS PROBLEM DESCRIPTION: How do I update Customer custom fields? SOLUTION: You can update Customer custom fields using the update query. For Example: Update Customer Set CustomFieldContract='QO...
TROUBLESHOOTING - QREMOTESERVER HANG ON CONNECTION PROBLEM DESCRIPTION: I am trying to connect to QuickBooks/QuickBooks POS using QRemote Server, But QRemoteServer is Hang on Connection. SOLUTION: Please check if QuickBooks Or QuickBooks POS is hav...
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...
SAMPLE CODE FOR C++ WITH QODBC #include #include #include #include #include #include #include #include using namespace std; void ConvertTimeStampStructToString(TIMEST...
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...
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 ...
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 - 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...
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...
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...
TROUBLESHOOTING - UPDATE FROM A SELECT STATEMENT NOT WORKING PROBLEM DESCRIPTION: I am trying to update records through the select statement. But it is not working. UPDATE Customer SET CustomFieldProjectNumber = i.JobNumber FROM ( SELECT ListID, {fn...
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 ...