Knowledgebase: Sp_commands & Reports
[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:

|All|Today|Yesterday|ThisWeek|ThisWeekToDate|LastWeek|LastWeekToDate|NextWeek|NextFourWeeks
|ThisMonth|ThisMonthToDate|LastMonth|LastMonthToDate|NextMonth|ThisQuarter|ThisQuarterToDate
|LastQuarter|LastQuarterToDate|NextQuarter|ThisYear|ThisYearToDate|LastYear|LastYearToDate|NextYear|

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))
Helpful
Not helpful

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