Just a further 0.02 on this. generating a PDF in a folder gives you (with no extra work) a handy archive of invoice documents actually generated. If you ever need to quickly refer to one (or have the tax man come to visit), an archive of PDFs is IMHO quicker than firing up GC and searching.
But maybe I'm too old school... Maf. On Tuesday, 3 January 2023 08:48:28 GMT david whiting wrote: > Gnucash can use SQLite and that works well. I set up what Cam Ellison > described for our football club, where I needed to send about 450 > statements at the end of each month showing players how much they had paid > and how much they owed. Querying the SQLite database to create the > statements as pdf files was quite easy. I wasn't using the business > features for that, as each player was a sub-account in Assets, rather than > a customer, but I did some other queries with invoices and can see how you > can easily get what you need. > > David > > > > On Tue, 3 Jan 2023 at 03:54, Simon Roberts <si...@dancingcloudservices.com> > > wrote: > > Also an interesting idea. I'll keep that in mind and in the meantime make > > a > > background task to investigate documentation on how one runs this against > > a > > DB, and what makes any given DB compatible or not. I would be happy to run > > it against something like Derby or MySQL. Well, any open source DB that I > > can reliably connect to from Java/Scala I guess. > > > > Thanks for the idea Cam, much appreciated. > > > > Cheers, > > Simon > > > > On Mon, Jan 2, 2023 at 8:24 PM Cam Ellison <c...@ellisonet.ca> wrote: > > > If you use GnuCash with a database, and have the coding skills, you > > > could generate whatever invoice you want, and convert and email it. This > > > would be straightforward in most cases, though not trivial. Access to > > > the database is not confined to GnuCash itself. Just the same, you'd > > > have to do it outside of GnuCash. > > > > > > Cheers > > > > > > Cam > > > > > > On 2023-01-02 17:48, Adrien Monteleone wrote: > > > > If by 'directly' you mean from 'within GnuCash', no, you can't. > > > > > > > > Since the customer's e-mail address can appear on the invoice in their > > > > info block, you might be able to set up a script, possibly combined > > > > with a folder 'watcher' that can automate e-mailing a resulting PDF > > > > from printing the invoice to that e-mail address and crafting a > > > > subject line perhaps with the invoice number taken from the document. > > > > > > > > You can of course do the same thing with HTML, via running the invoice > > > > report, then use the Export button rather than print-to-file. > > > > > > > > How much of this you want to automate to reduce clicks is up to you. > > > > > > > > Regards, > > > > Adrien > > > > > > > > On 1/2/23 7:15 PM, Simon Roberts wrote: > > > >> Can I directly email PDF, or was Adrien correct? > > > > > > _______________________________________________ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > ----- > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > -- > > Simon Roberts > > (303) 249 3613 > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
