Aged A/R Detail

This report is a prior date report that lists each customer with amounts owed printed in five aging categories: Current, 31-60 Days, 61-90 Days, 91-120 Days, and Over 120 Days. The unpaid invoice details include the invoice# with document date, due date, PO#, and the invoice amount, discount and unpaid balance.
This is the detailed report corresponding to Aged A/R Summary.

The Aged A/R report can be generated for an earlier period.
This program recreates the customer account status as of a selected cutoff date. It uses the Payment History and accurately identifies the exact invoices that were paid.

The option is provided to print the output or export it to an Excel spreadsheet.
When printed to a spreadsheet, the document division is listed in the first column of the data, and the aging information is printed for each invoice.
An option is provided to also print a line on the spreadsheet to summarize the Aging Totals.

There is also an option to print the prior date report in an Expanded format. If selected, the report prints aging periods for 91 - 120 days, 121 - 150 days, 151 - 180 days, and OVER 180 days.

The P.O.# on the spreadsheet reflects both the P.O. posted on the AR transaction and the P.O. assigned to the Invoice if they are different.

The prompts are:

CUT-OFF DATE

This date determines the ending point for printing invoices. The cut-off date applies to the document date not the due date.

Accept today's date as the cut-off date or enter a preferred cut-off date.

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

AGE AS OF MONTH END

Aging refers to the grouping of the unpaid invoices by date, such as 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.

STARTING NAME

Leave this field blank for all customers, or type in the first name or lookup the starting customer from the search window, as outlined in Accounting Customer Search.

ENDING NAME

Leave this field blank for all customers, or type in the last name, or lookup the ending customer in the search window.

ALL CURRENCIES

Check this box to include all currencies.

Uncheck this box to select a currency.

CURRENCY CODE

Enter a Currency code or select one from the drop-down list.

ALL SALESMAN CODES

Check this box to include customers for all salesman codes.

Uncheck this box to select a salesman.

SALESMAN CODE

Enter a Salesman code or select one from the drop-down list as setup in Salesman Codes.
Only customers assigned to this Salesman in the Codes window of Customer Information will be included on the report, regardless of the Salesman recorded on the invoice.

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 divisions or divisions by customer region to include in the report, as outlined in Division Select By Region.

The divisions included in the report output are restricted by the Access Values assigned to the operator.
For more information on this security feature refer to Divisional Restricted Views.

PRINT ZERO BALANCE TRANSACTIONS

Uncheck this box to include only customers with outstanding invoices, finance charges or unapplied payments.

Check this box to print the complete history of the account, including both unpaid invoices (transactions with a balance), and paid invoices (transactions with a zero balance).

AGE BY DUE DATE

Uncheck this box to age the report by the actual Invoice Date.

Check this box to age the report by the Due Date of the invoice.

PRINT EXPANDED AGED A/R

Check this box to include extra aging categories. The usual Current, 31-60, 61-90, are printed and then it also breaks the Over 90 Days column into 91-120 days, 121-150 days, 151-180 days, and over 180 days.
The expanded aging categories may be useful if you submit this report to a bank or other credit institution.

Uncheck this box to group the aging categories as just Current, 31-60, 61-90, and Over 90.

CUSTOMER ACCOUNT TYPE

Select one of the following account types for the customers as flagged in Customer Information:

• Cash to list only customers flagged as Cash only.
• On Account to list only customers flagged as charge On Account.
• Both to include all customers.

SALESMAN TO USE

This field really only applies to the spreadsheet output for invoice documents, as the report output does not print the salesman, and the payments and finance charges are always associated with the 'customer' salesman.

Select one of the following Salesman sources for the invoice details to print on the Excel output:

• Click Invoice to list the salesman assigned to the invoice in the spreadsheet details.
  If the output is being generated for a single Salesman per the Salesman Code field above, all invoices with that selected Salesman on the Invoice are listed on the spreadsheet, regardless of the Salesman assigned in Customer Information.

• Click Customer to list the salesman assigned in the Customer Information.
  If the output is being generated for a single Salesman per the Salesman Code field above, all invoices for a customer that has been assigned the selected Salesman in Customer Codes are returned on the output, regardless of the salesman on the document.

Note: The report output always selects by Customer Salesman as assigned in Customer Codes.

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.

INCLUDE CUSTOMER AGING LINE

This selection option is only available with the Excel spreadsheet output.

Check this box to print an extra line for each Customer with the Aging Totals. The aging at the invoice level will always print.
Uncheck this box if the summarized Aging Totals by customer is not required on the output.

ACCEPT or CANCEL

Click the ACCEPT button to begin printing the report, or CANCEL to abort.

Note: Because the program uses the Payment History, this option may not be accurate if the A/R has ever been compressed.