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 - VEHICLEMILEAGE TABLE SHOWING DELETED RECORDS
PROBLEM DESCRIPTION:
I am using QODBC for working with QuickBooks. I can delete the
VehicleMileage record.
After deleting a record from the VEHICLEMILEAGE table in QuickBooks,
the deleted...
TROUBLESHOOTING - QODBC HUNG UP, EVERYTHING LOOKS LOCKED UP, OR THE
APPLICATION IS NOT RESPONDING WHEN FETCHING QUICKBOOKS DATA.
PROBLEM DESCRIPTION:
I can access the database, but when I added another table & fetch
table data, it generally hung up. No...
TROUBLESHOOTING - HOW TO APPLY PAYMENT TO MULTIPLE INVOICES
PROBLEM DESCRIPTION:
How can a payment be applied to multiple invoices?
Scenario 1
- 3 Invoices are created.
- A payment is received that covers 2 of the invoices, but not
necessarily in...
HOW TO USE M-FILES WITH QODBC
PROBLEM DESCRIPTION:
How to use M-Files with QODBC?
SOLUTION:
Please follow the steps below for using M-Files with QODBC.
1. Open M-Files Admin.
2. Expand the desired connection to the M-Files Server in the
left-side...
TROUBLESHOOTING - EXCEL ONLY RETURNS 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 the DateFrom and DateTo
parameters. The qu...
TROUBLESHOOTING - SERIAL NUMBER/LOT NUMBER QUANTITY ON HAND DOES NOT
MATCH THE QUICKBOOKS REPORT.
PROBLEM DESCRIPTION:
I recently ran into an issue when querying the inventory for each lot
number. In QuickBooks, there is a report called "Lot Numbers in...
TROUBLESHOOTING - HOW WOULD I PRODUCE A TRANSACTION LIST THAT
INCLUDES THE CLASS FIELD?
PROBLEM DESCRIPTION:
I am working on the transactions table, but I do not see a "class"
field. How would I produce a transaction list that includes the class
field...
TROUBLESHOOTING - HOW CAN I EXTRACT BUDGET DATA
PROBLEM DESCRIPTION:
I'm trying to extract QuickBooks budget data to SQL for reporting
purposes. However, I don't see any tables that would hold the budget.
My research is telling me this may not be possi...
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...
HOW TO AUTO-ADD A RELATIONSHIP BETWEEN TWO TABLES IN QLIKSENSE DESKTOP
USING QODBC
PROBLEM DESCRIPTION:
How to Auto-Add a relationship Between two tables in QlikSense Desktop
using QODBC?
SOLUTION:
Please create a new application in QlikSense Desktop...
HOW TO USE QLIKSENSE DESKTOP WITH QODBC
To use QlikSense Desktop with QODBC, please follow the steps below.
Open QlikSense Desktop & click on the "CREATE A NEW APP" button.
Enter the app name and click the "Create" button.
A New application in Qlik...
USING OPTIMIZER OFF FOR SELECTED TABLES IN AN MS-ACCESS LINKED TABLE
WITH QREMOTE
PROBLEM DESCRIPTION:
I am using QODBC to access QuickBooks Data. I have linked all
QuickBooks tables using QRemote DSN.
I want to use the Customer table to be Optimizer...
TROUBLESHOOTING - WHERE ITEM SERIAL NUMBERS OR LOT NUMBERS ARE STORED
PROBLEM DESCRIPTION:
I'm having trouble finding where an Item's serial numbers are stored
in the QuickBooks database. I have gone through your table schema
online here http://doc.qod...
TROUBLESHOOTING - ERROR 3180 - THERE WAS AN ERROR WHEN SAVING A DATA
EXTENSION NAMED ". "QUICKBOOKS ERROR MESSAGE: ATTRIBUTE WITH THE
SPECIFIED NAME ALREADY EXISTS.
PROBLEM DESCRIPTION:
I am using QODBC for creating Invoices in QuickBooks. I am using
C...
QUICKBOOKS SPECIFICATIONS FOR THE MAXIMUM NUMBER OF RECORDS OR
TRANSACTIONS
AS OF DATE: 2007-07-25
QuickBooks can handle a maximum of 2 billion transactions. The maximum
number of transactions is limited more by your computer's disk space
and memory t...
TROUBLESHOOTING - HOW CAN I ADD A LINE TO AN EXISTING CHECK
PROBLEM DESCRIPTION:
Is it possible to add a line to a check that already exists?
Here is an example from the QuickBooks Sample file. Below is a check
for $500.00
Now I want to add additio...
TROUBLESHOOTING - HOW CAN I ACCESS ONLINE BANKING ALIASES USING QODBC
PROBLEM DESCRIPTION:
Does anybody know which table the Online Banking Aliases data is
stored in QuickBooks?
To see what I'm talking about, go to the "Additional Info" tab of the
"E...
TROUBLESHOOTING - HOW TO LOCATE EMPLOYEE EMERGENCY CONTACT
INFORMATION USING QODBC
PROBLEM DESCRIPTION:
Is it possible to retrieve an employee's emergency contact
information? If so, from what table?
SOLUTION:
Employee Emergency Contact Information ...
TROUBLESHOOTING - HOW TO RECEIVE INVENTORY WITHOUT PURCHASE ORDERS
PROBLEM DESCRIPTION:
Is it possible to register an item's arrival without the purchase
order?
If yes, can I insert the rows in the "ItemReceiptItemLine" table using
the reference to t...
HOW TO AUTO-ADD A RELATIONSHIP BETWEEN TWO TABLES IN CRYSTAL REPORT
USING QODBC
PROBLEM DESCRIPTION:
How to Auto-Add a relationship between two tables in Crystal Report
using QODBC?
SOLUTION:
A relationship can be extracted using the ODBC function
"S...
QODBC READ-ONLY TABLE LIST
PROBLEM DESCRIPTION:
I am using QODBC & trying to modify data in QuickBooks. In a few
tables, I can't insert/update records.
I am getting a "[QODBC] Not supported" error when inserting records.
Also, I have noticed "Error ...
TROUBLESHOOTING - MS ACCESS AND QUICKBOOKS FREEZE (NOT RESPONDING)
WHEN ACCESSING FOR THE FIRST TIME
PROBLEM DESCRIPTION:
When pushing data from the Access database to QuickBooks, the QODBC
message indicates waiting on QuickBooks, and both Access and
Q...
TROUBLESHOOTING - HOW TO FIND AN ESTIMATE FOR INVOICE CONVERSION TIME
PROBLEM DESCRIPTION:
I am using MS Excel to access QuickBooks Data through QODBC. I have
Estimate & some of the Estimates are converted to QuickBooks. I want
to know how many Estimat...
TROUBLESHOOTING - WHO CREATED AN INVOICE/SALES ORDER
PROBLEM DESCRIPTION:
We don't have an operational problem, just a SQL/technical question --
we are currently pulling invoices like this:
SELECT * FROM Invoice WHERE RefNumber ='221206' (works great...
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 a Linke...
HOW QODBC OPTIMIZER WORKS
PROBLEM DESCRIPTION:
I am using QODBC to access QuickBooks Data. I am using the QODBC
optimizer, and I want to know more about how the optimizer works.
I can connect to QODBC, but when I fetch any table, it takes a lot of
ti...
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...
TROUBLESHOOTING - QODBC CUSTOMSUMMARY REPORT IS NOT RECONCILING WITH
QUICKBOOKS CUSTOMSUMMARY.
PROBLEM DESCRIPTION:
I am running the QODBC report "CustomSummary" and comparing it to what
should be the identical report in QuickBooks. I am encountering ...
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...
HOW TO EXPORT QUICKBOOKS INVOICES INTO CRYSTAL REPORT FORMAT
PROBLEM DESCRIPTION:
I would like to know if QODBC will convert QuickBooks Pro Desktop
invoices into Crystal Reports.
The attached invoice is similar to what we need to export to Crystal
R...
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]
to download the Sample Code.
Please refer to...
TROUBLESHOOTING - ERROR 3120 - OBJECT X SPECIFIED IN THE REQUEST
CANNOT BE FOUND.
PROBLEM DESCRIPTION:
I could link all tables to an MS Access DB from the QuickBooks
Database.
But I got the following error when I tried to open the
ItemAssembliesCanB...
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 take the changes
and needs the compa...
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:
...
SAMPLE CODE FOR INSERTING INVOICELINE TO AN EXISTING INVOICE USING
C#.NET WEB APPLICATION
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net.zip]
to download the Sample ...
SAMPLE CODE FOR INSERTING INVOICELINE TO AN EXISTING INVOICE USING
PHP
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVPHP/QODBC-Invoice-Insert-Sample-php.zip]
to download the Sample Code.
Please refer t...
TROUBLESHOOTING - HOW DO I GET THE COMPANY BUSINESS NUMBER
PROBLEM DESCRIPTION:
In QuickBooks Enterprise, the company information form shows me the
company's business#.
In a custom report, the field is displayed as blank.
In VBDEMO, the field shows as...
TROUBLESHOOTING - CANNOT LOAD CUSTOMER TABLE RECORDS.
PROBLEM DESCRIPTION:
I am trying to query the Customer table. The Title Bar of the Access
Application says Not responding. Still, it never opens for me in the
datasheet view, either double-clicking t...
TROUBLESHOOTING - UPDATE QUERY OPTIMIZATION.
PROBLEM DESCRIPTION:
Can you give me some insights on optimizing an update query to the
PriceLevelPerItem table?
I am trying to update all of my existing price levels, and I'm looping
through each inventory ...
TROUBLESHOOTING - GETTING ERROR [QODBC] REQUIRES AT LEAST ONE CHILD. I
CANNOT DELETE THE LAST LINE
PROBLEM DESCRIPTION:
I entered a series of purchase orders with queries that look like
this:
INSERT INTO PurchaseOrderLine ("VendorRefListID", "RefNumb...
TROUBLESHOOTING - REFUNDING CREDIT CARDS - THERE WAS AN ERROR WHEN
PARSING THE PROVIDED XML FILE.
PROBLEM DESCRIPTION:
Hello, I am trying to refund CC payments in QuickBooks. I can create
the credit memo. However, when attempting to add the refund us...
[QODBC-Desktop] Troubleshooting - Unable to load all customer records due to CustomerShippingAddress
TROUBLESHOOTING - UNABLE TO LOAD ALL CUSTOMER RECORDS DUE TO
CUSTOMERSHIPPINGADDRESS
PROBLEM DESCRIPTION:
I am unable to load all customer records through QODBC.
I have a large number of customers with ship-to addresses.
I have tried to execute th...
TROUBLESHOOTING - DOES QODBC SUPPORT "LIKE 'I%'"?
PROBLEM DESCRIPTION:
How should the following SQL query be written to work with QODBC,
using the "like" filter to restrict records?
SELECT Sales.RefNumber, Sales.BillAddressAddr1, Sales.Type,
Sales.Tx...
TROUBLESHOOTING - ERROR 3180 - THE CREDIT LIMIT FOR THE NAME ON THIS
TRANSACTION HAS BEEN EXCEEDED
PROBLEM DESCRIPTION:
We use QOBDC Read Write 8.00.00.234 with QuickBooks Enterprise 2007.
When trying to save a SalesOrder with three SalesOrderLines, r...
TROUBLESHOOTING - CHECK THE ISTOBEPRINTED UPDATE QUERY.
PROBLEM DESCRIPTION:
I'm having a problem running this SQL statement in QODBC TEST TOOL.
The application returns an error message: [QODBC] Not supported.
UPDATE Check SET IsToBePrinted = 1 WHERE ...
TROUBLESHOOTING - WHERE IS RETAINED EARNINGS DATA FOUND?
PROBLEM DESCRIPTION:
I cannot find a table with the retained earnings listed in it.
Furthermore, I found no transactions for this account, yet QuickBooks
reports two closing entries.
In the acc...
TROUBLESHOOTING - HOW TO INSERT UPDATE PAYROLLITEMNONWAGE LIKE AUTO
ALLOWANCE, BENEFITS, FEDERAL INCOME, ETC
PROBLEM DESCRIPTION:
How can we update the Insert PayrollItemNonWage field as Auto
Allowance, Benefits, Federal Income, etc.?
Suppose we add,...
TROUBLESHOOTING - EASIEST WAY TO MAKE A REPORT SHOWING THE AVERAGE
TIME BETWEEN RECEIPT AND INVOICE OF THE ITEM
PROBLEM DESCRIPTION:
I want to make a report to show me which items are selling quickly and
slowly. I figure I need to look at the length of...
NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING
ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER
JAVA-BASED APPLICATIONS.
Refer: Oracle JDBC-ODBC Bridge
[http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bri...
TROUBLESHOOTING - CREDITCARDINFOCREDITCARDNUMBER RETURNS ******1234
PROBLEM DESCRIPTION:
This used to work, and I have no idea why it now blinds all reads of
the CreditCardInfoCreditCardNumber field in the Customer table.
I previously used QODBC to t...
[QODBC-Desktop] Troubleshooting - Creating PO using Alpha Five basic scripting not working correctly
TROUBLESHOOTING - CREATING A PO USING ALPHA FIVE BASIC SCRIPTING IS
NOT WORKING CORRECTLY
PROBLEM DESCRIPTION:
I am using Alpha 5 version 10.5 basic scripting to export our data to
QuickBooks Enterprise 2016.
I have successfully exported our customer...
TROUBLESHOOTING - HOW TO CREATE PRICELEVELPERITEM &
PRICELEVELFIXEDPERCENTAGE USING QODBC
PROBLEM DESCRIPTION:
How to create PriceLevelPerItem & PriceLevelFixedPercentage using
QODBC.
SOLUTION:
To create a new PriceLevel and PriceLevelPerItem item (...
HOW TO INSERT A SALESORDERLINE ITEM INTO AN EXISTING SALESORDER
PROBLEM DESCRIPTION:
I routinely create new sales orders with queries similar to this:
INSERT INTO SalesOrderLine ("CustomerRefListID," "RefNumber,"
"SalesOrderLineItemRefListID," "Sales...
TROUBLESHOOTING - GETTING ODBC-CALL FAILED ERROR IN MS ACCESS WHEN
OPENING THE RECEIVEPAYMENTTODEPOSIT TABLE
PROBLEM DESCRIPTION:
I am trying to link the ReceivePaymentToDeposit table through the
linked table in MS Access. I can connect the ReceivePaym...
HOW TO CONNECT AND USE FOXPRO WITH QODBC
Open Visual FoxPro from the Start Menu:
FoxPro started:
Open "Command Window" from Windows Menu:
"Command Window" Opened. You can execute FoxPro commands from the
"Command Window."
You need to write FoxPro...
TROUBLESHOOTING - HOW CAN WE SELECT INVOICES FOR PAYMENT FROM THE
BILLTOPAY TABLE USING QODBC
PROBLEM DESCRIPTION:
In the BillToPay Table - How can we select invoices for payment using
QODBC?
We would like to have the Checkmark Selected for the resp...
TROUBLESHOOTING - MS ACCESS DISPLAYS "#DELETED" IN EVERY FIELD
PROBLEM DESCRIPTION:
Using QuickBooks Accountant, QODBC, and MS Access Linked table.
Sometimes, e.g., at present, working with the InventoryAdjustment
table, a table view or query returns...
Help Desk Software by Kayako