SQL-Ledger® ERP is a double entry accounting/ERP system. Accounting data is stored
in a SQL database 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.
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 database 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. Plus, if more control is required it is easy to add
additional functions to the SQL database server.
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 real time 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 can be accessed remotely so people can be in different parts of a city, country or across the world.
SQL-Ledger is platform independant and runs on any *NIX, Mac or Windows