RSS Feed
Knowledgebase : TroubleShooting > Sp_commands & Reports
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...
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 can I get it in QODBC. ...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING. PROBLEM DESCRIPTION: When I run report query, query works very slow & take about 1-5 mins per simple report like: "sp_report ARAgingSummary show Current parameters DateFrom={d'2014-11-12'}, Dat...
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...
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, L...
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 ...
INSTRUCTIONS QODBC Online works by accepting SQL commands through the ODBC Interface, then converting those calls to qbXML navigational commands within the QuickBooks Online API and returning recordsets that qualify for the query results. This driver is...
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...
TROUBLESHOOTING - HOW DO I VOID AN INVOICE? PROBLEM DESCRIPTION: How do I void an Invoice? And How do I query for invoices that have been voided? I don't see any kind of indicator in the Invoice table. SOLUTION: You can use SP_VOID just like you wo...
TROUBLESHOOTING - 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 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 that it returns contains...
TROUBLESHOOTING - SP_REPORT CHANGING DAYS PER AGING USING QODBC PROBLEM DESCRIPTION: I recently discovered QODBC and have been playing around with it for a few days now. It's pretty good. The problem I have is when I try to get an A/P aging. The A/P...
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 particular products over ...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL PACKAGE PROBLEM DESCRIPTION: I am getting Error SOCKET Closed because of abnormal package in QRemote client. I am accessing QuickBooks Data from the remote machine over the internet (WA...
TROUBLESHOOTING - GETTING INCOMPLETE DATA WHEN RUNNING PROFITANDLOSSBUDGETVSACTUAL REPORT PROBLEM DESCRIPTION: Good Day To You. Using This Sp_report And Having Some Problem With The Column Layout. Command Text Is As Follows: Sp_report Profitandlossbud...