[QODBC-Desktop] How to find MONEY TRANSFERS BETWEEN ACCOUNTS transactions using QODBC
Posted by Juliet (QODBC Support) on 22 July 2010 08:38 AM
|
|
How to find MONEY TRANSFERS BETWEEN ACCOUNTS transactions using QODBCNote: This is a known issue with the Intuit qbXML SDK. One would expect that they would appear in the Journal Entry tables, but they currently do not. Sp_report Querysp_report CustomTxnDetail show TxnType, Date, Memo, Account, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonth', SummarizeRowsBy = 'TotalOnly', OpenBalanceAsOf = 'Today', TxnFilterTypes='Transfer' where RowType='DataRow' Parameter Data LocationDateMacro='ThisMonth' shows transactions for this month to date. It could also be 'ThisWeek', 'Yesterday', or 'Today.' How to Insert New Transfers using QODBCWhen using QODBC (instead of the QuickBooks User Interface), you could debit and credit the amount from the accounts using a General Journal. See: How to create Journal Entries using QODBC. | |
|