Date: 17th March 2008
Further Refined User Specifications
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.
*During the process of generating the SQ, the client can view the stock status namely: in-stock, low-stock and out-of-stock. When the stock status is in-stock or low-stock, the delivery would be made within 14 days and approximately 44 days (inclusive of shipping) respectively. However when the stock status is out-of-stock, the delivery date will be notified to the client upon stock availability.
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: 17 March 2008
Refined User Specifications
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
CIDP: Work Distribution & Progress Day 3 (27/02/08)
Date: 27th February 2008
Venue: Database Tech Lab
WORK DISTRIBUTION
Matric No. | Members | Roles |
075038G06 | Abdul Muttalib Mohammed Rahman | Edit Database with more fields |
Familiarize with ASP.net and VS | ||
Research on Pop-up windows | ||
075059D06 | Ahmad Hafiz Bin Ismail | Research, Development & Testing |
075028D06 | Albert Chua | Create new classes |
Handle Stored Procedure | ||
Resolve DB problems | ||
Debug Login Module | ||
074958J06 | Muhammad Hariz Bin Bakri | Implementing GUI design |
075129K06 | Siti Nadiah Binte Zainal (Leader) | Create Work Distribution & Progress |
Create Form Template (SQ,PO,SO) | ||
Obtain Information for the Forms | ||
Research on VB |
WORK PROGRESS
ABDUL MUTALLIB MOHAMMED RAHMAN | CAT | PROGRESS | COMMENTS | |
1 | Added phone field (bigint) in tblClient | DB | Completed | |
2 | Added field itmMore{varchar(1000)} to tblItm to store more details for item | DB | Completed | |
3 | Added field itmFeat{varchar(1000)} to tblItm to store features of item | DB | Completed | |
4 | Familiarise with asp.net and visual studio | MISC | Completed | |
5 | Research on customisable pop-up window using javascript and asp .net | RES | Completed | |
6 | Code on pop-up window to be used for 'more details' for the items | RES | Completed | |
AHMAD HAFIZ BIN ISMAIL | CAT | PROGRESS | COMMENTS | |
1 | Assist Members with any problems occurs
| RES | Completed | |
ALBERT CHUA | CAT | PROGRESS | COMMENTS | |
1 | Stp “stpGetAllItms” added | DB | Completed | |
2 | Class added
| CLS | Completed | |
3 | ClsCommon.vb merges with ClsConfig.vb | CLS | Completed | |
4 | ClsCommon.vb removed | CLS | Completed | |
5 | Items Image display problem resolved.
| DB | Completed | |
6 | Stored Procedure Added
| DB | Completed | |
7 | Stored Procedure Amended
| DB | Completed | |
8 | Remove input param @UserType | DB | Completed | |
9 | Amend Login module to remove the customer checkbox from the login module. | LOG | Completed | |
10 | frmCustSQCfm.aspx
| SQ | Completed | |
MUHAMMAD HARIZ BIN BAKRI | CAT | PROGRESS | COMMENTS | |
1 | Implementing GUI design | GUI | In Progress | |
SITI NADIAH BINTE ZAINAL | CAT | PROGRESS | COMMENTS | |
1 | Create Work Distribution & Progress | MISC | Completed | |
2 | Create Sales Quotation Form Template | GUI | Completed | |
3 | Create Purchase Order Form Template | GUI | Completed | |
4 | Create Sales Order Form Template | GUI | Completed | |
5 | Add SQ,PO,SO information to the Forms | GUI | Completed | |
6 | Analyze VB codes for understanding | RES | Completed | |
7 | Coding on Dataview and Datasource | RES | Completed | |
Legend:
DB - Database
MISC - Miscellaneous
GUI - Graphical User Interface
LOG - Login
CFG - Config
PL - Product List
RES - Research
TEST - Testing
SQ - Sales Quotation
CLS - Class
CIDP: Work Distribution & Progress Day 2 (26/02/08)
Date: 26th February 2008
Venue: Database Tech Lab
WORK DISTRIBUTION
Matric No. | Members | Roles |
075038G06 | Abdul Muttalib Mohammed Rahman | Database Refinement |
075059D06 | Ahmad Hafiz Bin Ismail | Research and Test on Pop-ups |
075028D06 | Albert Chua | Debug Login Module |
Refine Login Module | ||
SQ Module | ||
074958J06 | Muhammad Hariz Bin Bakri | Design GUI layout |
075129K06 | Siti Nadiah Binte Zainal (Leader) | Create Work Distribution & Progress |
Research on White & Black Box Testing | ||
Test Cases for Login Users | ||
Update Database with Sample Data |
WORK PROGRESS
ABDUL MUTALLIB MOHAMMED RAHMAN | CAT | PROGRESS | COMMENTS | |
1 | Added login sql under stored procedure | DB | Completed | Developers logging in to the database can just use TALIBLAPTOP\SQLEXPRESS for the server name instead of using Talib’s IP address. |
2 | Rename SOItem and SQItem tables to tblSOItem and tblSQItem respectively | DB | Completed | |
3 | Added xLoc and yLoc fields in bigint in table tblItm for x and y coordinates of the location of the item | DB | Completed | |
4 | Added itmName field (varchar(100))to tblItm | DB | Completed | |
5 | Added item name to itmName in tblItm | DB | Completed | |
6 | Research on mouseover using javascript | RES | Completed | |
AHMAD HAFIZ BIN ISMAIL | CAT | PROGRESS | COMMENTS | |
1 | Testing on Pop-up - Fadebox | RES | Completed | |
2 | Testing on Pop-up - Popbox | RES | Completed | |
3 | Testing on Pop-up - Slide | RES | Completed | |
4 | Wrapping up <div> element for different user | GUI | In Progress | |
ALBERT CHUA | CAT | PROGRESS | COMMENTS | |
1 | Bugs for customer login | LOG | Completed | |
2 | Parameter btw codes and STP not tallied. | LOG,DB | Completed | |
3 | Stp ‘sttpLogin’ amended | DB | Completed | |
4 | Add checking for scenario that, customer login without identify as customer | DB | Completed | @resultCode of 2 will be returned in this case. |
5 | Develop 'Generate SQ’ Module | SQ | Developing | Problems with displaying image file |
MUHAMMAD HARIZ BIN BAKRI | CAT | PROGRESS | COMMENTS | |
1 | Design GUI layout | GUI | Completed | To start developing the GUI ASAP |
SITI NADIAH BINTE ZAINAL | CAT | PROGRESS | COMMENTS | |
1 | Create Work Distribution & Progress | MISC | Completed | For 25th and 26th February 2008 |
2 | Research on White & Black Box Testing | RES | Completed | |
3 | Create Test Cases for Login Module | TEST | Completed | |
4 | Update tblUser with sample data | DB | Completed | |
5 | Update tblClient with sample data | DB | Completed | |
Legend:
DB - Database
MISC - Miscellaneous
GUI - Graphical User Interface
LOG - Login
CFG - Config
PL - Product List
RES - Research
TEST - Testing
SQ - Sales Quotation
CIDP: Work Distribution & Progress Day 1 (25/02/08)
Date: 25th February 2008
Venue: Database Tech Lab
WORK DISTRIBUTION
Matric No. | Members | Roles |
075038G06 | Abdul Muttalib Mohammed Rahman | Create Database |
075059D06 | Ahmad Hafiz Bin Ismail | Familiarising with ASP.NET 2.0 |
Create Master Page (Assist Hariz) | ||
075028D06 | Albert Chua | Login Module |
074958J06 | Muhammad Hariz Bin Bakri | Familiarising with ASP.NET 2.0 |
Create Master Page | ||
075129K06 | Siti Nadiah Binte Zainal (Leader) | Familiarising with ASP.NET 2.0 |
Create Product List |
WORK PROGRESS
ABDUL MUTALLIB MOHAMMED RAHMAN | CAT | PROGRESS | COMMENTS | |
1 | Added relationship between user and usertype | DB | Completed | |
2 | Added relationship between user and client | DB | Completed | |
3 | Added tables POItem, SOItem, SQItem | DB | Completed | |
4 | Changed unitPrice of tblItm from float to monetary value | DB | Completed | |
5 | Created a user defined varchar(500) | DB | Completed | |
6 | Added the user defined varchar(500) to field itmDesc from varchar(200) in table tblItm | DB | Completed | |
7 | Added data obtain from the product list into tblItm table | DB | Completed | |
8 | Changed image names to shorter variables | MISC | Completed | |
9 | Added image pathname to tblItm | DB | Completed | |
AHMAD HAFIZ BIN ISMAIL | CAT | PROGRESS | COMMENTS | |
1 | Exploring features on Master page | GUI | Completed | |
2 | Exploring features on Login module | RES | Completed | |
3 | Exploring features on WebPart | RES | Completed | |
4 | Discuss on details on Forms | MISC | Completed | |
5 | Brainstorming on company name and logo | MISC | Completed | |
ALBERT CHUA | CAT | PROGRESS | COMMENTS | |
1 | Login Module | LOG | Debugging | Bugs for customer login |
2 | Stp ‘stpLogin’ added | DB | Completed | |
3 | Class file ‘ClsCommon’ added. For commonly shared variables and functions. | CFG | Completed | |
4 | Class file ‘ClsConfig’ added. For the configuration value or functions of the application. | CFG | Completed | |
5 | Class file ‘ClsBLL_Login’ added. Functions for logging. Including the data access layer to the database. | LOG, DB | Completed | |
MUHAMMAD HARIZ BIN BAKRI | CAT | PROGRESS | COMMENTS | |
1 | Create Master page | GUI | Completed | |
2 | Exploring features on Login module | RES | Completed | |
3 | Discuss on details on Forms | MISC | Completed | |
4 | Brainstorming on company name and logo | MISC | Completed | |
SITI NADIAH BINTE ZAINAL | CAT | PROGRESS | COMMENTS | |
1 | Exploring features on Login module | RES | Completed | |
2 | Brainstorming on company name and logo | MISC | Completed | |
3 | Research images for data entry | RES | Completed | |
4 | Create a product list consisting of | PL | Completed | Descriptions to be created as a jpg due to char and format constraints. Easily stored in DB. |
5 | Summarizes product descriptions | PL | Completed | Short descriptions (Consists of 100 words.) |
6 | Assist Talib with data entry | DB | Completed | Talib done overall. |
Legend:
DB - Database
MISC - Miscellaneous
GUI - Graphical User Interface
LOG - Login
CFG - Config
PL - Product List
RES - Research
Sequence Diagrams
Client & Account Admin Activities
Sales Admin Activities
Logistic Staff & Logistic Manager Activities
Deliveryman Activities
Sales Admin Activities
Logistic Staff & Logistic Manager Activities
Deliveryman Activities
Refined User/System Specifications
Refined User Specification
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 Nameless Private Limited. 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 also provides the option for the client to download the SQ in PDF file format. However, if the logged in user is the Sales Admin, he/she can monitor the submitted Purchase Order (PO) through the system. By the Sales Admin’s request the SIS can convert the PO to Sales Order (SO). Once a new invoice is generated, the SIS will update the new invoice detail. If the log-in user is the Logistic Staff, he/she can monitor the submitted Sales Order (SO) through the system. By the Sales Admin’s request the SIS can convert the SO to Delivery Order (DO). The WMS allows the Logistic Staff (LS) to maintain the stock. If the stock is out or low, the LS can request to restock the item. However, if the logged in user is the Logistic Manager, he/she can monitor the stock level. If the Delivery Man logs in, he/she can monitor the invoice status and request the item location. Updating the Delivery status could also be done in the WMS. 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.
*A common form would be needed for Purchase Order, Sales Order and Delivery Order. System should be able to keep track of the payment.
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.
Preliminary User/System Specifications
User Requirement
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 Nameless Private Limited. Both systems are linked through a common database.
The Sales and Invoicing System must be able to generate Sales Quotation which would be converted into a PDF file thus enabling the user to print or email it to the client. The system must also convert the Sales Quotation to Sales Order upon receiving the Purchase Order from the client. Delivery Order and Invoice could be generated and printed out for softcopy.
The Warehouse Management System is able to provide the location of the item stored. It also provides status and updates on incoming and outgoing warehouse items thus checking for the stocks availability.
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.
Team Members & Assigned Roles
From left: Hafiz, Talib, Nadiah, Albert & Hariz.
Task Allocation
| Members | Matric No. | Role(s) |
| Abdul Muttalib Mohammed Rahman | 075038G06 | Database Developer and PDF file |
| Ahmad Hafiz Bin Ismail | 075059D06 | Sales and Invoicing System |
| Albert Chua | 075028D06 | Sales and Invoicing System |
| Muhammad Hariz Bin Bakri | 074958J06 | Warehouse Management System |
| Siti Nadiah Binte Zainal (Leader) | 075129K06 | Warehouse Management System |
Distributed on 15th January 2008
| Members | Matric No. | Role(s) |
| Abdul Muttalib Mohammed Rahman | 075038G06 | Use-Case Model |
| Ahmad Hafiz Bin Ismail | 075059D06 | Gantt Chart |
| Albert Chua | 075028D06 | Identify Technical Issues |
| Muhammad Hariz Bin Bakri | 074958J06 | Website Administrator |
| Siti Nadiah Binte Zainal (Leader) | 075129K06 | User Specification and Task Allocation |
Distributed on 22nd January 2008
Subscribe to:
Posts (Atom)
