Knowledgebase
[QODBC-Desktop] How to run a Balance Sheet Standard Report in QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

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 as Amount, Amount_1_Title as "As of"
      parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'TotalOnly'

Predefined DateMacro Options

     All the predefined DateMacro options available to you are:

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

Display in QODBC

(208 vote(s))
Helpful
Not helpful

Comments (6)
Masar Hoxha
08 October 2015 11:57 AM
Hello, how can i run a BalanceSheet in Foreign Currency?

also the other SP_REPORT in FOREING CURRENCY?
Jack
09 October 2015 07:23 AM
Hi Masar,

I'm sorry to inform you that the showing report for each customer in their specific currency feature is not available through the Intuit SDK so they are not available through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn’t expose one feature to application in SDK, QODBC could not do it either.

If Intuit add this feature in the QuickBooks SDK, then QODBC will able to add this feature. So you need to ask Intuit to add this feature in SDK.
Nick
02 February 2016 04:02 PM
How can I change the "As Of" date so I can run it for previous periods?
Jack
04 February 2016 01:45 PM
Hi Nick,

You can use DateFrom & DateTo parameters for running report for specific period.

For Example:

sp_report BalanceSheetStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of" parameters DateFrom = {d'2014-10-01'}, DateTo= {d'2014-10-31'}, SummarizeColumnsBy = 'TotalOnly'
Bobby Gill
19 May 2016 11:11 PM
Is there a way to include multiple time periods on the balance sheet? For example, if I wanted to include the account balances for each month end for the last twelve months?
Jack
20 May 2016 07:47 AM
Hi Bobby,

You can use SummarizeColumnsBy = 'Month' parameter for account balances for each month end for the last twelve months.

For Example:
sp_report BalanceSheetStandard parameters DateFrom = {d'2015-01-01'}, DateTo= {d'2015-12-31'}, SummarizeColumnsBy = 'Month'

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).