This blog has not been updated for a while. We are busy working hard to add new features to our already enhanced sql-ledger version. (You can view the list of existing enhancements here.) Our enhanced version is based upon the latest official sql-ledger 2.8.30. Our new enhancements include: Item price history lookup on invoices, orders […]
Bank reconciliation patch
We have released an sql-ledger 2.8.24 patch which corrects the following bank reconciliation issues: When there are multiple receipts for a single invoice/date or same amount/date, only one is shown. This happens when * When source column is blank for both payments * When source column contains same value for both payments. Marking one receipt […]
A small ‘All Items’ report bug
This bug prevented the display of a warehouse with negative item onhand quantities on ‘All Items’ report. See the patch at ledger123 github repository.
Tax toggle on invoice screens
Our new enhancement for our hosted sql-ledger allows you to make any invoice line item non-taxable regardless of its customer/item settings. Following screen shots explain this feature: The Tx checkbox is checked by default and the line item tax is calculated according to customer/item settings. When you un-check the Tx checkbox, tax is not calculated […]
Git repository upgraded
We have upgraded the sql-ledger git repository to release 2.8.23 from sql-ledger.com. Code changes in 2.8.19 Code changes in 2.8.20 Code changes in 2.8.21 The changes in 2.8.22 and 2.8.23 are insignificant. We have merged all the upstream changes to our customizations as well. It just took a single ‘git merge sql-ledger’ and there were […]
Git repository updated to Sql-Ledger 2.8.18
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 […]
Default Department/Warehouse for Users – Part 2
In part 1 we discussed the code changes required to define department and warehouse defaults for each user through admin.pl. In this part we have made some code changes which will restrict a user to the data he or she created for his or her department and/or warehouse. If the following two conditions are met […]
SL Development History in GIT
We have recreated our GIT repository with all sql-ledger versions starting from 2.6.0 up to 2.8.17. Change log as published by sql-ledger.org has been added as part of commit message for each version. All versions have been tagged appropriately. Tags SL260, SL2627, 2817, for example, represent 2.6.0, 2.6.27 and 2.8.17 respectively. This repository can be […]
Sql-Ledger on github
GIT is next generation directory content management system (or version control system if you like it this way). We have recently switched from Subversion to GIT due to, among other things, ease of branching and merging. We have created a public git repository for sql-ledger on github.com. We intend to publish our patches and other […]
Diff and Patch
diff and patch commands are available in all Linux/Unix operating systems and are a great help for software developers. A brief writeup of these two commands to manage the sql-ledger customizations is available on wiki.ledger123.com.