Knowledgebase: Setup
[QODBC-Desktop] Quick Report on an Account
Posted by Jack - QODBC Support on 11 August 2014 09:32 AM

Troubleshooting: Quick Report on an Account

Problem Description:

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


Please use the below command: sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAccount, Debit, Credit parameters DateMacro = 'ThisYearToDate,' AccountFilterFullNames = 'Suspense Income,' SummarizeRowsBy = 'Account,' OpenBalanceAsOf = 'ReportEndDate.'  

(1 vote(s))
Not helpful

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