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.