RSS Feed
Knowledgebase : Tutorials > Sp_commands & Reports
TYPICAL TIME BY JOB SUMMARY 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 TimeByJobSummary show Label, Duration_1 as "Dur M...
NOTE: Actually we don't have a sp_report for the QuickBooks "Open Sales Order by Item" report which is not available via Intuit SDK, however, I've managed to extract similar data using QODBC. TYPICAL OPEN SALES ORDER BY ITEM REPORT IN QUICKBOOKS For ...
TYPICAL TRIAL BALANCE 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 TrialBalance show Debit_1_Title as Date, Label as Account...
TYPICAL TIME BY NAME REPORT IN QUICKBOOKS The following interesting Time By Name Report was created in QuickBooks to show the number of hours/month for each employee: REPORT DISPLAYED IN QODBC STORED PROCEDURE COMMAND With QODBC the same report can...
TYPICAL OPEN INVOICES 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 OpenInvoices show Text, Rowdata as Type, Blank, TxnType, D...
TYPICAL A/R AGING SUMMARY REPORT IN QUICKBOOKS NOTE: It's easy to get confused here, in QODBC Today often means your system date, while in QuickBooks Today means the QuickBooks date. So when looking at the QuickBooks sample files, or company files that ...
PROBLEM DESCRIPTION: Can you please tell me which tables and fields link the purchase order payments to purchase orders? I can't seem to track that. Basically, I need to see how much has been paid against a purchase order and that the outstanding bala...
TYPICAL BALANCE SHEET STANDARD 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 BalanceSheetStandard show Text, Label, Amount_1 a...
HOW TO RUN JOB PROFITABILITY SUMMARY REPORT USING QODBC NOTE: When trying to extract a report showing total profitability per customer, for all jobs. A sp_report named Job Profitability Summary could get what you want. SYNTAX IN QODBC NORMAL SYNTAX I...
INSTRUCTIONS FOR PASS-THROUGH QUERY IN ACCESS NOTE: "Pass-through" reports or queries are useful as it allows specific SQL statements to be sent directly to QODBC (including connection settings), bypassing the MS Access syntax checker. HOW TO CREATE P...
ONLINE DATA LAYOUTS SOURCE   We have provided the tools to help you determine where field information comes from in QuickBooks, which tables contain the information you want, how tables can be related, and sample SQL statements. Please click here [http:...
INSTRUCTIONS QODBC works by accepting SQL commands through the ODBC Interface, then converting those calls to qbXML navigational commands within the QuickBooks SDK and returning recordsets that qualify for the query results. This driver is not a Client/...
Typical Customer Balance Detail Report in QuickBooks Report Displayed in QODBC Stored Procedure Command       With QODBC the same report can be generated using stored procedure reports like this:     ...
TYPICAL JOB ESTIMATES VS. ACTUALS SUMMARY 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 JobEstimatesVsActualsSummary show Text...
Typical Profit and Loss Budget Overview Report (for the current Fiscal Year to Date) in QuickBooks Note: The QuickBooks Sample files set the QuickBooks date to December 15, 2007, hence the current Fiscal Year shown above is October 1 through Decembe...
Typical Profit and Loss Standard Report in QuickBooks Report Displayed in QODBC Stored Procedure Command        With QODBC the same report can be generated using stored procedure reports like this:   &nbs...
TOPIC LIST FOR "HOW TO RUN REPORTS IN QODBC" How to run an ARAging Summary Report in QODBC [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2080] How to run a Balance Sheet Standard Report in QODBC [http://support.flexqu...
HOW TO USE BATCH STATEMENTS WITH QODBC NOTE: There are three stored procedures for batch statements which are SP_BATCHCLEAR, SP_BATCHSTART, SP_BATCHUPDATE. SP_BATCHCLEAR SYNTAX AND INSTRUCTION SP_BATCHCLEAR tablename - Clears any cached batch statem...
Schema Rules in QuickBooks Online Edition THE SCHEMA RULES DIFFERENCES BETWEEN LOCAL QUICKBOOKS AND QBOE INSTRUCTIONS Schema rules in QuickBooks Online Edition are different from local QuickBooks version, this article lists all table modes available ...
PROBLEM DESCRIPTION 1: Where are the "Company & Financial" sp_report for "Statement of Cash Flow" and "Cash Flow Forecast"? Is there any other way I can access values for 'Cash at the beginning of period' and 'Cash at the end of period' please? SOLUT...
HOW TO BUILD ASSEMBLY REPORT VIA QODBC PROBLEM DESCRIPTION: How can I Build Assembly report via QODBC SOLUTION: If you want to replicate the Build Assembly report via QODBC, I kingly suggest you to pull CustomSummary records using QODBC, below are t...
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. ...
HOW CAN I FIND SOURCE OF SP_REPORT PROBLEM DESCRIPTION 1: Is there a way to see the SQL that QuickBooks uses to generate their reports? Also, Which tool do they use to generate reports? PROBLEM DESCRIPTION 2: I need to access information that is u...
TROUBLESHOOTING: SP_REPORT BALANCESHEETSTANDARD REPORT ERROR "[QODBC] AT LEAST ONE FIELD REQUESTED REQUIRES DATEFROM TO BE SET". PROBLEM DESCRIPTION: I am running BalanceSheetStandard through VB Demo & It is returning below error. When I run this que...
TROUBLESHOOTING: SP_REPORT PROFITANDLOSSBUDGETPERFORMANCE IS RETURNING NO ROWS. PROBLEM DESCRIPTION 1: I am running ProfitAndLossBudgetPerformance through MS Query & It is returning no rows. But using QuickBooks UI I am able to get records from ProfitA...
TROUBLESHOOTING: QUICK REPORT ON AN ACCOUNT PROBLEM DESCRIPTION: How can I get a Quick Report on an account from Chart of Accounts? In Quick Books 2006 Premier, I opened chart of accounts (Ctrl+A) then selected an account and then pressed Ctrl+Q. SOLU...
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...
TYPICAL BALANCE SHEET REPORT IN QUICKBOOKS ONLINE REPORT DISPLAYED IN QODBC ONLINE STORED PROCEDURE COMMAND With QODBC the same report can be generated using stored procedure reports like this: sp_report BalanceSheetDetail show RowData, Amount_1 as...
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 CAN I USE WILDCARD (*) WITH CRYSTAL REPORT AND SP_REPORT PROBLEM DESCRIPTION: I am using the following sql statement: sp_report JobProfitabilityDetail show AmountActualCost_Title, AmountActualRevenue_Title, AmountDifferenceActu...
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 - 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 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...