Company name bug

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 does not get printed on […]

Payment Difference

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.

Parts Images

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.

What Needs to be Ordered Today?

There is a ROP (Re-Order Point) column on parts file. You can set this column to the minimum quantity you have to stock in your inventory. A simple sql statement like the following can show the items that are below the ROP quantity and need to be ordered. SELECT partnumber, description, onhand, rop, rop – […]

Emailing Sql-Ledger Reports using Cron

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

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 and Outstanding Reports Difference

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. […]

Email in Preferences

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 or through ‘Preferences’ menu option. Seems logical enough but sometimes it gets overlooked as was the case.

Markup Column in 2.8.17

There is a new feature in sql-ledger-2.8.17 which displays item markup percentage next to the price column on invoice lines. This column is a helpful hint and allows you to adjust item price during sale process without going too much back and forth. It will also keep you happy with every sale. Some people, however, […]

Ledger Doctor

SQL-Ledger does not enforce referential integrity across database tables. It manages all validation through its Perl code. This makes it possible to have some invalid data in your sql-ledger database. LedgerDoctor is a small script which does several checks on your sql-ledger database and reports any inconsistencies. These checks include: Dates range check which identifies […]