A - In your situation, I would suggest you use A/R Aging Report by Collector. Since most of our users do not have multiple collectors, we can be innovative. To do this, go to Customer File maintenance and make all your customers' collector fields the same as the salesman. Then the A/R Aging Report by Collector is the same as by salesman. Unfortunately, there is no utility to change all your collectors to be the same as your salesmen. We could help you to do a mass update through the PSQL back end. Don't do this yourself. Just call us, if you don't want to manually change customer collectors yourself. In the future, you need to adopt a new procedure when adding customers, or change the customer's salesman and ensure the collector is equal to the salesman.
If the above procedure is too much for you, another alternative is to use the A/R Expanded Aging Report which can exported to a CSV file. the Salesman column is part of the CSV file. Therefore, you can bring up this CSV file in Excel, and sort by salesman (then, customer, apply-to# and doc-date). This will be equivalent to the A/R Aging Report by Salesman in the spreadsheet format.EMK