I have a small manufactureing company and I maintain an excel spreadsheet that list parts that my suppliers shorted me on witch means that they did not deliver all the parts I needed.
So I would like a system that will allow me to upload my spread sheets that list all the parts shorted and when it gets uploaded it maintains and updated a database online of my shortages.
So when upload todays list I will like an automatic emails to be sent out to all my buyers and suppliers detailing what items were shorted.
I would like my suppliers to be able click on a link in the email and they will be able to access my system and fill out a short form providing the reason why it was shorted and a new delivery date. And then this information will automaticly update on my data base
I would like for everytime a supplier replies an email gets sent to the buyer incharge of that supplier and tells the buyer that they have replied and tells the buyers witch other suppliers are pending
-------------------------
I would also need a admin area were I can add and remove suppliers and buyers. I would want be able to have the choice to do bulk updates as while using an excel spreadsheet. I want to be able to export information from the database into an excel spreadsheet also
This project will be needed to be completed in under a week.
I have a small............... Budget so please no Outragous bids.