Encerrado

Mobile Phone Serial Number Tracking Database

We have won a contract to refurbish large volume of mobile phones for another company. We are processing the first few batches currently but before volumes increase they want to send one of their staff to inspect premises and systems.

I need a basic database built tracking the handsets that we are refurbishing. All handsets are from the same company.

As you maybe aware every phone has an IMEI number which is a unique serial number (15 digits)

The functions/processes I need to record on the data base are:

Book Used Phones in (used Phones arrive from customer for refurbishment / arrival date )

Book Refurbished Phones Out (Return to Customer / despatch date)

Book Faulty Phones Out (Return to Customer / despatch date)

Book Outsourced Units Out ( if we outsource the work to another supplier / despatch date)

Book Outsourced Units In (returned from supplier if we outsource the work to another supplier / arrival date)

All the above will be scanned in using a barcode scanner. We currently do this onto excel files.

The reports I would need to run/print are:

Run report to show handsets on our premises at anyone time

Run report to show handsets outstanding at suppliers if we have outsourced the refurbishment.

Despatch Note with all serial numbers on, used when returning phones to customer our outsourcing to supplier.

We need to record the following details for each handset:

Make

Model

IMEI

Date Booked In

Date Booked Out

Customer who sent stock to us

Supplier we sent to if we outsource work.

Status of phone when returned e.g Refurbished or Faulty (unable to refurbish).

Currently it is only 3 models:

Samsung i9100 / S2

Samsung i9300 / S3

Samsung i9505 / S4

Please bare in mind that we would like to scan in quite a lot in one go. So would need to say select i9100 x 200 units and then scan all, rather than scan each imei into a seperate field.

Uploading a text or excel file may also be quicker. Please note the handsets are booked in and out in large batches not individually. We will probably book approx up to 500 phones in and out in one week in a few batches.

The database is solely to track the physical location/history of every handset. There is no need to involve any financial data.

A search function would be needed to check one IMEI's history.

E.g we could search one IMEI and find out when it came to us, if we outsourced the work or carried it ourself and when it was despatched back to your customer.

Habilidades: FileMaker

Ver mais: we search outsourcing, outsourcing suppliers, outsourcing staff, outsourcing financial models, outsourcing excel model, outsourcing database, outsource it work, outsource for excel, outsource excel file, outsourced excel, outsourced database, outsourced company, outsource data processing, outsource a model, number function, n is a number, models of outsourcing, mobile outsourcing company, mobile outsourcing, i.s.s. tracking, function number, find company suppliers, filemaker work, excel reports outsourcing, excel report outsourcing

Acerca do Empregador:
( 0 comentários ) United Kingdom

ID do Projeto: #5097600

5 freelancers estão ofertando em média £528 para este trabalho

mango953

Hello. I have developed several phone solutions for clients in South Africa, Australia, USA and Colombia. All with different needs but all phone distributors. All the tracking you need can be done with my solutio Mais

£277 GBP in 5 dias
(8 Comentários)
5.2
vkosta

I work with databases over ten years. It is mostly Access, but I also work with FileMaker. Your task is not very difficult, and I need to build my reputation, so price is very fair. Best regards, Kosta

£61 GBP in 5 dias
(0 Comentários)
0.0
ggiedrius

Dear Sir, I can do this job quickly and as requested. My company is the member of the FileMaker Business Alliance. My full time job is to create FileMaker solutions for personal and business use. I am developing Mais

£1666 GBP in 14 dias
(0 Comentários)
0.0
joeknipp

Hello, I would like to help you with your database needs. I build clean designs with user friendly navigation. I do have a question about your product description. It says you would like to scan in units in Mais

£388 GBP in 10 dias
(0 Comentários)
0.0
rpahladsingh

Goodevening, I would be happy to build this solitution for you: since I own a dedicated FileMaker Pro Advanced, you will be able to test it online with a FileMaker Pro 12 client. Data is transmitted via SSL over a 1 Mais

£250 GBP in 7 dias
(0 Comentários)
0.0