Forum : Quick Report on an AccountSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Reporting Forum

 New Topic 
 
 Post Reply 
[1]  
 Quick Report on an Account 
 Author   Message 
  Piyush Varma 
  
 Group: Members 
 Posts: 68 
 Joined: 2006-04-06 
 Profile
 Posted : 2008-03-21 07:58:17

How can I get a Quick Report on an account from Chart of Accounts? In Quick Books 2006 Premier, I opened chart of accounts (Ctrl+A) then selected an account and then pressed Ctrl+Q.



Thanks you,

Piyush

 

 

  Top 
  Tom Aczel 
  dd4bf_dawworld.jpg
 Group: Administrator 
 Posts: 6281 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-03-26 11:40:09

Try:

sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, Memo,
Account, ClearedStatus, SplitAccount, Debit, Credit
parameters DateMacro = 'ThisYearToDate', AccountFilterFullNames = 'Suspense Income',
SummarizeRowsBy = 'Account',
OpenBalanceAsOf = 'ReportEndDate'

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to