Sounds like you want a BalanceSheetSummary report.
sp_report BalanceSheetSummary show Amount_Title, Text, Label, Amount parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'TotalOnly'
Or for all the details:
sp_report BalanceSheetDetail show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, ClearedStatus_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Blank, TxnType, Date, RefNumber, Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonthToDate'
See: What do the new stored procedures SP_REPORTS and SP_PARAMETERS do? for more information on what parameters are available in each report. |