year 1998 , Freelance job
sales order system
System Feature
1.0 | Customer Information Maintenance Module
1.1  | 
This module will keep track of the customer information, which includes a small module called tax exemption maintenance module. This small module will keep the details of tax exemption applied by their customers.
2.0 | Product Information Maintenance Module
2.1  | 
This includes the maintenance on product color, product type and product code.
2.2 | 
Each product type will have a different kind of input mask. For example, yarn is 'Y#999.99c' where Y represents yarn; # represents optional digit and 9 represents fixed digit and c represents a color code. So, we created a control to handle different input mask and it allows the user to define new input mask (the control will change according to the mask).
3.0 | Sales Order Entry Module
3.1 | 
Once the user receives the purchase order from their customer, they will enter the details to the system.
3.2 | 
The factory supervisor will retrieve this data.
4.0 | Fulfillment Entry Module
4.1  | 
Enter the data when the goods is ready to deliver.
5.0 | Delivery Entry Module
5.1 | 
Enter the lorry details and the sales order details, then, print the Delivery Order for lorry driver.
6.0 | Invoicing Entry Module
6.1   | 
The accounts department will print the invoice when the goods are delivered to their customer.
6.2 | 
User Login Maintenance Module - maintained by System Administrator.
6.3 | 
The system administrator will add, update or disable the user login through the simplified version of security control module.
7.0 | User Login Maintenance Module - maintained by System Administrator
7.1 | 
The system administrator will add, update or disable the user login through the simplified version of security control module.
8.0 | Report Module
8.1 | 
This includes product listing, customer listing, sales order entry listing, etc.
Development Tools
1.1  | 
MS SQL 6.5 - database engine
1.2 | 
VB 5 - develop user interface
1.3 | 
Crystal Report - create reports
Client Background
Paper/plastic bag manufacturer who is operating their business in Penang Island, Malaysia.
Achievement
1.1  | 
Provides a better way to control over the production schedule and reduce the idle time. This is because the user can print the pending fulfill order sorting by estimated delivery date.
1.2 | 
Shorten the learning cycle of handling sales order, fulfillment, delivery order and invoice.
1.3 | 
Allows the user to expand the system easily.