Stock Control System
04-02-2009, 12:59 AM
#1
Senior Member
Thread Starter
Join Date: Jan 2008
Location: South Africa
Posts: 218
Likes: 0
Received 0 Likes
on
0 Posts
Hi guys,
I am in the Motor Spares Business.
I have thousands of different type of parts.
Till now we have not done stock as it is family run.
But we are having problems as business is expanding.
I have a degree in Internal Auditing and have experienced using PASTEL.
I want a system that can do the following.
1. Can read barcodes created by me ( I assume i have to get a barcode machine)
2. Can print invoices (and update the stock as it is sold)
3. Can set a reorder qty (So when items are reduced to this qty it will make a note to reorder)
For now that is all i can think about.
Can someone please help?
Thanks
I am in the Motor Spares Business.
I have thousands of different type of parts.
Till now we have not done stock as it is family run.
But we are having problems as business is expanding.
I have a degree in Internal Auditing and have experienced using PASTEL.
I want a system that can do the following.
1. Can read barcodes created by me ( I assume i have to get a barcode machine)
2. Can print invoices (and update the stock as it is sold)
3. Can set a reorder qty (So when items are reduced to this qty it will make a note to reorder)
For now that is all i can think about.
Can someone please help?
Thanks
04-02-2009, 06:28 AM
#2
Senior Member
Join Date: Apr 2008
Location: Western PA
Posts: 2,087
Likes: 0
Received 0 Likes
on
0 Posts
Vehicle: 2001 Tiburon
Sounds like you need just an inventory control system. There are a ton out there on the market for things like this.
My question to you is this, are you looking for a home grown app or a commercial app? What is the size of your inventory, how many different parts are you going to stock. Are you going to cross reference them? How many terminals are you going to want to run this on? What type of reports do you want to run?
I may be able to help, just have to know the scope you are looking at.
My question to you is this, are you looking for a home grown app or a commercial app? What is the size of your inventory, how many different parts are you going to stock. Are you going to cross reference them? How many terminals are you going to want to run this on? What type of reports do you want to run?
I may be able to help, just have to know the scope you are looking at.
04-02-2009, 08:00 AM
#3
Senior Member
Thread Starter
Join Date: Jan 2008
Location: South Africa
Posts: 218
Likes: 0
Received 0 Likes
on
0 Posts
Hey Bullfrog.
I knew someone here could help smile.gif
Well we are stocking maybe 6000+ different types of stock.
We dont need cross referencing.
Just need a barcode system that will just do the stock counting and print monthly figures.
Like an accounting system for stock and for Small Medium Enterprises.
Simple reports.
Nothing hectic.
I want a system that wont need the internet to be online.
Hope this helps
I knew someone here could help smile.gif
Well we are stocking maybe 6000+ different types of stock.
We dont need cross referencing.
Just need a barcode system that will just do the stock counting and print monthly figures.
Like an accounting system for stock and for Small Medium Enterprises.
Simple reports.
Nothing hectic.
I want a system that wont need the internet to be online.
Hope this helps
04-02-2009, 08:05 AM
#4
Senior Member
Join Date: Apr 2008
Location: Western PA
Posts: 2,087
Likes: 0
Received 0 Likes
on
0 Posts
Vehicle: 2001 Tiburon
Dannee, pm me your e-mail and if possible if you use any instant message service your screen name. Ill see what i can come up with and run it by you.
04-02-2009, 08:33 AM
#6
Senior Member
Join Date: Apr 2008
Location: Western PA
Posts: 2,087
Likes: 0
Received 0 Likes
on
0 Posts
Vehicle: 2001 Tiburon
Have to check later in the day. I can add you via yahoo web messenger. Let me see what i can do over the weekend, im going to be out of town for a little bit of it but ill see what i can get done.
04-02-2009, 11:14 AM
#8
Administrator
Join Date: Oct 2002
Location: ɯooɹpǝq ɹnoʎ
Posts: 13,943
Likes: 0
Received 0 Likes
on
0 Posts
Vehicle: ǝdnoɔ sısǝuǝƃ
Where is your degree in Internal Auditing from? Not many universities offer a degree, LSU is one of the few.
Since you're familiar with Internal Audit, use Microsoft Word for your invoices (or Quicken/Quickbooks). Just keep track of documentation and ensure all invoices are prenumbered.
For barcode information, start here:
http://en.wikipedia.org/wiki/Barcode_printer
http://www.idautomation.com/barcoding4beginners.html
You'll need software to generate barcodes, and of course a scanner that reads them. I don't think actual barcode printers are that expensive.
A basic inventory software package should give you what you need. The ability to print barcodes, scan them, and have the software easily identify what was scanned.
The inventory software would probably have to have user set guidelines to initiate a request for re-order, or preferrably PROMPT the user to reorder.
Since you're familiar with Internal Audit, use Microsoft Word for your invoices (or Quicken/Quickbooks). Just keep track of documentation and ensure all invoices are prenumbered.
For barcode information, start here:
http://en.wikipedia.org/wiki/Barcode_printer
http://www.idautomation.com/barcoding4beginners.html
You'll need software to generate barcodes, and of course a scanner that reads them. I don't think actual barcode printers are that expensive.
A basic inventory software package should give you what you need. The ability to print barcodes, scan them, and have the software easily identify what was scanned.
The inventory software would probably have to have user set guidelines to initiate a request for re-order, or preferrably PROMPT the user to reorder.