If you are looking for LAMP (PHP /MySQL or PostgreSQL) Accounting and ERP solutions, I hope that these links will be very helpfull to you (as they are for me).
- A list of Open Source packages: http://www.pbooks.org/blog/open-source-accounting/
- Good comparasion page, but lacking a lot of information for smaller finance projects on Wikipedia
- Another, older, list of packages: http://www.jimohalloran.com/2004/04/22/open-source-accounting-apps/
- Another list, with favoring PBooks.
- One good demystifying article from Dubai, about accounting.
- Quite a good informational page.
First, I would like to specify the packages that are worth considering, and that have demo available to test.
PBooks
PBooks is an active project with very clean and usefull interface. Still, it’s too much accounting and less business oriented.
Others
- PHP Invoice
It’s commercial package. Simple PHP Invoicing. Some extra features, but nothing irresistible. Solid interface.
- Wheremymoneygo
Its very simple Excell-like personal money tracking app. It looks not maintained from October 2006.
- XDB Money
Personal expense and money tracking, but it has scheduled transactions with good graphing. No demo, and last update in 2004.
- phpRechnung
Easy accounting with Croatian language (author). Nice and logical interface. Even if it’s not killer-app, this could be a good resource of understanding the English and German accounting phrases. Last release in 2006. It has only Income, not Payables. As it said in a name: Invoicing. Demo Available.
To be reviewed
- ValueERP, very interesting (used to be called Project Dot ERP)
- XRMS CRM, still to review
Dead or really basic projects
- The Address Book Reloaded, This is really not an CRM but I included it here for unknown reason
- Leopard CRM, the old open source version is really bad, and the new one is commercial
- ERPel, extremly basic. No purchasing at all
- ESM, really not very advanced, to be polite
- DeciGen, dead and abandoned
- Forth Valley CRM, really basic, dead site
- Pegasus CRM, dead
- EdgeERP (Business Accounting ERP) is really an WebERP. Really no time to analyse differences
- th-ERP is the same as some that I reviewed. Forgot wich one
This is a open-source of a commercial package called OpenMFG. The business logic is at the backend (PostgreSQL) and front-end is in GTK. I quote: “The xTuple Applications make heavy use of Postgres embedded procedural language, called PL/PGSQL. Whenever any kind of transaction is taking place in the system – a financial account being credited or debited, a piece of inventory being moved, or an order being taken – that is happening in a Postgres stored procedure, trigger, or function. Among the benefits of this approach is that it is relatively easy for other client software besides the OpenMFG or PostBooks graphical client to access business functionality.”
xTuple PostBooks does not have any kind of recurring payments or recurring billing.
Pbooks – No inventory and no plans for it, because it is strictly accounting package. Very strange but advanced backend. Problems installing it on Windows (WAMP) system – probably due the lack of symbolic links.
Phreebooks is an original piece of code , unlike so many other ERP applications that are copies of compier-adempier-openbravo… etc etc or teh other copy “forked” application open ERP. this is ORIGINAL work , the ajax scripting makes it load pages fast , teh basic functionality is acceptable from most small business’s . we code is easy to navigate and easy to expand on.
PhreeBooks Accounting – I really do love this piece software.
Phreebooks – still to do (and what weberp for example has): Break out of taxes by item (VAT problem). Ability to handle mutiple currencies simultaneously. Multiple branches.
Of all the ERP packages that are using MySQL, only two of them are using relations (PBooks & WebERP). This fact convinced that they have the best database schema (besides the fact that these two have a very small number of tables, for their functionality).
And FrontAccounting, Nola, and phreebooks (very nice db schema)
Even ValueERP uses InnoDB, but it looks really oldie. And vTiger (CRM, not ERP). And a good lik is: http://www.rdlt.com/why-vtiger-sucks.html
Moved to NatWest when undertaking a huge expansion of our small company 6 years ago (from Barclays as they were not helpful with our plans). I don’t know why I’ve stuck with them for 6 years, the personal business manager is useless, their customer relations are non existant, their attention to our needs is zero, no calls back, no help whatsover. Don’t waste your time with NatWest. They are hopeless and I’m now going to look elsewhere.
That was a single of essentially the most beneficial posts I’ve seen in a extended prolonged time. A great appreciated, I’m doubtless have to hold around right here far extra.