Knowledgebase
[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 QODBC

Note: 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.

          You can, however, extract your "MONEY TRANSFERS BETWEEN ACCOUNTS" transactions using the TxnListByDate or CustomTxnDetail sp_reports like below.

Sp_report Query

sp_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 Location

DateMacro='ThisMonth' shows transactions for this month to date. Could also be 'ThisWeek', 'Yesterday' or 'Today'
TxnFilterTypes='Transfer' filters the results to only show you Money Transfers
RowType='DataRow' displays the result as data only (no report headers or totals) like when using QODBC tables.

How to Insert New Transfers using QODBC

     When it comes to using QODBC (instead of the QuickBooks User Interface) you could simply debit and credit the amount from the accounts using a General Journal. See: How to create Journal Entries using QODBC

(138 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).