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 …
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 …
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 …
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 …
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 …
Continue Reading about Emailing Sql-Ledger Reports using Cron →
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 …