Đang Thực Hiện

121898 Company App+DB

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.

Database

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.

Customer history

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.

Functions

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.

Reports

Technician invoices.

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

Kỹ năng: Bất kì công việc gì, ASP

Xem thêm: work home customer service jobs, work from home tech support jobs, work from home tech support, work from homes jobs, work from home paid weekly, work from home over the internet, work from home jobs us based, work from home jobs that pay weekly, work from home jobs list, work from home jobs in us, work from home it support jobs, work from home get paid daily, work from home customer service companies, work customer service from home, work at home tech support jobs, work at home tech support, work at home tech jobs, work at homes, work at home jobs that pay weekly, work at home it support jobs, work at home get paid daily, work at home customer service companies, work at home customer service, work as tech support from home, wiring technician jobs

Về Bên Thuê:
( 0 nhận xét )

Mã Dự Án: #1868064