I'm sitting here struggling with my home-made paperwork of inventory tracking, repair tracking, and show schedules, and what a mess. There's got to be a better way, so I've come up with an idea.
There have been several inquiries lately about inventory control, including mine and I've come up with something. I've talked to a couple of folks here and I've come to realize that things like HireTrack, RentalDesk, and a couple of others are fine, but waaay too much sugar for a dime for companies like ours. And trying to learn something like Access or FileMaker to the point of making what I'm looking for is out of the question. So I'd like to propose something to the programmer-oriented member or members of the community. How about we come up with an idea for a simple, no-frills inventory-control program and can be written by someone here and offered for sale to the community whose needs it would suit? I'm talking a program that consists of a database of all of the equipment along with the ability to group together items (such as an FX rack or amp rack). Then you would have the ability to "book" an item or groups of items under two categories, either "show" or "rental", with the booking showing up in the database as "unavailable". A repair-tracking setion would be helpful (what the gear is, what's wrong, who's repairing it, tracking numbers, status in the inventory, etc.)For our needs, it doesn't have to have the value or depreciation listed. A "preventative maintinence" schedule would be cool, but not necessary. It doesn't need accounting capabilities. Personel info would be cool, but not necessary, as would trucking. Client info and/or sales info wouldn't be necessary, either. This would NOT take the place of HireTrack or such programs, but for smalled companies just needing to track where the gear is going, it would be fine. I still haven't found anything commercially available that fits this wish list. Maybe it could be written in modules such as sales, rentals, shows, trucking, personel, but then it would get complicated and encroach on the larger programs.
If this sounds like a doable idea, let's toss some things around. If not, let it crash and burn, won't hurt my feelings.
Gotta run, but I'll get back to this and see what we think...or don't...
(edited for speedy typing, girlfriend rang the dinner bell!)