Accounts Receivable System Reports by Legler Systems in CA

Legler Systems Company

AR Reports

Accounts Receivable System Reports

The accounts receivable reports can be requested at any time, sorted and printed on a standard line printer or a laser printer. Most accounts receivable reports are 120 characters wide (landscape), while some audit control reports are 80 characters wide (portrait). Also, these standard accounts receivable reports can be written to a temporary disk file for subsequent viewing in a separate report window by using procedure 92V or 92W.

A new 2018 option (Sys-Opt-44 in DB03) converts all uppercase letters to upper and lowercase letters when accounts receivable reports are printed for easier reading.

The standard accounts receivable reports are Customer Invoice Report, Cash Receipts Report, Customer Master List, Aged Receivables Report, Receivables Distribution Report, Outstanding Invoice Report, Customer History Report and Receivables Posting Report. Each of these standard reports have several variations based on selection parameters entered online by the user. Preprinted forms are generally used for Statement of Accounts and Past Due Notices. Some 43 accounting and management reports printed by the Accounts Receivable System from Legler Systems are identified below.

List of Accounts Receivable Reports:

     PROC S  B   AR Report name and description
      --  -  -   ---------------------------------------------------------
  1.  04  Y  Y   Cash Receipts Report by accounting period range.
  2.  04  Y  Y   Cash Receipts Report by received date range.
  3.  04  Y  Y   Cash Receipts Report by location code (4).
  4.  04  Y  Y   Cash Receipts Report by customer number (4).
  5.  04  Y  Y   Cash Receipts Report by bank ID (4).
  6.  04  Y  Y   Cash Receipts Report by credit code (4).
  7.  04  Y  Y   Cash Receipts Report by batch number (4).
  8.  04  Y  N   Cash Receipts Summary by status code, account code
                   and invoice date (5).
  9.  05  Y  Y   Customer Invoice Report by accounting period range.
 10.  05  Y  Y   Customer Invoice Report by invoice date range.
 11.  05  Y  Y   Customer Invoice Report by location code (4).
 12.  05  Y  Y   Customer Invoice Report by salesman code (4).
 13.  05  Y  Y   Customer Invoice Report by customer number (4).
 14.  05  Y  Y   Customer Invoice Report by status code (4).
 15.  05  Y  Y   Customer Invoice Report by batch number (4).
 16.  05  Y  N   Customer Invoice Summary by product number, account code
                   and invoice date (5).
 17.  06  Y  Y   Customer Master List by location code (4).
 18.  06  Y  Y   Customer Master List of active or inactive customers.
 19.  06  Y  Y   Customer Master List by salesman code (4).
 20.  06  Y  Y   Customer Master List by batch number (4).
 21.  06  Y  N   Customer Master Summary by total customer sales (5).
 22.  07  Y  Y   Aged Receivables Report by location code (4).
 23.  07  Y  Y   Aged Receivables Report by bank ID (4).
 24.  08  Y  Y   Receivables Distribution Report by period range.
 25.  08  Y  Y   Receivables Distribution Report by customer number (4).
 26.  08  Y  Y   Receivables Distribution Report by account code (4).
 27.  08  Y  Y   Receivables Distribution Report by department number (4).
 28.  08  Y  N   Receivables Distribution Summary by account code
                   and department number (5).
 29.  09  N  N   Receivables Posting Report by location (4) - Preliminary.
 30.  09  N  N   Receivables Posting Report by location (4) - Final.
 31.  11  Y  N   Statement of Accounts by customer number range.
 32.  11  Y  N   Statement of Accounts by location code (4).
 33.  12  Y  N   Past Due Notices by customer number range.
 34.  12  Y  N   Past Due Notices by location code (4).
 35.  13  N  N   ARS Purge Control Report by period range - Counts only.
 36.  13  N  N   ARS Purge Control Report by period range - File update.
 37.  14  N  N   ARS Batch Input Report - Preliminary.
 38.  14  N  N   ARS Batch Input Report - Final.
 39.  16  Y  Y   Outstanding Invoice Report by customer number (4).
 40.  16  Y  Y   Outstanding Invoice Report by location code (4).
 41.  16  Y  N   Outstanding Invoice Summary by days late (5).
 42.  17  Y  Y   Customer History Report for amounts received.
 43.  17  Y  Y   Customer History Report for number of invoices.

--------------------------------------------------------------------------
Notes:
 1.  Column "PROC" refers to the online procedure number on the AR menu.
 2.  Column "S" means sort by customer number, ZIP, name initials or
       Alphasort when 'Y', otherwise 'N' means no record sorting.
 3.  Column "B" indicates both online processing and batch job processing
       is available when 'Y', otherwise 'N' means no batch processing,
       only online processing.
 4.  These accounts receivable reports can be printed for a single customer
       or all vendors.
 5.  Summary reports are printed when the 'Entry Correct' prompt = "S".
--------------------------------------------------------------------------

In addition to the standard accounts receivable reports identified above, custom accounts receivable reports can be created, sorted and printed by procedure DB12 in the Database Control System, where the user specifies the data content and report format.

The online procedures that print these accounts receivable reports are described in the Accounts Receivable Menu document.

More Information on the AR Software:

Any questions about these Accounts Receivable System reports, e-mail Bill Legler in the SF Bay Area, California or go to the Accounts Receivable System main page.