Slashdot Mirror


Mid-Range Accounting Solutions for Linux?

markdavis asks: "For Linux to really succeed in business, it must first have support by vendors for the core financial applications: General Ledger, Accounts Payable, Accounts Receivable, and Payroll/HR. I am the IT Director for a long-term-care medical facility (400 employees) and found out a few weeks ago that the vendor that supplies our GL, AP, HR, and Payroll software is dropping support for Linux, in November (after using them for four years). They code in Progress and have decided to convert to a proprietary web GUI (IIS + IE6 + ActiveX) rather than use Progress + Apache + any browser. This means we either abandon Linux, or we are in the market for new accounting software modules (I bet you know which is my preferred choice). Does anyone use Linux server AND client (or web browser under Linux) software for financials in a medium or smaller/medium sized organization? If so, what do you use? Do you like it? What problems did you have in using it? What other advice can you give to someone trying to use Linux in this manner?" All businesses require the core accounting functions, mentioned above. Most companies also require 'industry specific' software which is customized for their industry. For example, in healthcare, AR (Accounts Receivable) is VERY different from all other industries. It is 2007, so hopefully the Linux choices for at least the core, non-industry specific financial software have improved since our last search, four years ago.

have been working on an RFI/RFP (Request for Information/Proposal) and identifying as many possible vendors as possible. I have searched through hundreds of vendors so far and identified 39 possibilities, but could always use more."

21 of 137 comments (clear)

  1. "For Linux to succeed..." by LDoggg_ · · Score: 3, Informative

    For Linux to really succeed in business

    Why do people so often preface Linux questions with things like that? "For Linux to really succeed in business" "For linux to succeed on the desktop".

    Linux is succeeding in many aspects. Success doesn't have to mean 90% of the market share.

    Anyway, that pet peeve aside. Take a look at compiere. Only drawback that I see is that it requires a non-free database to run on top of.

    --

    "If they have both, tell them we use Linux. And if they have that, tell them the computers are down." -Dave Chapelle
    1. Re:"For Linux to succeed..." by numbski · · Score: 4, Informative

      Precisely. My company does Windows -> Linux/Mac migrations. I just did a small 2-machine shop yesterday, moved both machines to Kubuntu. Client's happy, I'm happy, and he didn't pay Microsoft to upgrade to Vista. :) He needed to reload, didn't have his Windows installer discs, and well...

      The 90% market share isn't important. Get the small stuff first. Market share comes with time. I can tell you this much: anyone I've moved from Windows to mac has NOT wanted to go back. I have had an occassional user go from Linux to Mac, usually because product X needs commercial support, but is not available on Linux, but none have gone back to Windows. None.

      Linux has and is succeeding. So is FreeBSD. All of my servers, sans a couple of Mac OpenDirectory servers, run FreeBSD. I interoperate with several other ISP's around here, 2 run FreeBSD, another runs on Linux.

      Yup, it's failing. :P

      --

      Karma: Chameleon (mostly due to the fact that you come and go).

    2. Re:"For Linux to succeed..." by Johnny+Mnemonic · · Score: 3, Insightful

      ...but none have gone back to Windows. None.

      You assume that they'd call you back to do the reverse migration. Think that's a reasonable assumption?

      --

      --
      $tar -xvf .sig.tar
    3. Re:"For Linux to succeed..." by mr_mischief · · Score: 2, Interesting

      1% is an astounding success if your goal is 0.01%.

      Yes, it'd be nice to see more Linux on the desktop. I run two desktops at work -- one XP, one Linux. I run XP, OS X, and two Linux desktops at home. So for me personally, it's 50% of the machines I use on a regular basis.

      As for accounting specifically, that's one area that's less suited to OSS than other areas. The IRS doesn't look kindly on "well, there's a bug report filed". Your accounting needs to work 100% of the time. Accounting software could very well be Open Source, but it's a bit more liability than if the GIMP crashes. Lots of business owners won't feel comfortable with accounting software without some guarantees.

    4. Re:"For Linux to succeed..." by numbski · · Score: 2, Interesting

      Sure, and the answer is that I use FreeBSD and MacOS X Server on servers, and Linux and OSX on workstations.

      FreeBSD is typically advanced enough as to be confusing to an end user for a Desktop system. Kubuntu Linux is the Desktop OS of choice for us on PC hardware. When we need to use Linux on a server, we use Gentoo. When putting a server at a customer site, we lobby hard for an OSX Server, if not, then it winds up being FreeBSD, but customers tend to pale when they realize that they get black screen and white text, since we don't install X11 usually.

      Just a matter of taste really. I have no problem installing FreeBSD on someone's Desktop, but Kubuntu is quick, simple, and done well.

      --

      Karma: Chameleon (mostly due to the fact that you come and go).

  2. Oracle by stoolpigeon · · Score: 2, Informative

    Oracle offers a few packages that do all the things you mention - and will run on a variety of platforms. They have versions of at least two of their products that are tailored for small to medium business. So you could take a look at: http://www.oracle.com/applications/suites.html
     
    I've never worked with any of their small business stuff -- so I can't recommend it, just pointing it out.

    --
    It's hard to believe that's how Micronians are made. Why don't we see it right now by having you both kiss one another?
  3. Re:Bias? by daeg · · Score: 2, Funny

    Have you ever met accountants? They're crazy, man, do you really want them making software choices?

  4. LedgerSMB by 6031769 · · Score: 5, Informative

    I think just about everything is now covered in LedgerSMB or the project from which it was forked - SQL-Ledger. My business has been using these systems for the last four years and has found them to be stable, flexible and reliable.

    The back end runs on an Apache server with PostgreSQL underneath. The client side can be just about any browser platform (including Lynx). There are online demos where you can test most of the functionality before deploying in your own network.

    HTH.

    --
    Burns: We're building a casino!
    McAllister: Arrr. Give me 5 minutes.
    1. Re:LedgerSMB by itwerx · · Score: 2, Informative

      I think just about everything is now covered in LedgerSMB or the project from which it was forked - SQL-Ledger. My business has been using these systems for the last four years and has found them to be stable, flexible and reliable.

      We've been using SQL-Ledger for a couple of years now and while it does a great job, it has a few minor annoying bugs that have lasted through several development cycles and the long-awaited payroll module is still nowhere to be seen. What have your experiences with LedgerSMB been like?

  5. Re:Go with the leader by div_2n · · Score: 2, Informative

    SAP is right now aggressively marketing to mid-sized businesses with pricing quite competitive. I know this because I've taken a few sales calls from them.

  6. Re:Bias? by RESPAWN · · Score: 2, Insightful

    The problem is that accounting runs the risk of picking the cheapest package out there, not necessarily the best accounting package. While one option may be cheaper in the short order, it may run you more money in the long term from unforseen costs due to inferior software support or each revision of the software requiring a hardware upgrade, etc. I'm sure that many of us in IT have run in to situations where we've been forced to make less than desireable choices due to accounting constraints. Not to mention, he's in healthcare where, unless an executive makes it one of their pet projects to "modernize" the computers, IT generally gets the shaft as far as funding is concerned. At least, that was my experience in my 4 years of performing healthcare IT. Some of you may have worked in poorly funded environments, but I'll bet not many of you have replaced dumb terminals with Windows 95 machines... in 2004.

    Accounting does deserve some input on the features that they require and the overall usability, and in the end, the CFO will still be the one to sign the purchase order, but when you're talking a client/server package that needs to be compatible with their current environment, it's not a bad idea to have the director of IT involved in the decision.

    --

    If Murphy's Law can go wrong, it will.

  7. Re:Bias? by numbski · · Score: 3, Interesting

    "the Job"

    The best tool for "the Job" is "the Mac". :)

    j/k

    Seriously. Let's say the perfect tool for the job is a 31.25 kg ball-pien hammer. You go to the hardware store, and they have that 31.25 kg ball-pien hammer, but in order to use it, you have to purchase a special glove with which to hold that hammer. The glove costs...$300? Per hand? If you buy the glove, it comes in a box. When you open the box, and go to put on the glove it has a slip of paper that blocks you putting your hand in the glove. It reads:

    End User License Agreement
    By putting on this glove you agree to ....blah..blah...blah....first born son....blah....pentagram....blah blah blah blahallyourbase....blah, blah blah.

    On the shelf next to that glove is a 31 kg ball-pien hammer that can be used with the glove of your choice. You know, it might not be the PERFECT choice, or the BEST tool for the job, but sometimes it's not just the tool that you have to consider, but the work environment you create by choosing that tool.

    --

    Karma: Chameleon (mostly due to the fact that you come and go).

  8. TinyERP by dmayle · · Score: 2, Insightful

    I put my vote in for TinyERP.

    It's easy to use, there are great demo's online, and it does everything, multi-platform support, interfacing with eCommerce engines, invoicing, orders, crm, etc...

  9. Re:Bias? by JoeCommodore · · Score: 2, Interesting

    Well if he's picking tooling for the accounting dept does he periodically wander down to theatre and tell the surgeons what implements they can and cant use during surgery?

    Accountants are users not admins, they get trained on one thing and probably would prefer to still use it. One I know was a big fan of Peachtree and wanted to install it wherever she went even though in some situations it was inadequate for the size or not suited for th type of the business she was working for.

    But also you sould choose a system with sonone who knows the financial end of the business so they can tell you if it will work or not (or what problems you might face) before you roll it out.

    --
    "Enjoy what you're doing! If it becomes drudgery, you're doing it wrong!" - Jim Butterfield
  10. OpenBravo by ninevoltz · · Score: 3, Informative

    http://demo.openbravo.com/ OpenBravo is the only one I've seen that looks promising. Compiere was incredibly difficult to setup, I never actually succeeded. Try the demo link above. Don't even think about using Sage products. They are TERRIBLE! I speak from experience here. They were written using 20 year old "Business BASIC" language. They are not even truly client-server applications, they use file sharing and locking instead. Very unreliable. http://en.wikipedia.org/wiki/ProvideX

    --
    Death is life's great reward. R. Hoek
  11. Their job is to write the -specs- by coyote-san · · Score: 2, Insightful

    The job of the accounting department (like any end user) is to write the specification. "We need GL, A/P, A/R, payroll, federal and state taxes, etc.", with additional constraints as required. Must support million+ records. Must support multiple concurrent users. All of the fun domain stuff.

    And that's it. If they say "we need package XYZ", they're as off-base as a technical person saying that they must us the Simpson-Barr deprecation schedule for domestic exotic livestock.

    The tech people must consult with the accounting department, of course, since both groups need to keep training and maintenance costs in mind, but the final word has to be the CIO/IT department since they understand the cost of integrating the application into their existing shop. The cost of the software itself is usually trivial compare to the human costs and there could be a 100% markup on one package over a nearly identical one if one requires staff obtain and manage hardware outside of their usual expertise.

    --
    For every complex problem there is an answer that is clear, simple, and wrong. -- H L Mencken
  12. Choice is clear: dump Linux. by xxxJonBoyxxx · · Score: 2, Insightful

    They code in Progress and have decided to convert to a proprietary web GUI (IIS + IE6 + ActiveX) rather than use Progress + Apache + any browser. This means we either abandon Linux, or we are in the market for new accounting software modules (I bet you know which is my preferred choice).


    Looks pretty black and white to me.

    A) Switch OSs. This makes the users and the company happy and saves the company thousands of dollars compared to...

    B) Switch Applications. This makes one whiny IT guy happy and will cost the company thousands of dollars in lost time and effort making the conversion and retraining.

    Looks like "dump Linux" is the smart choice here.
  13. Re:Bias? by extremescholar · · Score: 2, Insightful

    As an an accountant (a CPA even) with both an MBA and a MS in CS, I agree. Accountants are rabid. Don't focus on the fact that it runs on Linux. They don't (and shouldn't) care. I don't care if it runs on two caterpillars and a walnut. Tell them about features and security, heavy on the security. Physical access to servers and logical access to the underlying data. No touchy. Show them pictures of the screens, set them in front of it. How do I do a journal entry? Can I get a trial balance? Will it export to Excel and Access? Give them an honest choice on features. Then the IT dept has to agree that its supportable. Team effort here please, its a joint decision.

    --
    Using the Freedom of Speech while I still have it.
  14. Fanatics again by DerekLyons · · Score: 2, Insightful

    I am the IT Director for a long-term-care medical facility (400 employees) and found out a few weeks ago that the vendor that supplies our GL, AP, HR, and Payroll software is dropping support for Linux, in November (after using them for four years). They code in Progress and have decided to convert to a proprietary web GUI (IIS + IE6 + ActiveX) rather than use Progress + Apache + any browser. This means we either abandon Linux, or we are in the market for new accounting software modules (I bet you know which is my preferred choice).

     
    If you were actually doing your job - your preferred solution would be that which was better for your employer. Instead, what's clear, is you place your own religious beliefs ahead of any other consideration.
  15. Hey, let's make extra work! by rueger · · Score: 2, Insightful

    You have an existing accounting system that works, and the only thing that would change is that they wish to use Windows instead of Linux as an OS?

    And you're suggesting moving the entire accounting system into a new software package just so you can keep it in Linux?

    I'm betting you haven't discussed this with your boss, or with anyone who has ever moved accounting systems between packages.

    Keep what works and don't complicate people's lives. Instead going on wild goose chases, take a couple of days and learn the basics of administering the new Vista or XP box.

  16. Re:Bias? by OSXCPA2 · · Score: 2, Insightful

    As a (former) accountant, auditor and now implementation consultant, I agree except: accounting almost *never* gets asked about functionality. The 'do-ers' in accounting know the best way a process works. The managers, who usually come from public accounting (Big 4 or regional) almost NEVER have any actual accounting experience - in terms of doing accounting. They were auditors, which requires no actual accounting ability. Hence, conversations like this, "You're net income is overstated, because you mis-stated depreciation expense for last quarter. Fix it.", "OK, how? What is the journal entry?", "I'm an auditor, not a bookkeeper... you figure it out..." I kid you not.

    Clerks can't pass the CPA exam, because they lack a theoretical background ("Discuss FASB141 impact on long-term assets..."). Managers can't pass Practical Accounting 101 - 'How to keep good books' because they never *worked* as an accountant, yet they became decision makers.

    In my experience, a senior-level accounting manager (controller level or above) gets sold on a system by a consultancy - they look at price or sex appeal, but NEVER take a few staff accountants and have them test out the system before purchase. What? Get some high-school educated clerk who has done the same job for 15 years test this complicated product? What do they know? They wear reindeer sweaters to the Christmas party fer chrissakes!

    Yah, they only know exactly how the job is done, what should happen, and usually what should work better, but since no one cares to ask their opinion, and they are routinely reminded they are not considered 'the best and the brightest' in the office, because they get paid way less than a freshie straight from University, management never finds out what would actually work.

    I went into consulting because I decided, after 4 companies, each worse than the last, that if I had to deal with this kind of idiocy, I was damn well gonna be on the 'getting paid' side of it. That, and I get to talk to Ms. Reindeer sweater and help her out during the implementation and setup where her manager could care less. Kinda nice, actually.

    Back OT, don't blame accounting for bad IT decisions - they're either marketing victims, too stupid, or not asked for their input. Blame senior management and their love of free golf outings. /rant