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
|
|
P&L by Class summarizing incorrectly |
Author |
Message |
Al |
|
Group | : Members |
Posts | : 4 |
Joined | : 2007-02-17 |
|
Profile |
|
Posted : 2008-05-01 03:50:05 |
I have a P&L query that I run by class with multiple level expense accounts that works fine from QB, but running the SP_report from VB Demo, some of the account summarizations are showing at a higher level than should be.
I searched the forum and haven't seen this before, and wondered if that rang a bell with you?
tks
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-05-01 07:58:51 |
When debugging a sp_report use the DisplayReport='Yes' parameter to force the report to be displayed in the QuickBooks user interface (QBUI), for example:-
sp_report ProfitAndLossByClass show Label, Amount parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'Class', DisplayReport='Yes' where RowType = 'DataRow'
This then allows you to examine how the sp_report statement built the report and you can then play around with the fitler settings in the QBUI to correct the report and to see what the problem may be.
See: Profit & Loss Summary Report by Class and How do I use the QuickBooks Reporting Engine with QODBC? I've heard something about sp_report ? for more. |
|
|
|
|