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 screen, 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 Reprts > End of Month Reports > Salesperson & Writer Reports menu, select Aged Receivables by Salesperson to display the Aged Receivables by Salesperson Report screen.

  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 following fields, as needed:

Field

Description

Detail/Summary

Indicates what level of detail 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.

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.

Incl Blank Home Br (Y/N)

To include customer accounts that have not been assigned a home branch, enter Y; otherwise, enter N.

Cust w/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 w/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.

Select In/Outside Salesperson

Indicates whether to select accounts by the customer's inside sales representative or the outside sales representative. The default value is Outside.

Respect Balance Forward Flags (Y/N)

To list the balance forward on the report, enter Y; otherwise, enter N.

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

Customer Level

Indicates whether to report on the customers' bill-to or ship-to accounts. The default value is Bill-To.

Credits (Include/Exclude)

Indicates whether to include or exclude invoices with a negative balance.

Print ShipDates on Reports (Y/N)

To include ship dates on the report for each invoice, enter Y; otherwise, enter N.

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