SQL-Ledger Accounting 2.6.19 review

SQL-Ledger Accounting project is a double entry accounting system

License: GPL (GNU General Public License) File size: 0K Developer: Dieter Simader

0

SQL-Ledger Accounting project is a double entry accounting system. Accounting data is stored in a SQL Server, for the display any text or GUI browser can be used. The entire system is linked through a chart of accounts. Each item in inventory is linked to income, expense, inventory and tax accounts. When items are sold and purchased the accounts are automatically updated.

With the assembly feature you can build manufactured goods from parts, services, labor units and assemblies. When the assembly is sold all the accounts linked to the individual parts, services, labor units and assemblies are updated and stock levels adjusted accordingly.

Invoices, Packing List, Income Statement, Balance Sheet, Sales, Work and Purchase Order, Statements, Receipts and Checks are generated from templates and can be changed to suit your needs. Templates are provided in html, tex and text format. The tex templates are processed with latex to produce postscript and PDF documents. Documents can be sent to a printer, file or fax, displayed with a PDF viewer or sent by email.

The translation mechanism for items and foreign language templates can be set for each customer/vendor so it is possible to generate invoices in a foreign language without knowledge of a foreign language. This translation facility can also be used to generate different forms for a group of customers/vendors.

DWS Systems Inc. is the developer of SQL-Ledger and provides ongoing support and customizations. SQL-Ledger is licensed under the GPL license, and is free software.
SQL-Ledger can be used on any UNIX, Mac OS X and Windows computer.

SQL-Ledger is written in Perl, developed on FreeBSD and Linux with Galeon, Konqueror, Netscape, Lynx, Links, W3M, Voyager, Explorer to render the display, Apache, thttpd, boa to communicate between the server and the browser, and PostgreSQL, Oracle, or DB2 to store accounting data.

Languages:

English
Arabic (Egypt)
Bahasa Indonesia
Brazilian Portuguese
Catalan
Chinese (Simplified)
Chinese (Traditional)
Czech
Danish
Dutch
Estonian
Finnish
French
German
Greek
Hungarian
Icelandic
Italian
Latvian
Lithuanian
Norwegian
Polish
Portuguese
Russian
Spanish
Swedish
Turkish
Ukrainian

Here are some key features of "SQL Ledger Accounting":
Accounts Receivable
Accounts Payable
General Ledger
Inventory Control
Billing / Invoicing
Time Cards
Recurring Invoices
POS
Check Printing
Purchase / Sales Orders
Customizable Taxes
Multi-user
Multi-company
Audit Control
Foreign Currency
Internationalization
Access Control
SQL server backend
Customizable Templates
Customers
Vendors
Assemblies (BOM, kits)
Chart of Accounts
Customizable Reports
Financial Statements
Administration Module
Backup to file/email
Application Interface
Use on Handheld

Requirements:
Web server (Apache, thttpd 2.22+, boa, AOL server, ....)
Perl 5+
SQL Server ( PostgreSQL 7.1+, Oracle 8+, DB2 7.2+ )
Database Independant Interface DBI
Database Driver for SQL server DBD ( DBD-Pg, DBD-Oracle, DBD-DB2 )
LaTeX (optional)

What's New in This Release:
fixed session handling bug fixed path traversal bug for terminal variable
fixed New Window tab session timeout removed formatting for invoice amount without decimals variable