USING MICROSOFT POWERBI WITH QUICKBOOKS DATA
PROBLEM DESCRIPTION 1:
How to connect to QuickBooks Data with Power BI using QODBC Desktop?
SOLUTIONS:
Open the QODBC setup screen and change the QODBC Compatibility mode
from "Default" to "3.8."
To cha...
TROUBLESHOOTING - HOW TO CONVERT MS OFFICE FROM 64-BIT TO 32-BIT
PROBLEM DESCRIPTION:
I am on Windows 64-bit and Office 365 64-bit. QODBC Test Tool works
fine when I use QuickBooks Data as a connection source.
If I use QRemote, I get the "Evaluation ...
HOW TO CREATE SP_REPORTS USING MICROSOFT EXCEL
HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL
OPEN MICROSOFT QUERY IN EXCEL
Open Microsoft Excel, get external data from Microsoft Query via Data
Menu -> "Get Data -> From Other Sources->From Microsoft...
TROUBLESHOOTING - EXCEL ONLY RETURNING AMOUNT_1 AND NOT AMOUNT_1
THROUGH AMOUNT_12.
PROBLEM DESCRIPTION:
I am working in Excel. I have set up three pass-through queries and
had them work on referencing cells for DateFrom and DateTo parameters.
The quer...
TROUBLESHOOTING - HOW TO USE PROMPTED DATE RANGES IN MS EXCEL WITH
SP_REPORTS
PROBLEM DESCRIPTION:
I am using QODBC for exporting QuickBooks reports in MS Excel. I am
using the BalanceSheetStandard report for specific date ranges as
below.
sp_report ...
TROUBLESHOOTING - HOW CAN I COMBINE TWO REPORTS AND GET A CUSTOMER'S
TRANSACTIONS REPORT?
PROBLEM DESCRIPTION:
I need a report by a particular Customer showing the beginning
balance, payments made by the Customer, invoices with details showing
the expe...
TROUBLESHOOTING - QREMOTE FOR QUICKBOOKS IS NOT LISTED AS A CHOICE IN
ODBC SETUP SCREEN
PROBLEM DESCRIPTION:
I am trying to set up the QODBC Driver on a machine running Windows
Server 2016. Previously, I have had it set up and working fine on my
local ...
TROUBLESHOOTING - GETTING ERROR WHEN TRYING TO CONFIGURE QODBC IN SQL
SERVER
PROBLEM DESCRIPTION:
I'm trying to install the QODBC on our SQL Server, and I followed all
steps in your documentation on How to create a Link Server with MS SQL
2005/2008/201...
TROUBLESHOOTING - [FIXED] MICROSOFT EXCEL/ACCESS 365/2016 - INVALID
CERTIFICATE ERROR/DIGITAL SIGNATURE ERROR/CERTIFICATE ERROR/GETTING
INVALID CERTIFICATE ERROR WHEN TRYING TO CONNECT USING MS ACCESS OR
EXCEL
PROBLEM DESCRIPTION:
I am using QODBC to e...
TROUBLESHOOTING - GETTING ERROR A FOUR-PART NAME WAS SUPPLIED, BUT
THE PROVIDER DOES NOT EXPOSE THE NECESSARY INTERFACES TO USE A CATALOG
OR SCHEMA.
PROBLEM DESCRIPTION:
I am using QODBC to fetch QuickBooks Data in SQL Server. I have
created Linked S...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE
PROBLEM DESCRIPTION:
I am using QODBC to access QuickBooks Data. I have linked all
QuickBooks tables using QODBC.
I want the Customer table to be Optimizer OFF and the rest to be
Optim...
TROUBLESHOOTING - "TRANSACTIONS" TABLE, BUT THEY DON'T APPEAR TO
"BALANCE."
PROBLEM DESCRIPTION:
I am attempting to extract data from a client's hosted QuickBooks
Enterprise system. I need every transaction in the system as we are
transitioning to a di...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS EXCEL REPORT FORMAT
PROBLEM DESCRIPTION:
I would like to know if QODBC will convert QuickBooks Pro Desktop
invoices into MS Excel Report.
The attached invoice is similar to what we need to export to MS Excel...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS ACCESS REPORT FORMAT
PROBLEM DESCRIPTION:
I would like to know if QODBC will convert QuickBooks Pro Desktop
invoices into Microsoft Access.
The attached invoice is similar to what we need to export to Access...
SAMPLE VB.NET WEB APPLICATION FOR INSERTING INVOICELINE INTO EXISTING
INVOICE
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net-VB.zip]
for down...
SAMPLE VB.NET SOURCE CODE FOR INSERTING INVOICELINE INTO EXISTING
INVOICE
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample-VB.zip]
for downloading Sample Code.
Please refer be...
TROUBLESHOOTING - HOW TO CHANGE THE CONNECTION STRING STORED IN EXCEL
PROBLEM DESCRIPTION:
I have changed the setting in QODBC Setup Screen from Open mode to the
same as the company file, but my Excel still does not takes the
changes and needs the comp...
TROUBLESHOOTING - HOW TO FIND AN ITEM NOT SOLD AFTER A SPECIFIC DATE
AND MARK IT INACTIVE.
PROBLEM DESCRIPTION:
We would wish to inactive items that have not sold after a certain
date. Is this possible? If so, any help would be appreciated.
SOLUTION:
...
TROUBLESHOOTING - RUNTIME ERROR (28) WHEN USING WINDOWS XP BUT NOT
WINDOWS 2000.
PROBLEM DESCRIPTION:
We have four machines using the ODBC driver with QuickBooks and Access
2003 that work perfectly fine. The odd machine is a slightly higher
version of A...
TROUBLESHOOTING - PERFORMANCE ISSUE QODBC TEST TOOL VERSUS MY C# APP.
PROBLEM DESCRIPTION:
I am running the same query on both returns, a big difference. The
QODBC Test Tool app takes around 7 seconds, and my C# app takes 1:20
minutes.
Are there any s...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN
SQL SERVER.
PROBLEM DESCRIPTION:
I am trying to create Linked Server on SQL Server.
QODBC TEST TOOL connects successfully to QREMOTE on QuickBooks Server.
Setting up the Linked se...
Help Desk Software by Kayako