Problem Description:

I would like to purchase a new QuickBooks 2024 standard license - no subscription

Solution:

 Businesses that need new or extra licenses for QuickBooks Desktop Pro Plus 2024 can purchase them from resellers or trusted marketplaces.

One option is the StackSocial deal for a 1-user Windows license:

https://www.stacksocial.com/sales/intuit-quickbooks-desktop-pro-plus-2024-1-user-for-windows-lifetime-license

Once purchased, you’ll receive a license key and product number used to activate the software during installation.

Problem Description:

I want to get copies of invoices.

Solution:

Proforma Invoice

Please visit the following link: https://flexquarters.onfastspring.com/account.

Input the email address associated with your license.

Check your email inbox, and you should receive an email with the subject:

<Your Fullname>, here is a link to manage your orders

From: FastSpring Checkout <mailer@fastspring.com>

Click the link received to manage your account.

The link (URL) should look like https://flexquarters.onfastspring.com/account/somerandomtext.

Click the Manage icon and then click Proforma Invoice.

The Proforma invoice will be generated and will be opened in a new tab.

Please ensure you click Allow pop-up so that a new tab can be opened.

Past Invocies:

Please check your email inbox for Invoices received from FastSpring.

If you need any specific Invoice that you are unable to find in your mailbox, please email us the following details.

Your Order ID:  or QODBC CDKEY:

Product Name:

Invoice Month:

Please raise a support ticket and submit the requested information.

https://support.flexquarters.com/esupport/index.php?/Tickets/Submit

Tags: QuickBooks Online, QBO, Subscription QODBC Online, Cancel subscription

Problem Description:

Since we’re dealing with a lot of sensitive data, is QODBC SOC 2 compliant for the IRS?

Solution:

A common concern when working with sensitive financial data is whether the software in use complies with recognized security standards such as SOC 2 (often referenced in the context of IRS requirements). Customers often ask if the QODBC Driver is SOC 2 compliant.

This concern arises from the assumption that QODBC transmits or stores QuickBooks company file data outside the local environment. However, this is not the case.

• The QODBC Driver does not send QuickBooks company file data to any QODBC server.

• All processing occurs locally on the user’s computer where QuickBooks is installed.

• The optimizer file, which improves query performance, is stored only in the local directory. Furthermore, this file is encrypted, ensuring that sensitive data cannot be accessed in plain text.

Therefore, the typical risks associated with hosted or cloud-based solutions—such as third-party storage, transmission, or centralized processing - do not apply to QODBC.

SOX Compliance

The Sarbanes-Oxley Act (SOX) is designed to regulate financial practices and corporate governance for publicly traded companies. Since QODBC is not operated by a publicly traded company, SOX compliance is not mandatory.

Reference: SOX Compliance Overview

SOC 2 Compliance

SOC 2 compliance focuses on service providers that store, process, or manage customer data. It evaluates how such providers handle data security, availability, processing integrity, confidentiality, and privacy.

In the case of QODBC:

• No customer data is transmitted or stored on QODBC servers.

• All data processing is performed locally on the end user’s environment.

• The QODBC team does not access, manage, or retain QuickBooks company data in any form.

Because QODBC does not operate as a hosted or managed data-processing service, SOC 2 compliance does not apply to its operations.
Reference: SOC 2 Compliance Explained 

QRemote

Please use an encrypted mode of data exchange when using QuickBooks Data remotely.

Please refer to Important Notice About Data Security - QRemote Security, Best Practices, and Recommendations

Download Sample

Sample Code for using QODBC DSN:

# Array of ListIDs to be updated

$listIDs = @(
"20",
"21",
"22"
)

# Define the DSN name
#$dsnName = "QuickBooks Data"
#$dsnName = "QuickBooks Online Data"

# Add your DSN name here
$dsnName = "Your DSN Name"

Write-Output "Connecting to $dsnName"

# Build connection string
$connStr = "DSN=$dsnName;"

# Create a new ODBC connection
$conn = New-Object System.Data.Odbc.OdbcConnection
$conn.ConnectionString = $connStr

try {
# Open the connection
$conn.Open()
Write-Output "Connected to DSN: $dsnName"

Write-Output "Updating records."
foreach ($listID in $listIDs) {
#Prepare the SQL statement
# Either use ifnull or use the 2nd SQL statement
$sql = @"
UPDATE Account SET Description = {fn IFNULL(Description, '')} + '.' WHERE ListID = '$listID'
"@

# Prepare the SQL statement
$sql = @"
UPDATE Account SET Description = Description + '.' WHERE ListID = '$listID'
"@

Write-Output "SQL statement: $sql"
# Create command
$cmd = $conn.CreateCommand()
$cmd.CommandText = $sql

try {
# Execute the update
$rowsAffected = $cmd.ExecuteNonQuery()
Write-Output "Updated ListID: $listID ($rowsAffected rows affected)"
} catch {
Write-Error "Error updating ListID: $listID - $_"
}
}
}
catch {
Write-Error "Could not connect to ODBC DSN: $dsnName - $_"
}
finally {
# Close the connection
if ($conn.State -eq 'Open') {
$conn.Close()
Write-Output "Connection closed."
}
}

Script execution & Result:

For 32-Bit Driver

Open Windows PowerShell (x86) from the start menu:

For 64-Bit Driver

Open Windows PowerShell (x64) from the start menu:

or

Open Windows PowerShell from the start menu:

Navigate to your PowerShell script folder:

Run your PowerShell script:

Result:

Problem Description:

I would like to use the new QuickBooks integrator module from Bookkeeper to allow me to import data directly into Bookkeeper.

Solution:

1. Create a New Company in Bookkeeper

• Launch Bookkeeper and create a new company (this will be the target for the QuickBooks data).

• Choose the standard setup.

• Enter basic company info (it will be overwritten during import).

• Set:

  • Accounting method (irrelevant, will be replaced).

  • Next fiscal year end.

  • Advanced Payroll (ensure this is selected).

• Set a password.

• Select “Import from QuickBooks” and click Import.

 Please ensure you have downloaded and installed the "QuickBooks Integrator tool"

2. Prepare the Bookkeeper Database for Integration

• Click “Prepare Integration” in Bookkeeper.

• Ensure you have taken a backup of your Bookkeeper database.

• Bookkeeper will copy the integration tool to the Integration folder and will shut down the Bookkeeper application.

• This will copy the database to a staging area for the integrator module.

3. Open QuickBooks

• Start QuickBooks and log in to the QuickBooks company file as QuickBooks user "Admin".

• Important: Do not run QuickBooks as an administrator.

   

4. Open the QuickBooks Integrator Module

• Double-click on the QuickBooks Integration tool from the Desktop

• Important: Do not run QuickBooks as an administrator.

• Click the "Connect" button.

• When prompted by QuickBooks, allow access and confirm the connection.

• You should see the QuickBooks company name.

5. Connect to Bookkeeper

• Click “Connect” in the Integrator to connect to the Bookkeeper company you created.

• Select the correct company from the dropdown list if needed.

• Select the Bookkeeper company from the list.

6. Configure Import Options

• Optionally select a start date to limit historical data.

• By default, company info, bank accounts, and chart of accounts are imported.

• Choose whether to import:

  • Transactions

  • Lists (customers, vendors, etc.)

• Click “Start” to begin the import.

   

7. Monitor the Import Process

• The integrator will show status messages and record counts.

• Large datasets may take hours, depending on size.

• Let the process complete fully.

8. Finish Integration in Bookkeeper

• After completion, close the integrator module.

• Launch Bookkeeper from the desktop. Right click on the Bookkeeper shortcut icon and click Run as Administrator.

• Go to File > Import > Complete Integration.

• This copies the staged database back into Bookkeeper.

• This copies the staged database back into Bookkeeper.

• The Bookkeeper application will restart.

9. View Imported QuickBooks Data

• Reopen Bookkeeper (Run as Administrator).

• Log in with your set password.

• You’ll now see all your QuickBooks data:

  
  

  • Bank accounts

  • Customers

  • Vendors

  • Transactions

 Important Tips

• Don’t run QuickBooks or the Integrator as Administrator.

• Run Bookkeeper as Administrator only during the final import step.

• Be selective with data to import to save time and avoid performance issues.

Problem Description:

QODBC stopped working this morning, and I got a message that / License verification is required.  I opened License Sync and hit the "Sync Now" button. It seems like something might be happening, but I get no message of any sort popping up, and QODBC still has the message that license sync needs to be run. How can I resolve this?

Problem Description:

Where/How do I use License sync to verify my QODBC license?

Solution:

Solution applicable to "QODBC for QuickBooks Desktop":

Problem Description:

When I connect to QODBC, I am prompted to free disk space.

Solution:

Please ensure you have 1 GB of free space in your primary drive where your Windows Profile / Roaming Profile or QODBC Optimizer folder is saved.

Ideally it is "C" Drive

Location

%appdata%\QODBC Driver for QuickBooks

Example

C:\Users\YourWindowsUserName\AppData\Roaming\QODBC Driver for QuickBooks

On your C Drive, you should have 1 GV free space available.

Alternatively, you can turn off the optimizer from QODBC 32-Bit Setup Screen.

Problem Description:

What should be the Default Windows User Access Control (UAC)?

Solution:

The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security settings.

UAC (User Account Control): This new technology in Windows Vista has been used to improve system security. It asks all users permission to run programs and tasks under a standard account module. It can prevent the installation of programs without authentication and contain an inappropriate system setup change from a regular user.

Please open the Windows start menu and type or search for "Windows User Access Control" (UAC)

Please set the default value of Windows User Access Control (UAC) to the following (as per your Windows Operating system edition).

Windows 10 and Windows 11

Windows 7

Start -> Control Panel -> User Account -> Open "User Account Control" (UAC) -> Change User Account Controls

Please Also Refer: Connecting QODBC Driver to QuickBooks for the First Time (Video)

Problem Description:

I want to cancel my QODBC Driver for QuickBooks Desktop monthly subscription.

How do I cancel the subscription to QODBC Driver for QuickBooks Desktop?

Solution:

Start QuickBooks and log in to the QuickBooks company file as QuickBooks user "Admin".

Connect to QuickBooks Data using the QODBC 32-bit Test Tool.

Execute the following SQL statement.

sp_optimizefullsync TableName

example

sp_optimizefullsync Customer
or

sp_optimizefullsync Vendor

or

sp_optimizefullsync Invoice

Tags: QuickBooks Desktop, QBD,Desktop Subscription QODBC Desktop, Cancel subscription

Start QuickBooks and log in to the QuickBooks company file as QuickBooks user "Admin".

Connect to QuickBooks Data using the QODBC 32-bit Test Tool.

Execute the following SQL statement.

sp_optimizefullsync TableName

example

sp_optimizefullsync Customer

or

sp_optimizefullsync Vendor

or

sp_optimizefullsync Invoice

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 statement to insert data into the VendorCredit table

Insert into VendorCreditItemLine(RefNumber,VendorRefListID,APAccountRefListID,TxnDate,PrivateNote,ItemLineItemRefListID,ItemLineMemo,ItemLineQuantity,ItemLineRate,ItemLineAccountRefListID,ItemLineCustomerRefListID,FQSaveToCache)
Values('TestRef','98','165',{d'2021-11-01'},'New building','36','Installation',15,100,'231','59',0)

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 application. You need to use QRemote 64-Bit and configure it to use ODBC Compatibility 3.8.

64 and 32-bit worlds are kept totally separate in the Microsoft Windows Operating System. QuickBooks is a 32-bit application, so in order to communicate with it, a 32-bit ODBC driver is required.

Since a 64-bit application cannot talk to a 32-bit driver, we have to do a bit of magic to get the worlds to connect, we call it QRemote. QRemote works as a bridge between 64-bit Applications and the 32-bit QODBC Driver by communicating data calls between the two worlds using TCP/IP protocol. QRemote makes it possible for 64-bit Web Servers and 64-bit applications to talk to QuickBooks live for the first time via the QODBC Driver.

QRemote has two components “QRemote Client Driver for QODBC” and “ QRemote Server for QODBC”

QRemote Client Driver: Allows 64-bit Applications to connect to QRemote Server and sends the Request to QRemote Server for Processing.

QRemote Server: Processes requested instruction from QRemote Client to QuickBooks using QODBC DSN Driver.

Setting Up a New QRemote Connection.

Start “QRemote Server for QODBC” from the start menu.

Double click on the QRemote Server icon from the system tray.

QRemote Server Main screen will appear that shows the IP address, and Port allows the QRemote Client to connect to.

Make a note of the IP address and port number listed on the QRemote Server "Event Logs window".

Create a new DSN entry

o Before creating A DSN entry, verify you have created a DSN entry for QODBC, which can connect to QuickBooks. 

Configure the default 64-bit DSN/or Create a new 64-bit DSN

Navigate to Start Menu, QODBC Drivers for Use with QuickBooks, and click on

"Configure QODBC Data Source 64-bit" 

Navigate to System DSN and select "QuickBooks Data 64-bit QRemote" DSN and click on Configure.

Note: "QuickBooks Data 64-bit QRemote" is the default DSN created when installing QODBC.

o Under the "QuickBooks Data 64-bit QRemote"- Client DSN configuration screen, Please fill in the following information

· Data Source Name: Name of your DSN entry

· Server: IP address displayed on QRemote Server

· Port: Port displayed on QRemote Server

· Encryption Key: encryption key ( keep this empty )

For the Alteryx Designer application, you need to set compatibility 3.8 in QRemote Client.

Select 3.8 from the list and click on "Ok".

Remote DSN: Select the QODBC DSN from the list. (Make sure QRemote Server is running)

After filling in all the details, click "Test Connection" to test the QRemote connection.

Test connection is successful.

Open Alteryx Designer Studio and drag the input/output connection and drop in the workflow screen.

Select Input connection and click on "Connect a file or Database".

From the Data Souce list, select "Generic ODBC connection".

From the Data Source name, select "QuickBooks Data 64-bit QRemote" DSN and click on "Ok".

Navigate to Tables tab and select any table from the list and click on "Ok" button.

Click on "Output Data" connection and select "Write to File or Database".

You can select any type of file connection from the screen.

Navigate to "Files" and select the "Microsoft Excel 1997-2003 .Xls"

In the dialog box, provide the file name and click on "Save".

Now, the input/output connection is ready.

Click on "Run" button.

After running the workflow successfully, the customer data will be exported to the targeted MS Excel file.

Open your MS Excel file.

Tags: Dynamic IP Address, QRemote IP Address changes, Random QRemote IP Address, 

Problem Description:

I am fetching one year of data from the QuickBooks Online General Ledger report using QODBC Online.

I get partial data/incomplete data. The expected is 30,000 records, but I got only 12910records.

Solution:

QODBC Online is able to access data from QuickBooks Online using the QuickBooks Online API, which is an embedded feature of the QuickBooks Online Application.
QODBC Online can only use those fields and commands which are allowed by the QuickBooks Online API.

Any data row limit or API limitation/restrictions of QuickBooks Online API are applicable to QODBC Online.

Please refer to the question posted on Intuit Developer Forum - 

https://help.developer.intuit.com/s/question/0D50f00004lEX6qCAG/report-qbo-api-any-limits-on-the-maximum-numbers-of-rows-in-the-response

Solution:

Please change your SQL statement to fetch 3 months' data.

 Open the "QODBC Online Test tool" from the start menu.

Once the "QODBC Online Test tool" opens, select the DSN from the list and click the "Connect" button.

Use the following SQL statement. Note: we will limit the date range to three months.

"sp_report GeneralLedger show Date, TransactionType, DocumentNumber, Client, vendor, location, class, ProductService, AccountNumber, Account, Amount, Currency, ForeignAmount parameters DateFrom={d'2022-07-01'},DateTo={d'2022-09-30'}"

Click on the "Run" button to execute the query.

Note: The above query is used as an example only.

Once you are able to fetch three-month data, fetch another three-month data by changing the DateFrom and DataTo parameters.

Example: "sp_report GeneralLedger show Date, TransactionType, DocumentNumber, Client, vendor, location, class, ProductService, AccountNumber, Account, Amount, Currency, ForeignAmount parameters DateFrom={d'2022-10-01'},DateTo={d'2022-12-31'}"

Also, refer to 

How to connect to QuickBooks Online Sandbox

[API call limits and throttles] - https://developer.intuit.com/app/developer/qbo/docs/learn/rest-api-features

Problem Description:

I would like to rename some of my bulk items (i.e., inventory items) and their related child items (i.e., assemblies) in QuickBooks Desktop.

I found several item related tables, item, iteminventory, iteminventoryassembly, and all of them seem to have the item number in the name field and full name.

I had assumed that the item name was only in the items table, but obviously, I was wrong.

So, do I have to change the name and full name in all item related tables or just the item table? I guess it would have to be all tables.

Is there anything else I would need to do?

I am fairly new to QODBC and don't want to screw up the database.

Solution:

The ITEM table is a combined (read only view) list of all Item tables in QuickBooks: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup; with minimum common fields.

Inserts and updates are actually done using the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, or ItemGroup tables.

To update a part name, we would do:

Update ItemInventory Set Name = 'New Name' where Name = 'Old Name'

or

Update ItemInventory Set FullName = 'New Name' where FullName = 'Old Name'

or

Update ItemInventory Set FullName = 'New Name' where ListID = 'Old Name'

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 complete (3).

When I try clicking on Reload All Data, I get its companion:

Reload All Data did not complete (3).

I tried resetting the optimizer, which was a suggested fix for what appeared to be a similar issue, but it did not work. What should I do?

Please advise.

Solutions

Please download the latest version of the QODBC Driver and try again.

If you still face the issue, please raise a support ticket - Click Here.

Problem Description

A trappable error (E06D7363) occurred in an external object. The script cannot continue running.

I receive this error when reading and writing data concurrently from two Internet explorer windows from an asp page. When using one browser window, the error doesn't occur. The error occurs only when there are two browsers creating connections at the same time.

Environment to reproduce the error: Windows Server OS, IIS 6.0

When running and refreshing qbcust.asp from two or more browsers located on different machines, I receive the following error message:

QODBC Customer Web List Demo Page
Preparing to Create Connection Object
ADO Connection Created
ADO Recordset Created - Opening QuickBooks Sample Company File

Provider error '8000ffff'

Catastrophic failure

/Test/qbcust.asp, line 27

---------------------end out put--------------------------------------------------------

QODBC Customer Web List Demo Page
Preparing to Create Connection Object
ADO Connection Created
ADO Recordset Created - Opening QuickBooks Sample Company File
QODBC DSN QuickBooks Data Open
ADO Recordset Open

Customer - Outstanding Balance
*****************************
Adam's Candy Shop - $40

Active Server Pages error 'ASP 0115'

Unexpected error

/Test/qbcust.asp

A trappable error (E06D7363) occurred in an external object. The script cannot continue running.

---------------------------------end output-----------------------------------------------

The above two errors do not happen every time, but about 30% of the time, one of the two browsers will crash with either one of the above error messages. The error typically doesn't occur when running from two browsers on web server. However, when running and refreshing two browsers on different machines the error is easily reproduced. I checked the qodbc message log but did not find any logs that corresponded to the time of the failure.

Please advise.

Solutions

Refer to the following articles.

If you are still facing the issue, please raise a support ticket - Click Here.

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 data without having QuickBooks installed on my development machine?

If I need to purchase QuickBooks, I will buy the latest version. Will my client's 2022 company file work with that version, or will they have to upgrade as well?

Kind Regards

Solution:

This

Accounting software is unlike other software in that governments worldwide make changes all the time in relation to taxes and how people are employed and paid. A QuickBooks 2022 format company file will be converted by QuickBooks 2023 to the new format when it's opened, and there's no backward converter.

If you are going to use that company file for development only and you will not be sending it back to your client/customer, then they need not have to upgrade either QuickBooks to 2023.

Also, in my experience, there's no such thing as a one off application. Sooner or later, you're going to have to fix, modify, change or enhance your application because of a new business requirement. On going work requires the developer to have their own QODBC license. QODBC is licensed to each computer it is used on.

As far as what you can do when the 30-day evaluation runs out, well, you can still use a QuickBooks Sample Company file even with an expired evaluation. You can't use a real company file. After 30-Days, you can either purchase a QODBC license or use a QuickBooks sample company file.

QODBC Desktop can be used with QuickBooks Sample company, and no QODBC license is required.

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+ minutes, and the status dialog showed it waiting on QuickBooks as it went through all 2,500 customers - but it took over 15 minutes to complete! I have a situation where moving an invoice to another Customer may occur several times in a batch of invoices. Are there additional conditions I can put in the WHERE clause that would speed this up?

Solution:

Please make sure Optimizer is enabled.  - https://qodbc.com/links/2358

If you are executing an SQL statement for the first time on this table, QODBC has built the optimizer before processing the SQL statement. "Waiting on QuickBooks" may take longer than usual.

Please run the SQL statement again, and if you are still facing the same issue, please try the following options.

Make use of the index fields such as TxnID or TxnDate to filter the number of records scanned.

Update invoice set CustomerRefListID = '1500' where TxnID='ValueOfYourTxnID'

or

Update invoice set CustomerRefListID = '1500' where TxnDate>={d'2022-11-10'} and  TxnDate<={d'2022-11-15'} and  TxnNumber = 8453

If you are still facing the issue, please try using the UNOPTIMIZED keyword.

Update invoice UNOPTIMIZED set CustomerRefListID = '1500' where TxnID='ValueOfYourTxnID'

Problem Description:

We have low performance in SQL Server Linked Server using QREMOTE.

For example, the below statement is taking less than 2 seconds in the QODBC 64-bit Test tool and more than 2 minutes in our linked server:
UPDATE Customer SET JobTitle = 'Job3' WHERE ListID='8000000F-1466614340'.

In SQL Server, the statement seems to scan the whole table to be executed (14000 records)

We are running QuickBooks and SQL Server on the same machine on a cloud server. All drivers are 64bits. The same system DSN is used in Test Tool and in SQL Linked server: QuickBooks Data 64-bit QRemote

Solution:

Please make sure Optimizer is enabled.  - https://qodbc.com/links/2358

Update QREMOTE...customer set JobTitle = 'Job' where ListID='8000000F-1466614340'

When you use the above query, SQL Server will fetch all the data from the Customer table. SQL server will then apply the filter of List ID.

SQL Server will generate an update statement from the derived result and send it to QODBC/QRemote.

Thus, for a single record update, the entire table is scanned.

To avoid this, use OpenQuery and select only the record you want to update.

Please use the Index fields in the "select" and "update" clauses.

Example:
update openquery (QRemote, 'select ListID, JobTitle from Customer where ListID=''8000000F-1466614340''') set JobTitle = 'Job' where ListID='8000000F-1466614340'

Note: Here, we are using ListID (the index field) in the select statement and the OpenQuery update statement.

If you are still facing the issue, please use the UNOPTIMIZED keyword.

update openquery (QRemote, 'select ListID, JobTitle from Customer UNOPTIMIZED where ListID=''8000000F-1466614340''') set JobTitle = 'Job' where ListID='8000000F-1466614340'

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 missing field or report, or feature?

Method 01:

Start QuickBooks 

1. In the top menu bar, go to Help, Send Feedback Online, then Product Suggestion. 
2. Choose a Type of Feedback and Product Area (optional) from the available drop-down menus. 
3. Enter any suggestions/feedback in your Here is my suggestion: field. 
4. Select Send Feedback. 

You can also send your feedback directly to our developers by filling out our QuickBooks Feedback form. Simply enter your request/suggestions, and rest assured that all our suggested plans are subject to further study. 

Method 02:

Log in or register at https://developer.intuit.com/

Click the profile icon and then click the support icon. i.e., https://help.developer.intuit.com/s/

Click "Sign In"

Click "Sign In" again.

Under the Help menu, select "Developer Resources" and then click "Contact Support"

https://help.developer.intuit.com/s/contactsupport

Product: QuickBooks Desktop or QuickBooks Online

Category: QuickBooks API or QuickBooks SDK or SDKs or QBSDK

Existing bug list: https://help.developer.intuit.com/s/bug-tracker-page

Method 03:

QuickBooks community https://quickbooks.intuit.com/community

https://quickbooks.intuit.com/learn-support/us-quickbooks-community/misc/03/community-us

Method 04:

Also, refer to

How to enable verbose logging to see the entire request and response logs 

https://help.developer.intuit.com/s/article/QBD-QBSDK-Logging

https://help.developer.intuit.com/s/article/Understanding-QBXML-Verbose-Logs

Issue:

We recently upgraded our Windows OS to Windows 11 and SQL Server to 2019.

We can connect from SQL Server to QODBC/QRemote.

We can execute select statements.

We are experiencing an issue when updating a record. This is working correctly in Windows 10 and SQL Server 2017. The following is the SQL statement we are using.

Update QRemote...Bill set Memo='Sent' where TxnID='12-1234-56789'

Reason:

There are some changes in the standard ODBC API in Windows OS 11 or Windows Server 2019 when using SQL Server.

The issue is caused because QODBC received the SQL statement from SQL Server.
Update QODBC.Bill set Memo='Sent' where TxnID='12-1234-56789'
instead of
update QODBC.Bill set Memo='Sent' where TxnID='12-1234-56789'

Solution:

The issue has been identified and resolved in QODBC build 346.

Please install the latest version of QODBC.

QODBC Desktop - https://qodbc.com/download/desktop

QODBC Online - https://qodbc.com/download/online

QODBC POS - https://qodbc.com/download/pos

Issue:

We created a new QODBC 32-Bit DSN with the name "QODBC-MyCompany.

The DSN was created successfully.

We tried to change the "Mode when opening" to "Single-user Mode" or "Multi-user Mode," applied the changes, and closed QODBC Setup Screen.

The changes are not saved.

We tried changing the company file path but the same issue.

Reason:

We have identified the issue and are currently working on the fix.

The issue is limited to QODBC Desktop build 348.

Solution:

Please download and install the QODBC build 349 or above. - https://qodbc.com/download/desktop

Workaround:

Create a new QODBC 64-Bit DSN with the same name as your QODBC 32-Bit DSN.

After creating a 64-Bit DSN of the same name, you can apply the changes to your 32-Bit DSN.

Please raise a support ticket with us if you do not wish to apply the above workaround. We will help you with downgrading QODBC to build 345 or 346.

Click here to raise a support ticket.

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 refer to the below link on how the optimizer works.

Refer to: How Optimizer Works

The Display Driver Status will show the current status in 'Red color,' which means data is fetched from the QuickBooks SDK instead of the QODBC optimizer.

Either you are fetching the data for the first time, or you might not be using QODBC Optimizer.

If the QODBC Display Driver Status is showing in 'Red color,' the data fetching process will be longer.

The reason is QODBC has to fetch all the data from QuickBooks SDK.

The time required to fetch data will depend upon the number of records in your QuickBooks company file.

The data will be stored in an Optimizer file to increase the retrieval performance of queries.

From the second time onwards, you will notice the current status inside the QODBC Display Driver Status in 'Black color,' which means data is fetched from the QODBC Optimizer.

Tags: Optimizer, Red text, QODBC optimizer

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

Solutions: 

You must enable TLS 1.1 and TLS 1.2 on the Windows 7 OS.

To allow QODBC Online to communicate securely to the Intuit QuickBooks Online server using TLS 1.1 and TLS 1.2, you have to do the following:

Please enable the internet connection on your machine. Please follow the below steps to enable TLS 1.2 on your system.

Follow the below steps to launch 'Services' from the start menu:

Click the Windows Start button from the desktop and search with the keyword 'Services.'

Click on 'Services' to launch the 'Services' application.

Start the below two services:

1) Background Intelligent transfer system (Right-click and go to "Properties" and select start type as "Automatic" and click on the "Start" button)

2) Windows Update (Right-click and go to "Properties" and select start type as "Automatic" and click on the "Start" button)

Create a folder named TLS12 in your C: drive.

Download the two files below and place them in the TLS12 folder.

install-kb.ps1

tls-reg-edit.ps1

To download the compressed file - click here

Run PowerShell (without x86) from the start menu as "Run as administrator."

In the PowerShell command prompt, navigate to the TLS12 folder and execute the below commands one by one.

PS C:\Windows\system32> cd\

PS C:\> cd .\TLS12

PS C:\TLS12> Set-ExecutionPolicy Bypass -Scope Process ; .\install-kb.ps1

Type "Yes" and press the "Enter" key.

It will update the system to KB3140245.

Restart your machine.

Run PowerShell (without x86) from the start menu as "Run as administrator."

In the PowerShell command prompt, navigate to the TLS12 folder and execute the below commands one by one.

PS C:\Windows\system32> cd\

PS C:\> cd .\TLS12

PS C:\TLS12> Set-ExecutionPolicy Bypass -Scope Process ; .\tls-reg-edit.ps1

Type "Yes" and press the "Enter" key.

Restart your machine.

After restarting the machine, launch the QODBC Online Test Tool from Start Menu>> QODBC Driver for use with QuickBooks Online>> QODBC Online Test Tool

Connect using the DSN' QuickBooks Online Data'.

You should be able to connect.

Source of PS  -  How+to+Configure+Microsoft+Windows+7+to+use+TLS+Version+1.2

If you are still facing the issue, Install the Windows update KB3140245, either through Windows Update, where it is available as an Optional Update, or download it from the Microsoft Update Catalog (www.catalog.update.microsoft.com).

Download the file MicrosoftEasyFix51044.msi from the following page and install it on your computer:

Update-to-enable-tls-1-1-and-tls-1-2-as-a-default-secure-protocols-in

The file is available for download in the section labeled Easy To Fix on the above-mentioned page. Suppose the easy fix option is not suitable for you, and you prefer to manually edit your computer's registry. In that case, the article also provides that information in the section "How the DefaultSecureProtocols registry entry works."

If you are still facing the issue, please raise a support ticket to the QODBC Technical Support Department from the below-mentioned link & provide the requested information:

Submit a Ticket

Please attach the below-listed files:

1) Screenshot of QODBC Setup Screen -- > About

2) Screenshot of the issue you're facing.

Share Entire Log Files as an attachment in text format from

3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages

4) QODBC Setup Screen -- > Messages -- > Review SDK Messages

Refer to: How to take a screenshot: How to take a screenshot

Tags: QuickBooks Online, QBO, oAuth, Windows 7, TLS, Unable to connect, QODBC Online, QO

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 card expired, and I need to enter a new one, but I do not see any web pages that allow me to do this.

Solution:

QODBC Online Subscription customers are given a unique URL in their Order Notification that will take them to a secure page where they can update their payment method or cancel their subscription.

You will find the link below in your subscription or renewal email. 

https://sites.fastspring.com/flexquarters/order/s/FLE111111-1111-111111

Please visit that link & click on Edit Subscription to modify the payment method for your QODBC Online subscription:

Click "Update Payment Method" and click "Next."

Input the new Payment Method and click "Update Payment Method."

Tags: QuickBooks Online, QBO, QODBC Online, QXL Online, online subscription, Credit Card

If you downloaded The QODBC Desktop product between October 7^th and 9^th, 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 this version.

Only a few downloads were affected. This version does not have our normal security key wrapper (Microsoft Authenticode), so it may be detected as not coming from us by your Windows system, which is true.

Please uninstall any downloaded version of QODBC Desktop acquired on the above dates, install Antivirus software if you do not yet have any, and run a full system check immediately.

If no problems are detected, download the latest version of QODBC from our website https://qodbc.com/download.htm and install it.

Should you encounter any difficulties installing the latest version of QODBC Desktop or have any questions for us, please create a support ticket, and we will try to get your issues resolved as quickly as possible. 

Click here to create a support ticket.

To double check, if you right-click the installer properties and tab to digital signatures, you can view the security key is in place and that this is the valid secure download.

We apologize for this disruption in our software and are taking steps to ensure that only our security-protected software will be downloadable by customers in the future.

Thanks for being a customer of QODBC Desktop!

Thanks

QODBC Desktop Support Team

Problem Description

• How does QODBC validates all the business logic which are part of the QuickBooks application?
• Can QODBC read or write directly to the QuickBooks company file (.QBW or . QBB)?

Solution

QODBC works as a Windows ODBC driver (DLL) to access the QuickBooks data. QuickBooks Accounting stores its data in its own proprietary encrypted file system.

Due to the nature of accounting systems, balancing, and transaction integrity, the QuickBooks system prevents all external applications from directly accessing the data files used by QuickBooks. However, Intuit created a workaround called the QuickBooks SDK (software development kit), which resides inside the QuickBooks application interface.

QODBC allows users of any ODBC-compliant front-end application to read and write data contained in the QuickBooks system similar to any other ODBC-enabled database by processing commands via the QuickBooks SDK interface in the desktop application, so QODBC will not run if QuickBooks is not installed on the same machine or a connected machine (see: QRemote) because the SDK resides in the application
itself.

QODBC accepts SQL (structured query language) commands from applications through the ODBC interface, then converts those calls to navigational XML commands, passing them to the QuickBooks SDK for processing and returning recordsets that qualify for the query results.

This driver is not a Client/Server product or a direct database access tool because that method is prohibited by Intuit, but rather communicates directly with the QuickBooks application as it runs.

QuickBooks is a flat-file database; this driver will not change it into a relational database, so keep that in mind when developing with this driver.

QODBC acts as a 'wrapper' around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools, speeding development time.

QODBC does not write to the QuickBooks company file directly. QODBC is writing through the QuickBooks SDK, which follows all business rules & validation.

Note: QuickBooks requires you to approve the security settings for QODBC to allow it to access the data in QuickBooks once for each application/company file combination. After this step, the connection to data in QuickBooks can be fully automated and not require user input.

Tags: QuickBooks start, QuickBooks autostart, QuickBooks startup, QuickBooks connect, Hidden QuickBooks, Quiet QuickBooks, Silent QuickBooks, Background QuickBooks, How to setup QODBC for Auto-login into QuickBooks, a process for automatically start of QuickBooks, QuickBooks automatic, automatic quick books, autostart QuickBooks, automatically start of Quickbooks, running QuickBooks automatic, autologin, connection to data does not work unless Quickbooks is running even though I have that option turned on in the QODBC control panel, how to run without QuickBooks

Problem Description:

I want to cancel my QODBC Driver for QuickBooks Online monthly subscription.

How to cancel the subscription of the QODBC Driver for QuickBooks Online?

 I received an email saying a subscription was going to be renewed. I need to cancel this subscription.

Solution:

Latest Method:

Please visit the following link: https://flexquarters.onfastspring.com/account.

Input the email address associated with your license.

Check your email inbox, and you should receive an email with the subject:

<Your Fullname>, here is a link to manage your orders

From: FastSpring Checkout <mailer@fastspring.com>

Click the link received to manage your account.

The link (URL) should look like https://flexquarters.onfastspring.com/account/somerandomtext.

Latest Method:

You can manage the subscription of the QODBC Driver for QuickBooks Online using the link you received in your renewal email.

On your monthly subscription renewal receipt, you will see the following as in this example:

Order ID: FLE1XXXXX-1XXX-6XXXXB
1 QODBC Desktop Driver for QuickBooks Online USA
https://sites.fastspring.com/flexquarters/order/s/ (your order number). Click on this link on YOUR receipt, and you can cancel the subscription.

Example
https://sites.fastspring.com/flexquarters/order/s/FLE111111-1111-111111

Please visit that link & click on Cancel Subscription to cancel your QODBC Online subscription:

Tags: QuickBooks Online, QBO, Subscription QODBC Online, Cancel subscription

Problem Description:

I am getting the error "Invalid operand for the operator: <assignment>" while trying to insert an invoice line item:

INSERT INTO InvoiceLine ( CustomerRefListID, TemplateRefListID, RefNumber, InvoiceLineItemRefListID, InvoiceLineRate, InvoiceLineAmount, InvoiceLineTaxCodeRefListID, FQSaveToCache) VALUES ( '800019E1-1428688811', '8000001B-1360624407', '17003', '80000129-1362767268', 65.0000, '130.00', '80000002-1358615111', 0)

Solution:

You will get an Invalid operand for operator error when you provide the wrong data type values in your query.

For Example:

The column data type is decimal/integer/bit & you are inserting the value as string/character.

In your query, the InvoiceLineAmount column data type is decimal & you provided the value as string/character.

Please refer to sample query & test again:

INSERT INTO InvoiceLine ( CustomerRefListID, TemplateRefListID, RefNumber, InvoiceLineItemRefListID, InvoiceLineRate, InvoiceLineAmount, InvoiceLineTaxCodeRefListID, FQSaveToCache) VALUES ( '800019E1-1428688811', '8000001B-1360624407', '17003', '80000129-1362767268', 65.0000, 130.00, '80000002-1358615111', 0)

Please refer to QODBC Data Layout for more details.

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 noticed QuickBooks needs to be logged in and open to function. Is there a server version that will not require a user to log in or passes the info along automatically, so the website continues to function correctly?

Is there a way to try the server version by syncing to the SQL server? I need to be able to dump the customer table once daily into SQL. Maybe other tables in the future, like orders or quotes. Does the server version need a remote desktop session open to work? If the server reboots because of an update, I need to log in to make it work again. That doesn’t seem very feasible for us. 

Solution:

QODBC is not a driver you would install on a server; multiple workstations would have access to it. The server version of QODBC is for synchronizing SQL Server with QuickBooks data or for a web or intranet application.

>>Is there a server version that will not need a user logged in or passes the info along automatically, so the website continues to function correctly?
>>Does the server version need to have a remote desktop session open to work?

Please refer: To how to Setup QODBC to Access QuickBooks when no one Logged in.

OR

You may configure a session-0 to start and starts QuickBooks and QRemoteServer automatically.
When you configure session-0, you are setting up the auto login of a user, and that user will have a desktop session running.

>>Is there a way to try the server version by syncing to the SQL server?

You can use Linked Server on SQL Server and connect to QuickBooks Data using QRemote. When you query Linked Server/tables, you will always get live QuickBooks Data.

For dump of All the tables or selected tables from QODBC to Tables in SQL Server Database, You may write a script to create the table(s) in SQL Server and Get data from the linked server.

e.g.
SELECT * into LocalSQLTableName FROM OPENQUERY(YourLinkedServerName, 'SELECT * FROM LinkedTableName')

SELECT * into tblVendor FROM OPENQUERY(QRemote, 'SELECT * FROM Vendor')

You can add the script to the agent to run periodically.

Please refer to the below-mentioned article for How to create a Link Server with MS SQL 2005/2008/2012 Using QODBC/QRemote.

For 32-bit SQL Server, refer to:
How to create a Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote

For 64-bit SQL Server, refer to:
How to create a Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC/QRemote


Also, Refer:
How to set up QODBC Driver to auto-connect to QuickBooks. (Video)
How to setup QODBC for Auto-login into QuickBooks

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 the Customer table has a field called "Id," but this also comes back as "column not found."

Can you let me know if this unique ID column is being renamed or something?

Solution:

ListID column data type is varchar, So you need to add quotes (i.e. ') around it. Please use the below query & try again.

select * from Customer where ListId='557'

Regarding ID, I think you might have tried

select * from Customer where ID='557'

ID is not part of the QODBC-Online Schema. Please use the listed.

You can get QODBC Online table schema from below link:

Please refer to QODBC Online Data Layout for more details:

Tags: QuickBooks Online, QBO, QODBC Online, Customer

For system requirement details of QODBC Online, click here.

How to install QODBC Online & Using Microsoft Excel/Access with QODBC

You can also see: How to use QODBC Online with QuickBooks Online Edition

For system requirement details of QODBC Online, click here.

Tags:

Installing QODBC Online

How to connect QODBC Online

Tags: QuickBooks Online, QBO, MS Access, Excel, QODBC Online, connect online

Table Differences:

Number of Tables available in

List of Tables available in QODBC Desktop

List of Tables available in QODBC Online

List of Tables available via API from QuickBooks Online

Report Differences:

Number of Reports available in

List of Reports available in QODBC Desktop

List of Reports available in QODBC Online

List of Reports available via API from QuickBooks Online 

Stored Procedure Difference:

Stored Procedure which is not working in QODBC for QuickBooks Online:

QODBC Desktop Stored Procedures Command-List

Also, Refer

Detailed Difference between QODBC for QuickBooks Desktop and Online.

Tags: QuickBooks Online, QBO, QODBC Online, difference

Problem Description:

QRemote Does not consider FQSaveToCache with working with OdbcCommand & Parameters.

I have an application that creates Sales Orders. This is what I execute for each line item:

Running this code against QODBC DSN works well if everything is local - using a 32-bit local DSN and QuickBooks local to the application. The Sales Order appears correct in QuickBooks.

Taking the same code and connecting it to a 64-bit QRemote DSN connected to a 32-bit qODBC DSN on another machine (via QRemote Server) does not work.

The basic flow is like this:

cnQODBC = New OdbcConnection(ConfigurationManager.AppSettings.Item("QuickBooksConnectionString"))

cnQODBC.Open()

[Repeat for every sales order line item]

Dim cmdQODBC As OdbcCommand = New OdbcCommand("insert into SalesOrderLine (CustomerRefListID, TxnDate, SalesOrderLineClassRefListID, TemplateRefListID, RefNumber, " & "SalesOrderLineItemRefListID, SalesOrderLineDesc, SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineAmount, " & "CustomFieldSalesOrderLineOther1, FQSaveToCache) values (??, ??, ????????)", cnQODBC)

cmdQODBC.Parameters.AddWithValue(", "strCustomerListID)

cmdQODBC.Parameters.AddWithValue("", "{d'" & dteInvoiceDate.ToString("yyyy-MM-dd") & "'}")

cmdQODBC.Parameters.AddWithValue(", "strLineClassListID)

cmdQODBC.Parameters.AddWithValue(", "strTemplateListID)

cmdQODBC.Parameters.AddWithValue("", intSalesOrderNumber)

cmdQODBC.Parameters.AddWithValue("", strLineItemListID)

cmdQODBC.Parameters.AddWithValue(", "strain description)

cmdQODBC.Parameters.AddWithValue(", "intQuantity)

cmdQODBC.Parameters.AddWithValue(", "dblLineRate)

cmdQODBC.Parameters.AddWithValue(", "dblLineAmount)

cmdQODBC.ExecuteNonQuery()

[End repeat]

cnQODBC.Close()

cnQODBC = Nothing

cmdQODBC.ExecuteNonQuery()

Solutions:

Integer, double, and long datatype parameter passing in QRemote pass-through string format because of flow QRemote Client --> QRemote Server --> QODBC Datatype conversion create the problem in QODBC and due to this issue occurred.

The workaround for this problem is to pass value in string format instead of basic format as in the below example:

cmdQODBC.Parameters.AddWithValue("", intSalesOrderNumber.ToString()) //cmd.Parameters.AddWithValue("", "3");

cmdQODBC.Parameters.AddWithValue("", intQuantity.ToString()) //cmd.Parameters.AddWithValue("", "44.2");

cmdQODBC.Parameters.AddWithValue("", dblLineRate.ToString()) // cmd.Parameters.AddWithValue("", "113.4");

cmdQODBC.Parameters.AddWithValue("", dblLineAmount.ToString()) //cmd.Parameters.AddWithValue("", "0");

Instead of

cmdQODBC.Parameters.AddWithValue("", intSalesOrderNumber) //cmd.Parameters.AddWithValue("", 3);

cmdQODBC.Parameters.AddWithValue("", intQuantity) //cmd.Parameters.AddWithValue("", 44.2);

cmdQODBC.Parameters.AddWithValue("", dblLineRate) //cmd.Parameters.AddWithValue("", 113.4);

cmdQODBC.Parameters.AddWithValue("", dblLineAmount) //cmd.Parameters.AddWithValue("", 0);

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 = '19650'

SELECT @TSQL = 'SELECT * FROM OPENQUERY(QRemote ,''SELECT * FROM ReceivePayment WHERE ReceivePayment.RefNumber = ''''' + @ID + ''''''')'

EXEC (@TSQL)

Update Query:

DECLARE @TSQL varchar(8000), @ID varchar(25), @CName varchar(25)

SELECT @ID = '80000146-1513345553'

SELECT @CName = 'New Company'

SELECT @TSQL = 'Update OPENQUERY(QRemote ,''SELECT * FROM Customer WHERE Customer.ListID = ''''' + @ID + ''''''')' + 'SET CompanyName = ''' + @CName + ''''

EXEC (@TSQL)

Please refer below link:
How to pass a variable to a linked server query
Including parameters in OPENQUERY

Problem Description:

I'm trying to establish a connection to QuickBooks using QRemote Server. But when I tried to connect, I got the below error message:

"Wrong client Encyptkey setting":

 Or

"QRemote Client Encryption Key does not match with the one specified on QRemote Server."

How can I solve this error?

Solution 1:

You will receive this error when using the encryption key in QRemote Server, which does not match the QRemote Client encryption key.

If you want to use the Encryption key, you need to set the same encryption key on the QRemote client & server.

You can check the QRemote Client encryption key from:

32-bit QRemote DSN:

Start>> All Programs>>QODBC Driver for use with QuickBooks >> Configure QODBC Data Source >>Go To "System DSN" Tab >> select QuickBooks Data QRemote >> click "configure"

64-bit QRemote DSN:

Start>> All Programs>> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source 64-bit >>Go To "System DSN" Tab >> select QuickBooks Data 64-bit QRemote>> click "configure"

You can check the QRemote Server Encryption key from:

You can find the QRemote server running in the System Tray. If it is not running, then please run from the following:

Start>>All Programs>> QODBC Driver for use with QuickBooks >> QRemote Server for QODBC

Open QRemote Server from the system tray:

File>> Setting >> Encryption tab

Please verify the encryption key from the client & server. If the Encryption key is different, then please set the same encryption key apply changes & restart QRemote Server & test again.

If you don't want to use the Encryption key, turn off the encryption, and please keep it as the default key("QODBC#QRemote$1") on the QRemote Client side & QRemote Server side.

Open QRemote Server from the system tray:

File>> Setting >> Encryption tab>> Select "No Encryption in transmission," apply changes & restart QRemote Server & test again.   

Solution 2:

Delete the file "QRemoteServerConfig.ini" from the below-listed location:

C:\ProgramData\QODBC Driver for QuickBooks

After deleting the file "QRemoteServerConfig.ini," exit QRemote Server

If you are using QRemote Remotely or an SQL server with QRemote from another machine, perform the above steps on that machine.

Do not change the default encryption option or setting; try connecting it again.

[QODBC Online]

Delete the file "QRemoteServerConfig.ini" from the below-listed location:

C:\ProgramData\QODBC Driver for QuickBooks Online

After deleting the file "QRemoteServerConfig.ini," exit QRemote Online Server.

If you are using QRemote Online Remotely or an SQL server with QRemote Online from another machine, perform the above steps on that machine.

Please do not change the default encryption option or setting; try connecting it again.

[QODBC POS]

Delete the file "QRemoteServerConfig.ini" from the below-listed location:

C:\ProgramData\QODBC Driver for QuickBooks POS

After deleting the file "QRemoteServerConfig.ini," exit QRemote for QuickBooks POS Server.

If you are using QRemote for QODBC POS Remotely or an SQL server with QRemote for QODBC POS from another machine, perform the above steps on that machine.

Please do not change the default encryption option or setting; try connecting it again.

Step 1 - Download QXL

If you haven't already downloaded QXL, go to the download page now. Don't forget to read the "Readme" file during installation for the latest information on QXL setup, new features, and other driver information. Save the self-extracting executable "QXLSetup.exe" in a temporary directory or your "My Documents" folder to extract the installation files.

Step 2 - Running the Installer:

Click on the Install program from within Windows to install the driver. Select the destination directory to install the QXL support files. Click "OK" to continue.

The QXL - QuickBooks Export Made Easy® has been successfully installed on your computer. You can begin to use it because it will immediately run as a 30-day evaluation version.

Step 3 - Use QXL:

After installation, you may notice the following icons on the desktop.

QXL – Silent Mode - It uses the last saved settings of QXL and Automatically starts Executing the data export with no user interface.QXL – Direct Mode - It uses the previously saved settings of QXL and Automatically starts Executing the data export with the user interface, i.e., displaying progress data export.QXL – Manual execution of Data Export/Update Settings/Activation-Deactivation. You can select tables and destinations to which the files should be exported. Start QuickBooks, log in to your company file, Switch back to QXL, and click Export Data.

After the export is completed. Exported data folder will open.

Exported data is placed at the below location by default: C:\Users\User Name\Documents\QXL\

QXL Features:

1. Export QuickBooks Data to XML format via QODBC.

2. Export QuickBooks Data to CSV format via QODBC.

3. Ability to choose export file(s) location.

4. Ability to export to Separate files or a single file.

5. Ability to export all selected, tabled, or excluded tables.

6. Ability to save your default settings from Options.

Also, Refer:
QXL options and settings

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/null date, or is there a special function for this?

Solution:

You can select a blank/null date using "IS NULL" in your query.

For Example below query will return a row whose InventoryDate is blank or null:

SELECT * FROM ItemInventory where InventoryDate IS NULL

In the same way, you can use "IS NOT NULL" in your query.

For Example below query will return a row whose InventoryDate is not blank or null:

SELECT * FROM ItemInventory where InventoryDate IS NOT NULL 

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 automatically, and the next invoice I create using my outside table will be incorrect.

I need to replicate what QuickBooks does in determining the following QuickBooks invoice number. What do you recommend?

Solutions:

While inserting a new invoice from QODBC, if you do not pass RefNumber, QuickBooks will automatically manage and assign a RefNumber to the newly inserted invoice.

If you would like to specify the RefNumber, and RefNumber is numeric, it should be easy to sync up. Just get the max RefNumber from the Invoice table( of the current year), add 1 to it, and specify it in the insert statement.

Problem Description:

How do I Auto increment the Ref Number for the Invoice?

Solutions:

While inserting a new invoice from QODBC, if you do not pass RefNumber, QuickBooks will automatically increment and assign a RefNumber to the newly inserted invoice.

For example, if the RefNumber of the last Invoice is 1111, then QuickBooks will automatically assign 1112 as a RefNumber for the newly created invoice.

Problem Description:

How do I Get max and insert RefNumber for the Invoice?

Solutions:

You can get the max RefNumber for Invoice by using the below query & add 1 to the result and can create a new invoice:

SELECT Max(RefNumber) FROM InvoiceLine  

We got 2581 as the max RefNumber. Now we are creating the new invoice with RefNumber 2582.

INSERT INTO InvoiceLine (CustomerRefListID, RefNumber, InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) VALUES ('620000-1071526513', '2582', '240000-933272656', 'POWER TRAK-2000', 200.00000, 200.00, '20000-999022286',0)

Problem Description:

What happens If I use the same RefNumber for Invoice creation?

Solutions:

QuickBooks is allowing duplicate RefNumber. So when you use the same RefNumber for Invoice creation. QuickBooks will create an invoice with a duplicate RefNumber/

For example, if the RefNumber of the last Invoice is 1111, then QuickBooks will automatically assign 1112 as a RefNumber for the newly created invoice.

Problem Description:

How do I Auto Increment Alphanumeric RefNumber for Invoice?

Solutions:

First, create any Invoice from QuickBooks UI & assign the alphanumeric RefNumber "R0001T". Now create a new Invoice from QODBC & do not pass RefNumber. QuickBooks will automatically increment and assign a RefNumber (i.e., "R0002T") to the newly inserted invoice.

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 your current display is just a quick keystroke away. Follow this guide to take a screenshot of your whole screen, a specific window, or any display section you want.

1. Press the "Print Screen" (⎙ PrtScr) key on your keyboard. This will capture an image of your entire screen and copy it to the clipboard. The dimensions of the image will be the same as your desktop resolution. The ⎙ PrtScr button may be labeled "PrtScn," "Print Scrn," "Print Scr," or something similar. On most keyboards, the button is usually found between F12 and Scroll ⇩. You may have to press the Fn or "Function" key on laptop keyboards to access the "Print Screen." [1] You will not receive any confirmation that the screenshot has been taken.

2. Paste the screenshot. Once you've made the screenshot, you must paste it into a program to see it. The most common way to paste it is into a Paint file. This will allow you to save it as an image file that can be transferred to others—open Paint from the Accessories section in your Start menu. With a new blank canvas available, press ^ Ctrl+V to paste the image onto the canvas. You can also open the Edit menu and select Paste or right-click on the canvas and select Paste. Click file, then Save to set the image's name and file type. The most common file types are JPG and PNG. The recommended format for screenshots is PNG due to the high quality and small file size. You can also paste the screenshot into other programs, such as Word, or into the body of an email. Open the program you want to paste the image into and press ^ Ctrl+V.

3. Save the screenshot: Perform any edits you want, such as cropping the image to a specified area, and click the main File option in the top-left corner. Afterward, select Save as, title the new file, choose a save location, and select your desired file format from the drop-down menu. JPG will do fine for most purposes, but various other forms are available, such as PNG, BMP, GIF, and others. Click the gray Save button in the bottom right-hand corner when finished. 

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 without changing the stock quantity. Here is an example:

This item has a COGS Average Cost of $69.73429:

Using QODBC, I adjusted the opening balance equity cost of the stock item by $250.00 using the following SQL insert statement:

INSERT INTO "InventoryAdjustmentLine" ("AccountRefFullName," "TxnDate," "RefNumber," "Memo," "InventoryAdjustmentLineItemRefFullName," "InventoryAdjustmentLineValueAdjustmentNewValue," "FQSaveToCache") VALUES ('Opening Bal Equity,' {d'2007-05-23'}, '110', 'Value Adj 250', 'Wood Door: Exterior', 250.0, 0) 

This item now has a COGS Average Cost of $106.69857:

The value adjustment details can be seen in the Inventory Valuation Detail: 

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 things, too, like JOINs - but I'm stuck with this problem. The minute I give Access a date constraint like receive payment.TxnDate >=#11/1/2014# as stated in your "How Dates Are Formatted.." documentation for Access Date formats, Access immediately crashes. No msgs in the brief QODBC log files about the crashes, as best I can tell:

Solutions:

Please try executing the following command using QODBC Test Tool to see if it can solve the issue: sp_optimizefullsync ALL.

This command will bring some data to a local cache to increase query retrieval performance. I want to suggest you, please let me run the above command entirely. The above command may take some time, depending on your records in QuickBooks. It may take 2-24 hours or more, depending on the number of documents in the QuickBooks company file. Please let this command run entirely. Do not kill this command. It is not advisable to kill/close the application while building the Optimizer file.

After successfully executing the above command, please create a new MS Access Database file & link all tables & execute the query again. It should work without any issues.

Please refer: How to Use QODBC with Microsoft Access 2010

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 details from the "Cc" field in the Customer & Entity table.

The Alt Email 1 and 2 field is not available through the Intuit SDK, so they are not available through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.

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 time the update statement, with OpenQuery or without openquery on the linked server, it searches all the records of EstimteLine and then updates the record. This process takes 3.5 to 4 minutes.

Ideally, it should not scan all the records as the Ref Number is provided.

I am using the below query:

Update openquery(qremote, 'select ClassRefListId from EstimateLine where RefNumber=''501'' and EstimateLineTxnLineID=''8DB9-1071524326''') SET ClassRefListId = '40000-933272658'

Solutions 1:

The performance of an update query with OpenQuery can be improved by including the "where" criteria outside the open query.

For Example:

The Query

Update openquery(qremote, 'select ClassRefListId from EstimateLine where RefNumber=''501'' and EstimateLineTxnLineID=''8DB9-1071524326''') SET ClassRefListId = '40000-933272658'

will perform faster when executing it as

Update openquery(qremote, 'select ClassRefListId,EstimateLineTxnLineID,RefNumber from EstimateLine where RefNumber=''501'' and EstimateLineTxnLineID=''8DB9-1071524326''') SET ClassRefListId = '40000-933272658' where RefNumber='501' and EstimateLineTxnLineID='8DB9-1071524326'

So yes, you need to include [ RefNumber='501' and EstimateLineTxnLineID='8DB9-1071524326' ] twice, inside the OpenQuery and outside too.       

Problem Description 2:

I am using an MS SQL-linked server with QRemote.

In SQL Server, when we use update openquery, without including fields that identify a single row that needs to be updated, then SQL returns the error "OLE DB provider "MSDASQL" for linked server "QREMOTE" returned the message "Key column information is insufficient or incorrect. Too many rows were affected by the update." Rows were updated, but still, it shows the error message. The OLE DB provider "MSDASQL" for linked server "QREMOTE" could not UPDATE table " [MSDASQL].".

I am using the below query:

Update openquery(QREMOTE,'select customfieldtransportaddress,CustomFieldOther from salesorderwhere txnDate >= {d''2013-12-29''} and refNumber = ''8801'' ') set CustomFieldOther='1514999',customfieldtransportaddress = 'Conexão333'

Error message:

OLE DB provider "MSDASQL" for linked server "QREMOTE" returned the message "Key column information is insufficient or incorrect. Too many rows were affected by the update.".Msg 7343, Level 16, State 4, Line 1The OLE DB provider "MSDASQL" for linked server "QREMOTE" could not UPDATE table "[MSDASQL]." 

Solutions 2:

To overcome this issue, you need to include an extra "where" clause outside the open query.

For Example:

Update openquery(QREMOTE,'select refNumber,customfieldtransportaddress,CustomFieldOther from salesorderwhere txnDate >= {d''2013-12-29''} and refNumber = ''8801'' ') set CustomFieldOther='1514999',customfieldtransportaddress = 'Conexão333' where refNumber = '8801'


So, you need to include the where condition twice, inside the OpenQuery and outside.       

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 the QlikView file & Click "Next."

6. Select chart type & Click "Next."

7. Define dimensions & list boxes & click "Next".

8. Add expression & Click "Finish."

9. Now, please navigate to the file & click "Edit script."

10. Please select ODBC database & enable the "Force 32 Bit" option & click "Connect."

11. Select "QuickBooks Data" DSN & click "Test Connection."

We can see a connection made with QuickBooks through QuickBooks Data DSN.

12. QlikView locks up when we click the "Select" button on the Edit Script window. Please do not click on the Select button. You can write SQL statements as per your requirement & click on the "Reload" button to execute the script.

For Example:
SQL select * from the customer

13. Choose a field that you want a show from tables that is returned by SQL statements & click on OK.

You can see the results. You can repeat the same process for other tables & fields.

Note : In case the QlikView designer is hanging when using "Select * from TableName," Please try changing the SQL Statement to include limited Fields, e.g., "Select ListID, FullName from Customer"

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

Go To the "System DSN" Tab, Select "QuickBooks Data" DSN & click "Configure."

Navigate to the "Message" Tab & enable the "Detail Tracing (Slow)" option.

2) Switch to the "Advanced" tab & Select "Add XML to Detail Trace Log."

3) Apply the changes. Close all the applications. ( If any of the application is already connected, QODBC will not start logging )  Connect again after Querying, close the connection and refer to the logs. 

Troubleshooting:

I am trying to add a new Line in ODBCINST.ini file TracewithXML=Yes. It is giving me the message "Access is denied."

To resolve this issue, copy the "ODBCINST.ini" file to another place and then add a new line you want to add. Restore the "ini" file in the same place.

You cannot edit any file under the Windows folder.

I am also using your link "How to Locate Log Files of QODBC for Troubleshooting," but it is still showing me this message when I click on the Review QODBC Messages button it is giving me this message QODBCLOG.txt is Empty.

QODBCLOG.TXT is Empty, as your application is running perfectly. It doesn't contain any errors.

Still, if you want to check again, restart your connected applications and QuickBooks company file.

When trying to connect to QuickBooks using the QODBC Test Tool, I am facing the error :

QuickBooks Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

Solution:

Please first keep QuickBooks running and log in as Admin in single-user mode. Go to QuickBooks, "File" list menu, and then check if there is a "switch to Multi-User Mode" option. If there is, then you are running QuickBooks in single-user mode. But if there is no option, click the "switch to single-user mode" option in the same list menu to set QuickBooks running at single-user mode.

If you are not sure how to connect to QuickBooks using QODBC, please refer to this article for more information:

How to Connect to QuickBooks for the First Time

If you are using "Remote Connector" to build a remote connection, please check if you have configured it correctly.

Please refer to this article for more information about setup a "Remote Connector":

How to Setup QODBC Remote using Remote Connector

Please make sure you have unchecked the "Connect To QuickBooks Online Edition" option in QODBC Setup Screen, "Online Edition" window if you are not going to use QODBC to access Connect To QuickBooks Online Edition(QBOE):

And also, please make sure you have unchecked the "Use RDS Client/Server" option in QODBC Setup Screen, "RDS Server" window if you are not going to access QuickBooks remotely:

RDS is a product from QuickBooks; we may not be able to provide much help if there is any problem using RDS. If you are going to set up QODBC to access QuickBooks remotely, Please use QRemote. For more information on using QRemote as a remote access solution, please refer to this article:

Using QuickBooks data remotely via 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 data (Name, AccountNumber....., Balance, credit limit). But QODBC is not allowed me to insert data. When I attempted to insert received the below error:

Solutions

     Use the "OpenBalance" field instead of the "Balance" field, As QuickBooks SDK does not allow to insert value in the "Balance" field but uses "OpenBalance." After inserting the value in the "OpenBalance" field, the value is moved to the "Balance" field.

     Sample Query:

Insert into Customer
(AccountNumber,Name,BillAddressAddr1,BillAddressAddr2,BillAddressCity,BillAddressState,BillAddressPostalCode,BillAddressCountry,Phone,Fax,Email,Contact,Notes,SalesRepRefFullName,CustomerTypeRefFullName,TermsRefFullName,CreditLimit,OpenBalance,IsActive)
Values ('ABC-111', 'XYZ', 'DEF St. ', '', 'Minneapolis', 'MN', '55401', '', '999 999-9999', '', 'temp@xyz.com', 'XYZ', 'great guy', 'XYZ', '', 'COD', 0, 0, 1) 

     Note: Sample query contains dummy data. You can add/remove fields from the question as per your requirements. Ref fields are subject to change as per your company file.

Problem Description:

QuickBooks application and QuickBooks data are on a remote machine.

On my machine, I do not have QuickBooks installed.

I want to connect to a remote machine where QuickBooks is installed so that I can access QuickBooks data remotely.

How can I connect to QuickBooks remotely via QODBC?

Solution:

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 of automatically updating a name server in the Domain Name System (DNS). Using Dynamic DNS, you will always be able to access your computer even if your IP address is dynamically assigned.

You can refer below links for more details about Dynamic DNS & can implement it at your end.

DYN DNS

DYNU DNS

NOIP DNS

Change IP DNS

Note: When you use Dynamic DNS, You should use the Encryption feature in QRemote Client & QRemote Server. So your data transmission will be secure.

Refer: How to turn On/Off Encryption on QRemote

Also, Refer

Using QuickBooks data remotely via QODBC with SQL Server 64 Bit

Using QuickBooks data remotely via QODBC

Keywords: qodbc installed on Quickbooks server

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 like this: "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application."

There are two solutions. You need to either use QRemote relate DSN in your connection string or manually run VB Script under 32-bit mode to solve this problem.

Solution 1 "Using QRemote":

To use QRemote in your connection, you need first to have one QODBC DSN that can connect to QuickBooks without any problem.

Then run QRemote Server:

Note down the IP Address on your QRemote Server.

Click  Start -- > All Programs -- > QODBC Driver for use with QuickBooks  -- > Configure QODBC Data Source 64-bit.

Alternative if the above menu is not available: Go to 64-bit ODBC manager at C:\Windows\System32\odbcad32.exe:

In the "System DSN" tab, find "QRemote Data 64-bit":

QODBC 13.0.0.292 Onward, the DSN Name is changed to QuickBooks Data 64-bit QRemote

Click the "Configure" button to set up this DSN:

In this window, the "Server" is the IP Address you get from QRemote Server. The "Remote DSN" is the QODBC DSN you use to connect to QuickBooks. Ensure the DSN you assigned in this option is available to access QuickBooks.

After the QRemote DSN is configured, please use this DSN in your connection string instead of using QODBC DSN like this:

Set oConnection = CreateObject("ADODB.Connection")
oConnection.Open "DSN=QRemote Data 64-bit;OLE DB Services=-2"

Solution 2 "Set VB Script to Run as 32-bit":

To do this, please follow the steps below:

Please follow the steps below:

1) Click Windows Start

2) Click Run. In the window, type "%windir%\SysWoW64\cmd.exe."

3) Click OK, navigate to the folder where you store your VBS file, or move your VBS file to C:\Windows\SysWOW64.

4) Type "cscript Filename. vbs" in the cmd window. For example, if you have a vbs file named test.vbs, then type the command like this: "cscript test.vbs".

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 detailed Steps.

1) Locate and Navigate to Windows System Directory

Right Click on "My Computer" and select Open

Navigate to System Directory

For Windows 64-bit Operating System:  c:\Windows\SysWOW64

For Windows 32-bit Operating System: c:\Windows\System32

2) Locate/Find the file fqqb32.dll

3) Right Click on fqqb32.dll  and select "Properties."

4) Switch to the tab "Digital Signature."

5) Click "Detail" to know Certificate details

6) To know more about the Certificate, like its expiry and the issuer, please click View Certificate

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 turned OFF, it can show the correct value

SELECT QuantityOnHand FROM ItemInventory where Name = 'MY PRODUCT.'

Is there a way to get QuantityOnHand Keeping Optimizer On

Solutions

Please enable the "Dirty Reads" or "Real Time" option via Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source.

Go To the "System DSN" Tab, select "QuickBooks Data" DSN & click "Configure."

Change the following value on the Optimizer tab and try again. Under "For balances and stock quantities," select Either "Dirty Reads"/"Real Time."

For balances and stock quantities: the option Nulls - will return NULLs for all fields that cannot be kept in sync, Dirty Reads - means return the most current value that was loaded into the optimizer cache, and Real-Time uses the slower method to get the data directly out of QuickBooks making sure you get the most current value for the requested fields. (Real Time is the previous method used).

For More Details, Please Refer: to QODBC Setup Options

QODBC Online

QODBC Online

Keywords: Quantity on hand, Current Balance, quantity null,  onhandquantity is on blank, quantity is blank, quantity is empty, blank quantity, empty balance

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 files cannot be found. So we write this article to make a brief instruction on how to find Opt files.

1)Click Windows Start->Run

2)In the open option, input "%UserProfile%\QODBC Driver for QuickBooks\Optimizer." This is the default path for the QODBC optimizer to store opt files.

OR

2)In the open option, input "%appdata%\QODBC Driver for QuickBooks\Optimizer." This is the default path for the QODBC optimizer to store opt files.

3)In the folder, you will find the opt files named after your company file: