Aged A/R Summary - Selected


Accounts Receivable Menu -> Reports -> Aged A/R Summary - Selected

Accounts Receivable Menu -> Reports -> Aged A/R Summary -> Current Selected option -> Aged A/R Summary - Selected


This report is intended to be a collection tool for the Accounts Receivable clerk.
Accounts over a certain dollar amount, or over 60 days or over 90 days can be identified for focus when collecting on delinquent accounts.
After the accounts are selected, the accounts print out the totals based on the current status of the account.

This report uses the same print format as Aged A/R Summary.
A summary by customer and a summary by division are generated.
The prompts are:

REPORT TYPE
Select one of the following reporting options:
  • Select Prior Date to generate the Aged A/R Report using the prior date formula as outlined in Aged A/R Summary.
    This option might be slightly slower, however it is more accurate for result as of a cut-off date other than today.
  • Select Current Selected to generate the Aged A/R Report as of today with the options to select the customer accounts by cut-off date and amount as outlined below.

CUT-OFF DATE
This date determines the ending point for printing invoices.
Accept today's date for the cut-off date or enter a preferred cut-off date.

NOTE: Invoices or payments posted after the aging date will not print and are not included in the Totals.


AGE AS OF MONTH END
Aging refers to the classification of the unpaid invoices according to Current, 31-60, 61-90 and Over 90 days.

Check this box to age the account using the current month end.
e.g. If the current month end was February 28th, an invoice issued January 31st would be aged as 31-60 Days (with the rest of January invoices).

Uncheck this box to age the invoices according to invoice date.
e.g. If the month end was Feb 28th, an invoice dated Jan. 31st would be Current (with invoices dated 30 days or less).


SELECTED CUT-OFF DATE
To select accounts that have amounts owing over 60 days, type in a cut-off date of 60 days ago.
e.g. If today is Dec 31st, type in Oct 31st.

To select accounts based on a dollar amount only, accept today as the selected cut-off date.


STARTING NAME
Leave this field blank to include all customers, or enter the first few characters of the starting customer name, or select the customer from the Document Customer Search window.

ENDING NAME
Leave this field blank to include all customers, or enter the first few characters of the ending customer name, or select the ending customer from the window.

CURRENCY CODE
Check this box for all currencies.

Uncheck this box to specify a single currency.

CODE
Enter a currency code or select one from the drop-down list as setup in Currency Codes.

DIVISION, "ALL" OR "SEL"
  • Type ALL to include all divisions in the report.
  • To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
  • Type SEL to select several specific divisions or divisions by customer region to include in the report, as outlined in Division Select By Region.

DIVISION TO USE
Select one of the following division source options:
  • Select Customer to print the report by the division assigned to the customer in Customer Information.
  • Select Invoice to print the Aged A/R Summary by the division on each Invoice.

CUT-OFF AMOUNT
Accept the default value displayed to choose the accounts according to the selected cut-off date only.

To select accounts based on dollar amount, type in the minimum amount,
e.g. To select only accounts that are over $200.00, type in 200.00 for Cut-Off Amount.

If the Selected Cut-Off Date is NOT today's date, then this program will combine both the Selected Cut-Off Date and the Cut-Off Amount when choosing the accounts.
e.g. If the Selected Cut-off Date was 60 days ago and the cut-off amount was $200.00, then only accounts which have $200.00 or more over 60 days will be printed.


ALL TYPES
Check this box to include all types of customer.

Uncheck this box to select a specific Customer Type.

CUSTOMER TYPE
Enter a Type or select one from the drop-down list as setup in Customer Types.

REPORT OPTIONS
This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?
Click the ACCEPT button to generate the output, or CANCEL to abort.

Topic Keyword: ARAR23
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)