Accounts Receivable Features:
The primary objective of the Accounts Receivable (AR) System from Legler Systems
is to process accounts receivable information in an online environment, so
specific online procedures are performed in seconds rather than the hours required
for traditional batch methods of computer processing. This AR System performs
the basic accounts receivable objectives by providing a complete and accurate
record of all accounting transactions affecting each customer.
Specific Accounts Receivable features and objectives of this software are
highlighted below:
- Maintain a Customer Invoice Record on the dollar amounts to be collected
from customers, as well as the associated general ledger revenue account codes.
- Automatic voucher number assignment is done when new customer invoice
transactions are added to the AR System for control and audit trail purposes.
This accounts receivable feature can be overridden by the setting of
System-Option-16 (DB03).
- Automatically post revenue information to specific ledger accounts in
the General Ledger System (AR09) by accounting period (YRMO) to
eliminate clerical posting errors. Either the cash accounting method
or accrual accounting method is supported.
- Print accounting reports, such as Customer Invoice Report, Cash
Receipts Report, Aged Receivables Report, Receivables Distribution
Report and other reports to provide an audit trail of accounting data
entered into the system, so adequate control is maintained over
company cash receipts and GL revenue distributions.
- Print customer statements (AR11) showing the invoices issued during
the period and customer payments received.
- Automatically calculate the average days delay between the invoice
date and the date the customer payment is received and update this
information in the Customer Master Record.
- Maintain a Customer Master Record for each customer invoiced by the
company. Information in this record includes customer name,
address, sales tax rate terms, credit dollar limit and general
ledger revenue account codes.
- Handle cash sales associated with customer invoices.
- Allow for the receipt of a partial customer payment
against a single customer invoice. Up to four parital customer payments
can be entered for one customer invoice.
- Print Past Due Notices (AR12) showing all unpaid customer invoices and
calculate a customer finance charge when requested by the user.
New Customer Invoice Records can be automatically created to reflect
this customer finance charge.
- Provide reporting capability by different locations. The location
code used by this system should be consistent with that used by
other financial systems installed at the company.
- Provide auxiliary input capability for initial file creation and
processing input transactions created by other computerized systems,
including separate data entry operations.
- Handle any fiscal year for accounting purposes, even one different from
the calendar year, through the use of a separate accounting period
number (YRMO) field.
- Provide source document control over input invoice transactions to the
computer by establishing batch numbers.
- Provide online inquiry capability to identify all invoices and
payments received for a specific customer.
- Provide online inquiry capability to identify all invoices
associated with a specific customer and to summarize payments by
month for the last five years.
- Define an Active-Flag for each customer to prohibit online entry of new
invoice data for an inactive customer, yet reference that old customer
number for historical reporting purposes.
- Handle multiple bank accounts through a user definable Bank-ID code.
- Automatically update the Customer Master Record with new total sales
for the latest two years with automatic rollover from one year to
the next, so special year-end clerical procedures are avoided.
- Provide the capability to create custom AR reports where the user
defines the data fields to be selected, sorted and printed. Procedure
DB12 is a general purpose custom report writer that produces
custom AR reports.
- Provide the capability to enter customer prepayment information in AR03
and automatically update the actual invoice when it is added to the
AR System by procedures AR02, AR14 or OE05. This customer prepayment
information stored in a temporary Customer Invoice Record.
- Customer payment application,/B> allows the updating of
multiple customer invoices at one time from a single payment using
procedure AR18.
- Allow the user to specify the sequence of records in a report by
entering a primary (customer) and secondary (invoice) sort option.
- Automatically display a detail record (Customer Master Record,
Customer Invoice Record or Cash Receipts) when function key F7 is
pressed from data entry procedure AR03 and procedure AR02 and from
inquiry procedure AR10 and procedure AR15. This accounts receivable
objective enables the operator to quickly drill down to more information.
- Select customer invoices with a credit balance, invoices with a net
balance less than x dollars, or invoices with net balance greater
than y dollars when printing the Aged Receivables Report (AR07) and
Outstanding Invoice Report (AR16).
- Verify the state code and ZIP code (first 3 digits) associated with
a customer address. The Canadian province code is validated when
the ZIP code is not numeric.
- Automatic customer number lookup by initals occurs whenever the
customer name initials are entered as the customer number for faster
customer number lookup. The customer name initials are manually or
automatically set in the Customer Master Record when it was created.
- Automatically test for duplicate invoices at the time of entry of
new customer invoices. This option is set by System-Option-25.
- Establish a Sales-Tax code to identify different sales tax rates and
store it in each Customer Master Record to minimize file updates
associated with a sales tax rate change. This accounts receivable
objective allows the user to define multiple county Sales-Tax codes.
- Provide system options in the Company Control Record to handle
6-digit or 8-digit dates for user preference.
- In addition to online processing, batch job processing is supported where
AR report requests are entered online for later batch processing.
Customer prepayment information can be entered into the Accounts Receivable
System as a Customer Invoice Record prior to entry of the actual invoice
where a temporary record is created with a special invoice number (PPNNNN).
When the actual invoice is added to the system, customer prepayment information
is automatically moved to the new invoice and the temporary prepayment record
is deleted.
The Accounts Receivable System keeps track of unpaid customer invoices
and partial customer payments against an invoice. The Aged Receivables Report
(AR07) can be printed at any time to identify the total dollar amount of all
unpaid invoices by customer. Individual unpaid customer invoices
are identified in the Outstanding Invoice Report (AR16).
Customer statements (Statement of Account) and Past Due Notices are
printed on letter-size paper for direct mailing to customers with the company
heading format specified by System-Option-12 (DB03).
The AR System procedures that can be run by the user are identified in the
Accounts Receivable Menu document.
Customer Master Record:
Customer name and address information is stored in the Customer Master Record.
Online procedure AR01 is used to add, change (modify), query or delete
Customer Invoice Records by entering a specific customer number. For new
customers, automatic customer number assignment is done by the AR System
when the customer number is blank. The customer name and address printed on
customer statements and past due notices is from these master records.
The primary key of the Customer Master Record is the Record-Type code and
customer number.
Customer Invoice Record:
Each customer invoice mailed to a customer is stored in a separate
Customer Invoice Record. Online procedure AR02 is used to add, change (modify),
query and delete Customer Invoice Records. For all new customer invoice entries,
the voucher is automaticlly assigned using a sequence number counter in
the Company Control Record (DB03). Procedure AR03 is used to modify
Customer Invoice Records with customer payment information. These transaction
records identify the invoices sent to the customer for payment.
The primary key of the Customer Invoice Record is the Record-Type code,
customer number and voucher number.
More Information on Accounts Receivable Objectives:
For additional information on this online Accounts Receivable software,
please e-mail Bill Legler in the SF Bay Area, California
or go to the Accounts Receivable System page.
Version 7.11 - Copyright 2010 by Legler Systems Company. All rights reserved.