Running the Aged Receivables by Salesperson Report

The Aged Receivables by Salesperson Report is an aged accounts report to help you manage your receivables.

You can run the report for salespeople assigned to bill-to customers or ship-to customers. For each selected customer, the report displays summary information about the money owed to you, followed by a list of their outstanding invoices and associated aging categories. In addition, totals are listed by salesperson, customer and total received.

If the Apply credits to oldest buckets when aging account field is flagged on the Credit Control Parameters window, the Aged Receivables by Salesperson Report displays all credits as applied to the oldest aging bucket with a balance. Flagging that field does not cause a cash receipts application of credits to open invoices. That must be done manually using the Cash Receipts program.

To run the Aged Receivables by Salesperson Report:

1. From the Reports > End of Month Reports > Salesperson & Writer Reports menu, select Aged Receivables by Salesperson to display the Aged Receivables by Salesperson Report window.

2. In the Data Through field, enter the date through which to display aged receivables. The system populates this field with the current date, but you can change it, if needed. This field supports variable dates.

3. In the Age as of field, enter the date from which to age the receivables. The system populates this field with the current date. This field supports variable dates.

4. Complete or change the fields, as needed:

   Field	Description
   Salesperson	The login ID of a specific sales representative whose accounts you want to review. To run the report for all sales representatives, leave this field blank.
   Customer	The name of a specific customer whose receivables you want to review. To run the report for all customers, leave this field blank.
   Report Currency	Determines the currency to use when calculating receivables. Enter one of the following: Base - Runs the report in your company's base currency, as defined in Control Maintenance. Customer Primary - Runs the report in each customer's primary currency, as defined in the Primary Currency field of the Customer Pricing/Printing screen accessed from Customer Maintenance. Valid Currencies - Lists each valid currency. Select a currency to run the report in that currency.
   Home Branches	Displays receivables for the accounts in a specific home branch. To include all customer accounts that have been assigned a home branch, enter ALL.
   Sale Branches	Displays receivables for the orders entered at a specific branch. To include accounts from all sale or pricing branches, enter ALL. You can use this option to produce reports detailing sales transaction activity out of one or more branches. It is particularly useful for situations when branches represent separate companies and those branches run their own reports.
   Customers with Debit Amounts	The aging period for which to include customers who have an amount due. If left blank, all customers who have an amount due in any aging period are included.
   Print Activity Comments with Source	Limits the activity comments printed in the report to only those assigned to a particular source. If left blank, the report lists all comments associated with the designated receivable.
   Comments Entered After	Limits log entries to those made after a specific date. If left blank, the report lists all comments associated with the designated receivable.
   Customer Level	Limits the report to either Bill-To or Ship-To customers.
   Print Shipdates	Indicate if you want to print ship dates for the orders listed.

    

5. Select the Print Shipdates box to include ship dates on the report.

6. In the Display Options area, indicate which level of detail you want to print on the report:

• Detail - In addition to listing the information included in the summary version, lists each invoice and the amount due in each aging category. To run the report for a salesperson, enter their ID in the Salesperson field. If left blank, the report includes all salespeople.

• Summary - Lists each customer and the total amounts due in each aging category.

Note: When run in Detail mode, if an invoice does not have a balance, the invoice does not print. However, if the invoice has a balance of $0.00, the invoice does print.

7. In the Include Blank Home Branches area, indicate if you want to include blank home branches.

8. In the Sales Person area, indicate whether to select accounts by the customer's inside sales representative or the outside sales representative. The default value is Outside.

9. In the Respect Balance Forward Flags area, indicate if you want to list the balance forward on the report.

Note: This field is accessible only if you run the report in Detail format.

10. In the Credits area, indicate if you want to include or exclude orders with credits.

11. Set options, if needed, and generate the report.