[QODBC-DESKTOP] TROUBLESHOOTING - NO DATA RETURNED - UNABLE TO EXECUTE
- INVENTORYSTOCKSTATUSBYITEM
PROBLEM DESCRIPTION
Upon pulling QuickBooks data into Microsoft Access, I didn't see any
values (all blank) in the QuantityonOrder field of either the...
SOLVED: [QODBC ONLINE] COLUMN NOT FOUND - ARAGINGSUMMARY AND
APAGINGSUMMARY
PROBLEM DESCRIPTION:
Unable to use ARAgingSummary and APAgingSummary
Error - Column not found: Amount_Title, Column not found: Amount_1,
Column not found: Amount
SOLUTIONS:
...
TROUBLESHOOTING - GETTING INCOMPLETE DATA WHEN RUNNING THE
PROFITANDLOSSBUDGETVSACTUAL REPORT
PROBLEM DESCRIPTION:
Good Day To You. Using This Sp_report And Having Some Problems With
The Column Layout. Command Text Is As Follows: Sp_report
Profitandlo...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL
PACKAGE
PROBLEM DESCRIPTION:
I am getting Error SOCKET Closed because of an abnormal package in the
QRemote client. I am accessing QuickBooks Data from the remote machine
over the inter...
TROUBLESHOOTING - REPORTING SHIP TO ADDRESSES
PROBLEM DESCRIPTION:
Has anyone run a report that will pull all the detail for a range of
invoices? In particular, I'm looking to run a report that shows the
ship-to addresses for specific products over a ...
TROUBLESHOOTING - SP_REPORT CHANGING DAYS PER AGING USING QODBC
PROBLEM DESCRIPTION:
I recently discovered QODBC and have been playing with it for a few
days. It's pretty good.
The problem I have is when I try to get A/P aging. The A/P aging has a
d...
TROUBLESHOOTING - HOW DO I REMOVE SUBTOTALS AND BLANK LINES IN
SP_REPORT
PROBLEM DESCRIPTION:
I'm trying to link a general ledger report in Excel. I've created the
sp_report SQL query in Microsoft Query just fine, but the data it
returns contains subt...
TROUBLESHOOTING - BILLABLE PAYROLL - NEED TO DISPLAY MORE FIELDS ON
INVOICE
PROBLEM DESCRIPTION:
We need to bill all payroll costs to various customers. Payroll costs
are defined as all of the following:
1. Employee's gross salary
2. Company share ...
TROUBLESHOOTING - HOW DO I VOID AN INVOICE?
PROBLEM DESCRIPTION:
I don't see any indicator in the Invoice table. How do I void an
Invoice? And How do I query for invoices that have been voided?
SOLUTION:
You can use SP_VOID just like you would use ...
DETAILED DIFFERENCE BETWEEN QODBC FOR QUICKBOOKS DESKTOP AND ONLINE.
TABLE DIFFERENCES:
QODBC for QuickBooks Desktop has 150 tables while QODBC for
QuickBooks Online has 83 tables.
TABLE IN QODBC FOR QUICKBOOKS DESKTOP BUT NOT IN QODBC FOR QUICKBOOKS...
INSTRUCTIONS
QODBC Online accepts SQL commands through the ODBC Interface, then
converts those calls to qbXML navigational orders within the
QuickBooks Online API and returns recordsets that qualify for the
query results. This driver is not a Client/Ser...
TYPICAL TRIAL BALANCE REPORT IN QUICKBOOKS ONLINE
REPORT DISPLAYED IN QODBC
STORED PROCEDURE COMMAND
With QODBC, the same report can be generated using stored procedure
reports like this:
sp_report TrialBalance show RowData as Account, Amount_1 as...
TYPICAL PROFIT AND LOSS BY CLASS REPORT IN QUICKBOOKS
REPORT DISPLAYED IN QODBC
STORED PROCEDURE COMMAND
With QODBC, the same report can be generated using stored procedure
reports like this:
sp_report ProfitAndLossByClass show Amount_Title, Text, ...
DIFFERENCE BETWEEN QODBC FOR QUICKBOOKS DESKTOP AND ONLINE.
TABLE DIFFERENCES:
Number of Tables available in
QODBC DESKTOP
QODBC ONLINE
150
83
List of Tables available in QODBC Desktop
[http://doc.qodbc.com/qodbc/usa/TableList.php?catego...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING.
PROBLEM DESCRIPTION:
When I run a report query, the query works very slowly & takes about
1-5 mins per simple report like:
"sp_report ARAgingSummary show Current parameters
DateFrom={d'2014-11-...
HOW TO GET MEMORIZED TRANSACTIONS & MEMORIZED REPORTS IN QODBC
PROBLEM DESCRIPTIONS:
How can I get information about Memorized Transactions & Memorized
Reports using QODBC?
I can see them in QuickBooks, but I don't know how to get them in
QODBC.
SOL...
PROBLEM DESCRIPTION:
I am attempting to add InvoiceLine records to a sample company. I
exported 15 InvoiceLine records from QuickBooks via QODBC, then built
a table with these records trimmed down to what I believe are the
minimum required fields, then a...
Help Desk Software by Kayako