sql query to link invoice payments to invoice id?
jannick.news at gmail.com
Sun Jan 9 19:40:25 EST 2011
I am trying to identify the invoice payments TOGETHER with the
associated invoice in the sqlite file of my GnuCash file. Since there is
a window to process the payment, I suspect there should be a link
between the payment and the invoice guid.
I am aware that the payment amount need not be identical to the invoice
amount. As there might be slight differences between these two amounts
in reality anyway, I prefer not to have a query using the invoice
Any ideas on this highly appreciated!
More information about the gnucash-user