There is a small bug/gotcha in the latest version (2.8) of sql-ledger which causes confusion to a number of users. This problem also affects those users who have upgraded from 2.6. Here is the detail: 1. The company name (and phone numbers) you specify during a user creation (through admin.pl) does not get printed on […]

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.

You can specify image filenames when adding or changing parts. When you display your parts using Goods & Services–Reports–Parts and check Image checkbox, thumbnails for these images are shown. When you click on the thumbnail, the image is shown in actual size.

There is no built-in support in sql-ledger to email reports periodically but you can easily build a shell script which will do so. The trick is to call sql-ledger API through command line to generate the report into an html file and then use mutt to email the report. For example following call to API […]

Start and End Dates columns on customers and vendor screens allow you to enable or disable them on transaction screens. If the transaction date does not fall between the start and end date of a particular customer, SL will not allow you to select that customer for the transaction. When you add a new customer […]

Aging report in sql-ledger applies ‘To’ date report condition to invoice date only. So if you display aging report upto 10-June-2008, payments made on 11-June-2008 will also be accounted for. Not sure it is a bug or a feature. Outstanding report correctly shows only those invoices and payments which were made upto the report date. […]

While troubleshooting an SL installation I just discovered that email was not being sent (invoices, orders, statements) because user email address was blank. This email address can be specified when you create user through admin.pl or through ‘Preferences’ menu option. Seems logical enough but sometimes it gets overlooked as was the case.