SQL EXAMPLES FOR: Custom Txn Detail

SQL STATEMENT EXAMPLES

sp_report CustomTxnDetail show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, Account_Title, ClearedStatus_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Text, Blank, TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonthToDate', SummarizeRowsBy = 'TotalOnly', OpenBalanceAsOf = 'Today'