INTRODUCTION

1. Description

This system lets you enter all the contact information for your consignors, and all the inventory items for each consignor. It can then report on these items by selecting criteria (such as to show all items sold from a start date to an end date), and sorted in any sequence. Examples of information you can get through this reporting system are lists of unsold inventory, sale amounts by day, sale amounts by item category, sale amounts by consignor, aging of unsold inventory, amount owed to each consignor, total amount owed to all consignors, items covered by a particular check. etc. This information is presented in either detail or summary format. In addition, a copy of a listing may be sent to a file capable of being read and printed through the Microsoft Excel program, for use in backoffice work.

The system allows you to define a commission rate applicable for all items. When entering information for a new item and either the cost price or the sale price is first entered, the system will calculate the other price, rounded to a selected dollar amount. For instance, if you designate that price be rounded to the closest dollar, and if your commission is 35%, and you enter a cost price of $80, it will calculate the sale price of $123. Conversely if you entered the sale price of, say $150, it will calculate the cost price (amount due to the consignor) of $98. You will of course have the ability to over-ride these prices manually. This feature takes effect only if the other price is blank, otherwise it would keep you from manually over-riding either price.

Consignors who rent space can have a monthly amount automatically posted on a specified due date against their balances. These are used to net out amounts owed consignors for sales.

The system provides a function whereby all the items of a particular consignor that are sold and not yet paid for can be displayed, showing the total amount due, thus allowing you to manually write a check for that amount. The system will then mark the items as paid with a reference check number. In this process you have the option to de-select any item you do not want to pay for yet.

A utility program allows you to delete in one step all items sold and paid for prior to a specified date, thus discarding obsolete inventory items.

Also available is the ability to backup and restore the entire data base to and from a pre-designated drive and folder, such as a flash memory card.

The information for each consignor consists of:

Last name

First name

Phone

Email address

Street address

City, State and Zip Code

Notes pertaining to the consignor.

The information for each item consists of:

Item description