Frequently Asked Questions - 1.1
- Which versions do you support?
- What is Perl?
- I want to install LedgerSMB. Where do I start?
- How to clone database with no financial transactions?
- Is LedgersSMB free software?
- Can VAT be automatically be split off into the required VAT accounts?
- How do I get admin.pl to work? (./Build test errors)
- What are the IRC guidelines
- What is the community code of conduct?
- Does ledgersmb support SSL connection ?
- How do I get LaTeX on Ubuntu? I am trying to print to PDF's and it's not working.
- How do I account for Depreciation in LedgerSMB?
- I'm not an accountant, how do I learn how to keep my books?
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.
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.
The Bernard Chan Perl Tutorial
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.
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
GNU GENERAL PUBLIC LICENSE Version 2
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.
(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 ..."
Also note the last line "Failed 6/6 test programs. 58/76 subtests failed." Clearly something is wrong here.
BEGIN failed--compilation aborted at LedgerSMB/Sysconfig.pm line 8.
Compilation failed in require at LedgerSMB/Form.pm line 37.
BEGIN failed--compilation aborted at LedgerSMB/Form.pm line 37.
Compilation failed in require at t/99-versioning.t line 8.
BEGIN failed--compilation aborted at t/99-versioning.t line 8.
# Looks like your test died before it could output anything.
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
Failed Test Stat Wstat Total Fail List of Failed
t/01-load.t 12 3072 30 12 1-3 5 11-12 14 16 20 26-27 29
t/02-number-handling.t 255 65280 ?? ?? ??
t/03-date-handling.t 255 65280 ?? ?? ??
t/10-form.t 255 65280 ?? ?? ??
t/12-menu.t 255 65280 37 74 1-37
t/99-versioning.t 255 65280 9 18 1-9
Failed 6/6 test scripts. 58/76 subtests failed.
Files=6, Tests=76, 1 wallclock secs ( 0.93 cusr + 0.12 csys = 1.05 CPU)
Failed 6/6 test programs. 58/76 subtests failed.
After restarting both postgresql and apache, I tried to go to http://localhost/ledgersmb/admin.pl and received the following error on Firefox:
The server encountered an internal error and was unable to complete your request.
Premature end of script headers: admin.pl
If you think this is a server error, please contact the webmaster.
Mon Nov 2 08:59:41 2009
PROBLEM SOLVED ==> See below for the solution to this installation problem.
The problem was solved with the help of irc.freenode #ledgersmb. Here is how:
The error message says, "BEGIN failed--compilation aborted at LedgerSMB/Sysconfig.pm line 8." Line 8 in LedgerSMB/Sysconfig.pm is "use Config::Std;" This suggests that there was something wrong with Config::Std. Either it was not installed or there was some problems with its installation.
So, I tried reinstalling Config::Std and I received error messages suggesting problems with dependencies that were not reported when I ran "perl Build.PL"
http://search.cpan.org/ allows you to look up modules, such as Config::Std. Once found, there is a "dependencies" link, which lists dependencies, each of which have further dependencies, which have dependencies... . Well, you get the idea. Be patient and follow through noting all the dependency modules and dependent on dependent modules. Download and install each of these. I started installing those with least dependencies themselves.
I then reran "perl Build.PL" and "./Build test" and then restarted Apache and PostgreSQL. Voila! When I went to http://localhost/ledgersmb/admin.pl, I received the login page with no error!!
Written by: Joe
Q: How could I set it up ledgersmb to support SSL connection?
SSL support on Apache is handled by configuring Apache. For having LedgerSMB connect to PostgreSQL using SSL, you can set the PGSSLMODE environment variable to 'require' in the ledgersmb.conf. Note that by default, LedgerSMB will try to connect to PostgreSQL via SSL and fall back to unsecured connections if this is not available.
We highly recommend using SSL for any access to LedgerSMB over the network.
Make sure you have TexLive installed. Older TeTeX was recommended but according to Ubuntu repositories, TexLive is the new package to install.
You can install this with the following command:
apt-get install texlive-latex-extra
NOTE: LedgerSMB has a Fixed assets module as of 1.3. The FAQ below is out-dated.
LedgerSMB does not have a built-in assett tracking / depreciation feature. Depreciation can be managed manually using General Ledger Transactions. You should probably confirm this with your accountant, but the basic procedure (kindly suggested by Tony Fraser) is, assuming a computer asset over 5 years:
Set up 3 accounts:
- An asset account such as "Computers"
- An asset account such as "Accumulated Amortization, Computers" that is normally a negative balance therefor it is a contra account
- An expense account such as "Computer Depreciation"
Upon purchasing a depreciable asset (in this case, a computer):
|On purchasing the computer|
|End of Year 1|
|Computer Depreciation||400.00||(40% of $1000)|
|Accumulated Amortization, Computers||400.00|
|End of Year 2|
|Computer Depreciation||240.00||(40% of $600)|
|Accumulated Amortization, Computers||240.00|
|End of Year 3|
|Computer Depreciation||144.00||(40% of $360)|
|Accumulated Amortization, Computers||144.00|
|Bank Account||75.00||(sale of computer)|
|Accumulated Amortization, Computers||784.00||(reversing entry)|
|Computer Depreciation||141.00||(residual value)|
Quite a few users find some of the terminology and accounting processes a little confusing at first. Some of the more popular small business accounting packages tend to hide these aspects of book-keeping from users for simplicity, so with the current user interface there is often some new ideas to grasp.
First step is the manual - the LedgerSMB manual is free and highly recommended reading.
If you would like some background on general accounting practices, there is an (unassociated) tutorial So, you want to learn Bookkeeping" which seems a good place to start.
Another excellent resource is second-hand book stores. Lots of MBA studends sell off their textbooks (presumably to finance their first business rather than pay of gambling debts) so second-hand bookstores will often have very good texts on accounting at bargain prices - these can make great reference books.
Finally it would be remiss not to recommend securing the services of an accountant to help you out with the finer points from time to time, should you feel the need or have a legal obligation to do so.