We need a form created to track our stock /serial numbers as the stock moves from customer to customer. Need to track supplier info and customer info.
## Deliverables
**We want a GUI or Excel workbook or some sort of interface which will allow us to track our serialized stock items. We need to be able to attach a file where outlined below and when searching for a customer we need the attachments and below information to come up.**
**
I have not described below but if there was a history section to track if a stock item has IE: been sold to a customer, then they returned it and it was sold to another customer. We want to be able to track that items moments.**
**It will be installed on our server and there will be about 2 pcs that will access this server.**
**When bidding for this job please include a screenshot /example of some previous forms you have made of the same nature. I need it completed in the next 48 hours.**
**If you need any info let me know**
**Please call the software 'APT' (ANTTEL product tracking)**
**ENTERING INFO**
** **
Item Details
Brand:
Model:
Quantity:
(Pop up- once quantity inserted a pop up box comes up requesting the relevant number of serial numbers for each item, can be left blank if doesn’t have serial).
Supplier Information
Supplier Name:
Contact Number:
Purchased Date:
Warranty Period:
(Attach button ??" to attach invoice of item)
Sold to
Customer Name:
Sold Date:
Install/Dispatch Date:
(Attach button ??" to attach customer invoice)
Notes:
(need a box to add notes to the transaction)
___________________________________________
SEARCHING
(we need to be able to search on the below fields)
** **
Customer Name:
Supplier Name:
Product Model:
Serial Number:
Date: