Migration of Departmental Accounting System (Phase II)

  Purpose

This project is basically a total rewrite - from the ground up - of the Phase I system described elsewhere. After implementation, it became obvious that there were several serious structural flaws in the database design; flaws not recognizable until the program was actually used and tested. Among these were the billing methods, and recording of the payments. Job and inventory tracking, which were initially planned for the 2nd phase, became a neccesity more immediately, so the decision was made to begin the rewrite immediately. The Phase II system will be much more encompassing, handling inventory tracking and control, job management, and employee tracking as well as point-of-sale entry and billing.

  Goals

1-Jun-1999
Begin point-of-sale data entry in the Electrical Shop.
15-Jun-1999
Implement billing in new system; roll out Carolyn's interface.
circa 20-Jun-1999
Roll out the Shops interface for testing of job entry / inventory tracking.
1-Aug-1999
1st Major revision after month of user testing.
1-Sept-1999
1st billing is done completely on new system: no FoxPro, no Phase I. Inventory is now tracked on one system; buyers enter data at point-of-sale.

  Time Line

Time line last adjusted on 12-November-1998
24-May-1998
Initialted project, assigned Adam Mikeal to create initial database and explore strategies, started to gather information necessary to implement system.
23-Jun-1998
John Mcclain and Adam Mikeal met with Barbara Sloan to discuss

  Discussions and Meetings