Project |
Time-Ex Couriers Management Application |
Organization |
TIME-EX & FLASH Couriers, Dallas, Texas |
Project Type |
Off-site Consultant and project development |
Duration |
Apr 1995 – Nov 1998 |
Platform/OS |
Windows Server NT 4.0, Windows 2000 |
Position |
Access Developer and System Analyst |
Software |
Access 2.0/97/VBA |
Description |
Time-Ex Courier Management Application is full feature of a Courier management program for managing small and medium size Courier businesses.
It takes delivery tickets then creates invoices and gets account receivable. It
controls each client balance and reports all the activities of the processes. It
calculates drivers and salesmen commissions. It shows daily, monthly, yearly income,
sales, and payments. Backs up the old data, repairs and compacts the databases. |
|
Key Features |
- Order Ticket Entry
- Dispatching
- Invoice Creation
- Calculate Commissions (Drivers, salesmen)
- Account Receivable and Account Payable
- Reporting (daily, monthly, yearly income, sales, and
payments)
- Security
- internal e-mail/messaging
- Back up old data, repair and compact the databases
|
My Tasks |
- Designed forms, reports, macros, modules and queries.
- Analyzed existing order entry, dispatching, invoice
creation, commission calculation, A/P, A/R, past due, mailing, clients, and drivers’
info processes and integrate them as one application.
- Designed internal e-mail/messaging, compact/repair
and login security modules.
- Created reports and graphs for delivery, sales, payment,
and expense info by daily, weekly, monthly, quarterly and yearly.
|