Re: [GNC] csv of invoice data

2023-09-02 Thread Morgan Read via gnucash-user
Follow up to: https://lists.gnucash.org/pipermail/gnucash-user/2023-August/108625.html Apologies for not following up until after the month has rolled over... David, yes. Thank you. I think that has put me on the right track. There's a bit of a steep hill to climb, but at least I know now whic

Re: [GNC] csv of invoice data

2023-08-28 Thread david whiting
I needed to play with the invoices data a while ago and used the query below (gnucash file saved as an sqlite database). I didn't need the full invoice details and only selected a few of the fields. This should be enough to get you started. Note that the invoices are in one table and the invoice it

[GNC] csv of invoice data

2023-08-28 Thread Morgan Read via gnucash-user
Hi again :) In addition to wanting to deal with some old invoices, I'm also wanting to generate a csv of invoice data. There's this post a few years back, but I feel there must be better. I've discovered the page on 'ledger-cli': https://wiki.gnucash.org/wiki/Ledger-CLI - which seems compli