Database Reference
In-Depth Information
e. Daily Invoice Register: For each invoice produced on a given day, list the invoice number,
invoice date, customer number, customer name, sales amount, freight, and invoice total. A
sample of this report is shown in Figure A-22.
343
HOLT DISTRIBUTORS
DAILY INVOICE REGISTER FOR 10/15/2013
10/16/2013
PAGE 1
Invoice
Number
Invoice
Date
Customer
Number
Customer
Name
Sales
Amount
Invoice
Amount
Freight
11025
10/15/2013
1354
Smith Rentals
$414.00
$42.50
$456.50
$2,840.50
$238.20
$3,078.70
FIGURE A-22
Daily invoice register
f. Monthly Invoice Register: The monthly invoice register has the same format as the daily
invoice register, but it includes data for all invoices that occurred during the selected month.
g. Stock Status Report: For each part, list the part number, description, price, MTD and YTD
sales, units on hand, units allocated, and reorder point. For each part for which the number
of units on hand is less than the reorder point, an asterisk should appear at the far right of
the report.
h. Reorder Point List: This report has the same format as the stock status report. Other than
the title, the only difference is that parts for which the number of units on hand is greater
than or equal to the reorder point will not appear on this report.
i. Vendor Report: For each vendor, list the vendor number, name, address, city, state, and zip.
In addition, for each part supplied by the vendor, list the part number, the description, the
price the vendor charges for the part, the minimum order quantity that the vendor will
accept for this part, and the expected lead time for delivery of this part from the vendor.
j. Daily Cash Receipts Journal: For each payment received on a given day, list the number and
name of the customer that made the payment and the payment amount. A sample report is
shown in Figure A-23.
10/05/2013
HOLT DISTRIBUTORS
DAILY CASH RECEIPTS JOURNAL
PAGE 1
Payment
Number
Customer
Number
Customer
Name
Payment
Amount
5807
1354
Smith Rentals
$1,000.00
$12,235.50
FIGURE A-23
Daily cash receipts journal
k. Monthly Cash Receipts Journal: The monthly cash receipts journal has the same format as
the daily cash receipts journal, but it includes all cash receipts for the month.
l. Customer Mailing Labels: A sample of the three-across mailing labels printed by the system
is shown in Figure A-24.
