I have been asked to set up an ordering system for a clothing company to hold stock records and process orders.
Design Specification
A - Requirements
I have been asked to set up an ordering system for a clothing company to hold stock records and process orders. The system should reflect the outdoor image of the company. The company colours are blue/yellow and it has a logo, which could be used to personalise the system.
The system must be able to:
- Hold Information
- hold the details of 20 stock items including, stock code, description, price and quantity in stock
- hold customer details for 10 clients including full name, address and postcode, current balance and credit limit
- Take an Order
- Input name of client (check if name is on record and generate an error message if not)
- Input stock code for items required (check for valid code and display item and price each)
- Input quantity of item required (check there is sufficient stock and generate an error message if not)
- Repeat for up to 5 stock items
- Calculate the total bill for the items ordered
- Apply a discount of 10% for orders over £500
- Add VAT at 17.5% (including a way to alter this if it changes)
- Calculate the overall cost for the invoice (check it is within the client’s credit limit and generate an error message if not)
- Include a way to process or abort the order
- Produce an Invoice
- Generate an invoice from the information input in 2
- Print out the invoice
- Update the customer current balance to reflect the new order
- Update the stock to reflect what has been sold
- Clear out data from order form ready for next order
- Update Information
- Update stock quantity when new stock arrives
- Update customer current balance when an invoice is paid