We are a fulfillment company that does satellite TV installs. We need a database that can track our inventory of receivers, customer history and invoice system for a small inventory of parts and accessories we sell to our installers. We would prefer if the database is web based, with everything being entered into a webpage or a program that connect over the internet/VPN/LAN to a database.
We need to be able to track the location of any receiver that we have ever had, whether it is currently at one of our warehouses, on a technician's truck or installed at a customers home. We need to track customer service calls and be able to display all equipment (receivers, switches, dishes) we have ever installed at the location and possibly notes if the are escalations/problems. We also sell a small inventory of parts to our installers that we need to be able to track and deduct from their pay. We also do custom audio & video installs and pre wiring of custom homes that we would like to be able to track the customer and items installed.
I have enclosed a excel spreadsheet that we currently use as our DB. We have our MAIN page which is where all receivers at our warehouse are located. The TECH page is our entire technician inventory. The RMA page is for defective equipment. The INSTALLED page is for all receivers that have been installed at a customer's house, all receivers that have been installed have a subscriber number attached to them. We need to track when a receiver was first put into inventory, when it was given to a technician and when it was installed or returned to the warehouse. Also we need to know if any receiver has been in our inventory for more than 25 days and not installed. This also needs to work with multiple warehouses in various cities/states.
Enlosed is our customer service info. We use this to track customer history, equipment installed, custom labor charges and how much we are supposed to get paid for the services. We would like to possibly add a function that checks an excel spreadsheet given to us and calculate how much we got paid and update the database. Along with that function we would need to know if any of the jobs we paid incorrectly.
Daily ï¿½ Add items into a technicians inventory and remove any items not installed the previous day. Also create invoice for additional parts technician needs. Add customer service information into database.
Weekly ï¿½ Add new receivers delivered to the warehouse. A additional function to check a list of receivers given to us against what we actually scanned in. We receive a list of every item we should be receiving with bar codes next to them and want to be able to check that against what we just scanned in ourselves.
RMA ï¿½ list of receivers going to be returned. Printed so the company receiving them can sign it showing they took it back.
We need to be able to search our database by just about every record. We will mainly be searching by serial number, access card, TechID, job number and subscriber number. We want to be able to either print a query or open it in excel/word.
This should be custom designed, no premade systems. Programmer must have decent english communication.
System should be designed so that it can support multiple companies with seperate databases.
Prefer ASP/.NET and MSSQL