|
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
|
|
| How do I suppress display of zero or null Amount accounts in ProfitAndLossBudgetOverview report? |
| Author |
Message |
|
|
| Posted : 2008-03-08 05:23:14 |
Hi Tom,
Is there a report parameter (or any other solution) to skip the zero 'Balance Total' amount sub-level accounts and its parent level accounts from the report?
I will greatly appreciate your hints please. My SQL is below:
sp_report ProfitAndLossBudgetOverview show Text, Label, Amount_1, Amount_2, Amount_3, Amount_4
parameters FiscalYear = 2008, SummarizeBudgetRowsBy = 'Account'
where NestedText6 is NULL and (Text is not NULL or Amount_1 <> 0)
It skipped an account which had a zero value for January but has a value for February. The Total Income line did not appear.
May be I will have to obtain the account numbers from Label or Text columns, total them and skip them if they are zero.
May I request you to add such a parameter value in future to the reports please?
Thank you very much,
Piyush |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-03-12 11:15:52 |
Try testing the TOTAL column:
sp_report ProfitAndLossBudgetOverview show Text, Label, Amount_1, Amount_2, Amount_3, Amount_4 as TOTAL
parameters FiscalYear = 2008, SummarizeBudgetRowsBy = 'Account'
where (Text is not NULL or Amount_4 <> 0) |
|
|
|
|
|
| Posted : 2008-03-13 12:02:35 |
Hi Tom,
Quick Books does not display Inactive accounts in the report.
How do I do it using a report parameter or other means please?
Thank you,
Piyush |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-03-13 12:48:05 |
Just add a list of the accounts you don't want to see, for example:
sp_report ProfitAndLossBudgetOverview show Text, Label, Amount_1, Amount_2, Amount_3, Amount_4 as TOTAL
parameters FiscalYear = 2008, SummarizeBudgetRowsBy = 'Account'
Where Text is not NULL or (Amount_4 <> 0
and not (AccountFullName = 'Construction:Discounts given'
or AccountFullName = 'Interest Expense:Loan Interest')) |
|
|
|
|