Order entry system
- Support for multiple price points; for example $100 each, or 3 for $250.
- Support for one or two-letter city codes to speed data entry for common
city names.
- Spelling of address data and cities may be automatically corrected and
expanded. For example, "Ave" to "Avenue", or "South Bby" to
"Burnaby".
- Optionally supports the use of a direct mail database, to allow quick
entry of orders from direct mail campaigns by use of a customer or direct mail code
number.
- City, province and area codes can be defaulted based on the postal code.
Batch management
- Loading from external data sources (for example, telephone answering
services or call centres).
- Data validation
- Importing batches and assigning ticket numbers.
- Tickets may optionally be assigned non-consecutively, on a system-wide
basis, by batch, or individually.
Printing tickets
- Tickets may be printed or reprinted by batch, by range of ticket numbers,
by order, or individually. As well, all unprinted tickets may be printed at once.
- Tickets may be sorted, keeping international orders at the end of the
printout. This makes it easy to sort batches of tickets requiring different postage.
- Tickets may by grouped by order number, even if they are assigned
non-consecutively. This makes it easy to combine all the tickets for an order into one
envelope, if you are manually stuffing tickets.
- Tickets may also be printed in order for a paper cutter, so that once
cut, they are in consecutive order.
Transactions
- Data maintenance.
- Lookups by any field in the transaction file.
- Canceling and restoring tickets.
- Information tracking. Lottery Manager/Professional keeps the following
dates to help you with customers that call about their orders:
- Date and Time Entered. When the order was entered into the system.
- Date Printed. The date the tickets were printed.
- Date Mailed. The date the tickets were mailed. You can set the date when
a range of tickets were mailed at the touch of a button.
- Comments are automatically time-stamped with the date, time and user ID.
- The original values of fields are stored in the comments whenever a
change is made.
- An audit trail is maintained separately as well for any changes made.
System-wide searches
- Current status of any order can be reviewed, even if it has not yet been
assigned a ticket.
- The order can be brought up in the appropriate order entry or transaction
screen automatically, right from the search screen, and changes made if necessary.
Prizes
- All prizes may be entered into the database so that the draw can be
recorded on-line.
- Screen for entering ticket and prize numbers during the draw.
- Updates a table with all data required for merging with prize winners'
letters.
- Two workstations can draw at the same time, in master/slave mode, with optional
real-time synchronization of entries to ensure they're correct.
Reports
- Sales reports by location, source, city, postal sorting area, and batch
number
- Daily sales summary.
- Prize winner's.
- Extracts of the data for mailing lists and for auditing.
- Batch reconciliation.
- Full lists of ticket owners, by name or by ticket number
- Auditing reports.
- Generic Statistical Reports
Mail Merging
- Directly supports Microsoft Word for printing form letters. Sample
Thank-You, Too-Late and Prize winners' letters are included. By using Lottery Manager to
control Word directly, these letters can be marked as printing in Lottery Manager's
database. Duplication of the letters is automatically avoided, and you need to know very
little about how to set up the mail merge in Word.
Security
- Access rights can be set on a per-user basis.
Miscellaneous functions
- Maintaining city, province, location and source tables.
- Maintaining the Auto-Spell entries for order entry.
- System Setup and Configuration
- Verification of the database.
|
