1. Download the sql-ledger github repository:

 git clone git://github.com/ledger123/ledger123.git

You will get a fully working sql-ledger installation which includes our enhancements. (The default 'master' branch)

2. From now onwards you can upgrade to our latest enhancements (which includes any latest releases from sql-ledger.com) with the following simple commmand:

git pull

3. Let us say you are not interested in our enhancements and just want to maintain and upgrade to the sql-ledger release from sql-ledger.com. Switch to the sql-ledger branch first time.

 git checkout -b sql-ledger origin/sql-ledger

4. From now onwards upgrading to official sql-ledger from sql-ledger.com is as easy as:

 git pull

(We keep our git repository updated with releases from sql-ledger.com)

5. Note that you can always switch back and forth between our enhanced sql-ledger and the official one by git checkout as:

 git checkout master # enhanced sql-ledger
 git checkout sql-ledger # official sql-ledger

6. You can switch back to any past sql-ledger version. First see a log of all commits and 40 chars hashes:

 git log --pretty=oneline

To revert to sql-ledger 2.8.17

 git checkout 7b15e9b

(First 7 characters of 40 chars commit string are enough)

You can also download tar.gz package instead of using git/github:

1. Visit http://github.com/ledger123/ledger123/.
2. Click 'Download Source' link in top right corner of the page as shown below.

The installation procedure for our enhanced sql-ledger is exactly the same as for the official one. There are two additional steps for existing datasets:

1. Database changes

Install custom table and column changes into your existing datasets. These are required by our enhancements

 psql -U postgres yourdataset < sql/Pg-custom_tables.sql

New datasets are automatically created with these table and column changes.

2. Warehouses

If you want to enable the warehouse module follow additional instructions at warehouses page.

It is always a good idea to enable this module even if you a single warehouse. You will have access to a number of new inventory reports.