I am looking to rebuild our existing Microsoft Access - Order Invoice management Database to a MYSQL database to work with a web shopping cart also to be developed. The current Access solution has some bugs and I don’t know if it can be re-used as is. The Access source code, Front and Back End is available if needed to bid.
We expect the application to look and feel the same as the original Access DB.
Payment will be in full after project completion. This term is not negotiable and escrow will not be used. Should the successful developer complete the project within the desired timeframe and to our expectations, a 15% bonus will be paid.
I have created a new set of tables with their relationships. I include the new tables with this project submission
Timeframe is 6 weeks from initial developer selection.
Here are the requirements:
1. Secure log in.
2. Log-out function to log a user out of the system if inactive for longer than 5 minutes
3. Main Menu
4. Stock/Client search form
5. Order Entry Form consisting of:
a. Capture an new customer
b. Search for a existing customer
c. Capture of order details
d. After the order has been saved the user must to be able to print, e-mail and or fax the order or invoice to the customer.
6. Stock capture form – Stock must be split into WEB Stock and BRANCH
7. Stock categories
8. Suppliers capture form
9. Order Details
10. Customers capture form
11. Employees capture form
12. Accounts Payable capture form
13. Accounts Receivable (Report)
14. Mail send capture form
15. Mail received capture form
16. Run Reports
17. Run Queries
18. Export/import tables
19. Shopping cart