|
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
|
|
| Change the Interval for the ARAgingSummary Report |
| Author |
Message |
|
|
| Posted : 2008-06-19 04:15:41 |
I am trying to customize the ARAgingSummary report in MS Access. I would like to change the Interval to 15 days from 30 days.
I see that this is possible within QBooks, but I cannot see how to change the interval setting for the Amount column in SQL. My query looks like this:
sp_report ARAgingSummary show Current_Title, Text, Label, Current, Amount_1 as "1 - 30", Amount_2 as "31 - 60", Amount_3 as "61 - 90", Amount_4 as "> 90", Amount_5 as TOTAL
parameters DateTo = {d'2008-05-31'}, AgingAsOf = 'ReportEndDate'
Where Amount_3 > 0
But I would prefer it to be something more like this:
sp_report ARAgingSummary show Current_Title, Text, Label, Current, Amount_1 as "1 - 15", Amount_2 as "16 - 30", Amount_3 as "31 - 45", Amount_4 as "46 - 60", Amount_5 as "61 - 75", Amount_6 as "76 - 90", Amount_7 as "> 90", Amount_8 as TOTAL
parameters DateTo = {d'2008-05-31'}, AgingAsOf = 'ReportEndDate'
Where Amount_3 > 0
Is this possible? Thanks for your help.
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-06-19 08:20:25 |
Sorry no, the Days per aging period? QuickBooks parameter is not currently implemented in either sp_report ARAgingSummary or the ARAgingDetail report.
|
|
|
|
|