Recent industry trends show that organizations. while cutting costs to counter the slowdown are also keen on exploring open source ERP packages and comparing them against their commercial counterparts. There are several open source ERP solutions available and many of them cater to requirements of various industry verticals. Indeed some ERP packages provide complete solution for a specific business process. SQL-Ledger is one such ERP solution that addr.esses complete accounting requirements for an organization.

It is is an open source accounts ERP available for free download. It uses Postgre SQL database to store accounting information. As it's written in Perl. it has an HTML interface that makes it accessible on any operating system. thus providing cross-platform usage. It covers all aspects of an organization's accounting needs. from point-of-sale entries to accounts receivables and payables. and for stock tracking. It has multi-user capability and is well suited for the needs of a small business organization.

Name:  Open Source ERP for Accounting.jpg
Views: 654
Size:  50.7 KB

SQL-Ledger has primarily been written for the Linux platform but can also be installed on Windows or Mac machines. You have a certain set of prerequisites to fulfill for Linux after which you can execute 'setup. pi' script to complete SQL-Ledger installation and also to update Apache web server's config file. To install it on Windows or Mac, some manual changes need to be done to the SQL-Ledger code and to Apache's configuration files. In this article we will show how SQL-Ledger can be installed.

Getting started
The downloaded SQL-Ledger is a zipped package of Perl files that constitute the interface and business logic of the whole accounting system of the ERP solution. but is devoid of any database or web server. For installing SQL-Ledger. we have to configure and install the web-server and the database first. Also. for process¬ing Perl scripts and code. we need to have the Perl runtime installed. And the database driver for Postgre SQL for Perl engine has to be configured before we start using SQL-Ledger. With this month's DVD we are providing the SQL-Ledger package with all essentials needed for its working.