Hi, i have a simple little ASP website requirement with SQL 2005
Add/Edit/Delete Customers
Add/Edit/Delete Inventory Items
I need to? be able to create the following? after this
-Create a quotation for the customers listed in the customers table
* on creation of Quote,? First thing should show to? me is a list of customers, Click on customer and new Quotation should open, and dispay some customer details at the top.
The Quotation lines should have drop down box in description field for user to select and after Quantity is filled work out the tax and tota ( Price * Qty * Tax = Total)
-Save the Quote and edit it later if needed
(have an table that has the customer name and details etc. and then seperate table that has the? Quote's lines linked via an Record ID )?
Basic layout looks like this
SAMPLE
-----------------------------------------------------------------------------------------------
Customer? Name: Mr Trump?
Address: 123 Some road in the desert
Fax? Number: 000-0000-0000
Contact Number: 000-0000-0000
-----------------------------------------------------------------------------------------------
Item? ID | Description | Qty | Price | TAX |Total
-----------------------------------------------------------------------------------------------
132 | Fix Carburetor |1 |$ 10.10 |? $ 0.00 |$ 10.10 | Delete Row | Add row |
132 | Fix Carburetor |1 |$ 10.10 |? $ 0.00 |$ 10.10 | Delete Row | Add row |
132 | Fix Carburetor |1 |$ 10.10 |? $ 0.00 |$ 10.10 | Delete Row | Add row |
-----------------------------------------------------------------------------------------------
Grand Total $ 30.30
-----------------------------------------------------------------------------------------------
I will give more info later
I require to give customers quotes and then send them the quote via PDF and email
## Deliverables
i have a data flow diagram, database and documentation on each screen