Knowledgebase: TroubleShooting
[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 Chart of Accounts? In Quick Books 2006 Premier, I opened chart of accounts (Ctrl+A) then selected an account and then pressed Ctrl+Q.

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

Solutions:

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