1.0

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;

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.

Is LedgersSMB free software?

Yes, its Open source. The tools we use (Perl, PostsgreSQL, Apache ++) is also Open source.
Open source means that the source code of the software is available for free to everyone and you can modify the code and distribute it yourself. http://en.wikipedia.org/wiki/Open_source

Can VAT be automatically be split off into the required VAT accounts?

Short answer: Yes

LedgerSMB can tie product sales to a tax class so that VAT can automatically be split off into the required VAT accounts on a sale, and when cancelling an invoice, automatically perform the reverse bookings.

Each product can be 'attached' to an account and the associated % will be applied automatically.

How do I get admin.pl to work? (./Build test errors)

(admin.pl is replaced with setup.pl in LedgerSMB v. 1.3.x and upwards)

I am trying to install ledgerSMB on SuSE 11.1 and have followed the INSTALL and README documents to do so, and have also installed all dependencies.

When I get to the following instruction I get some errors.

$ ./Build test

The errors are seen in the last few lines of output following the instruction. I list them below. Note that prior to these last few lines are many lines starting with "BEGIN failed--compilation aborted ..."

Pages

Subscribe to 1.0