- This topic has 7 replies, 7 voices, and was last updated 19 years, 4 months ago by
.
-
Posts
-
Can anyone suggest a basic pc based system for a small operation say two or three engineers to monitor van and storeroom stock?
Are there any suitable ‘off-the-shelf’ products that anyone has any experience of?No TBH any I’ve seen have either been a hodge-podge of an accounts package or a proprietery system, often a manufacturers. 😕
There’s loads of stuff out there, mostly you’d have to pay for it though and whether it’s any good for this industryor not I haven’t a clue.
K.
kwatt wrote: any I’ve seen have either been a hodge-podge of an accounts package
We use Quickbooks for all our accounting needs. The stock control couldn’t be simpler. Any items purchased are keyed in on a daily basis and all parts used are recorded on the invoices and keyed as a usage.
It has its limitations and problem (mostly due to duplicate part numbers when items are sourced from a different supplier and/or the package has a different part number from the supplier’s invoice.)
However it works well for us and we can see exactly what is in stock at any time. It can be set up with minimum order levels and the system will prompt for the item to be reordered.
Bob
Re: Stock control system
Yeah Bob, quite a few people do that and it works on a small scale but Quickbooks is limited to a certain number of product lines IIRC and that’s where you start to hit problems as it wasn’t designed for what we do sadly. It’s great for accounts though, we use it and I think Sean does as well.
I also know that Scott at ANSA uses it too, that’s how I know about the product limitations and he’s had the same issue as you with superceded numbers although I think he came up with a workround for that, a bit.
The other huge problem that we all have on this front is that the manufacturers information is usually (without swearing ;)) lacking shall we say. They don’t make it easy as they’re too busy trying to protect the data, quite who from I’ve still to work out as in most industries the info is made available to enable people to sell stuff, not hinder sales.
What do I know though?
K.
Re: Stock control system
Hi
I missed this post. I have written a package for warehouse & VAN stock control.
As a company we use it for 13 engineers but it will happily do 2 -100
Several companies are using it. It has the abillty to produce reports, monitor top usage, Produce picking lists automaticly order stock when van stocks are low etc. Show instant Warehouse and vanstock values (handy for the accountant!)I also have had over 20 years experience in the white goods industry so I know what the small whitegoods Industry needs, I have the package ready to go, It runs on Access2000 or 2003. I can also tailor the package to suit your needs and I would be happy to quote for this.
If anyone is interested the you can email me chris.thorn@dsl.pipex.com
Regards
ChrisRe: Stock control system
Don’t get much time these days to pop onto this forum so only just seen this..
I wrote my own stock program useing MS Access.. Pretty esay to use and there are pleanty of usefull books out there to help.. Took about 6 weeks of evenings to get a system up and running and taylored it all to my own needs. Didnt even have to learn Visual Basic to get a good system up and running… I have been using it for about 15 years now and works a treat and it is all menu driven..
The Book I used was a Wrox publication called The Beginers Guide to Access 95, Although quite old now I’m sure they will do a recent publication for the latest Access program.. The book was very self explantary and showed you how to write your own stock system.
The only drawback to this is that you need to buy MS Access or Office pro to get Access which is an arm and a leg..
Mick
- You must be logged in to reply to this topic.