Database

Database

Inventory, Vendors, Customers, Department Codes, Sales Persons and Tax

Previous Top Next

Network File and Record Locking
This controls the access to the database so many people can use the same information and do the same operations at the same time.

Inventory
Manage inventory easily at this screen. This feature rich program includes serial number control, 3D matrix, price management (quantity pricing, mix and match, exceptions, customer pricing, etc.,)Manage layaways, export/import utilities, rewards programs and more.

Inventory (Stock on Hand)

Add, change, delete, manage prices, see sales history and print tags. There is also a note pad, for each item, with a find feature.

Inventory Look Up
Key fields for searching are along the top. They are Description, Sub-description, Stock Locater (Number), Item ID (the vendor part number), Department Code and Vendor Code. Click the column heading or press the function key to set the search key.

For example, press F4 to find by Description. Start typing and the position in the list immediately moves to the word matching what you type. The more you type, the closer the match.

You can scroll or page up and down from beginning to end of the database regardless of the number many records.

Inventory Look Up

Wildcard search finds within the field rather than just from the left.

Item Link ©
automatically adds an item when an item is sold. Use it for bottle deposits, tag fees and prompting for up selling. For example, selling a bottled drink adds an item called bottle deposit for ten cents without any action on the part of the clerk.

Break Pack Link ©
Sell a single and the quantity for each pack is adjusted automatically. For example, a drink, six pack 12 pack and case. Order by the case. Check stock by each: single, six, 12 and case.

Promotional Price Manager
Set the start date, end date and the price that is to be in effect during the promotion. Prices apply without the clerk having to take any action. Promo prices can be set at the store or at Headquarters.

Promotional Prices Manager

Custom Lists
Define (and save) custom inventory, customer and vendor lists exactly as you want them. Set the range, what is to be listed and even in what order on the list! Once defined, call them up and use them repeatedly. Send lists to a printer or a file.

Define Custom Lists

db out

Sample of Custom List

Names
Manage names (customers, clients or members) at this screen. Includes a note pad for each name, custom lists, mailing labels, letter writer, e-mail, sales history, receive on account, account history and more.

Names (Customers and Clients)

Look Up Names
Look up names using the selections across the top. Selecting F7, Business, instantly re-sorts the list (even thousands of names!) in alphabetical order, by business. Start typing and the list moves to the nearest match.

Move from beginning to end of the list. Search using Wild Cards.

Names Look Up

Vendors
Select Vendors to manage the database. Search and list as in Inventory and Names. Do custom lists, write letters, send E-mail, print a mailing label and see a history of your purchases from this vendor.

Vendors

Notes for Customers, Vendors, Items and Transactions
CAP provides a note pad for each customer, vendor, item and transaction. This continues to be a most popular and powerful way to track what is happening in a business. Press a key to record the date, time and print a label. There is also a letter writer for customers and vendors.

The first line of the note pad is visible near the center of the screen in names, vendors and inventory. Pressing a single key opens the 80 column by 330-line note pad. The note pads are a powerful enhancement to the flexibility of the program. Use notes to:

·	Record contacts with customers and suppliers.

·	Record the date and title of letters filed in notes for instant recall.

·	Record comments about inventory items.

·	List alternate vendors and their item codes and prices.

·	Set start and end dates for promotional sales.

·	Record multiple price levels for preferred customers.

Some Notes Features and Key Commands

·	Reduce the amount of information on paper and record it electronically.

·	80 columns by 330 lines of notes for each inventory item, customer and vendor.

·	Press F1 for help on notes.

·	Press F2 to search for a key word in all notes.

·	Press F5 to stamp time.

·	Press F6 to stamp date. Sales code is appended.

·	Press F7 and F8 to move margins.

·	Press F9 to print notes. Shift plus UP/DN arrows highlight section to print, copy or delete.

·	Notes can be marked, copied to the clipboard, and pasted in letters.

Sample Notes for an Inventory Item