A typical Custom Transaction Detail Report in QuickBooks looks like this:
With QODBC the same report can be generated using stored procedure reports like this:
sp_report CustomTxnDetail show Text, Blank, TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonthToDate', SummarizeRowsBy = 'TotalOnly', OpenBalanceAsOf = 'Today'
|