Inventory Tracking & Purchasing 63
nimr0d writes "I work for a company is subcontracted entirely to the county government. We write the software in-house. We have approximately 100 different locations we service, and don't expect that to change much, for better or for worse. Currently, we have an archaic, DOS-based, ICOBOL inventory system which tracks every piece of digital equipment we have, by a individually unique serial number, which is further tracked by a 'SystemID', which is a container for each individual workstation. We then have another container for the location where the equipment resides. We currently track around 30,000 individual parts. Problem is, our system is very bug-ridden and is constantly prone to 'losing' equipment. We desperately need a new system for PO's, RA's, and inventory/cost/depreciation tracking desperately. Does anyone have any advice?"
"We need to be able to ship an exact copy of the system we originally sold them, in the event of a failure. Some stations serve different functions, so the ability to classify system's and parts by type is also very helpful. We also currently have flags for leased or purchased equipment, and whether that part is covered under warranty or not.
We have looked into several companies that write custom software, but they are looking for upward of $35,000 for a SQL or Access application, which is insane for a company of our size (approximately 25 people) to buy into. There has to be something out there reasonably priced that can do what we need it to, we can't be the only ones."
you may not believe this (Score:1)
You could probably manage your inventory with:
I'm not being totally facetious. Usually the problem is overkill with managing information. If it's low transaction (sounds like yours is), with minimal dynamics, I've seen so many sledgehammer applications that are exactly what you describe: buggy, with data constantly "lost".
The tool
Re:you may not believe this (Score:3, Insightful)
Re:you may not believe this (Score:2)
Re:you may not believe this (Score:2)
Re:you may not believe this (Score:2)
Re:you may not believe this (Score:2)
Although I have to say that I haven't seen any change in these fundamental GNU CLI apps that hasn't been easily integrated into legacy code. How often do you think
Re:you may not believe this (Score:2)
Re:you may not believe this (Score:3, Informative)
Your "solution" MIGHT work for a mom-and-pop shop, but even then, it would be an error-prone, tricky-to-use, work-intensive hassle.
Re:you may not believe this (Score:5, Funny)
$ ncol -2 | join -l, | sed -e 's/^,/$/g'
duh.
Amortization of assets?
vi won't work, but vim includes a macro.
duh.
Automatically deal with purchase orders?
in emacs 'PO' mode, use ctrl-meta-R ctrl-meta-Q crtl-meta-C ctrl-meta-P ctrl-meta-ASDF ctrl-meta-option-alt-command-F5.
duh.
If you can't be bothered to learn how free software works, you have no business on slashdot.
Re:you may not believe this (Score:2)
Re:you may not believe this (Score:2)
Re:you may not believe this (Score:2)
Re:ERP. (Score:3, Insightful)
Re:Advice... (Score:2)
But using the same phrase twice in a sentence is fine?
Re:Advice... (Score:1)
Re:Advice... (Score:1)
Re:Advice... (Score:2)
Asset Tracker / Request Tracker (Score:3, Informative)
(fairly) simple in-house work. (Score:1)
Then you just n
OFBiz (Score:2)
this is what we use at work (Score:2)
What the...? (Score:3, Informative)
Don't take me for a troll, but I'd like to politely say that this seems like a rather inane question to make the front page of Slashdot. After all, anyone who has taken a programming class has been made to write software like this as a gentle, easy introduction to programming. Naturally, this is a real-world problem that is a bit larger and more complex than simple practice problems (ie larger data set, possible need for network code), but the fundamental idea is very similar.
The fact that the original system was written in COBOL and ran on DOS is a little telling. Back when my father used to work for Radioshack, he coded an inventory transaction system in BASIC in his spare time, and it was used by quite a few of their shops. His programming experience is quite modest, and he's always been more of a user than a coder.
My point being this: You can produce this software in-house a lot more effectively than by seeking an outside solution. Other people may have written programs (or systems of programs) that do what you want, but they aren't tailored specifically for your company. Also, I imagine that it would be a lot cheaper (sure, there is freeware, but somebody still has to work on it to make it fit).
Often not possible (Score:2)
Any IT project got to run at least a year (planned) go overtime by at least a year. Go at least 2 million over budget. Not deliver what is required. Require that whatever the software does it cannot do it well or at all for at least half a year after it has been rolled out.
What the above ain't law? Then why do the same IT companies that screw up time and time again get the contr
Bwahahaha! (Score:1, Insightful)
I have a CS degree from the University of Rochester. I worked on a bunch of mentally challenging, but low paying research / robotics projects after college. It was very 'hard' CS work, but I wanted a car, so I got a high paying job in business.
Now, I program a huge order entry system in COBOL.
The problem isn't that writing an order entry system is hard; there's nothing technically difficult abo
6 step plan. (Score:5, Insightful)
Produce DETAILED requirements of ALL the processes that need to be performed and all the reports that are required of the system.
Step 2.
Determine what each part of the application is worth to you. How much business would you lose without it, how much easier would your job be if the software did it for you.
Step 3.
Find any existing products free or otherwise.
Step 4.
Compare the features against your requirements.
Step 5.
Offer to pay someone to implement those feature you want, that the software doesn't have. Possibly the original vendor / author of the software or for free software you could offer the job to someone internally if they're up to it, or well anyone really.
Step 6.
Look at what you've now got, realise that it's totally unworkable, just a buggy if not more so as the last software you used, and pay the $35k to someone else who works in the industry and knows what they are doing to sort out the mess.
Here's some free advice. Getting software to work exactly the way you want can be quite complicated and costly. Don't underestimate it.
Advice? (Score:1)
Re:Advice? (Score:2)
I see this problem ALL the time (Score:1)
There is a general lack of good quality easy to use software out there and most of that runs over windows, which means you not only have to teach your staff how to use windows in addition to the software, you have to BUY windows and then deal with all the problems that windows brings with it.
My friend worked at a warehouse that had some horrible antiquated made for them text based system, where each keystroke
Re:I see this problem ALL the time (Score:2)
That said the browser based interface is good for everyone who needs to look at this but does not work on it all day. I would say the best solution is a browser interface with an additional traditional front-end. Personally I would put the front end to
Re:I see this problem ALL the time (Score:2)
In real life you have to adapt the machine to the people who are using it, not the opposite. Unless you really want SAP...
Sage FAS Fixed Asset Management (Score:3, Informative)
FAS Website [sagespecialized.com]
Have you considered a hosted solution? (Score:1)
ERP (Score:2, Informative)
Take a look at http://tinyerp.com/ [tinyerp.com] if does everything you want and a lot more, maybe you will find it interesting. Yes it is an almost full featured ERP+CRM but the stock modules are pretty complete. They have the multiwarehouse you need, the backtrack and some aditional niceties.
You can use too http://compiere.org/ [compiere.org], but from my experience with both packages, Compiere is heavier, harder to
Re:ERP (Score:2)
Compiere ERP (Score:2)
Re:Compiere ERP (Score:1)
http://www.compiere.org/support/install/installDa
Re:Compiere ERP (Score:2)
Easy... BS/1 meets the need.... (Score:1)
All you need is some delphi experience.
[Disclaimer: no, I am not affiliated with the company, just a satisfied
Sage Pro (Score:1)
We have 5 years experience with it and it has performed rock solid. It is now called sage pro, http://sageproerp.com/ [sageproerp.com]
Modules run from $1500-3000 cdn, but they always seem to offer new user specials quarterly, discounting their products 25-50%
The software should not set you back $
Rub eyes, drop jaw, repeat! (Score:2, Insightful)
1. Find and hire a young CS student
2. Pay them well for the summer
3. Discuss exactly what you want the software to do for you
4. Watch the kid build it in record time before your eyes
5. Give them a 1000$ bonus in the end and enjoy the app.
Seriously, this sort of app is the every programming student's first major project. Most "custom business solutions" are basically the exact same thing, but with a glorified int
Re:Rub eyes, drop jaw, repeat! (Score:1)
Re:Rub eyes, drop jaw, repeat! (Score:1)
It's now possible to write a nice generic business app with very little code because someone somewhere realized they're all the same. Pick up VB.Net or Delphi or if you like overpriced proprietary single-vendor lock-in, Powerbuilder. Hell, you can design your SQL tables and relationships, point the IDE to your database and it will build a skeleton app for you in a split-second, then you just tweak the interface and add a few dozen lines of logi
Hire one competent computer guy (Score:1)
Quasar (Score:2)
It has a few more features than you're looking for, but it does inventory tracking pretty well.
It's also GPL'ed.
GLPI (Score:1)
Hardcat (Score:2)
Why not re-write it? (Score:2)
Why not write the software in-house?
KangarooTrax (Score:1)
You may be more interested in the fact that it's built on MySQL and has an open architecture that can integrate into whatever applications your build in-house or drag around for historical reasons.
We're in beta testing right now, but
Have you looked at SQL Ledger? (Score:2)
It has inventory control.
big project (Score:1)
The software is only part (50%) of the cost. You need to migrate all the old data over (this is ALWAYS expensive). You need to train people in the new system. You need to host the software on the right hardware and
This is not to be blamed on ICOBOL (Score:1)
Re:This is not to be blamed on ICOBOL (Score:1)