Graabein asks:
"I'm part of an effort to startup a VoIP provider. We've decided to use Open Source Software wherever possible. Production is not a problem, we can handle the VoIP network itself, POTS termination, web sites, email systems, all the usual stuff. The business side of things is another matter entirely. We need to be able to handle Customer Relationship data, manage subscriptions, handle invoicing and accounts, have a web shop of sorts, online billing, credit card transactions, and more. Whatever system we use has to be able to handle national standards for accounting, or at least be possible to modify to do so. We've looked at Compiere, but our business types are not impressed. Neither am I, for that matter. Requiring an Oracle license is one thing (database independence is 'in development', but it has been for a long time, with no discernable progress), not working properly with Mozilla is another (you need IE to use it fully in HTML mode). What other options are there?"
"Our business types are full of suggestions for supposedly excellent and well suited systems, however they all have in common that they require Windows on the client. If we choose one of those systems our OSS policy is pretty much moot and OSS has been relegated to (some) servers in the computer room and that's about it. I don't mind running these business functions on a Windows server if that is the best system for the job, but having to run Windows on every client in order to access the data is simply not acceptable.
We want Linux and OpenOffice on every desktop. We want to be able to access customer data from a variety of clients, even including Windows. The same goes for Accounting data, HR data, QA data, you name it. Do we have to write our own system from scratch? I'm not sure that is very realistic."
Slashdot Mirror
http://www.sql-ledger.com
You might want to peek at OpenGroupware. My colleagues and I have skimmed though what was available and it seems to be the most impressive for at least the customer management side. Though the look of the web interface will not amaze your artist friends, it seems to work well. You can interoperate with Evolution, Mozilla Calendar and some other programs - even Outlook should you want to buy the driver.
I'd strongly suggest not to be impressed by eGroupWare's feature list and cute themes (I know WE've been fooled). Seems like these guys, though talented, are not really working towards stabilizing the tree, so you see frightening changelogs - like code rewrites between 1.0RC2 and 1.0RC3. They forked from phpGroupWare lately but I can't tell if it's a more serious project.
One of my friends is completely sold to the Horde Project so you might want to try it.
All of these will not solve all your issues but no application does and as these three above are open source, you can do the linking as you like.
Have you looked around on freshmeat.net? There are quite a few people providing some sort of business management package. A quick search for "billing invoicing" turned up the Trabas VoIP Billing package as the first hit. Probably a good place to start. I'm sure there is plenty of stuff that will do most of what you want. Is your company comfortable with doing some minor coding on an existing project to get exactly what you want? If so, there are a lot more options.
I think this is a common problem. I run a business myself, with two friends. We've just started, but we're looking into getting things like customer related software in order before doing anything serious about ourselves. I've worked voluntary with organisations and economy before, and I know things screw up if things are not kept track of.
I think your questions are hard to answer, and even though I have searched a lot for software (not online shopping/CC, we send invoice by mail since we're only doing business inside Norway) I have yet to find anything free and useful.
We've really considered doing it ourselves, making a simpe customer registration and management system with a web frontend. Using f.i. perl modules, you can create Excel documents with tabular data, and such. So that might be a thing to do. If you accept a tiny bit of manual work, that is. Of course, that tiny bit isn't that tiny after you've got hundred customers to bill.
But at least, I know that GnuCash has some functions regarding invoicing and customer registry, but I haven't really had the time to try it out. The rest of GnuCash is good, though, so there should be a hope. So far we can keep track of our economy, and if it works, GnuCash might do our customers as well, even generating invoices.
Good luck, and I hope this post will create some feedback for myself as well. Feel free to email me if you want to discuss, by the way.
For CRM, we use TUTOS.
For accounting, it's SQL-Ledger. Both the CRM and accounting apps are backed by PostgreSQL.
For office suites, OpenOffice.
Web browsing is Mozilla; e-mail is whatever our employees prefer (Mozilla, Kmail, Evolution, Pine, Mutt, whatever...)
We are completely MSFT-free and intend to stay that way.
It costs you a couple of bucks to buy Starbucks coffee for all your employees. In the grand scheme of your business, it is an insignificant cost.
It is also a business expense which makes it tax-deductible, so the actual cost is even lower than the price you pay up front for coffee.
Suck it up and join the rest of the business world.
i love trolls
Simple answer: what you are looking for does not (yet) exist.
There are a lot of fancy applications on the net, none of them any usefull for your purposes (and please prove me wrong, I'd though I had been pretty thorough)
Having looked at the same problem for my own small business I'd say that if your business is essential to you, you either start asking for quotations for companies that can deliver a solution to fits your purposes or find a stock application that does most of what you need. (and does it in a way that most members of staff understand it)
Look at the price, and see if its matches your needs and budget.
As you are setting up your own business, you should NOT be fooling around trying to recreate the wheel; you will need al your energy to focus on your business and hope that it doesn't go belly up.
One sure way of doing that is having a dozen incompatible systems hide all your major business information from you, your customers, and your staff.
That was my last purchase from Intuit. I have removed it from my system and it sits on a shelf.
Don't count on a "web interface" equalling "will run on any platform". I've lost count of the number of "web enabled" applications that only work in I.E. Some vendors seem to think the purpose of a web interface is so you don't have to install new software on your Windows PC (giving them the benefit of the doubt vs just plain laziness/poor qa), whereas it _should_ mean it's platform and browser independent.
Personally, if it will only run on I.E. in Windows (wine/xover office notwithstanding), what's the point - may as well run a Windows app.
If a company goes to the trouble of making a web interface, it ought to be done "right", so any web browser that follows http/html standards can run it. It's not _that_ hard to do.
Some net apps require Microsoft extensions or are written using proprietary IE calls and absolutely MUST be run on IE. And don't tell me changing the browser id string will make it work. That will eliminate the warning messages but not make things work. I am having to deal with this issue right at this moment.
It's not the first $780 he's worried about, but the the 2nd, 3rd, 4th, etc.
You mentioned that you needed to process credit cards. Check out my employer, TrustCommerce, which offers a completely open source credit card processing API for connecting to our payment gateway. It compiles on tons of platforms (including Linux), and we have versions for many programming languages: C, C++, PHP, Python, Ruby, Perl, ColdFusion, Lisp, etc. All code is GPL.
Your opinion comes from a demonstrably spurious source.
MySQL and ReiserFS are both made available under the terms of the GNU General Public License.
The GPL allows people to do absolutely whatever they want with software obtained under it, including using it to run their business in a commercial environment. The GPL does not allow one to distribute the product which was obtained through the GPL in a non-GPLed product, or to distribute products which contain GPLed products under a non-GPL license.
MySQL AB and Hans Reiser make their money by offering alternative commercial licenses which will allow you to distribute the work you derive from their work under a non-GPL license. This only means you have to pay them if you want to release software which links to the code they wrote
"Give away the stone, let the oceans take and transmutate this cold and faded anchor." - Maynard James Keenan
I am a consultant that started my own thing just about a year ago. I do a lot of day-to-day Windows stuff, but internally run SUSE on just about everything and my wife has a Powerbook.
We use Quickbooks 2003 for accounting. Works well, fairly easy to use for my non-accounting brain. What I did to accomplish this was to run a Windows 2000 Server basically as a terminal server to allow either one of us to use Quickbooks on our boxes. I had the firewall forwarded so my accountant could get into it as well. They key is not to use the box for anything else, no web browsing, no e-mail, no nothing. Keep it patched, toss on a copy of Symantec antivirus, install the free version of SFU and you can back it up over the network on yer linux box. Seems to be the best way to "Windows-enable" your linux network.
I also run Mozilla mail against SUSE OpenExchange Server with great success and happiness. OpenExchange has an excellent web interface to mail as well as document management (with revision control), knowledgebase, contacts with contact history type functionality, job and project tracking (admittedly difficult to use), and internal instant messaging. Can sync yer Palm to it as well, or toss on Outlook with IMAP if you really have to. It's quite an excellent product and the pricing is quite reasonable considering what it can do. Doesn't need huge system resources either. I run it on dual a PIII-866 with 256MB right now--512MB would be quite sufficient. (swaps a bit with 256)
OpenOffice.Org runs on the SUSE desktops and the PowerBook has genuine MS Office X. She gets into some complex Excel formulas and macros so decided to go MS on that one. I have NO problem recommending OpenOffice.Org to anyone doing office tasks. If you gotta have support, go StarOffice from Sun--just as good, only a few bucks.
I haven't really gotten into any of the PHPProjekt-type wares. Seem to be a lot of functionality, but not much of it done up really well, and much less of it useful in and office setting. That groupware "killer app" is still lurking out there somewhere, if it's not the SUSE product.
Linux on the desktop is definately do-able. I do it here. My wife's old PC with XP crashed a few months ago--bought her the PowerBook and never thought about the Windows box again. All of your major tasks can be done on linux. I have an IBM X31 laptop and SUSE Pro 9.0 support all my hardware, including wireless network card and even some funky IBM stuff. I'm sure RedHat would be fine as well, especially on desktop systems--your preference.
The community will get better with accounting-type programs. I think it will probably still be a few years until something surfaces. The Win 2000 as terminal server should suffice until then, and it's not too expensive.
Good luck in your efforts, let us all know how you end up!
-m
http://www.invisik.com
IMO, browser-based interfaces lack in the usability front. They are simply not rich enough.
They work fine on the web because they are a compromise: I give you a site with a rather dull interface , but you get to it without installing custom software AND ALSO you are presented with a familiar and simple user interface (click links, scroll pages, fill up form fields, submit info), so you can catch on quickly with my site, because it work quite similarly to other sites you have visited before (an important aspect that some flash-based and some overworked DHTML-based sites seem to overlook).
Of course, the software used internally in a business has both more demands and less limitations.
It has less limitations because you can install wathever software you want (you have tech support, and don't depend on the end user failing to install the latest plugin). You don't have severe bandwidth limitations. You can standarize on a single platform for your clients, and on a single screen resolution (or, if it is not single, at least can be a known and definite set). You don't need to engineer your application to be run in a restrictive security sandbox, so you can have full control of the devices attached to your computer. For instance, you can make the application print an invoice as part of a transaction, without explicit user intervention (no "print" dialog), automatically selecting certain parameters (paper size, margins, resolution), not allowing the user to mess with them. The application you build can also have a steeper learning curve, because you won't have casual users (potential customers that have to figure out how things work on their own, and that you'll loose if they get annoyed), but permanent users that are your employees and can be trained.
The user interface of business software has higher demands too. If you fill in an online purchase form twice a week, you can put up with a clumsy user interface. But if that is your job, and you process purchase orders from 9 to 5, you'll need something better than the average HTML form. For instance, when a customer tells their name over the phone, you type the first three letters and a list of those customers that meet the citeria is instantly displayed for an easier selection. Also, you might want your text to be spell checked as you type when fou fill a text area. If you have used both SQL-Ledger and GNU cash, or PhpMyAdmin and mysqlcc, or any web-mail and any mail program, or groups.google.com and any newsreader then you should know what I'm talking about: even the best engineered web application falls short to almost all rich GUI applications.
Of course, in the future web interfaces might evolve to become richer (XForms, for intance), but until then, selecting a web-based architecture for internal business use certainly can hurt productivity.
Having said all this, I must also point out that it depends on what you call "a Browser-based application". I have taken for granted that the original poster meant a HTML-based application as opposed to, say, an application consisting in a single page containing a java applet or ActiveX control.
What sort of needs does a big business have? Well, they all need to manage human resources. Most need to track items in their warehouses and perhaps training for their employees. The industrial sector will have many additional needs to track equipment, schedule resources, control work authorizations, and safely take equipment in and out of service. Running an enterprise call system also takes more than a PHP app.
There are dozens of other highly generic needs that I haven't mentioned, but all take extensive effort to set up, customize, and integrate into a business environment. And these things are *mission critical*: millions of dollars can ride on the availability of the software. Open source can eventually get here, but it will have to (first) be written, (second) creep up through small business, and (third) be vetted and pushed by consultants who can make money from long-standing service contracts.
I'm not trying to be pessimistic about open source, but there are many unmet needs here. Don't expect to run a serious business without proprietary software. In fact, be as objective as possible when evaluating software needs for your business... pretend that you have to defend every decision in front of someone who doesn't care about the distiction b/t free and non-free software. Someone who only thinks in terms of money, growth potiential, implementation schedules, and risk. If OSS can't stand its ground here (even with the price advantage), drop it. Don't jeporadize your business, and (if you're working for someone else) don't give your boss a bad taste of what OSS is all about.
Stallman--as much as I support the guy--completely misses the real world when he says that "any business based on proprietary software deserves to fail". Deserving or not, any medium or large business that is not based on proprietary software will fail.
I hope open source can one day address these needs, especially for small businesses and start-ups, but I'm not too worried even if it can't. If Linux becomes good enough in other aspects, these proprietary apps will be made to run on Linux too (and some of them already do). "Mostly" free is good enough for me.
-1, Too Many Layers Of Abstraction