Knowledgebase: TroubleShooting
[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

 

 

Tags: QuickBooks Online, QBO, QODBC Online, report, Balance sheet

 

(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).