RSS Feed
Knowledgebase : QODBC Online > Sp_commands & Reports
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 PROFIT AND LOSS STANDARD REPORT IN QUICKBOOKS ONLINE REPORT DISPLAYED IN QODBC STORED PROCEDURE COMMAND With QODBC Online the same report can be generated using stored procedure reports like this: sp_report ProfitAndLossStandard show RowDat...
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...
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...