Using the System
   Updating Parameters
   Consignor Maintenance
   Item Maintenance
   Report Items
   Backing up Files
   Restoring Files
   Deleting Old Paid Items

   Consignor Maintenance
   Item Maintenance
  Report Items

Download Document File

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
Email address
Street address
City, State and Zip Code
Notes pertaining to the consignor.

The information for each item consists of:

Item description
Cost price
Sale Price
Date added
Date sold
Date paid
Payment reference (e.g. check number)
Notes pertaining to the item.

2. Screens

The system has 5 screens:

Consignor Maintenance:
Item Maintenance:
Item Report:

3. Terminology

Refer to the Item Maintenance screen to see examples of these:
Option button:                   a small circle beside its description, used to select an option or to initiate an action. 
Command button:             a blue rectangle with its function marked on it, used to initiate an action.
Text area:                          a white rectangle, under or over its appropriate heading, used to enter data.

Provides access to the other 4 screens
Allows you to enter the commission rate, rounding criterion and backup/restore location.
Allows the updating of consignors, e.g. names and addresses, including adding and deleting consignors.
Allows the updating of inventory items, including adding, deleting, selling and paying for items.
Reports on items in any order, in detail or summary format, based on selection parameters you enter.