CRM, stock inventory, and database

Hi All, We are a new start up company looking for a solution to integrate our installation team's paperwork with the sale reps all over an online database. I'm not too au fait with the IT terminology of what it is We are exactly looking for but I will try and explain the best I can and hopefully you guys can help us out. We are Wellington's largest audio visual installation company, and we work within a larger company group which includes imports and sales of hardware throughout NZ. As company manager and being only 26 (recently promoted) I want to implement an idea I have had for sometime to knock the socks off the higher management guys!! At present the jobs are processed like the following: -sale reps go to quote a job -sale reps win job -Sale reps pass on information to the installation team in various methods, some reps are shocking at transfer of valuable information, whereas others are pretty good. Including drawings and other important info. -The installation team arranges a date with the sale rep for the hardware install. -We more than often can not complete the job in one day for the following reasons. We can not gain access to the site, other tradesmen have not finished their jobs which have to be in order for us to install our hardware(we are always the last guys to work on a site) . -The above problems are due to lack of information passed from sale reps to The installation team -We as an install team perform inefficiently due lack of proper planning and management of the jobs! (purely the sales guys fault!) _I see a massive benefit of putting a program in place, to tie both teams into one streamlined process. Which is simple, clean and easy to learn how to use. Now this is how I envisage the program working. -Sale reps quote a job onsite with an ipad. So they select "new job" and have an option to use previous customer details (as we do work for the same clients over time) or add a new client into a database. -Once this simple sheet has been updated or a previous client's details are selected, they press next.... -Now on the next page all the information we find vital to prepare for a job as an install team can be taken down. Be it photos (taken onsite with the ipads) or attachments including technical drawings, access times etc. -Now once this job is logged, Our install team can access this information and prepare properly for the job in hand. They can look at photos and query anything before they get to site. -Now the guys can get to site with the correct equipment and get the correct access. -When the install guys finish the job, they can go back into the ipad and invoice for the job. -The install guys will mark off any materials used from an online stock inventory. I already have an excel work book to do this process. Maybe it could be incorporated into the program i'm looking at having developed. -The excel workbook is working, so that when stock levels of items drop below 30% a cell is flagged red telling me to re-order any particular item. _ I would like to automate this [login to view URL] that when the cell is flagged, it generates an email along with the stock code and the quantity of that item needed to the supplier for them to send to us. -I would manually update stock once it arrives at our office. The invoice would be emailed to my email address so that i can check it before we send it out to be charged for the install job. All this process would be LIVE and online for everyone of our company to use. Different people have different levels of access depending on their position of the company. I hope for the life in me this description sounds clear! We are looking primarily for people in Wellington to work with, but if you can persuade us otherwise we may consider other options. Regards Michael Speight Company manager Videopro Installations ltd