Ubuntu Installation Tutorial: LedgerSMB-1.3-SERIES

(Open source accounting/ERP application on Ubuntu Oneric Ocelot Ubuntu 11.10)


Update: mai 2012

Note that Template::Latex is included in Template::Plugin::Latex which is now in Debian as
libtemplate-plugin-latex-perl.  (It has migrated to Debian Testing ('wheezy') and Ubuntu)

Also for some of the files, need to update the links

OSX: Install LedgerSMB 1.3 on Apple OSX

Update 2012:
Installing LedgerSMB 1.3.21 on Mac OS X 10.6.8 (Snow Leopard) 2012-08-06
LedgerSMB 1.3.14

Please help us to make this a better guide. Post your comments on the mailinglist.

Migration from App X

App X could be Microsoft Money, QuickBooks, Sage, KMyMoney, Gnucash, Grisbi and others
Source: mail list: ledger.smb.user (Chris Travers and others)

With unknown programs you need to to find out:
1) How much data can you get out?
2) What database system does it use on the back-end?
3) If you cant export data, are there other means (i.e. custom ODBC
drivers, cvs export) that can access the info?

If you can get that information, you are about 50% of the way there.

1.3.14 released

The LedgerSMB core team is proud to announce LedgerSMB 1.3.14. This
release corrects the final outstanding missing feature from 1.3.x,
namely the ability to edit pricelists per customer or vendor. At
this point there are no known features from 1.2.x that are missing in

This release corrects a number of bugs including reconciliation
mappings not being set by default, the point of sale always using TCP
to communicate with the host for pole display purposes, unknown
databases incorrectly detected as SQL-Ledger, and more.

How do I migrate from SQL-Ledger?

A lot of people are wondering how to manage their migration to LedgerSMB from SQL-Ledger. While there is no one simple answer that will suit everyone's situation, there is some general advice.

First thing to know is - you are among friends. LedgerSMB is built on a community of people who want to see the software and it's users succeed. Information is freely shared, and as long as you are prepared to have a go at helping yourself, we are happy to jump right in and help you do that!

We now have a mailing list, whether you are actively working on migrating to LedgerSMB or even if you are staying with SQL-Ledger for now and want some friendly community support, join up the User List to get SQL-Ledger to LedgerSMB migration help

The best course of action depends on your situation:

How do I delete a company database ?

I had created a second database. To delete it, do I just drop the database from postgresql?

On a GNU-ish *nix platform use the script:
it'll remove the roles and the database.

Performance Issues w/Ledgersmb 1.3.x

By Steven Marshall

I found something very interesting. I created a test HTML page containing solely text called testpage.html. I dropped this file in two locations. One in the Apache root directory (/srv/www/htdocs/) and the other in the ledgersmb directory (/user/local/ledgersmb/). I changed ownership of the file to wwwrun:www. I then ran the following tests:

Test 1:
Results: Page loaded almost instantaneously.

Do I have to type in the full customer's name on the invoice screen? Didn't there used to be a drop-down list?


But I'm glad to be able to deny your conclusion above: the system will search on any partial match, both on the customer number or on the customer name. So, there's no need to spell them quite exactly.

Also, if you want the drop downs back, there's a setting in the System -> Defaults screen (third item below the currency settings input box; "Max per dropdown"). If you enter 99999 into that (assuming you don't have that many customers), you'll be presented the selection list you're used to.

FreeBSD Installation

Deploying LedgerSMB with nginx and Plack on FreeBSD by Mikkel Høgh

1.3.13 released, includes important fixes

LedgerSMB 1.3.13 has been released. The 1.3 branch brings real
security and significant scalability improvements to LedgerSMB, as
well as adding functions such as separation of duties.


Subscribe to LedgerSMB RSS