How to Print A/R Aging Report by Salesman
Q - How can we print an
AR Aging Report by Salesperson? The sale isn't complete till paid!! We need an AR report to give to the Sales Group as they usually prefer to contact their clients -- some relationships are tricky. The current AR report just needs to be modified to use customer field #21 as an option "by Salesperson." I think this report would help all collect their AR most efficiently.
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
Related Articles
Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
Release Date: 7/6/2016 A new selection field has been added to the Expanded Aging report screen. Before this change the report only included Open Items. The report may now be created that includes closed items. Enter "N" in field 8 to include closed ...
ARAGEMNU Accounts Receivable Aging Reports
Reports Aging Reports Application Overview The Aging Reports are reports that can tell you a great deal about the state of a customer's account. It will tell you how much the customer owes you, and how old these owed amounts are. In A/R Setup, you ...
ARSLMMNT Accounts Receivable Salesman File Maintenance
Salesman File Maintenance Application Overview You will use the Salesman File to keep a file of all of the salespersons you employ. There are many places in the Accounts Receivable package where this file is very useful. Here are a few of them. When ...
Feature - A/R Aging Report by Collector Customer Name Option
Release Date: 1/12/16 When printing the A/R Aging Report by Collector, entry of a new field "Sort By Customer No./Name (C=Customer Number, N=Customer Name)" has been added. The default is "C" for customer number, which is the current report sort ...
CPOPNSSN Customer Order Processing Open Orders by Salesman Report
Open Orders by Salesman Report Application Overview This report featuring only open orders can be used as a sales analysis auditing tool, measure productivity, and as a customer service tool. You can print the report for a single salesman or a range ...