SQL Ledger
Encyclopedia
SQL-Ledger is an ERP
and double entry accounting system. Accounting data is stored in an SQL
Database Server and a standard web browser
can be used as its user interface
. The system uses the Perl
language with a database interface module for processing and PostgreSQL
for data storage.
Version 2.8 of this program was released under the GNU GPL 2.0 license.
Version 3.0 (closed source) is available either hosted, or with an Enterprise Support Contract.
It offers all of the standard features of SMB accounting software. Specific customization is available, as part of an enterprise support contract.
In late 2006, LedgerSMB
was created as a secure fork of SQL-Ledger. In early 2007, SQL-Ledger 2.8 was released under the SQL-Ledger Open Source License, a license which retroactively revokes all previous licenses that the covered code has been released under. That version also contained an "anti-forking" clause.
However, within a month, SQL-Ledger 2.8.1 was released, under the GNU GPL 2.0.
Enterprise resource planning
Enterprise resource planning systems integrate internal and external management information across an entire organization, embracing finance/accounting, manufacturing, sales and service, customer relationship management, etc. ERP systems automate this activity with an integrated software application...
and double entry accounting system. Accounting data is stored in an SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
Database Server and a standard web browser
Web browser
A web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...
can be used as its user interface
User interface
The user interface, in the industrial design field of human–machine interaction, is the space where interaction between humans and machines occurs. The goal of interaction between a human and a machine at the user interface is effective operation and control of the machine, and feedback from the...
. The system uses the Perl
Perl
Perl is a high-level, general-purpose, interpreted, dynamic programming language. Perl was originally developed by Larry Wall in 1987 as a general-purpose Unix scripting language to make report processing easier. Since then, it has undergone many changes and revisions and become widely popular...
language with a database interface module for processing and PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
for data storage.
Business model
DWS generates their revenue from selling support services. There are 5 support levels. For free, DWS provides the source code of the actual and all the previous versions, installation instructions, an FAQ collection and a user forum.Version 2.8 of this program was released under the GNU GPL 2.0 license.
Version 3.0 (closed source) is available either hosted, or with an Enterprise Support Contract.
Capabilities
Not only is the user interface multi-lingual, but it also offers the ability to print out statements, invoices, and the like in the language of the customer, even if the user does not know the language that the content is being printed out in.It offers all of the standard features of SMB accounting software. Specific customization is available, as part of an enterprise support contract.
Supported Languages
- English (US,GB)
- Arabic (EG)
- Indonesian
- Brazilian Portuguese
- Bulgarian
- Catalan
- Czech
- Danish
- Dutch (NL,BE)
- Estonian
- Finnish
- French (FR,QC)
- German (DE,CH)
- Greek
- Hungarian
- Icelandic
- Italian
- Japanese
- Latvian
- Lithuanian
- Norwegian Bokmål
- Polish
- Portuguese
- Russian
- Simplified Chinese
- Slovak
- Spanish (ES,EC,MX,PA,PY,SV,VE)
- Swedish
- Traditional Chinese
- Turkish
- Ukrainian
Licensing Issues
At its inception, SQL-Ledger used the GNU GPL 2.0 license. In 2005, Debian legal questioned whether or not the program belonged in Free or Non-Free, due to wording in the Terms and Conditions notice in the tarball.In late 2006, LedgerSMB
LedgerSMB
LedgerSMB is a free software double entry accounting system. Accounting data is stored in a SQL database server and a standard web browser can be used as its user interface. The system uses the Perl language and a Perl database interface module for processing, and PostgreSQL for data storage...
was created as a secure fork of SQL-Ledger. In early 2007, SQL-Ledger 2.8 was released under the SQL-Ledger Open Source License, a license which retroactively revokes all previous licenses that the covered code has been released under. That version also contained an "anti-forking" clause.
However, within a month, SQL-Ledger 2.8.1 was released, under the GNU GPL 2.0.
See also
- Ledger123, a enhanced version of sql-ledger by ledger123.com. This version is kept in sync with the official version.
- LedgerSMBLedgerSMBLedgerSMB is a free software double entry accounting system. Accounting data is stored in a SQL database server and a standard web browser can be used as its user interface. The system uses the Perl language and a Perl database interface module for processing, and PostgreSQL for data storage...
, a fork of SQL-Ledger - Comparison of accounting softwareComparison of accounting softwareThe following comparison of accounting software documents the various features and differences between different professional accounting software and personal finance packages.- Free and open source software :- Proprietary software :...