How to create Accounts Receivable (A/R) Report for each Sales Rep (Salesman Report)

We will be using available Custom Fields, one for Sales Rep on Sales Forms (Invoice, Sales Receipt and Estimates). And, generate customized report to get Accounts Receivable for each Salesman Report. Since there is no way do it from the Customer Detail page. This page has no field for to include Sales Rep.

First, we will enable Custom Fields on. This feature is available in Essentials and Plus, but not in Simple Start.

From the home page screen > company gear (upper right corner) > settings > company settings > Sales > Sales form content > Custom fields > assign “Sales Rep” to custom fields > Check Internal and Public > OK > Done

Go to back to Invoice Form. Create Invoice. Assign Sales Rep on Invoice.

To generate report > From the home page screen > Go to blue navigation bar on the left > Reports > Go to report (magnifying glass) and type/select “A/R Aging Detail” report

Select Customize button (upper left) > Select “Change Columns” blue button inder Rows/Columns > Select “Sales Rep” from Available Columns list > Add > Move down or up to change order > OK

Go to Match > Sales Rep > Enter Name of Sales Person (as you have entered on Invoice)

Go Header/Footer > Change Report Title to: Customer Outstanding Invoices Report for Salesman by name (say Kathy as an example) > Run Report

Go to “Save Customizations” button > Name Custom Report (as you want it, say Kathy’s Report for example) > Add this report to a group by adding new name or selecting from existing list (optional) > Share this report with all company users (optional) > OK

Now, you have created and save Customized Report for Customer Outstanding Invoices Report for Kathy

You can follow the same steps to create customized report for each salesman.

Next time go to Reports and choose “My Custom Reports” and select Report from the list. Edit and Run Report as needed.


Watch Video Tutorial! We highly encourage you to watch the entire video. You do not want to miss a step!
http://youtu.be/_PpzrCx0RwA


 
1 Customer Information Page

2 Custom Fields

3 Invoice with Sales Rep Name

4 Customize AR Aging Detail

5 Select and Reorder Columns

6 Change Report Title Name

7 Customer Outstanding Invoices Report

8 Save Report Customizations