进行中

Asset / Customer DB

I need an hardware/customer tracking system created that will allow me to record details of hardware we buy and the customers it gets sold/rented to.

I need to be able to easily find where hardware is by reference to the serial number, and where/when it was purchased including supplier invoice number, the date it moved along with the option to see the history of movements.

Hardware can be moved from one customer to another or back to us for stock, or scrapped/used for spares.

Details of the hardware; including model number, specification, Operating System (if any), type, optional extras fitted, along with details of any RMA repars (reference, date, date sent, date returned, details of repair, chargeable repair) that are needed on hardware must be recorded against the hardware serial number.

.

There can be many different hardware parts at a customer site, and there may be customers that have more than one site.

Site and customer contacts, hardware supplier and/or manufacturer info is required.

A contact would typically have name/telephone/mobile/email/address details. A contact could be any type - site, customer, supplier, manufacturer or other.

I need to be able to lookup a telephone number to find whether it is a customer, supplier, site number or manufacturer.

Easy lookup to see where a piece of hardware is or customer details is required.

Initial lookups reqruied: (there will be more later)

By customer/site to show everything at a site(s) is needed.

By telephone number to see who it relates to

By invoice number to see everything on an invoice

By serial number to see history of that part

Lookups should work on any characters in the lookup field.

For flexibility, development would be preferred in Access or something that is simple to maintain for a non-experienced developer.

I'm sure there will be more info required but please let me have the initial thoughts. I have set the budget as a simple project but can be a bit flexible on cost.

技能: 视窗桌面

查看更多: supplier manufacturer, need a hardware developer, find an access developer, buy mobile development, where to find supplier, mobile tracking system, asset, windows serial number, windows manufacturer, serial mobile, access 2013 email, access customer system, customer contact, info hardware, record lookup, email access 2013, simple project telephone, invoice windows, windows invoice, customer tracking access, email stock option email, tracking number simple mobile, project spares, windows mobile developer needed, rma number

About the Employer:
( 8 reviews ) Northampton, United Kingdom

项目ID: #4133201

已悬赏给:

HaoPX

I'm ready for this project

$120 USD 在16天内
(1条评论)
0.0

2名威客为此工作的平均竞标价是$185

darrensc

Hello - I have over 20 years experience in Microsoft Access and am interested in working with you to complete this project. I have done projects that I think will be similar in nature to what you are looking for. 更多

$250 USD 在10天内
(0条评论)
0.0