GL Import is our enhancement to sql-ledger. This allows you to import general ledger double entry transactions in debit/credit format into sql-ledger.
This is an important feature and you can import data from any legacy system which will allow you to export data in a similar way.
Script can be found here on our git repository.
Documentation can be found here:
> http://wiki.ledger123.com/index.php?n=User.ImportGeneralLedger
You can import payments with Sql-Ledger. We have updated our wiki with a step-by-step example, a sample csv file and some useful hints.
Find it here:
> http://wiki.ledger123.com/index.php?n=User.ImportPayments
Sql-Ledger allows you to import sale invoices and payments from CSV files. In the next few weeks we will be exploring these built-in features.
To see how import sales invoices feature works visit the following page on our wiki.
> http://wiki.ledger123.com/index.php?n=User.ImportSaleInvoices
We will also build our own import scripts which will allow you to import gl transactions, customers, vendors and parts. As always these enhancements will be available through our GIT repository at github.com.
Payment Difference (+/-) column on AR and AP transactions report often causes confusion to new users of sql-ledger. This column displays the number of days between due date and last payment date for an invoice.
This column can be displayed by checking the ‘Payment Difference’ checkbox on the report search screen.
Our git repository has been updated to the latest sql-ledger release which is 2.8.18. Click here to see the code changes in this version.
‘master‘ branch tracks sql-ledger with our changes while ‘sql-ledger‘ branch tracks changes made by the sql-ledger author.
We have also merged these code changes into ‘master’ which brings our patches and other customizations up to 2.8.18.
To view our git repository visit http://github.com/ledger123/ledger123/tree/master
To download our repository, run the following command in your Linux/Unix with git installed:
git clone git://github.com/ledger123/ledger123.git