1.2

Which versions do you support?

Active support

Version 1.3 and higher are under active development and are supported by the community.

End of life

LedgerSMB versions 1.0, 1.1 and 1.2 won't be maintained any further due to the fact that there are some known security issues which can't be fixed. If you're looking for help on how to use these versions, please try mailing the users mailing list. If you're looking someone to create bugfixes, please check with one of the parties providing commercial support.

IRC Support

For real-time help try IRC - you will usually find most of the core team hanging out at irc.freenode.net / #ledgersmb

There are people there who range from users to developers who are willing to help. We have agreed to adopt the Ubuntu code of conduct for our community. Please read it if you plan on joining us.

We also ask that you always use a paste site when pasting more than 2-3 lines. Paste sites include:

Mailing Lists - RSS and NNTP Feeds

The best way to get (free) help is to join one of the LedgerSMB mailing lists:

What is Perl?

Perl is a high-level, general-purpose, interpreted, dynamic programming language. Perl was originally developed by Larry Wall in 1987 [ http://en.wikipedia.org/wiki/Perl ]

Perl 5 is a highly capable, feature-rich programming language with over 24 years of development.
http://www.perl.org/

Learn Perl
http://www.perl.org/learn.html

Select all parts in orders

All parts in order, from '2012-04-21' and '2012-04-22':

select p.partnumber, count(*), sum(qty) from orderitems o join parts p on p.id = o.parts_id where trans_id in (select id from oe where not closed and transdate between '2012-04-21' and '2012-04-22') group by p.partnumber;

Riverbend Community Math Center - Dean Serenevy

We are a US not-for-profit (http://riverbendmath.org/) using SQL-Ledger and LedgerSMB since 2006 (I'm not sure exactly when we made the switch). We are a small organization: ~15 part-time employees; ~$150,000 annual revenues; 2 users of the ledger. We are still using 1.2.x because my trial transition to 1.3.x did not work out as smoothly as I had hoped. Thus, I have put the transition on hold until I can give it a few days attention. As an organization we believe in and use open source software almost entirely. 

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:

I want to install LedgerSMB. Where do I start?

Check the downloads page for a package for your operating system, or use the procedure below:

Download the file and untar it (tar -zxvf filename.tar.gz). Then read the INSTALL file and follow the instructions.

On Windows you can use 7Zip to untar the file.
 

 

How to clone database with no financial transactions?

Copy db :
In psql or your sql client:
CREATE DATABASE my_newdb WITH TEMPLATE my_old_db;

Note this will clone everything.
If you want to get rid of the transactions, you will need to delete everything in the acc_trans, ar, ap, and gl tables.

Also if goods and services are used, delete from invoice and inventory as well, and if wishing to clear out all orders, delete from
orderitems and oe.

Where can I buy consulting and services?

Is there a place where we could buy some consulting for LedgerSMB?
or a minimal setup according to our specs?

Take a look at http://ledgersmb.org/topic/commercial-support

Pages

Subscribe to 1.2