EDAboard.com | EDAboard.de | EDAboard.co.uk | WTWH Media

Simple shop-floor inventory program

Ask a question - edaboard.com

elektroda.net NewsGroups Forum Index - Electronics Design - Simple shop-floor inventory program

mpm
Guest

Mon Feb 11, 2019 2:45 am   



Anyone know of an inventory program for:

> 6,000 discrete parts in inventory (Maybe 50%-60% routinely used in jobs.)

I just want to track (via barcode scan) in/out, by tech & job - and maybe compare that to the job BOM for variance.

I don't really need to go much further than that - i.e., no interfacing with NetSuite Accounting, ordering, stock levels, loading dock, RMA's, etc... The company doesn't want to spring for the full-blown inventory package in NetSuite because A) it's expensive, and B) is probably too complicated for our needs anyway. (That's another long story....)

A lot of what we build can be considered "custom one-offs", and I just need to generate a BOM quickly, pretty much at the same time we do the initial design. Each build is similar to the last, but "different enough" for it to be a real pain in the ass.

I have this (maybe not so) crazy idea that a few well-placed barcode scanners, hooked to a simple running list in/out inventory (by job / tech), even if as a flat file (Excel, *.csv, etc..) would help tremendously. Even during the design phase (don't ask.) :)

In short: Can one of you recommend a very basic (bare-bones) inventory program?
Windows based is preferred, and I can dedicate a machine to it. Thanks!!!

Martin Riddle
Guest

Mon Feb 11, 2019 4:45 am   



On Sun, 10 Feb 2019 17:40:45 -0800 (PST), mpm <mpmillard_at_aol.com>
wrote:

Quote:
Anyone know of an inventory program for:

6,000 discrete parts in inventory (Maybe 50%-60% routinely used in jobs.)

I just want to track (via barcode scan) in/out, by tech & job - and maybe compare that to the job BOM for variance.

I don't really need to go much further than that - i.e., no interfacing with NetSuite Accounting, ordering, stock levels, loading dock, RMA's, etc... The company doesn't want to spring for the full-blown inventory package in NetSuite because A) it's expensive, and B) is probably too complicated for our needs anyway. (That's another long story....)

A lot of what we build can be considered "custom one-offs", and I just need to generate a BOM quickly, pretty much at the same time we do the initial design. Each build is similar to the last, but "different enough" for it to be a real pain in the ass.

I have this (maybe not so) crazy idea that a few well-placed barcode scanners, hooked to a simple running list in/out inventory (by job / tech), even if as a flat file (Excel, *.csv, etc..) would help tremendously. Even during the design phase (don't ask.) :)

In short: Can one of you recommend a very basic (bare-bones) inventory program?
Windows based is preferred, and I can dedicate a machine to it. Thanks!!!


Their all complicated. Sounds like a job for Access, but if you insist
on a MRP there are a few small mrp systems out there. Like DBA
manufacturing, their single seat demo is free, which might work for
you.

Cheers

Joe Chisolm
Guest

Mon Feb 11, 2019 7:45 am   



On Sun, 10 Feb 2019 17:40:45 -0800, mpm wrote:

Quote:
Anyone know of an inventory program for:

6,000 discrete parts in inventory (Maybe 50%-60% routinely used in
jobs.)

I just want to track (via barcode scan) in/out, by tech & job - and
maybe compare that to the job BOM for variance.

I don't really need to go much further than that - i.e., no interfacing
with NetSuite Accounting, ordering, stock levels, loading dock, RMA's,
etc... The company doesn't want to spring for the full-blown inventory
package in NetSuite because A) it's expensive, and B) is probably too
complicated for our needs anyway. (That's another long story....)

A lot of what we build can be considered "custom one-offs", and I just
need to generate a BOM quickly, pretty much at the same time we do the
initial design. Each build is similar to the last, but "different
enough" for it to be a real pain in the ass.

I have this (maybe not so) crazy idea that a few well-placed barcode
scanners, hooked to a simple running list in/out inventory (by job /
tech), even if as a flat file (Excel, *.csv, etc..) would help
tremendously. Even during the design phase (don't ask.) :)

In short: Can one of you recommend a very basic (bare-bones) inventory
program?
Windows based is preferred, and I can dedicate a machine to it.
Thanks!!!


Take a look at Apache OFBiz ( https://ofbiz.apache.org )
Two projects I have worked on have used it. One built
a rather complex app on top of OFBiz. We used hand
scanners to track boxes going out the door. It might
be too much for what you want to do but you dont need to
use all the modules.

There are also many people that do OFBiz consulting and
customization work. If you think you might want to go
this route let me know. I know of a person that has
written a OFBiz book and does training/consulting/customization.

Also take a look at https://www.odoo.com
It's kind of a pick and choose what modules you need.

--
Chisolm
Republic of Texas

Waussie
Guest

Mon Feb 11, 2019 7:45 am   



On 11-Feb-19 9:40 AM, mpm wrote:
Quote:
Anyone know of an inventory program for:

6,000 discrete parts in inventory (Maybe 50%-60% routinely used in jobs.)

I just want to track (via barcode scan) in/out, by tech & job - and maybe compare that to the job BOM for variance.

I don't really need to go much further than that - i.e., no interfacing with NetSuite Accounting, ordering, stock levels, loading dock, RMA's, etc... The company doesn't want to spring for the full-blown inventory package in NetSuite because A) it's expensive, and B) is probably too complicated for our needs anyway. (That's another long story....)

A lot of what we build can be considered "custom one-offs", and I just need to generate a BOM quickly, pretty much at the same time we do the initial design. Each build is similar to the last, but "different enough" for it to be a real pain in the ass.

I have this (maybe not so) crazy idea that a few well-placed barcode scanners, hooked to a simple running list in/out inventory (by job / tech), even if as a flat file (Excel, *.csv, etc..) would help tremendously. Even during the design phase (don't ask.) :)

In short: Can one of you recommend a very basic (bare-bones) inventory program?
Windows based is preferred, and I can dedicate a machine to it. Thanks!!!




Visit the eevblog.com forum.


There have been lots of very lengthy threads on this matter and lots of
options.

elektroda.net NewsGroups Forum Index - Electronics Design - Simple shop-floor inventory program

Ask a question - edaboard.com

Arabic version Bulgarian version Catalan version Czech version Danish version German version Greek version English version Spanish version Finnish version French version Hindi version Croatian version Indonesian version Italian version Hebrew version Japanese version Korean version Lithuanian version Latvian version Dutch version Norwegian version Polish version Portuguese version Romanian version Russian version Slovak version Slovenian version Serbian version Swedish version Tagalog version Ukrainian version Vietnamese version Chinese version Turkish version
EDAboard.com map