MUSINGS

Gnucash with MySQL: Creating custom invoices with PDF output and template based email to the customer

Gnucash with MySQL: Creating custom invoices with PDF output and template based email to the customer

I’ve been using GnuCash for some time and have found it to be a great product. Where GnuCash falls short, in my opinion, is it doesn’t provide for scheduled automatic invoice generation. Additionally creating custom invoices involves learning Scheme which personally I don’t have time to get my head around. So I set out to fix these 2 issues using the tools I know well, namely MySQL, perl, and good old HTML. This post will cover custom invoice generation to html and pdf, and emailing the results to the customer using a template. GnuCash scheduled automatic invoice creation will be covered in another post in the near future. Read more about Gnucash with MySQL: Creating custom invoices with PDF output and template based email to the customer