Customer Address List (Report # 3-1)
Customer Phone List (Report # 3-3)
Multi-Code Sales Tax (Report # 3-5)
Shipping Labels From Orders (Report # 3-7)
Open Orders By Customers (Report # 3-8)
Customer Open Invoices (Report # 3-9)
Customer Order List (Report # 3-10)
Customer Invoice Ledger (Report # 3-11)
Customer Aged Trial Balance (Report # 3-12)
Customer Invoices on Plain Paper (Report # 3-13)
Customer Payment Ledger (Report # 3-14)
Customer Current Activity (Report # 3-15)
Customer Total Summary (Report # 3-16)
Shipping Info. By Customer (Report # 3-17)
Deposit Ticket (Report # 3-18)
Inventory Sold By G/L# (Report # 3-19)
Generate Finance Charges (Report # 3-20)
Packing List on Plain Paper (Report # 3-21)
Customer Invoice Payments (Report # 3-23)
Customer Orders Without Prices (Report # 3-24)
Customer Back-orders (Report # 3-25)
Customer Review (Report # 3-26)
A/R Sales By G/L # (Report # 3-27)
A/R Sales Journal by Invoice Number (Report # 3-28)
Count Customer Types (Report # 3-29)
Customer Address Labels (Report # 3-30)
Statements on Plain Paper (Report # 3-31)
Generate Invoices From Orders (Report # 3-32)
Customer Payments (Report # 3-33)
Sorted A/R Reports (Report # 3-34)
Customer Orders With Prices (Report # 3-35)
Statements on Nebs 9060 (Report # 3-36)
Cash Deposits By G/L# (Report # 3-37)
Customer Invoices on Forms 9040 (Report # 3-38)
Sales Tax Payable (Report # 3-39)
Salesperson List (Report # 3-40)
Customer Address List (Report # 3-1)
This is a wide report that prints customer codes,
names, addresses, and phone numbers. It may be
printed for a certain customer type, or for only
those customers who have activity after the date
entered.
You first need to choose if you want the report sorted by customer, salesman, type, or zipcode.
Customer List (Report # 3-2)
This report allows you to specify if you
want the Customer Codes & Names printed
in a 1, 2, or 3-column format.
The computer asks "Do you want condensed print?" if you choose 3-column format.
Customer Phone List (Report # 3-3)
This report prints the customer names and phone
numbers as set up in the Customer file (C).
The names and phone numbers are listed in two columns.
Customer Types (Report # 3-4)
This prints a list of the Customer Types and their
Privileges as entered in the Customer Type file
(Y).
Multi-Code Sales Tax (Report # 3-5)
This report calculates taxable and nontaxable sales, and
the tax amount for one or more tax codes.
When you run the report, you have the option of a 4-column report or a wide 9-column report. You can specify starting and ending invoice dates. The invoices included in the report are those that are within the set of reference numbers and within the dates specified.
The report lists Invoice #, date and customer name. The Report totals are at the top of the report. This is so you don't have to print the whole report in order to see the totals.
The report shows Net Sales and Total Tax in the first column. In each of the following columns are shown Non-Taxable Sales, Taxable Sales, Net Sales, and the Tax Amount, one tax code per column. Net Sales is total sales excluding tax.
Invoices that have no Tax code specified will show up in a "?" column.
For information on how to set up various tax codes see <Multiple Tax Codes> in your manual. Or press M to see the same information on the screen.
Quote Prices (Report # 3-6)
This prints the list of quoted prices from the
Quoted Prices file (Q), listing the customers in
alphabetical order followed by the items and
prices that have been quoted to them.
Shipping Labels From Orders (Report # 3-7)
This report works with Quantity/Label on the
Inventory file (I). It takes the amount in
Qty/Label to determine how many packages are
needed to ship the orders on file.
A label is printed for each package or part package.
Open Orders By Customers (Report # 3-8)
This report prints a list of the open orders
sorted alphabetically by customer Code.
Customer Open Invoices (Report # 3-9)
This report lists open invoices for each customer.
This may be sorted by Customer, Salesman, or
Customer Type.
Customer Order List (Report # 3-10)
This report prints a list of customer orders,
listed numerically by Order #.
Customer Invoice Ledger (Report # 3-11)
This is a list of invoices in numerical order,
with a total at the end. Use this report to get a
sales total for a sequence of invoices; for
example, to find the total sales for the day or
the month. To get a summary, select the report by
entering 11S from the 3 screen. The report will
print only the total without listing the whole
sequence of invoices.
The computer asks for Beginning and Ending
customer Type. If you have the Enhanced Version of
ABC Accounting, you can choose to list only the
invoices of customers of a certain type,
otherwise, simply press
Customer Aged Trial Balance (Report # 3-12)
You first need to choose to sort the report by customer,
salesman or type (Customer Type is part of the Enhanced
package.) You also have the option of choosing a one-line
format (one line per customer), or the detailed format
which lists each open invoice by customer.
This report checks the total of the open invoices and the
non-invoice amount against the customer balance. If they
are equal the customer is in balance. If an asterisk (*)
appears to the left of a customer balance, it indicates
that particular customer is out of balance. When this
happens, there will also be an asterisk at the end of the
report, with the words OUT OF BALANCE and the pages which
have the out-of-balance customers. If there are no
asterisks on the report, the computer will print, REPORT
IN BALANCE.
CAUTION! When an Aging Cutoff Date is used which is
earlier than the current date and payments were made after
that date, the computer will indicate that the report is
out of balance. This is because the computer lists
payments entered after the cut-off date but not invoices,
but the BALANCE at the end of the report includes ALL
invoices and payments.
Setting the Overdue Invoice Date determines which
customers will be listed. Any customers who only have open
invoices after that date will not be reported. Any
customers who have one or more invoices on or before that
date will be reported.
Customer Invoices on Plain Paper (Report # 3-13)
On taxable invoices, a "T" is printed beside each
taxable amount. The total taxable amount is
printed on the sales tax line.
Customer Payment Ledger (Report # 3-14)
To get a summary, select the report by entering 14S from the
3 screen. The report will print only the total without
listing the whole sequence of payments.
Customer Current Activity (Report # 3-15)
Customer Total Summary (Report # 3-16)
Shipping Info. By Customer (Report # 3-17)
Deposit Ticket (Report # 3-18)
Enter your bank account number in the Bank Dep# field on
the System Setup screen 2 (&) as you want it to appear on
this report.
Inventory Sold By G/L# (Report # 3-19)
Generate Finance Charges (Report # 3-20)
For finance charge calculation to work, the FINANCE CHARGE
INFO must be set up in the System Setup Screen 2 (&).
When you invoice finance charges, the report date is
critical because it is used to calculate the age of open
invoices.
Finance charges are based on the actual number of days any
invoice has been overdue, not including any days for which
finance charges were already applied. Days overdue are
determined by either the Due Date on the invoice or the
Free Days in the System Setup Screen 2 (&), whichever
comes first. However, a charge is applied only if the
report date is past both the Due Date on the invoice and
the Days Till Charge in the System Setup Screen 2 (&).
When the report is finished, the Last Finance Charge Date
is set to the Report Date.
Finance charges are not applied to customers with an "N"
in Late Charge on the Customer file (C), or to individual
invoices with an "N" in Interest Code.
Finance charges are stored as receivable invoices,
beginning with the next available reference number. A
total appears at the end of the report. Because they are
stored as invoices, the finance charges may be reprinted
with Report # 3 - 11 CUSTOMER INVOICE LEDGER.
Packing List on Plain Paper (Report # 3-21)
Customer Activity Report With Balance
(Report # 3-22)
This report prints an analysis of each customer's
payments, paid invoices, and open invoices.
Every invoice and payment are listed, starting
with the most recent. The fifth column is a
running balance.
You have the choice of selecting a monthly
analysis.
Customer Invoice Payments (Report # 3-23)
Customer Orders Without Prices (Report # 3-24)
Customer Back-orders (Report # 3-25)
Customer Review (Report # 3-26)
A/R Sales By G/L # (Report # 3-27)
A/R Sales Journal by Invoice Number (Report # 3-28)
Count Customer Types (Report # 3-29)
Customer Address Labels (Report # 3-30)
1. It can be printed alphabetically by Customer Code, or
by Zip Code.
2. You may select customers with a Print Code, or a
combination of several Print Codes. One customer may have
Print Codes of A,B,C and another Print Codes of B,C,E. If
you enter a Print Code of A,B and answer the question
"Must a Customer have all the Codes? (Y/N)" with a "Y",
only the first customer will print since the customer must
have an A and a B in Print Code. If you enter "N", both
the first and second customers will print since only one
of the codes must be found in the customer Print Code.
3. When an Activity Date is entered, only customers who
have a Post Date on or after the entered Activity Date
will print.
4. The message prints on the first line of the address on
the right hand side of the label or envelope.
5. If you are printing in alphabetical order by Customer
Code, you may print on labels, print on envelopes, list
the addresses on a page, or merge them with a record set
up on the Word Processor file (W). When merging the file
with a Word Processor record, the Word record must have
print insert (^I) or replace (^R) information on the Word
Processor page so that the name and address will print at
the proper locations. For each customer record that this
report selects, it will print the currently loaded page on
the Word Processor screen (W) and merge the customer data
at the places specified.
6. If you want a list of Customers sorted by how many
invoices they have and\or by the dollar amount from a
specified time in the past to the present, enter an
Accumulation Date to specify the time to count from, enter
the minimum number of invoices and enter the minimum
dollar amount.
A total of the address labels printed will be printed on
an additional label if there are more than 10 labels on
the list.
Statements on Plain Paper (Report # 3-31)
If you wish to print statements listing only invoices
after a certain date, you can do so by entering a (#)
followed by that date, when you are asked for a special
message. This occurs immediately after you press S for
screen or P for print. Be sure to enter it using this
format: #04/01/1996.
Generate Invoices From Orders (Report # 3-32)
If a group of orders all have the same Bill Code, you can
generate invoices for the whole group at once. (The Bill
Code is entered in the bottom right-hand corner of the
Order screen.) Enter the Bill Code of the orders that you
wish to invoice, when the computer asks for an
auto-invoice code.
You may have a special description print on the invoice.
To do this you must enter a dash "-" in the description
field on the order where you want the message to appear
and a dash "-" in the Unit field of that line.
Customer Payments (Report # 3-33)
Sorted A/R Reports (Report # 3-34)
When you choose to sort with (S), (1), or (2), you will
need to specify which salesmen you want the report printed
for, rather than which A/R Invoices. Enter the Salesman
Code in the "Starting at" and "Ending with" fields on the
Report Generator screen.
TURNS OPTION - You can also select the (T)urns option by
pressing "T". This shows your stock turnover; how many
times your current stock quantity would be sold in the
time period specified. The report lists the item code and
description followed by current stock. The quantities sold
are shown in the Quantity columns. The Amount columns tell
how many times current stock would have been sold in the
time frame shown at the top of the column.
You can specify Starting and Ending Inventory #'s as well
as the Maximum and Minimum Turn Ratios. The (T)urns option
can help you decide how much inventory you should stock.
When you choose a sort option (I, A, 2, 3, or T) that
includes inventory items, you will have some additional
options. You can enter a "Whole Goods Description Word" to
select only whole goods items (with a "-" in item#) with a
description that includes the word you entered. You can
also enter an "Inventory Print code" to select only items
with a print code that includes the code you enter.
Customer Orders With Prices (Report # 3-35)
Statements on Nebs 9060 (Report # 3-36)
The date specified in Statement Cut off tells the computer
not to print statements for customers that have invoices
only after this date. The date specified in Date to end
Print tells the computer not to list any invoices after
this date on the statements. No statements are printed for
customers whose balance is within the statement limits
specified in the System Setup Screen 2 (&). The report
date is used to calculate aging.
Cash Deposits By G/L# (Report # 3-37)
Customer Invoices on Forms 9040 (Report # 3-38)
On taxable invoices, a "T" is printed beside each
taxable amount. The total taxable amount is
printed on the sales tax line.
Sales Tax Payable (Report # 3-39)
Salesperson List (Report # 3-40)
A/R Balancing (Report # 3-41)
Calculate Salesman Comission
When you run the report, you are asked to enter the
salesman's code.
In the Starting at field, enter the first invoice that
should be considered for the salesman's commission. In the
Ending with field, put the last invoice to be included in
the calculation.
The report gives total commission and total sales for each
category as set up in the Salesman file (S). At the bottom
of the report a total of all the categories is given both
of commissions and total sales.
This is a report that lists open invoices for each
customer, with amounts arranged in columns by age. Age is
determined by subtracting the invoice date from the report
date. A total aging appears at the end of the report.
This report prints actual invoices on regular 8
1/2" x 11" paper, in numerical order. To print on
company letterhead paper, enter a "Y" in Omit
Company Heading on the System Setup Screen 2 (&).
This is a list of payments in numerical order, with a total
at the end. It also totals wherever there is a deposit
record with a Y in Deposit Total. It may be printed for only
a particular G/L Ledger # when Ledger numbers are entered on
the Deposit screen (D). At the end of an accounting period
the report will post the transactions to the G/L account if
you enter a "P" when asked if posting is desired. The proper
starting and ending Deposit # must be entered for the
period.
This report prints a listing of each customer's
activity for the current month. This report shows
each customer's Prior Balance, Current Sales,
Current Payments, and Current Balance. A total of
each of these is printed at the end. Note: This
will print for the current month only. An asterisk
(*) at the end of a line indicates that the
figures on that line do not balance, meaning
Current Balance does not equal Prior Balance plus
Current Sales minus Current Payments.
This is much the same as Report # 3 - 15 CUSTOMER
CURRENT ACTIVITY, except it prints only the total
number of Customers, Prior Balance, Current Sales,
Current Payments, and Current Balance. Note:
This will print for the current month only.
This report lists each customer's Shipping Address
and Ship VIA.
This report prints a Bank Deposit Ticket-size report that
can be fastened to your preprinted deposit ticket from the
bank. This way you do not have to manually write each
check on the deposit ticket. It prints Customer Name,
Check Number and Check Amount with a deposit total at the
end. It separates foreign deposits, cash, and credit
cards, and accumulates them into different totals. Foreign
deposits must have a Payment Type of F, and cash deposits
a Payment Type of C. Standard Payment Types for credit
cards are as follows:
A - American Express M - Master Card
B - Carte Blanche N - Diners Club
D - Discover V - Visa
This report lists the total quantities and amounts
for each inventory item sold during the period and
also the total amount sold by G/L number. Enter
the starting and ending dates for the period you
want this report to cover.
This is more than just a report. It actually enters
finance charges into the Receivable Invoice file (R) and
prints them at the same time. Since this report changes
file data, it is wise to back up the data before running
it, in case a power failure or error occurs during the
operation.
This report allows you to print packing lists for
any one invoice (Repor or list of invoices. The
packing list prints on regular 8 1/2" x 11" plain
paper. It is much like an invoice on plain paper,
except it prints # Ordered, # Shipped, #
Backordered, and physical Location of the items so
that it is easy for the person packing the items
to know just where to find them. It also differs
from the invoice in that it does not print the
prices for the items.
This prints a report of payments applied to the
customer invoices in numerical order by invoice
number.
This report prints out orders, but does not print
the prices. This can be used for packing slips,
pick tickets, etc.
This report prints back-orders from any reference
number to another.
This report scans the Customer file and checks for
a Review Date that is on or before the system
date. These Customers are printed and any message
you entered in the Message 1 field.
This report sorts by G/L#, and lists all invoices under
their proper G/L#. If you are on the accrual basis of
accounting, use this report to post A/R Sales to General
Ledger. You should post this at the end of the General
Ledger accounting period after all the accounts receivable
transactions for that period are entered. NOTE: When
posting, Report Date is VERY important! The Report Date
selects the period to be posted. (The Report Date is the
date after the word On in the Report Generator screen.)
This report lists invoices by invoice number. It displays
the invoice number, invoice date, customer code and name,
terms, salesman, each item on the invoice, tax code, G/L
account number, quantity, unit, extended price, extended
cost, gross profit and gross profit percentage.
This report prints a list of the customer types, a
total number of customers of each type, and a
total number of customers on file.
This report prints customer addresses on 15/16" x 3.5"
labels, on envelopes, or merged with a Word Processor file
(W) document. The report has the following options:
This report prints customer statements on regular 8 1/2"
by 11" paper. The date specified in Statement Cut off
tells the computer not to list any invoices after this
date on the statements. No statements are printed for
customers whose balance is within the statement limits
specified in the System Setup Screen 2 (&). The report
date is used to calculate aging. The date specified in
Date to end Print tells the computer not to print
statements for customers that have invoices only after
this date.
This report invoices recurring orders for uses such as
service contracts, rentals, etc. This report does not
delete the order from the Receivable Order file (% - O).
When the computer asks for a password, enter PASS unless
another password has been set up.
This report prints a list of all customer
payments sorted alphabetically by Customer
Code, with individual payments listed under
each customer.
This is a two-column comparative report which can be
sorted in seven different ways: (S)alesman, (C)ustomer,
(I)tem, (A)ll Three, (1) Salesman & Customer, (2) Salesman
and Inventory Item, (3) Customer & Inventory Item.
This report allows you to print Customer Orders
from any reference number to another.
This report prints Customer Statements on form # 9060 from
Advanced Business Computers, form # 91302 from Deluxe or
form # 9060 from NEBS. These are 6 1/2" x 7" statements
with detachable remittance stubs.
This report runs from deposit # to deposit #, and
generates a sales G/L distribution from the line amounts
of the invoices to which the deposit was applied. When a
deposit pays only part of an invoice, the percentage of
the payment amount divided by the total invoice amount of
the individual line G/L amount is used. This report may be
run for a particular bank account if the Bank G/L # was
entered on the Deposit screen (D). The G/L totals may be
posted to the G/L accounts at the end of the accounting
period by entering a "P" when asked to press "P" for
posting. The proper Starting and Ending Deposit # for the
period must be entered correctly.
This report prints customer invoices on form #
9040 from Advanced Business Computers, form #
91300 from Deluxe or form # 9040 from NEBS. If Cut
Sheet field on the 'P screen for the printer has a
Y then it prints the Laser form. Laser forms need
macros, which are graphic DOS *.MCR files,
installed in the DOS ABC directory which are sent
to the laser printer when ABC is started. If the
printer is turned off after, or while ABC is
started, the lines and the graphics on the invoice
will not be printed. Exit ABC and restart the
program while the laser printer is on. If the
laser is attached to a terminal the terminal needs
restarted.
This report calculates the taxable and nontaxable
sale amount and the amount of sales tax collected,
based on the amount of money received, as entered
in the deposit ledger. If an invoice is partially
paid, only the paid portion of the invoice is
included in this report.
This prints a list of the salesmen as they are
entered on the Salesman file (S). It lists Code,
Name, and Commission Code.
This report scans the Invoice file and adds up all
invoice totals per customer. It also scans the
Deposit file (D) and subtracts all payments
applied to accounts receivable for each customer.
It then compares the resulting balance with the
balance on the Customer file (C). Any customers
for which the balances are not the same are
printed on the report.
This report calculates how much commission a salesman has
earned, one salesman at a time.