SLUG Mailing List Archives
[SLUG] Inventory Control System / ERP - SQL Ledger?
- To: "SLUG list" <slug@xxxxxxxxxxx>
- Subject: [SLUG] Inventory Control System / ERP - SQL Ledger?
- From: Ben <shadroth@xxxxxxxxx>
- Date: Tue, 24 Jul 2007 22:23:02 +1000
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=LMlbQhUl5cht4iKJ6tQgaOJSBqPniZk1RJWRnsap97Rr7hgJ//UGmX+2dFwAB0Schf4JtrCI+2iA5UWjXwFHWgTOneirXgzvuuaEZnxYrHVW4wH2HL4jXTq3g4ZFmvjqaKc5iRjA1Q1jhUbRcUboOAeL8nbToaIHokLbi+V3hb0=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=SwautxdxRHuRUYzWI570zvBhOPdBDMDLZV43pt+A+HlQjfrS8/CdGAXlWqdllRH/CF/+FqDwafWPb8jqp4GN5FVU7xeQLv6TNRw5qPNe8vz9h/An+0uGecekvPyHUEwiqvDIVgq+gxg4Eae7JwegIJn2Ryr2nvV9EumMaRIM8kE=
I need an inventory control system for work. Work is not being
proactive about it and I'm only interested in learning something open
source. So far SQL Ledger looks like it might do the job, but before I
mess around with it I wanted to see if anyone has any suggestions. I
assume the real clincher will be finding a system that can cope with
syncing offline versions.
* We have several technicians who each carry stock, so some sort of
multiple wharehouse/site capability needs to exist
* The technicians swap stock around with each other, so they need to
log that one of their parts has been transferred.
* Some way to account for different purchase prices of the same item
* Should be able to be setup so it's useful away from the server -
eg. log a part swap or sale in a PDA/laptop and then synch with the
server when an Internet connection is available.
* Integration with some sort of scanner - barcode, RFID... etc.
Accounting is not needed at this stage, that's all done in MYOB. The
technicians just need to be able to print out a sheet each week
specifying the parts that have been sold or transferred, the sale
price, the cost price and an associated job ID.