Vendor Address List (Report # 2-2)
Vendor Payment Setup List (Report # 2-3)
Vendor Phone and Fax Directory (Report # 2-4)
Vendor Purchase Amounts (Report # 2-5)
Vendor Open Invoices (Report # 2-6)
Vendor Paid Invoices (Report # 2-7)
Vendor Address Labels (Report # 2-8)
Vendor Purchase Orders (Report # 2-9)
Inventory Price Update (Report # 2-10)
Payables By G/L# (Report # 2-11)
Vendor Aged Trial Balance (Report # 2-12)
Vendor Shipping Tickets (Report # 2-13)
A/P Bill Ledger (Report # 2-15)
A/P Bill Detail (Report # 2-16)
Vendor Entry Check (Report # 2-17)
Vendor E.I.N. & FICA #'s (Report # 2-18)
Vendor Rolodex Cards (Report # 2-19)
Purchase Orders (Report # 2-20)
Open Purchase Orders by # (Report # 2-21)
Purchase Orders Sorted by Item # (Report # 2-22)
Purchase Orders Sorted by Date (Report # 2-23)
Purchase Orders Sorted by G/L Account # (Report # 2-24)
P.O. Inventory Labels (Report # 2-25)
A/P Inventory Labels (Report # 2-26)
Shipping Tickets By P.O. # (Report # 2-27)
List Overdue Purchase Orders (Report # 2-28)
A/P Invoices by Purchase Order # (Report # 2-29)
List Bills Selected For Payment (Report # 2-30)
Bar Code Labels from Bills (Report # 2-33)
Bar Code Labels from Stock (Report # 2-34)
Bill/Serial# Info from Checks (Report # 2-36)
Vendor List (Report # 2-1)
This prints vendor codes and names in a
2-column format.
Vendor Address List (Report # 2-2)
This prints vendor codes, names, and addresses,
using one line for each vendor.
Vendor Payment Setup List (Report # 2-3)
This is a report of payment information by vendor.
It lists the vendor Code, Name, Purchaser Acct #,
Sales- person & Phone #, Net Days, Discount Days,
Discount % and Auto Pay (Y, N, or P).
Vendor Phone and Fax Directory (Report # 2-4)
This prints vendor codes, names, telephone numbers,
and fax numbers.
Vendor Purchase Amounts (Report # 2-5)
This is a wide report showing purchase and discount amounts
for each vendor for which there was activity. It lists the
Vendor Code and Name, Last Transaction date, and the Pur-
chase and Discount amounts for the Current period, the Prior
Month, and the Total Year-to-Date.
This information comes from two places: the B screen where bills have been entered for the Vendor and the L screen where checks have been written for the Vendor.
Vendor Open Invoices (Report # 2-6)
This lists open invoices for each vendor. It gives the
Vendor Code & Name, Reference #, Invoice Date, Control
Date, Vendor's Invoice #, Invoice Amount, Amount Paid,
Balance, Job #, and Pay Code. At the end of the report
you'll find the report total and the total to be paid
(amount due).
You will have the following options: (1) Include Payment Detail, (2) Include Terms Detail, (3) No Payment or Terms Detail, (Enter) Include Both Payment and Terms Detail, or (4) One-Line Terms. This last option is a one-line format that shows Due Date, Discount Date, and Discount Amount from the first line of terms on each bill. It does not show the Bill Amount or Amount Paid, only the Balance.
Vendor Balance Correction
Report 2-6 provides a hidden option to correct balances on
the Vendor file. When the computer asks for the detail
option (1/2/3/4), press B. You can then select a Vendor
range as usual. After verification, the computer will
adjust any Vendor balance, if needed, to match the total
of open invoices as it would normally calculate on this
report. It will also clear the balance on any Vendor
(in selected range) that has no open invoice.
NOTICE: This option should not be needed under normal circumstances. Use it only under the direction of your ABC consultant.
Vendor Paid Invoices (Report # 2-7)
This lists paid invoices for each vendor. It gives
the Vendor Code & Name, Reference #, Invoice Date,
Control Date, Vendor's Invoice #, Invoice Amount,
Job #, and Pay Code. There is a Total for each
vendor and a report Total.
You will have the following options: (1) Include Payment Detail, (2) Include Terms Detail, (3) No Payment or Terms Detail, or (Enter) Include Both Payment and Terms Detail.
Vendor Address Labels (Report # 2-8)
This prints vendor addresses on 1" x 3.5" labels.
You may sort this report by zip code and select
vendors by entering a Print Code, and/or an
Activity date. Entering an Activity Date means
after that date will be listed. You may also print a message which prints on the top line of the label.
Be sure to use 8 digits and two forward slashes for the Activity Date. For example, 08/08/1997.
Vendor Purchase Orders (Report # 2-9)
This lists each vendor's purchase orders with a
total for each vendor, and a report total at the
end.
It details the Vendor Code & Name, the Order #, Order Date, Total Amount, Number of times Back-Ordered, T)axable or Exempt, Job #, S)ubcontract M)aterial or D)irect, FOB Point, and Ship Via.
Inventory Price Update (Report # 2-10)
This is more than just a report. It actually updates
inventory prices, based on A/P bills.
Any bills that have been entered or changed since the last time this report was printed will automatically be processed sequentially. There is no need to enter a 'Starting at' or 'Ending with' number. Only the items that have changed are printed.
It lists the Item Code & Description, Unit, Multiplier, # per Case, Quantity, Update Code, Order Price, Bill Price, Old Book price, New Book price + Freight, % of Change, Old List price, New List price and Markup %.
The report may change any of the following four fields on the Inventory file (I): List Price, Date List Changed, Book Price, and Date Book Changed. The report will print any changes it makes to these fields.
The Pricing Code on the A/P Bill determines whether an item is updated. When a bill is entered, this code is set from the Inventory file or from the System Setup screen, but could be changed on the bill itself. The pricing code may be any of the following:
N - No price update.
B - Update the Book price if it increased.
L - Update the book price if it increased. Update the List price if it increased.
S - Skip.
D - Always update the book price.
A - Always update the book price and the list price.
I - Always update the Book Price. Update the List Price if it increased.
Book Price is taken from Price on the A/P bill and is increased by Book Increase % on the System Setup screen 2 (&).
List Price is based on the inventory Multiplier. If the Multiplier is not specified, the List Price will not be updated.
List Price is set to Price divided by Multiplier, multiplied by 100, multiplied by the Unit quantity. For example, if the A/P price is 1.50, and the multiplier is 60, and the unit is 12, then the list price per dozen would by 30.00 (1.50 divided by 60% times 12).
If the cost is updated, Date Book Changed is set to the Control Date from the A/P Bill. If the list price is updated, Date List Changed is set to the Control Date.
Payables By G/L# (Report # 2-11)
This is a sorted report from the A/P Bill file (B) which
shows open accounts payable by G/L account number as of
the Report Date. When posting, the Report Date selects the
ending date of the General Ledger period. If you are on
the accrual system, this should be posted to the General
Ledger at the end of each accounting period. There is also
an option to print all bills (open and closed) for the
period, and an option to sort by Vendor.
This report lists G/L# and Name, Bill Reference #, Control Date, Vendor Code & Name, Job# & Mat/Dir/Sub, and Amount. Shipping tickets are included if Shipping Tickets G/L# is filled in on the Setup screen (#).
The report gives totals for each G/L#, and a grand total with the A/P Account #. It also totals floor plan bills and shipping tickets where applicable.
Posting Accounts Payable to General Ledger (Report # 2-11)
Before posting accounts payable to General Ledger, the following account numbers must be set up on the Setup screen (#): Accounts Payable and Floor Plan. Shipping Tickets account number must be filled in if you want to include shipping tickets, or blank to exclude them.
Posting accounts payable creates two entries in the Computer Entries ledger. The first entry, dated the end of the report month, posts the totals of all open accounts payable. The second entry, dated the first of the following month, reverses the first entry. Both entries use Accounts Payable for the offsetting account (and Floor Plan and Shipping Tickets if applicable). As a result, each offsetting account is cleared at the beginning of the month, and reset to the ending balance at the end of the month, so the net change reflects the change in balance.
Vendor Aged Trial Balance (Report # 2-12)
This is a wide report that lists open invoices for each
vendor, with amounts arranged in columns by age. (0 - 30
days, 31 - 60 days, 61 - 90 days, 91 - 120 days, and over
120 days) Age is determined by subtracting the invoice
date from the report date. A total aging appears at the
end of the report.
Other details given are the Vendor Code, Name, Address and Telephone #, Invoice #, Invoice Date and Total Amount.
The report also indicates whether it found the Accounts Payable files to be in balance. If an asterisk (*) appears to the left of a vendor balance, it indicates that, that particular vendor 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, indicating that the vendor's balance does not match the total of the vendor's open invoices. If there are no asterisks on the report, the computer will print REPORT IN BALANCE instead.
Vendor Shipping Tickets (Report # 2-13)
This report lists the shipping tickets which have been
entered on the B screen. You can choose which vendors'
shipping tickets you wish to see.
The report lists the Vendor Code and Name, the shipping ticket reference number and the date received. The order number and order date from the Purchase Order screen are displayed. Also listed is the shipping ticket amount and Job number. There are vendor totals and a report total.
Bill Detail (Report # 2-14)
The Bill Detail report lists the bills from the B
screen in numerical order. You can choose which
reference numbers you want to see.
The report lists the bill #, the cost of each item, the item code, description and quantity.
A/P Bill Ledger (Report # 2-15)
This is a wide report listing bills in numerical
order.
It displays the Referemce # , the Vendor Code & Name, Vendor Invoice #, Amount, Net Due date, Discount Date, Discount Amount, Check #, Pay Date, Job # and Auto Pay code.
A/P Bill Detail (Report # 2-16)
This is a wide report listing bills, with their
line items, in numerical order.
It displays the Reference #, Vendor Code & Name, Invoice Date, Vendor Invoice #, Amount, Net Due date, Discount Date, Discount Amount, Check #, Pay Date, Job #, Auto Pay Code, Item # & Description, G/L # & Description, # per Case, Quantity, Price, Amount, and Freight & Other Adjustments.
Vendor Entry Check (Report # 2-17)
It prints each vendor's Code & Name,
Address & Phone #, P/O Address, Print
Code and Terms as entered in the ven-
dor file (V).
Vendor E.I.N. & FICA #'s (Report # 2-18)
This prints vendor Code & Name, Street Address,
EIN #, and FICA # for the vendors which have
either of these numbers entered on their file on
the Vendor screen (V).
Vendor Rolodex Cards (Report # 2-19)
This report allows you to specify a certain Print Code
for which you want to print rolodex cards. It prints
the Vendor's Code, Name, Address, Phone #, Fax #, Ac-
count #, Salesperson, Sales Person #, and Remarks on
continuous 3" x 5" rolodex cards.
Purchase Orders (Report # 2-20)
This allows you to print purchase orders from any
one number to another.
Open Purchase Orders by # (Report # 2-21)
This prints a list of open purchase orders sorted
by Order #.
It lists the Order #, Date, Vendor Code, Name & Telephone #, Item Code & Description, Quantity Ordered & Received, Balance, Unit Code, Price, Amount and Shipping Date. A Total is given for each Purchase Order. At the end, a Report Total is given.
Purchase Orders Sorted by Item # (Report # 2-22)
This prints a list of open purchase orders sorted
by Inventory Item #.
It lists the Item # & Description, P.O. # & Vendor Code, Shipping Date, Quantity and Amount. At the end of the report there is a Report Total.
Purchase Orders Sorted by Date (Report # 2-23)
This prints a list of open purchase orders sorted
by Ship Date.
It lists the Shipping Date, P.O.#, Vendor Code & Name, Item Code, Quantity and Amount. A Report Total is given at the end.
Purchase Orders Sorted by G/L Account # (Report # 2-24)
This prints a list of open purchase orders sorted by G/L
Account number.
It lists the G/L #, Item Code & Description, P.O. # , Shipping Date, Quantity and Amount. At the end is the Report Total.
P.O. Inventory Labels (Report # 2-25)
This prints from the Purchase Order file (O) the
number of labels indicated for each item on 1" x
3.5" labels. This prints Item # and Description,
P/O #, Job # & Name, and Location for each item.
Number of labels is determined by the Number of Labels field on the Purchase Order. Press <N> for more on setting up this field.
A/P Inventory Labels (Report # 2-26)
This prints from the A/P Bill screen (B) the
number of labels indicated for each item on 1" x
3.5" labels. This prints Item # & Description,
Weight, Company Name, and Phone # for each item.
Number of labels is based on the purchase quantity on the bill and the Quantity Per Label field on the Inventory file (I). Press <Q> for more on setting up this field.
Shipping Tickets By P.O. # (Report # 2-27)
This prints a listing of the orders in the
Purchase Orders file (O) that have shipping
tickets entered on the A/P Bill screen (B). It
will print the Ship Ticket #, Vendor Code and
Name, and Date Received on the line belowg the
P.O. #. Purchase Orders that do not have Shipping
Tickets entered will simply print their P.O. # on
the list.
List Overdue Purchase Orders (Report # 2-28)
This report prints open purchase orders that have
a ship date on or before the Report date, or no
ship date at all. It prints Purchase Order#, Item
# & Description, number Ordered, number Received,
and Ship Date.
A/P Invoices by Purchase Order # (Report # 2-29)
This report lists the Invoices that have been made
from Purchase Orders. It lists them by Purchase
Order #. Displayed are the Purchase Order #,
Purchase Order Date, Vendor Code & Name, Invoice
#, Invoice Date, Invoice Amount & balance, amount
Paid and Purchase Order Amount.
List Bills Selected For Payment (Report # 2-30)
This report lists the bills that are currently
selected for payment on the A/P Checkwriting
screen (/). It prints Vendor Code & Name, A/P
Reference #, Date, Invoice#, and Amount.
Bar Code Labels from Bills (Report # 2-33)
This report is used to print UPC Bar Codes labels for
items that are listed on an A/P Bill or Shipping Ticket.
The number of labels will match the quantity of items. For
example, if there are 10 of one style of brooms on the
bill, this report will print 10 identical labels for the
brooms.
Specify the A/P Bill numbers you want to print for in the Starting at and Ending with fields.
You should use 1/2" labels at least 2 1/2" wide. The computer prints the Item Code, description and list price (up to 40 characters) as well as the UPC bar code.
Bar Code Labels from Stock (Report # 2-34)
This report is used to print UPC Bar Codes labels for
inventory items. The number of labels will match the stock
quantity. For example, if stock quantity is 5, this report
will print 5 identical labels.
Use item codes in the Starting at and Ending with fields.
You should use 1/2" labels at least 2 1/2" wide. The computer prints the Item Code, description and list price (up to 40 characters) as well as the UPC bar code.
Bill/Serial# Info from Checks (Report # 2-36)
This report lists the A/P Bills and/or Serial # items that
were paid with a check when there was not enough room on
the check stub to list all of the Bill numbers and Serial
# items.
The report gives the Check #, the Vendor Name, the A/P Bill Reference #, the vendor's Invoice #, the amount and discount.
The computer makes a list in the Word Processor, using the code /.
*** in report generator enter check # as a six digit #