Chemical Stock Control

[Ric_]

Our science department is after some form of electronic system for stock control.

 

The requirements are simple:

* Input stock

* Input amounts taken out - obviously calculate new stock

* Set a minimum stock level - automated notification (email?) when this is reached

* Generate reports on stock usage and what's left, etc.

* Any other handy gubbins (e.g. making brews)

 

It's pretty simple stuff and can be bought but I reckon that it is probably the sort of thing that is available FOC (Opensource, GNU, etc.). Of course writing it myself is one way of doing it but what's the point in re-inventing the wheel?

 

Basically - I need ideas!

[tarquel]

Agreed - I'm sure our Science Techie would snap this up too

 

(same may go with other depts too)

 

Making it yourself as in php & mysql type system on a internal webserver perhaps?

 

Sounds good to me if so

 

PS. Isn't this section for "How to..." guides and solutions, not requests for things? Just thinkin in admin ways btw - no offense meant coz its a good question you ask Ric

 

Cheers

Nath

[Geoff]

ERP5 is whats usually mentioned for warehouse stock control.

 

http://www.erp5.org/

 

http://www.erp5.org/sections/screenshot/warehouse_management/view

 

However its ridiciously over complicated for what you wish to do. I cannot find anything thats more focused or simplified though.

[Mango_RW]

I was asked to find / make something similar for our print cartridges so I wrote a quick VB App and it has made things a lot easier. I intend to make the front end web based eventually but if the app works?!?!

[Ric_]

PS. Isn't this section for "How to..." guides and solutions, not requests for things? Just thinkin in admin ways btw - no offense meant coz its a good question you ask Ric

 

I thought it was how you find out how other places do 'it' - although it is kind of a cross-over post and I struggled to find the right place to put it.

[tarquel]

lol Ahhh I see... From the description of the board (when you look at it from the main forum index) I never got that meaning lol

 

But your the site admin so I do indeed bow to your supremecy (spell checker pls lol)

 

Cheers,

Nath

[Geoff]

spell checker pls lol

 

http://spellbound.sourceforge.net

[Dos_Box]

I've found one!!!

 

http://sourceforge.net/projects/slims/

 

SLIMS is a small laboratory information management system used to maintain chemical stocks and analyze biological assays. SLIMS comes in two flavors, a single user, single file database suitable for sending to collaborators and as a multi-user database.

 

Does this fit the bill Ric?