Web-based Accounting on a Linux Desktop?

March 7, 2002, 12:00 AM —  ITworld — 

The lack of financial applications comprises a major complaint about
using Linux on the desktop. SQL-Ledger (http://www.sql-ledger.org), a
Web-based multi-user double-entry accounting system, can help address
some of those concerns.

Supporting invoices, packing lists, balance sheets, sales orders, and
purchase orders, SQL-Ledger provides accounts receivable, accounts
payable, and general ledger reports. All of the forms and reports are
generated to HTML for display in a Web browser and you can customize
the templates to create any of these forms or reports.

The speed and the completeness of the package, which provides a lot of
support for businesses that sell physical products, is very impressive.
A manufactured part can be made up of assemblies and services, and each
assembly can be made up of other parts. When you sell a part made up of
the other parts and assemblies, SQL-Ledger automatically updates your
inventory and counts all of the proper items against the inventory.

SQL-Ledger comes with an impressive set of features, but it also shows
what you can do with a scripting language such as Perl, which was used
to program the entire package. The entire interface runs from a Web
browser, using HTML forms, meaning that users at remote sites could log
in and update data, depending on your security set up, of course. The
development team is also working on a Perl/Tk user interface that would
provide a native graphical user interface.

The requirements to run SQL-Ledger seem a bit steep, as you need a
database on the back end. You can get a number of free databases for
Linux, though, including PostgreSQL, one of the databases SQL-Ledger
supports. Furthermore, if you are using an accounting system, you need
somewhere to store the data, and a database is a better choice than
most.

The installation instructions are still quick, though, with just a
small number of steps. But SQL-Ledger requires you to install
PostgreSQL, Perl 5, the Apache Web server, the Perl DBI module for
generic database access, the DBD-Pg module for PostgreSQL access, and
the SQL-Ledger package itself.

SQL-Ledger appears in 17 different languages and is quite extensive.
The list of features at http://www.sql-ledger.org/features.html is nice
for an accounting system. A demo runs at http://abacus.sql-
ledger.org/sql-ledger/login.pl. This demo can give you a good overview
of what is available in the package.

Read more about opinion in ITworld's Opinion section

» posted by ITworld staff

ITworld

Sign up for ITworld's Daily newsletter
Follow ITworld on Twitter @IT_world

I like it!
Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
peer-to-peer

Brian Proffitt
Microsoft/Novell: Breaking Down the Coupon Numbers

Esther Schindler
Drupal's Dries Buytaert on Building the Next Drupal

Tom Henderson
Top Ten General Operating Systems Rants

pasmith
PS3 motion controller delayed; goes up against Project Natal

sjvn
Neolithic Windows security hole alive and well in Windows 7

claird
Perl source code comparison makes for good reading

mikelgan
Cell phones don't create stress or interrupt much

Sandra Henry-Stocker
How to: The Unix Interview

 

Where Google Chrome security fails: the password
I heard mention that the Chrome OS will have some sort of encryption available a la bitlocker. If it's possible to encrypt personal data using another password or key, then it may have potential for very secure data.... And Ubuntu has an 'encrypt home directory' option, perhaps google should follow suit.
- Dann

Join the conversation here

The Daily Tip

The Daily TipQuick, practical advice for IT pros. Made fresh daily.

Hot tips:

Want to cash in on your IT savvy? Send your tip to tips@itworld.com. If we post it, we'll send you a $25 Amazon e-gift card.

Newsletters

Subscribe to ITWORLD TODAY and receive the latest IT news and analysis.

I would like to receive offers via email from ITworld partners.
By clicking submit you agree to the terms and conditions outlined in ITworld's privacy policy.
Marketplace