[GNC] Invoice emailing?

[david whiting]

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 <simon at 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 <cam at 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 at 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 at 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.
>


-- 
David Whiting