Comment by wuming2
With recutils csv2rec I have my invoices list.
With recutils recsel | recfmt -f template.fodt I have my invoices.
soffice and curl to generate .pdf s and email them off.
With recutils recset I have my invoices status updated. Done.