Forum Home
PC World Chat
 
Thread ID: 123987 2012-03-30 00:23:00 After a manufacturing stock system hueybot3000 (3646) PC World Chat
Post ID Timestamp Content User
1267505 2012-03-30 00:23:00 Hey there peoples .

Got a new job and we are in need of a stock system because the current spread sheet is massive and messy .

Requirements are . . .

We have 3 basic levels of manufacturing . . .
1 . Raw material
2 . Painted material
3 . Processed material

We have approx 20 different raw products which come in either 2 . 4m and 3m lengths or 3m and 3 . 6m lengths depending on product .

Each product can then be painted either black, grey or white .

From there they are processed further with a final choice of 4 more options .

So one raw product can turn into about 12 different finished products and say we ordered in 1000 of raw product they could turn into anything at different quantities .

Does anyone know of a stock system that can deal with that? Preferably simple, we don't need any costs, accounting etc as that is all sorted . Just the stock . Price of software not an issue (within reason)

Thanks 		hueybot3000 (3646)
1267506 2012-03-30 00:50:00 MS Access gary67 (56)
1267507 2012-03-30 01:13:00 Maybe you come give these guys software a try, hes located in Nelson and from what I have heard will tweak software to suit your requirements.
www.khan.co.nz
I havent seen any of this software my self, but its an affordable option. 		Iantech (16386)
1267508 2012-03-30 04:14:00 B U G G E R, that would have been a dream job to under take, 30 years back.

Branch accountant for a feed a milling firm, I had the task of writing spreadsheets in Lotus Symphony, for manufaturing, sales, stock sheets, fixed assets, almost anything.

Symphony was the "big brother" to Lotus 123.

Sorry, I would not be much help with today's MS stuff.

Lurking. 		Lurking (218)
1267509 2012-03-30 04:17:00 What you want is really called a Bill of Materials.

I wrote one years ago on Paradox a dos database system and sold a few to some local manufacturers

You could do it in Access.

But why not look for a proper software product.

There must be some in the world, it does not need to be NZ written.

Try Google Bill of Materials.

(Of course if your company had someone in house to do it on Acess you could modify it later.)

Pros and Cons 		Digby (677)
1267510 2012-03-30 05:41:00 I'll add another voice supporting an MS Access database... naturally provided you've got Access on whichever machine(s) are required to access this DB.

I could throw a sample DB together to illustrate my own concept of it if you wish. I've done a DB for a well known pipe fitting co regarding their stock tracking, although your situation is a little different, as their DB is tracking WHERE it is, whereas yours is tracking quantities as the products flow through the workshop stages. 		Paul.Cov (425)
1267511 2012-04-01 21:09:00 Thanks guys, I should add that we are apple based here (I know!) so would prefer something compatible with the mac server . A web based stock control would also be an advantage as stock is often needed to be checked from out of office and overseas etc which becomes a problem when we go home and then someone in the UK gets up and needs to know something off it .

I have been looking at a few addons for Xero but they all seem a bit overkill for what we need . All of our costings etc is done through other software, perhaps we are using this wrong but I though t it'd be a lot easier to find a simple bit of software to do this .

I have considered building on in filemaker but I don't have the time, or the knowledge to do so . Maybe hiring someone to do this is an option as well . 		hueybot3000 (3646)
1267512 2012-04-01 21:19:00 I'll add another voice supporting an MS Access database... naturally provided you've got Access on whichever machine(s) are required to access this DB.

I could throw a sample DB together to illustrate my own concept of it if you wish. I've done a DB for a well known pipe fitting co regarding their stock tracking, although your situation is a little different, as their DB is tracking WHERE it is, whereas yours is tracking quantities as the products flow through the workshop stages.

PM Sent 		hueybot3000 (3646)
1267513 2012-04-01 23:32:00 PM Sent

And one back at ya. 		Paul.Cov (425)
1