Frequently Asked Questions - 1.2
- 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?
- Where can I buy consulting and services?
- Errors in apache error.log - missing "math lib's"
- How to add a barcode for a part?
- Does LedgerSMB support my country's laws?
- Is LedgersSMB free software?
- Can VAT be automatically be split off into the required VAT accounts?
- Why is Column DBpasswd in users_conf table is not encrypted?
- How do I get admin.pl to work? (./Build test errors)
- What is this software similar to? Is it similar to Sage ERP?
- 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.
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
Math::BigInt: couldn't load specified math lib(s), fallback to Math::BigInt::FastCalc
Full error message:
[Thu Nov 10 22:53:58 2011] [error] [client 127.0.0.1] Math::BigInt: couldn't load specified math lib(s), fallback to Math::BigInt::FastCalc at /usr/local/share/perl/5.10.1/LedgerSMB/Form.pm line 61, referer: http://localhost/ledgersmb/menu.pl?login=username&menu=1&id=103&open=:
What should you do with this? Nothing or install math libs
ehu: you can run without it, just slower.
ehu: but you can install it and rid yourself of the error reported.
Install Math:BigInt:GMP to get rid of the message.
apt-get install libmath-bigint-gmp-perl
Ubuntu 10.4 LTS:
sudo apt-get install libmath-bigint-gmp-perl
RPM (Centos, Redhat...)
perl-Math-BigInt-GMP is available from the rpmforge repository - http://repoforge.org/
haso: The setup script do not check for it. ... Should it ?
ehu: well, since you can run without, I don't think so.
ehu: do you?
haso: It could be an informed option.
ehu: well, that's indeed an idea.
ehu: it's in the install file for debian and RH, I think.
Sql ledger has the option to add a barcode to a part.
In 1.4, you will be able to add a barcode per make/model record.
How are barcodes added when using LedgerSMB?
Sort term solution:
It's not optimal for a UPC management but it solves the immediate problem:
Add a space separated list with the barcodes to the partnumber field
The partnumber is the "Number" filed on the same line as "Description" in the "Add Part" page.
And yes, "space separated list" works in the POS interface. (If you scan one of the codes in the space separated list )
Here's how the partnumber and description fields work
It searches for any substring match for the entry.
If there is only one match it populates and moves on
If there are no matches it asks you if you want to create one
If there are multiple matches it gives you a list to choose from
same on the invoice screens
Long term solution:
- add a UPC field to the makemodel table.
Question from: Tau (2009)
We don't know enough about the ideosyncracies with your laws to evaluate that. But quite frankly Free Software sometimes poses an issue with local regulation. If you go with LedgerSMB, I'd recommend working with us to detail any shortcomings and get those resolved.
You can help us to make a list over "X country" laws and LedgerSMB shortcomings according your countrys law.
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.
Versions affected: LedgerSMB 1.2.x
The decision was made because there is no way to hide this information from the web server, since it needs to log into the database. It is better not to have a false sense of security. SQL-Ledger obfuscates this information but does not truly encrypt it.
Anyway, this problem is going away because 1.3 changes the way db passwords are handled.
[originally submitted by fling]
(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
I am currently building an online travel suite for a client of mine who is interested to integrate with a full accounts package.
Is this software similiar to Sage ? Q from: Justin Fenech
Chris Travers: Yes, it is similar to Sage. We don't support payroll yet, but working on it.
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.