About
 

E R P

     
 
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 computer.