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 AccountProblem 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. 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.' | |
|
Comments (0)