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.

http://support.flexquarters.com/esupport/newimages/QuickReportAccount/Step1.jpg

Solutions:

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))
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).