Knowledgebase: QODBC Online
[QODBC-Online] How to run a Balance Sheet Detail Report in QODBC Online
Posted by Jack - QODBC Support on 27 November 2015 11:12 AM

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 Amount
      parameters DateMacro = 'ThisYearToDate'

Predefined DateMacro Options

     All the predefined DateMacro options available to you are:


Display in QODBC

      sp_report BalanceSheetDetail show RowData, Amount_1 as Jan16,Amount_2 as Feb16, Amount_3 as March16      parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'Month' where RowType='DataRow'

Display in QODBC


Also Refer

How to use the QuickBooks Reporting Engine with QODBC Online

List of Reports available in QODBC Online

List of Parameters available in BalanceSheetDetail report

(1 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).