Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Profit and Loss report - ALL ACCOUNT |
Author |
Message |
|
Posted : 2006-08-02 07:39:16 |
The P&L reports don't include all of the accounts that make the P&L from our Quickbooks application. We run a Quickbooks P&L with ALL ACCOUNTS (income and expense), and I can't seem to do this with sp_report. Any help on running a standard P&L with ALL ACCOUNTS? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-02 10:20:06 |
The following report appears exactly the same as it appears in QuickBooks:
sp_report ProfitAndLossStandard show Text, Label, Amount_1 parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'TotalOnly'
|
|
|
|
|
Posted : 2006-08-03 01:10:33 |
OOOOOOK; gee thanks. However - the P&L reports I generate are missing numerous income accounts. Note that I am filtering to a single class in the QODBC query, and using the same filter in the Quickbooks report. See for yourself - these reports are vastly different:
QUERY:
sp_report ProfitAndLossStandard show Text, Label, Amount_1 parameters DateMacro = 'LastMonth', SummarizeColumnsBy = 'TotalOnly', ClassFilterFullNames = '300-ADV'
QODBC:
QUICKBOOKS:
QB FILTERS:
3020-Closing Fee seems to be the only income account that shows on the QODBC report; when there are 5 additional income accounts on the Quickbooks report... What gives?
Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-03 08:43:03 |
You need to be doing:
sp_report ProfitAndLossStandard show Text, Label, Amount_1 parameters DateMacro = 'LastMonth', SummarizeColumnsBy = 'TotalOnly', ClassFilterFullNameWithChildren = '300-ADV' |
|
|
|
|