[CALUG] FOSS for inventory management

[Craig Younkins]

>
> "Are you tracking computer equipment on a network or widgets?"
>

I'm tracking widgets that I'm selling. Ideally, there would be a form for
new inventory, a form for when items are sold, etc. Invoice creation and the
like would be nice, but is probably overkill. Being able to attach product
images is a pretty high priority, and the fieldset must be configurable to
allow for shipment tracking numbers and widget-specific info.

I took a look at tracmor. It looked ok, but not configurable enough for my
needs. I couldn't figure out how to modify the inventory fieldset to include
such widget-specific information or include a picture. It's entirely
possible it's there, just hidden. Shipping courier integration with tracking
numbers is nice though.

"What about the OOO database app?"


So I didn't actually know that OOo had a database application! I checked it
out, but like most of the OOo suite, it is not very user friendly. I'm
somewhat familiar with relational database design, so I was able to get my
custom fields in there and all, but setting up the forms was a real pain. I
wanted to have a list of possible colors in a database, and have a one to
many relationship from widgets to colors. That is, a widget can have
multiple colors. This was absolutely aggravating to figure out, hardly
intuitive, and I ended up wasting ~3 hours on it yesterday, finally getting
that part to work. So OOo base is very powerful, but seems so hard to use.

Will check out Adempiere today.

Thanks for all the suggestions!

--

Craig Younkins
Mobile: (301) 520-0463
Website/Blog <http://cyounkins.blogspot.com/>


On Mon, Sep 28, 2009 at 2:49 PM, <mlb at imparisystems.com> wrote:

> Are you tracking computer equipment on a network or widgets?  There's
> Tracmor - http://www.tracmor.com o you could go into the ERP solutions
> that
> handle inventory like OpenBravo, Compiere or Adempiere.
>
> On Mon, 28 Sep 2009 14:09:11 -0400, Craig Younkins <cyounkins at gmail.com>
> wrote:
> > Hey all,
> >
> > I'm starting up a small business, and was wondering if anyone knew of any
> > good FOSS solutions for inventory management? I'm having a hard time
> > finding
> > any. At first I thought a spreadsheet would work well enough, but I think
> a
> > database is really necessary. Filemaker Pro comes to mind, but it's $300.
> >
> > Thanks!
> >
> > --
> >
> > Craig Younkins
> > Website/Blog <http://cyounkins.blogspot.com/>
>
> --
> Ubuntu-us-md mailing list
> Ubuntu-us-md at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-md
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.unknownlamer.org/pipermail/calug/attachments/20090929/27a271bf/attachment.htm