Linux Online - Application: SQL-Ledger

Application: SQL-Ledger

SQL-Ledger is a double entry accounting system written in perl. Accounting data is stored in a SQL Server. Any text or GUI browser can be used for the display. The entire system is linked through a chart of accounts. Each item in inventory is linked to income, expense, inventory accounts and tax accounts. When you purchase and sell goods and services the accounts are automatically updated. The assembly feature allows you to build manufactured goods from parts, services and assemblies. When you sell assemblies all the accounts linked to the individual parts, services and assemblies are updated and the inventory is adjusted for the items. Invoices, Packing List, Income Statement, Balance Sheet, Sales and Purchase Order are generated from templates and can be changed to suit your needs. Templates are provided in html and tex format. The tex templates can be processed with latex to produce postscript and PDF documents. Sales and Purchase orders are also a convenient way to create recurring invoices or to keep timesheets. Sales orders may be used in lieu of Quotations or work orders. Change the wording either internally or by adding an English to English translation and you have a new system. Foreign currency transactions are automatically converted and exchangerate differences, gains and losses, if any, posted to the appropriate accounts. AR, AP, GL reports can be customized and sorted to generate a great number of reports, aging reports show you what is outstanding at any given time, the tax report can be used to generate a list with taxable transaction for taxes collected and paid. The GL report can be used to produce sales and purchase journals or ledgers of any kind. You can also drill down into each account and view / edit transaction from the entire system. Language and data sources can be selected for each user. You can have a different language or a different set of books or use a different SQL server with one installation. Access to menu items can be disabled to allow users access to certain sections or functions only. Disabled menu items are not shown on screen. Access control is linked to the menu structure and if new items are added they will be automatically included as well. Audit control can be enabled for all transactions or up to a certain day. With audit control active, incorrect transactions must be reversed and posted anew. SQL-Ledger can be customized globally and per login with external perl code. Code plugs in without any modifications to the main core. The command line interface allows you to build and interface with other applications either in realtime or by batching transactions. This makes it possible to interface with off-line remote applications or use with a POS with a completely different storage scheme. SQL-Ledger is written in Perl, developed on FreeBSD, Linux with Netscape, Links, Lynx, Explorer, Galeon, Konqueror, Voyager (QNX), Apache for the display, and PostgreSQL, or Oracle to store accounting data. Supported languages Brazilian Portuguese Catalan Czech Danish Dutch English Estonian Finish French German Italian Norwegian Polish Portuguese Russian Simplified Chinese Spanish Traditional Chinese Turkish

Homepage	http://www.sql-ledger.org
Download	http://sql-ledger.org/source/
Author	Not Shown <dsimader_AT_sql-ledger_DOT_C.O.M>
Version	2.2.2
Licence	GNU
Source	Yes
Environment	Console
Status	Stable

We are currently updating this section of the site. Change submissions are temporarily disabled.

Click Here to go back to the index