Database Reference
In-Depth Information
344
Smith Rentals
153 Main St.
Suite 102
Grandville, MI 49494
Kayland Enterprises
267 29th St
Wyoming, MI 48222
John & Sons, Inc.
5563 Crestview
Ada, MI 49292
• • •
• • •
• • •
• • •
• • •
• • •
• • •
FIGURE A-24
Customer mailing labels
m. Statements: The system must produce a monthly statement for each active customer. A
sample statement is shown in Figure A-25.
HOLT DISTRIBUTORS
146 NELSON PLACE
BRONSTON, MI 49802
11/01/2013
Smith Rentals Customer Number: 1354
153 Main St. Sales Rep: 10 - Brown, Sam
Suite 102
Grandville, MI 49494 Limit: $5,000.00
Invoice
Number
10945
Description
Date
10/02/2013
10/05/2013
10/15/2013
10/22/2013
Total Amount
Invoice
Payment
Invoice
Payment
$1,230.00
$1,000.00CR
$456.50
$500.00CR
11025
Over 90
$0.00
Over 60
$198.50
Over 30
$490.20
Current
$1,686.50
Total Due >>>>>>
$2,325.20
Previous
Balance
Current
Invoices
Current Payments
$2,138.70
$1,686.50
$1,500.00
FIGURE A-25
Statement for Holt Distributors
n. Monthly Sales Rep Commission Report: For each sales rep, list his or her number, name,
address, MTD sales, YTD sales, MTD commission earned, YTD commission earned, and com-
mission rate.
o. Aged Trial Balance: The aged trial balance report contains the same information that is
printed on each customer
'
s statement.
Month-end processing. Month-end processing consists of the following actions that occur at
the end of each month:
a. Update customer account information. In addition to the customer
s actual balance, the sys-
tem must maintain the following records: current debt, debt incurred within the last 30 days,
'
