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
Salesman Security
Released Date: 08/30/2017 Sometimes your organization may use outside sales representatives. These reps, often, are not your real employees. In many cases, they represent multiple vendors' products. If you choose to let them access your Elliott ...
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 ...
ARCTLMNT Accounts Receivable A/R Setup
A/R Setup Application Overview A/R Setup is not an application that you will be running very often. In this application, you will answer some questions that tailor the Accounts Receivable package to the way you do accounting in your company. For ...
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 ...
Limitations for Inventory Aging Report
Release Date: 08/15/2018 The Inventory Aging Report is a very valuable tool. It is primarily used to determine the aging of the inventory for all locations for the current date, but you could use it for a specific location or use it to determine the ...