Stock Control System

Kingdomkerry

Registered User
Messages
18
Hi. I am looking for a recommendation for a stock control system?

I will soon be taking over a retail business (newsagent/gift shop). The turnover is about €500k. Currently there is zero stock control. No barcode scanner/EPOS just a till.

I wish to complete management accounts on a monthly basis so I would need to know the exact value and quantity of stock at anyone time.

As there is currently no stock control I would initially need to do a complete stock take. Hopefully this does not mean scanning each item of stock individually.

Some items of stock will not have a barcode so I assume I will need to print my own barcodes and attach to stock items.

Once a complete stock take has been taken I then need to receipt goods in and goods out will be accounted for by scanning items sold at the till.

I need the system to provide reports of what is selling and how quickly by category of stock and by supplier.

Other features I would find useful include:
Flexible demand forecasting

Self-adjusting reorder levels

Purchase order is (automatic purchase order which can be overruled/adjusted)

Ability to write off obsolete stock
 
Hi KingdomKerry,

I work in this sector, so if you would like more information, you can pm me.

To answer your questions,

1. To introduce an epos system to your business, you will have to set up each item individually unless you can get a spread sheet from your supplier and then import them to your system. If items do not have a barcode you can assign them a short code PLU(product look up) number e.g 100, 101 etc or you could generate a unique barcode in your software. Most Epos systems now give you the option of an item label printer, meaning you can print individual price labels with a barcode on it.

2. After you have created all items, you will need to do a full stock take. You could do this as you are going along but it will take that bit longer to get set up.

3. Most systems have plenty of reports to view your sales by department or sub department etc. Instead of looking at this information in reports, most epos systems will have an ordering program. In here you will specify a supplier and a date range. E.g Create an order for Supplier 1 based on sales from 01/09/2014-16/09/2014. You can then see how many you have in stock of all items supplied by that supplier, the sales for that period and a suggested order quantity based on the information. You will be able to over ride any suggested quantities or remove them completely from an order.

4. Writing off obsolete stock is usually done by a stock adjustment. You can then see a report of all stock lines adjusted by reason for the accountant at the year end.

Best of luck with it all and let me know if I can be of further assistance.
 
Back
Top