SQL-ledger Extras

a. Error Messages

Error messages are few and generally weak in SQL-ledger. This writer notes a few error situations:

There are a number of community lists that can assist in resolving errors. Here's a few:

Official SQL-ledger FAQ
SQL-Mail list

b. Tips

  1. Create a test database.
  2. Create a ‘template’ database for the company where customer data, stock parts – all info updated but with no transactions. To be used as a ‘starter’ file each year (or two).
  3. In starting the year, one can create reversed ‘Credit Note’ for the total outstanding of a customer as a negative figure linked to ‘Retained Earnings’ and put the list of unpaid invoices and interest changes in the notes.