We are to design an Enterprise Resources Planning (ERP) that links two standalone systems, Sales and Invoicing System and Warehouse Management System for biomedical equipment company called Buy-O-Medical. Both systems are linked through a common database.
Both the Sales and Invoicing System (SIS) and the Warehouse Management System (WMS) require all users to log in. If the logged in user is an existing client, the SIS must be able to generate Sales Quotation (SQ) by the client’s request. It provides the option for the client to download the SQ in PDF file format. The system allows the client to view existing SQ that has already been created by that particular client. Following that, the system allows the client to place or submit Purchase Order (PO) based on the SQ created. However, if the logged in user is the Sales Admin, he/she can approve the submitted PO through the system. The SIS then automatically generate the Sales Order (SO) and the Delivery Order (DO). Once the client is confirmed to have received the goods, the Sales Admin can generate the invoice and the system will e-mail the invoice to the client. Payment can be updated by the Sales Admin through the system after the client has made the payment (assuming the payment is not handled by the system). The system allows the Sales Admin to cancel the PO/SO when requested by the client (with exception only when the DO has not been issued). If the log-in user is the Logistic Staff, he/she can maintain the inventory and insert new item information through the WMS. If the stock is out or low, the Logistic Staff can request to restock the item. If the Delivery Man logs in, he/she can retrieve the DO, request the item location and update the delivery status in the WMS. The System Admin is able to access and maintain both systems as well as the user information. Both systems provide user help and system information to all users except for the System Admin. Both systems provide account settings where all users can update their particulars and password.
Software Specifications
This project is to be completed within 3 to 4 months. Due to time limitation and since developers understood the requirements well we have decided to use the Rapid Application Development (RAD) Model. We are able to use similar product in market for reference. Customer would prefer us to use ASP.NET 2.0, however, is open to options as long as it is web-based and stress on user-friendliness. Therefore, we have decided to use ASP.NET 2.0 and MSSQL 2005 database. Customer does not want us to compile the source code as there would be an IT team from their company which would manage and maintain the system.
Hardware Specifications
Distributed Database Server
- Core 2 Duo Processor
- 4GB 667Mhz Memory
- 1.5 TB Internal Storage
- Web Hosting (IIS)
- Windows Server 2003 SP3
For end user, use Internet Explorer (IE) 5.5 or above.
Date: 3rd March 2008
No comments:
Post a Comment