|
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
|
|
| ARAging reports by customer |
| Author |
Message |
|
|
| Posted : 2007-04-28 09:11:57 |
Hi,
Is there a way to run the ARAging reports by customer instead of by accounts? In other words, is it possible "join" the ARAgingDetail report to Customer table so we can run identify a customer by aging? Thanks |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-04-29 17:36:12 |
|
|
|
|
|
| Posted : 2007-05-01 02:00:02 |
I've taken a look at that - I see that you can pull the customer name in the ar aging detail.
What I need is to get a custom field in the Customer table. We use that custom field to identify customers with our other systems. So I need to pull the aging report by customer's customfield.
If not, is there a way to at least pull the customer id, then I can run a select query to join up the customer id with the custom field.
Also, are the names of the customers guaranteed to be unique in the ar aging report - unque enough to do a sql join on?
thanks in advance!
Dan |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-05-01 10:20:52 |
| Sorry you can't link a stored procedure report to a table, but you can use ROWDATA to uniquely identify the customer/job:
sp_report ARAgingSummary show RowData, 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 DateMacro = 'Today', AgingAsOf = 'ReportEndDate'
Simply read/append the report into a local table, like for example a MS Access table and then link it to the Customer table.
|
|
|
|
|