Keeping stock levels, & identifying products
Hi folks, As part of my role I've been asked to keep track of our printer Toners. I've created a Spreadsheet with column headings, Toners, Printers , Stock Level Keep in stock , Order I've created a formula that tracks Stock levels, and Keep In Stock to automatically link to the Order column. I've a list of companies to get quotes from for Toners and I am clear on the ordering process. When the post arrives in we have a reception that takes delivery and brings the items to members of staff. Now for the tricky part.... I need to be able to ideally, independently issue out the Toners on request. Have any of you suggestions on how I can identify the boxes I am handing out? I do have working eyes around me, but I want to cover myself as to not get pulled up for the 5 seconds it takes for me to ask a sighted person to read the Toner ID, eg. 2055 (05a). Bureaucracy being what it is this is bound to happen at some point. In due course I will be given an area to store the Toners, so I can organise these into shelves etc, but this still leaves me with the issue identifying the Toners by myself. I'm thinking possibly a barcoding app for my iPhone. Suggestions of apps to try welcomed, and any other methods most welcome! Thanks, Barry. Barry Toner ICT Assistant ICT Department Clanmil Housing Northern Whig House 3 Waring Street Belfast BT1 2DX Tel: 02890 876000 Fax: 02890 876001
participants (1)
-
Barry Toner