Point of sale (POS) software designed to track retail, resale and consignment sales. The system is a set of databases to be used as a standalone "runtime" or with FileMaker Pro®. The basic form of the program has remained the same since 1995, because ... it works!

General

• Works on either Macs or Windows; flexible system requirements
• Handles customer and inventory databases of any size
• Supports separate printers for sales receipts and reports
• Flexible and customizable: resize windows anytime; use your own logo on printed forms; define your own customer and merchandise categories; customize statement on cash register receipt
• All forms and reports can be previewed on the screen before printing
• Free technical support for one year after purchase (more info in Technical Support Policy below)
• Automatically networks with additional copies of FileMaker Pro®
• All data is fully importable and exportable in industry standard formats
• Exchange data with Microsoft Word or Excel via ODBC or XML.

Convenience Features

• Easy to use for you and your staff
• Create customized mailing lists and labels, for promotional mailings, etc.
• Direct mail marketing features: print labels, letters, envelopes, postcards
• Enter your logo and store information in one place and it will show on printed sales slips, customer order forms and invoices
• Instant access to detailed customer data
• Indexed Help file always available at the click of a button
• Button driven, no keyboard or shortcut commands to learn
• Simple "list views" to see data in multiple records simultaneously
• Fast, easy searches in any field. Sorts by any data criteria
• Password levels allow for restricted or total access
• Generate list of customer payments due for easy billing and payment

Making Sales

• Transactions show you who purchased what, when, for how much, how they paid (and who made the sale, if desired)
  • Typed in item code looks up item description, price, product category, and consignment percent due if any
  • Customer code automatically shows customer info in sale
• Handles many different payment types and combinations of payment
• Handles tax calculations, discounts, adjusted prices, returns (Note: you can override tax percentage on any sale or line item)
• Works with bar codes
• Works with receipt printer
• Search for sales by number, date, customer name, item purchased, product category, price, sales person, consign percentage . . . anything!
• Easy button access to main menu or related files (contacts, inventory, etc)
• On screen help file, as push button list, for easy reference by staff
• Automated reports in button driven menu (see Reports below)

Reports
All reports can be generated for any time period, and be previewed on screen before printing out

• Automated, detailed Daily Sales Report makes closing out easy and efficient at day's end
• Sales reports summarized by customized merchandise types, with subtotaled columns for discounted sales and sales tax paid
• Sales reports summarized by selected consignor(s), with consignment percentage and net amount owed consignor
• Consignor payout statements
• On-hand inventory amounts available anytime, which you can print to facilitate physical inventory taking
• Inventory value report of all or selected inventory
• Products list by description or category
• Vendor list with product cost and retail price
• Automated find of unpaid customer invoices
• Export sales data to a spreadsheet program for further analysis

Receiving and Managing Inventory

• Associate each item with artist/vendor name, and customized code, merchandise category, consignment percentage, retail price, and cost if applicable
• Mark each inventory item as taxable or nontaxable, if desired
• Modify consignment percentages
• Easy finds and sorts by item code, description, merchandise category, vendor, or any other field(s)
• Auto look up of last item code assigned enables quick assignment of new item codes
• Received items automatically add to on-hand quantity
• Modify inventory amounts, if necessary
• View history of each inventory item, when received and when sold
• Option to print merchandise labels for items received

Managing Contacts
Contacts is a database list for you to include any groups of people you have contact with, i.e. customers, suppliers, consignors, wholesale sources, employees etc.

• Handles any size number of contacts (i.e., a master list of people)
• Add or modify records
• Define your own client categories (retail customer, consignor, wholesaler, supplier, etc) and merchandise categories to what you sell in your store (i.e. ceramics consignor, glass wholesaler, etc)
• Keep key information on individual customers
• Quick finds and sorts... by first name, last name, business name, street address, city, phone number, state, etc., etc. No need for built in queries
• Easily select customized groups for targeted promotional mailings
• View customer purchase history, with totals, spent by an individual customer during any given period of time
• Print mailing labels
• Print mail merged letters, notices, postcards and more
• Print phone and/or address lists
• Print customized fax sheet with your logo, or fax directly from your computer with appropriate fax software
• Print envelopes with your logo and customer address
• Print return postcards with your name & logo
• Keep mailing list clean using date contact record (i.e., person's name) was created

If you own FileMaker Pro

FileMaker Pro owners have access to the structure of the database. By opening a database with the highest level password (provided with purchase), you can manipulate field placement on layouts; make new lists, reports, or print layouts; and write scripts.

Ram Design can provide custom development for you, either at an hourly rate or contract price. However, the net effect of this control is that your databases will never become obsolete from Ram Design going out of business. There are thousands of FileMaker developers who can provide support and service for advanced development. FileMaker, Inc., the maker of FileMaker Pro, is a leader in software sales and quality of product. (More)

With additional copies of FileMaker Pro software, your entire system can become easily networked over your local area network - ethernet or wireless. You can enter sales at the sales desk, be entering inventory in the receiving area, and be generating reports in the office - all data shared immediately by all users. Network sharing can be among Macintosh and Windows computers at the same time. And believe it or not, if you would rather work from home, your databases can be accessed via the World Wide Web, if enabled, via a FileMaker Pro application or with a standard web browser (ok, that trick isn't as easy but that's not the fault of the database).

Technical support policy

Ram Design will provide free technical support on the features, as described in the Help file of the Sales & Inventory program, for one full year after purchase. Ram Design can only provide free technical support for systems developed or modified by us (field definitions, layouts, scripts, password privileges). Support for your purchase of FileMaker Pro® is provided by FileMaker, Inc.

Our technical support history indicates that very little support is needed. Users can easily grasp how the whole system functions because of the simplicity of the database structure. A careful reading of the help articles, provided in the Help database, gives all the basic instructions needed for successful operation.